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}