In this kind of insert where you mention partition, you need to specify which partition.
Example load data local inpath './custs' into table custs partition(cust_prof=1); On Mon, May 19, 2014 at 7:02 PM, Rahul Channe <[email protected]>wrote: > 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} >
