Details
-
Bug
-
Status: Closed
-
Minor
-
Resolution: Duplicate
-
Impala 2.6.0
-
None
-
None
-
None
-
ghx-label-3
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?
Impala: ERROR: AnalysisException: Partition spec does not exist: