Schema evolution in hive tables

behaviour or am I missing something obvious? Coming back to the question of schema evolution, as business usecases grow, there is a need to add fields in the table. So am I restricted by hive to add my fields at the end only? Thanks -- Rajat Khandelwal Software Engineer

Filters with IN clause are getting omitted

Hi I've recently noticed incorrect behaviour from Hive Query Planner. The simplest example I could construct is as follows SELECT tbl3.col2 AS current_regularity_streak FROM (select 1 col1) tbl1 LEFT JOIN (select 1 col1) tbl2 ON tbl1.col1 = tbl2.col1 LEFT JOIN (select 1 col1, 1 col2) tbl3 ON