hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sanka, Himabindu" <>
Subject Issue joining 21 HUGE Hive tables
Date Thu, 24 Mar 2016 01:49:55 GMT
Hi Team,

I need some inputs from you. I have a requirement for my project where I have to join 21 hive
external tables.

Out of which 6 tables are HUGE  having 500 million records of data. Other 15 tables are smaller
ones around 100 to 1000 records each.

When I am doing inner joins/ left outer joins its taking hours to run the query.

Please let me know some optimization techniques or any other eco system components that performs
better than HIVE.


This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity
to which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified
that any dissemination, distribution or copying of this e-mail is
prohibited. If you have received this e-mail in error, please notify the
sender by replying to this message and delete this e-mail immediately.

View raw message