This document describes how to use Hue.
Hue's Beeswax app provides user-friendly and convenient Hive query capabilities, enabling you to select different Hive databases, write HQL statements, submit query tasks, and view results with ease.
You can use HBase Browser to query, modify, and display data from tables in an HBase cluster.
Hue's web UI makes it easy to view files and folders in HDFS and perform operations such as creation, download, upload, copy, modification, and deletion.
create database if not exists hive_sample;
show databases;
use hive_sample;
show tables;
create table if not exists hive_sample (a int, b string);
show tables;
insert into hive_sample select 1, "a";
select * from hive_sample;
Save the above content as a file named hive_sample.sql
. The Hive workflow also requires a hive-site.xml
configuration file, which can be found on the cluster node where the Hive component is installed. The specific path is /usr/local/service/hive/conf/hive-site.xml
. Copy the hive-site.xml
file and then upload the Hive script file and hive-site.xml
to a directory in HDFS, such as /user/hadoop
.
hadoop
user. At the top of the Hue console, select Query > Scheduler > Workflow.Note:This document uses the installation of Hive v1 as an example, and the configuration parameter is
HiveServer1
. If it is deployed with other Hive versions (i.e., configuring configuration parameters of other versions), an error will be reported.
3. Select the Hive script and hive-site.xml
files you just uploaded.
4. Click Add and specify the Hive script file in FILES
.
5. Click Save in the top-right corner and then click Run to run the workflow.
Create a scheduled job.
The scheduled job in Hive is "schedule", which is similar to the crontab in Linux. The supported scheduling granularity can be down to the minute level.
Create a scheduled job.
Notebooks can quickly build access requests and queries and put the query results together for comparative analysis. It supports five types: Hive, Impala, Spark, Java, and Shell.
Was this page helpful?