I have created a table in hive:
CREATE TABLE db.test ( fname STRING, lname STRING, age STRING, mob BIGINT ) row format delimited fields terminated BY '\t' stored AS textfile;
Now to load data in table from file, I am using following command -
load data local inpath '/home/cluster/TestHive.csv' into table db.test;
I dont want to load the first column. So how can I skip it?