Download the Beeline CLI tarball from Cloudera Data Warehouse (CDW) to your local
system and use the Beeline client to connect to a Hive Virtual Warehouse and run queries.
The archive file contains all the dependent JARs and libraries that are required to run the
Beeline script.
From the Cloudera Management Console user profile, note the Workload User Name
and Workload Password.
Log in to the CDP web interface and navigate to the Data Warehouse
service.
In the Overview page of the Data Warehouse service, click
See More in the Resources and
Downloads tile.
Select Beeline CLI and click to download the
file.
Save the apache-hive-beeline-x.x.xxxx.tar.gz file in your
local system and extract the tarball.
In the Data Warehouse service Overview page, for the
Virtual Warehouse you want to connect to the client, click and select Copy JDBC
URL.
Paste the copied JDBC URL in a text file, to be used in later steps.
Open a terminal window and go to the folder where the tarball is extracted to
start Beeline.
bin/beeline
This starts an interactive Beeline shell where you can connect to Hive and
run SQL queries.
Run the connect command to connect to Hive using the JDBC URL
that you copied earlier.
beeline> !connect [***JDBC URL***]
Connecting to jdbc:hive2://<your-virtual-warehouse>.<your-environment>.<dwx.company.com>/default;transportMode=http;httpPath=cliservice;ssl=true;retries=3
Enter the Workload User Name and Workload Password when you are prompted for
the user credentials.
Enter username for jdbc:hive2://<your-virtual-warehouse>.<your-environment>.<dwx.company.com>/default: [***WORKLOAD USERNAME***]
Enter password for jdbc:hive2://<your-virtual-warehouse>.<your-environment>.<dwx.company.com>/default: [***WORKLOAD PASSWORD***]
Connected to: Apache Hive (version 3.1.2000.7.0.2.2-24)
Driver: Hive JDBC (version 3.1.2000.7.0.2.2-24)
Transaction isolation: TRANSACTION_REPEATABLE_READ
To verify if you are connected to HiveServer2 on the Virtual Warehouse, run the
following SQL command:
SHOW TABLES;
INFO : Compiling command(queryId=hive_20200214014428_182d2b63-a510-421f-8bbc-65a4ae24d1d6): show tables
INFO : Semantic Analysis Completed (retrial = false)
INFO : Completed compiling command(queryId=hive_20200214014428_182d2b63-a510-421f-8bbc-65a4ae24d1d6); Time taken: 0.054 seconds
INFO : Executing command(queryId=hive_20200214014428_182d2b63-a510-421f-8bbc-65a4ae24d1d6): show tables
INFO : Starting task [Stage-0:DDL] in serial mode
INFO : Completed executing command(queryId=hive_20200214014428_182d2b63-a510-421f-8bbc-65a4ae24d1d6); Time taken: 0.018 seconds
INFO : OK
-----------
table_name
-----------
-----------
No rows selected (0.311 seconds)
to download the
file.
and select Copy JDBC
URL.
