hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ajay Chander <hadoopde...@gmail.com>
Subject Hive_CSV
Date Wed, 09 Mar 2016 17:43:36 GMT
Hi Everyone,

I am looking for a way, to ignore the first occurrence of the delimiter
while loading the data from csv file to hive external table.

Csv file:

Xyz, baseball, outdoor

Hive table has two columns sport_name & sport_type and fields are separated
by ','

Now I want to load by data into table such that while loading it has to
ignore the first delimiter that ignore xyz and load the data from second
delimiter.

In the end my hive table should have the following data,

Baseball, outdoor .

Any inputs are appreciated. Thank you for your time.

Mime
View raw message