[jira] [Created] (HIVE-3786) Alter table refresh command for external tables

["Anurag Tangri (JIRA)" <ji...@apache.org>]

Anurag Tangri created HIVE-3786:
-----------------------------------

             Summary: Alter table refresh command for external tables
                 Key: HIVE-3786
                 URL: https://issues.apache.org/jira/browse/HIVE-3786
             Project: Hive
          Issue Type: Improvement
          Components: Metastore
            Reporter: Anurag Tangri


If the data at the location for a partitioned/non-partitioned external tables gets changed, the queries on the partition gives incorrect results.

The workaround is to remove all the erroneous partitions and then add them again and then it works perfectly fine.

We should have a refresh command to do the same per partition or for all the partitions in an external table.





--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira