I have created the following partitioned table in hive

 create table custs ( cust_id int, first_name String,last_name
String,cust_age int ) partitioned  by ( cust_prof String) row format
delimited fields terminated by ',';

when I am trying to load data into the table, I am getting error

load data local inpath './custs' into table custs  partition(cust_prof);

FAILED: Error in semantic analysis:
org.apache.hadoop.hive.ql.metadata.HiveException: cust_prof not found in
table's partition spec: {cust_prof=null}

Reply via email to