[HIVE-22155] Exception while loading data into hive partitioned table

• Type: Wish
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: Hive
• Assignee: Kiet Ly
• Reporter: obbu Nireesha
• Due: 29/Aug/19
• Created: 28/Aug/19 12:39
• Updated: 28/Aug/19 12:39

Description

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