[
https://issues.apache.org/jira/browse/HIVE-14032?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15468082#comment-15468082
]
Chinna Rao Lalam commented on HIVE-14032:
-----------------------------------------
Hi [~ashutoshc],
Sorry for the late reply..
When we execute above queries this is the exception. It was failed in
validation because of case sensitive partition name(PARTITIONID).
{code}
hive> INSERT OVERWRITE TABLE sample2 PARTITION (PARTITIONID = 'one') if not
exists select a,b from sample1;
FAILED: ValidationFailureSemanticException Partition spec {PARTITIONID=one}
contains non-partition columns
{code}
This is the log..
{code}
2016-09-07T04:54:45,903 ERROR [56697602-dac6-4f1f-b49f-fd86a602883a main]:
ql.Driver (SessionState.java:printError(1053)) - FAILED:
ValidationFailureSemanticException Partition spec {PARTITIONID=one} contains
non-partition columns
org.apache.hadoop.hive.ql.metadata.Table$ValidationFailureSemanticException:
Partition spec {PARTITIONID=one} contains non-partition columns
at
org.apache.hadoop.hive.ql.metadata.Table.validatePartColumnNames(Table.java:382)
at
org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.validatePartSpec(BaseSemanticAnalyzer.java:1498)
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.doPhase1(SemanticAnalyzer.java:1662)
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.doPhase1(SemanticAnalyzer.java:1686)
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genResolvedParseTree(SemanticAnalyzer.java:10748)
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:10807)
at
org.apache.hadoop.hive.ql.parse.CalcitePlanner.analyzeInternal(CalcitePlanner.java:246)
at
org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:250)
{code}
Same queries without *IF NOT EXISTS* clause it is successful.
{code}
INSERT OVERWRITE TABLE sample2 PARTITION (PARTITIONID = 'one') select a,b from
sample1;
{code}
> INSERT OVERWRITE command failed with case sensitive partition key names
> -----------------------------------------------------------------------
>
> Key: HIVE-14032
> URL: https://issues.apache.org/jira/browse/HIVE-14032
> Project: Hive
> Issue Type: Bug
> Components: Metastore
> Affects Versions: 2.0.1
> Reporter: Chinna Rao Lalam
> Assignee: Chinna Rao Lalam
> Attachments: HIVE-14032.patch
>
>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
