[jira] [Closed] (IMPALA-6496) Impala Show Partitions is listing dropped partitions

2018-02-12 Thread Markon (JIRA)

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


[jira] [Created] (IMPALA-6496) Impala Show Partitions is listing dropped partitions

2018-02-09 Thread Markon (JIRA)
Markon created IMPALA-6496:
--

 Summary: 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


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 similar unresolved issues that went unanswered, does anybody know how to 
get Impala to correctly update the metadata and refresh the partition list?



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)