[IMPALA-6496] Impala Show Partitions is listing dropped partitions

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Duplicate
• Affects Version/s: Impala 2.6.0
• Epic Color: ghx-label-3
• Assignee: Unassigned
• Reporter: Markon
• Created: 09/Feb/18 17:02
• Updated: 12/Feb/18 12:03
• Resolved: 12/Feb/18 12:03

Description

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://issues.apache.org/jira/browse/IMPALA-2423