Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

hive very big table

avatar
Master Collaborator

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??

1 ACCEPTED SOLUTION

avatar

@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

View solution in original post

3 REPLIES 3

avatar

@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

avatar
Super Collaborator

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.

avatar
Super Guru

what do you mean by easy query?