You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@impala.apache.org by "Markon (JIRA)" <ji...@apache.org> on 2018/02/12 12:04:00 UTC
[jira] [Closed] (IMPALA-6496) Impala Show Partitions is listing
dropped partitions
[ 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)