hadoop - Perfomance improvement for hive query -


i using multiple union , doing sum of each column, query runs forever. have 96gb memory cluster. please tell me should performance improvement. following query in hive.

total ( select * (    select * table1    union    select * table2    union    select * table3    union    select * table4    union    select * table5    union    select * table6    union    select * table7    union    select * table8    union    select * table9 )p )   select * ( select sum(col_1), sum(col_2), sum(col_3), sum(col_4), sum(col_5), sum(col_6), sum(col_7), sum(col_8), sum(col_9), sum(col_10) total )q; 


Comments

Popular posts from this blog

javascript - Clear button on addentry page doesn't work -

python - Error: Unresolved reference 'selenium' What is the reason? -

asp.net ajax - Jquery scroll to element just goes to top of page -