Using Hue

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

1. Download and unzip one year of bike trips from the Bay Area Bike Share program. This file is about 80 MB in size.
2. Create a table from the ~/babs_open_data_year_1/201402_babs_open_data/201402_trip_data.csv file found in the unzipped babs_open_data_year_1.zip file:
   1. In the Cloudera Manager Admin Console, select Hue > WebUI > Hue Load Balanced to launch Hue.

   2. In the left panel of Hue, make sure the default database is selected, and click the plus sign to create a table:

      
      
      
      
      

      If the default database is not selected, click the "less than" icon that is next to the database icon in the left panel. This enables you to select the default database.

   3. In the center panel Importer UI, set Type to File.

   4. Drag the 201402_trip_data.csv file to the Path field:

      
      
      
      
      

   5. Set the formats as follows:

      • Field Separator = Comma (,)
      • Record Separator = New line
      • Quote Character = Double Quote

      Then click Next at the bottom of the page.

   6. Set the properties Format = Text.

   7. Edit the FIELDS as follows:

      • Rename Bike # to Bike ID
      • Change the data type of ZipCode to string.
      • Remove all of the spaces in the Name fields.

      Then click Submit at the bottom of the page.

3. Click Query at the top of the page and select Editor > Hive to open the HiveQL editor and then create a query.

   • Enter the following query into the editor window:

     SELECT * FROM default.201402_trip_data
     LIMIT 10;
               

   • Click the execute icon to run the query. The following rows are returned:

     
     
     
     
     

4. Click Query at the top of the page and select Editor > Impala to open the Impala SQL editor and then create a query.

   1. In the left panel, click the refresh icon and select Perform incremental metadata update to make the new table visible to Impala:

      
      
      
      
      

   2. Enter the following query into the editor window:

      select 'startstation', 'endstation', count(*) as trips from default.'201402_trip_data'
      group by 'startstation', 'endstation' order by trips desc;
                    

   3. Click the down arrow just under the execution icon and select Format:

      
      
      
      
      

      This reformats the query:

      
      
      
      
      
   4. Click the save icon , enter a query name, and click Save.
   5. Click the execute icon to run the query.

5. Create a bar chart that is based on the query results:

   1. Click the chart icon and then select Bars.

      
      
      
      
      

   2. Set the bar chart elements as follows:

      • X-AXIS = startstation
      • Y-AXIS = trips
      • LIMIT = 10
      
      
      
      
      
6. Create a pie chart by clicking the chart icon again and then select Pie.
7. Download the query results by clicking the download icon and selecting in what format you want to download, copy, or export the results.