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?