Useful Impala commands that you can use to improve queries performance are:
COMPUTE STATS
SET MEM_LIMIT
CREATING TEMP TABLE
Those statements will make your code smarter.
Performance will be greater and your managers, users and DB’s will be happy to work with you.
INSERT OVERWRITE – will make your life much easier when handling deletes.
Continue reading to know when it is good to apply those statements.
Read More