Why Don't you load all data and use just two columns for querying? Alternatively use regular expressions.
> On 09 Mar 2016, at 18:43, Ajay Chander <hadoopde...@gmail.com> 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.