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 .
   • 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 to execute a select query in Hive.
4. Go to Query Editors > Impala.
   • Click Refresh 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 to make the query multi-line.
   • Click Save , input a query name, and click Save.
   • Click Execute to run the query.
5. Create a Bar chart by clicking :
   • 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 .
7. Download the results by clicking and selecting CSV or Excel.

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