Start a Hive shell locally
You can start the Hive shell, which uses Beeline in the background, to enter HiveQL commands on the command line of a node in a cluster.
The prompt consists of the following components:
- jdbc: The Java Database Connectivity protocol designator
- hive2: The HiveServer protocol designator in HDP 3 for using Hive 3
- myhost-1.com: The fully-qualified domain name (FQDN) of the node that hosts HiveServer
- 2181: The hive.zookeeper.client.port defined in /etc/hive/conf/hive-site.xml
- You added the Hive service on the cluster, using Ambari for example, and the following components are running:
- Hive Metastore
- A database for the metastore, such as the default MySQL Server
- Hive clients
On a node in your cluster, start Beeline in the background and a Hive shell in the
> hiveYou can use the
-hoption to see the online help.The Hive 3 connection message appears, followed by the Hive prompt for entering HiveQL queries on the command line.
Enter a HiveQL query.
SHOW DATABASES;Hive creates two databases when you add the Hive service to a cluster: information_schema and sys. All Metastore tables are mapped into your tablespace and are available in sys. The information_schema data reveals the state of the system, similar to sys database data, but in a user-friendly way. You can query information_schema using SQL standard queries, which are portable from one DBMS to another.Output is:
+---------------------+ | database_name | +---------------------+ | default | | information_schema | | sys | +---------------------+
Exit the Beeline and Hive shells.