Using Hue

This section provides information about how to use Hue for the following tasks:

It is easy to get started using Hue. Try the following tutorial to start using Hue immediately.

Getting Started with Hue

Analyze and visualize your data with Impala, a high-speed, low-latency SQL query engine.

  1. Log on to Hue: select Hue > WebUI.
  2. Download and unzip one year of bike trips from the Bay Area Bike Share program (~80 MB).
  3. Create a table from ~/babs_open_data_year_1/201402_babs_open_data/201402_trip_data.csv.
    • Go to the Metastore Tables Manager (or Tables Browser).
    • In the default database, click the Create Table icon Hue Create Table icon.
    • Set Type = File.
    • Set Path by dragging 201402_trip_data.csv to the Path field.
    • Set Formats (Comma, New Line, Double Quote) and click Next.
    • Set Properties Format = Csv.
    • Edit Fields and click Submit:
      • Change ZipCode to data type string.
      • Rename Bike # to Bike ID.
    • Click Run Hue Run icon to execute a select query in Hive.
  4. Go to Query Editors > Impala.
    • Click Refresh Hue Refresh icon and select Perform incremental metadata update to display your new table.
    • Input a query into the editor, for example:
      select `start station`, `end station`, count(*) as trips from `default`.`201402_trip_data` group by `start station`, `end station` order by trips desc; 
    • Click Format Hue Format icon to make the query multi-line.
    • Click Save Hue Save icon, input a query name, and click Save.
    • Click Execute Hue Run icon to run the query.
  5. Create a Bar chart by clicking Hue Bar Chart icon:
    • Set the X-axis as start station and the Y-axis as trips. A bar chart displays.
    • Set the Limit to 10.
  6. Create a Pie chart by clicking Hue Pie Chart icon.
  7. Download the results by clicking Hue Download icon Blue and selecting CSV or Excel.