Daniel, thanks for your time. Is it like creating two tables, one is to get all the data and the another one is to fetch the required data out of it? If that is the case I was just concerned of redundant data. Please correct me if I am wrong. Thanks
On Wednesday, March 9, 2016, Daniel Haviv <[email protected]> wrote: > Hi Ajay, > Use the CSV serde to read your file, map all three columns but only select > the relevant ones when you insert: > > Create table csvtab ( > irrelevant string, > sportName string, > sportType string) ... > > Insert into loaded_table select sportName, sportType from csvtab; > > Daniel > > > On 9 Mar 2016, at 19:43, Ajay Chander <[email protected] > <javascript:;>> wrote: > > > > 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. >
