Creating a table from an Amazon S3 file

Using Hue to create a table from an Amazon S3 file streamlines the process.

  1. Go to the Metastore Manager by clicking Data Browsers > Metastore Tables.
  2. Create a new table from a file by clicking Hue Create Table from File icon.
  3. Enter a Table Name such as "earthquakes".
  4. Browse for the Input Directory, s3a://quakes/input/, and click Select this folder.

  5. Select Create External Table from the Load Data menu and click Next.
  6. Delimit by Comma(,) and click Next.
  7. Click Create Table.
  8. Click the Browse Data icon to automatically generate a SELECT query in the Hive editor:
    SELECT * FROM `default`.`earthquakes` LIMIT 10000;