Re: hive query

The query is assuming Keyword/Hour is unique which I am not sure if that's an assumption per requirement. If not, you'd probably want to group by those two columns. select k.keyword , h.hour , sum(coalesce(t.totalcount,0)) from (select distinct keyword from t) as k join (select

Fwd: Hive 0.14 schema evolution for orc table

How does schema evolution work for orc table in hive 0.14? Does it support add column at the end of the row only? What else is supported?