Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

hive very big table

Solved Go to solution

hive very big table

Super 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

Accepted Solutions

Re: hive very big table

@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 REPLIES 3

Re: hive very big table

@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

Highlighted

Re: hive very big table

Expert Contributor

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.

Re: hive very big table

what do you mean by easy query?

Don't have an account?
Coming from Hortonworks? Activate your account here