Updated on 2024-10-08 GMT+08:00

Using Hue WebUI to Operate Hive Tables

Hue provides the file browser function using a graphical user interface (GUI) so that you can view files and directories on Hive.

Prerequisites

You have installed Hive and Hue, and the Kerberos authentication cluster in the running state.

Procedure

  1. Access the Hue web UI. For details, see Accessing the Hue Web UI.
  2. Open the Hue web UI and choose Query Editors > Hive.
  3. In Databases, select a Hive database, the default database is default.

    The system displays all available tables. You can enter a keyword of the table name to search for the desired table.

  4. Click the desired table name. All columns in the table are displayed.
  5. Enter the HiveQL statements in the area for editing.

    create table hue_table(id int,name string,company string) row format delimited fields terminated by ',' stored as textfile;

    Click and select Explain. The editor checks the syntax and execution plan of the entered HiveQL statements. If the statements have syntax errors, the editor reports Error while compiling statement.

  6. Click , and select the engine for executing the HiveQL statements.
  7. Click to execute the HiveQL statements.
  8. In the command text box, enter show tables; and click . Check whether the hue-table table created in 5 exists in the result.