Cloudera Enterprise 5.15.x | Other versions

Get Started with Hue

Hue is a web-based interactive query editor in the Hadoop stack that lets you visualize and share data.

Figure 1. Impala Query Results in Hue

Play with Hue

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

  Tip: If you don't have your own Hue instance, try running sample queries on http://demo.gethue.com/.
  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.

To learn more about the power of Hue, see Hue How-tos.

Page generated May 18, 2018.