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