[ https://issues.apache.org/jira/browse/IMPALA-6496?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Markon closed IMPALA-6496. -------------------------- Resolution: Duplicate > Impala Show Partitions is listing dropped partitions > ---------------------------------------------------- > > Key: IMPALA-6496 > URL: https://issues.apache.org/jira/browse/IMPALA-6496 > Project: IMPALA > Issue Type: Bug > Affects Versions: Impala 2.6.0 > Reporter: Markon > Priority: Minor > > An external table had one of its partitions dropped on Hive. When > SHOW PARTITIONS elevationP; > is run on Hive, the updated list of partitions is displayed. However on > Impala, even after : > REFRESH elevationP; > and > INVALIDATE METADATA elevationP; > when > SHOW PARTITIONS elevationP; > is run, the dropped partition is still being displayed. > Dropping it the same way on Impala using: > ALTER TABLE elevationP DROP PARTITION(degrees='60'); > didn't work either and showed: > ERROR: AnalysisException: Partition spec does not exist: (degrees='60'). > > I saw rather similar unresolved issues that went unanswered (see bellow), > does anybody know how to get Impala to correctly update the metadata and > refresh the partition list? > > > ---- > [https://community.cloudera.com/t5/Interactive-Short-cycle-SQL/Partition-Spec-Does-Not-Exist-error/td-p/33460] > [Impala: ERROR: AnalysisException: Partition spec does not > exist:|https://stackoverflow.com/questions/40739022/impala-error-analysisexception-partition-spec-does-not-exist] > https://issues.apache.org/jira/browse/IMPALA-2423 -- This message was sent by Atlassian JIRA (v7.6.3#76005)