Page Comparison

...

1. Open a browser and and enter URL of the Hue interface.
   
   

2. Create a staging directory.

   1. Open the file browser in Hue.

   2. Select a directory in the file browser, e.g. /user/impala/uploads

   3. Click the New button and then select directory.

   4. Enter the name of the new directory, e.g. staging and then click Create.

   5. Select the directory in the file browser.

   6. Click the Actions button and then select Change Permissions.

   7. Update the permissions to make the new directory available to the UNIX user(s) that is used to start the ECs.
       

3. Create a database and a table to be used by Data Hub.

   1. Select Impala from Query Editors.

   2. Enter a CREATE DATABASE statement in the editor and then click the Execute button.

      Info

      title	Example - Creating a database

      Code Block
      CREATE DATABASE test;

   3. Click the Refresh button.

   4. Enter a CREATE TABLE statement in the editor and then click the Execute button.

      The CREATE TABLE statement may contain the following data types:

      1. STRING

      2. INT

      3. FLOAT

      4. DOUBLE

      5. BOOLEAN

      6. BIGINT

      7. REAL

      8. SMALINT

      9. TINYINT

      10. TIMESTAMP
          

          Info
          title Example - Creating a table in Impala
          Code Block CREATE TABLE IF NOT EXISTS mytable (id STRING, start BIGINT, stop BIGINT) PARTITIONED BY (yearmonthday INT) STORED AS PARQUET TBLPROPERTIES ('transactional'='false');

          When you run the Data Hub agent, temporary tables will be created in the same schema. These table tables will be visible in Hue but hidden in the system.

...