Hue makes it easy to create Hive tables.
With HUE-1746, Hue guesses the columns names and types (int, string, float…) directly by looking at your data. If your data starts with a header, this one will automatically be used and skipped while creating the table.
Quoted CSV fields are also compatible thanks to HUE-1747.
Here is the data file used:
This is the SerDe for reading quoted CSV:
And the command to switch the SerDe used by the table:
ALTER TABLE banks SET SERDE 'com.bizo.hive.serde.csv.CSVSerde'