Hive optimization

Dear Durga,

        I have a big query in hive with multiple joins. Could you please advise me what is best solution for hive big query optimization. 

Ramkumar V

Hi @ramkumar,

I can advice you to use these two tips which can help a lot:

  1. Use stream table for joins (choose your main table to stream):

  2. Be sure you have your tables and columns with statistics computed:

Best of luck,