Using Hue WebUI to Operate Hive Tables

Hue aggregates interfaces which interact with most Apache Hadoop components and enables you to use Hadoop components with ease on a web UI. You can operate components such as HDFS, Hive, HBase, Yarn, MapReduce, Oozie, and Spark SQL on the Hue web UI.

Prerequisites

The Hue component has been installed.

Procedure

Access the Hue web UI. For details, see Accessing the Hue Web UI.
In the navigation tree on the left, click the editor icon and choose Hive.
Select a Hive database from the Database drop-down list box. 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.
Click the desired table name. All columns in the table are displayed.
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 to execute the HiveQL statements.

Figure 1 Executing a statement
In the command text box, enter show tables; and click . Check whether the hue_table table created in 5 exists in the Result.