Thanks for your update. I have 10 hive tables and I am inserting data from these 10 tables to one hive denorm table but we have some conditions for few columns. Here every column is coming from some table and I need to put populate the column only if certain condition is true for example if table has name,age,salary column and condition is like if salary is 1000 then populate name column. INSERT INTO TABLE MANAGE(NAME,country)SELECT TABLENAME.NAME,TABLENAME.COUNTRY FROM TABLE1,TABLE2 How can I populate the name column with some condition.
... View more
