hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rahul Channe <>
Subject Unable to load data in hive table
Date Tue, 20 May 2014 02:02:04 GMT
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}

View raw message