Start the Hive shell

Generally, you type hive on the command line of your cluster to start the Hive shell. In the background, Beeline launches the Hive shell.

  1. In CDP Public Cloud, in Environments > your environment > Data Lakes > your data lake, in the Data Lake Cluster tab, click CM-UI.
  2. In Cloudera Manager, click Hosts > All Hosts.
  3. Make a note of the IP address or host name of a node in your cluster, for example myhost-vpc.cloudera.com.
  4. Use ssh to log into the cluster.
    For example:
    ssh myhost-vpc.cloudera.com
  5. Type hive to start Hive from the command line.
  6. Enter Hive queries.
    SHOW DATABASES;
    CREATE TABLE students (name VARCHAR(64), age INT, gpa DECIMAL(3,2));
    INSERT INTO TABLE students VALUES ('fred flintstone', 35, 1.28), ('barney rubble', 32, 2.32);