Yea, it was just an example, as I didnt know your schema. Then you can do
(cust_prof='Pilot') or (cust_prof='Teacher'). Does that work for you?
On Tue, May 20, 2014 at 4:27 PM, Rahul Channe wrote:
> Hi Szehon,
>
> I have following records in my File, I want to load the cust table such a
> way
Hi Szehon,
I have following records in my File, I want to load the cust table such a
way that the records are partitioned based on profession
401,Kristina,Chung,55,Pilot
402,Paige,Chen,74,Teacher
403,Sherri,Melton,34,Firefighter
404,Gretchen,Hill,66,Computer hardware engineer
4000
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 wrote:
> I have created the following partitioned table in hive
>
> create ta
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 dat
