[
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)
