Hello Everyone - we have couple of queries which are simple create table or select queries taking long time.
we set the below parameters:
set hive.compute.query.using.stats=true;
set hive.stats.fetch.column.stats=true;
set hive.stats.fetch.partition.stats=true;
set hive.vectorized.execution.enabled =true;
set hive.vectorized.execution.reduce.enabled =true;
Still there is no siginificant change. First of all, what should i look oe where should i look on Tez UI to figure out what i taking time. When a user comes with questions saying - query taking loner time, what things i should check into.
Also - I dont understand Explain plan.
Please help me understand, what parameters of fields to look for.