Preparing the Database

Follow these steps to prepare the Impala database:

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.

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

5. Click the Refresh button.

   • 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

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