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.
