hive very big table

[#1]

Hi:

I have a hive table that contain 51.639.071 millions on row, and the easy query is very slow, I use ORC fomart ZLIB and bucket but still slow, any suggestion??

[#2 · Accepted solution]

@Roberto Sancho

Please refer to below Hortonworks blog with inputs to improve Hive query performance:

http://hortonworks.com/blog/5-ways-make-hive-queries-run-faster/

Hope this helps.

Thanks and Regards,

Sindhu

[#3]

Agree with Sindhus Comments. The link provides some basic setup to optimize the queries on Hive.

@Roberto Sancho

Can you please let us know how is the table partitioned, bucketed. If it is partitioned, can you please give us if the where clause makes use of the partition columns.

[#4]

what do you mean by easy query?