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:
http://www.fdic.gov/bank/individual/failed/banklist.html
This is the SerDe for reading quoted CSV:
https://github.com/ogrodnek/csv-serde
And the command to switch the SerDe used by the table:
ALTER TABLE banks SET SERDE 'com.bizo.hive.serde.csv.CSVSerde'
Now go analyze the data with the Hive, Impala or Pig editors!