Support Questions

Find answers, ask questions, and share your expertise
Check out our newest addition to the community, the Cloudera Data Analytics (CDA) group hub.

Hive Performance Tuning

New Contributor


I am new to this community and this is my very first post. Here is the problem I go through.

We have a hive table which is partitioned on source system name and we do the insert overwrite to keep only the current data. When the user queries this table , they wont use the source system name. This table wont grow drastically as we do the overwrite operation. If the user queries without the partition column condition, will this table be efficient to query? 

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.