[
https://issues.apache.org/jira/browse/HIVE-22155?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
obbu Nireesha reassigned HIVE-22155:
------------------------------------
> Exception while loading data into hive partitioned table
> --------------------------------------------------------
>
> Key: HIVE-22155
> URL: https://issues.apache.org/jira/browse/HIVE-22155
> Project: Hive
> Issue Type: Wish
> Components: Hive
> Reporter: obbu Nireesha
> Assignee: Kiet Ly
> Priority: Major
> Attachments: assignment-create-table-2018.txt
>
>
> Hi,
> I created one partition table while loadign the data it throws exception
> "FAILED: SemanticException org.apache.hadoop.hive.ql.metadata.HiveException:
> MetaException(message:Invalid partition key & values; keys [odr_date, ],
> values [])"
> create table statement:
> create external table assignment(
> cust_id string,
> cust_name string,
> shipdt date,
> Courer string ,
> recvd_dt date,
> returned_or_not string,
> returned_dt date ,
> reson_of_return string ) partitioned by(odr_date date)
> ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' STORED AS TEXTFILE;
> Loading data statement:
> Load data LOCAL inpath '/xxx/****/assignment.txt' overwrite into table
> assignment PARTITION(odr_date = "02-01-2017");
> Please let me know how it get resolved
>
--
This message was sent by Atlassian Jira
(v8.3.2#803003)
