obbu Nireesha created HIVE-22155:
------------------------------------
Summary: 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
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)
