Hive Shell

Hive Shell :

Hive shell is a primary way to interact with hive.

It is a default service in the hive.

It is also called CLI (command line interference).

Hive shell is similar to MySQL Shell.

Hive users can run HQL queries in the hive shell.

In hive shell up and down arrow keys are used to scroll previous commands.

HiveQL is case-insensitive (except for string comparisons).

The tab key will autocomplete (provides suggestions while you type into the field) Hive keywords and functions.

Hive Shell can run in two modes :

Non-Interactive mode :  

Non-interactive mode means run shell scripts in administer zone.

Hive Shell can run in the non-interactive mode, with the -f option.

 Example:

$hive -f script.q,   Where script. q is a file.

Interactive mode :

The hive can work in interactive mode by directly typing the command “hive” in the terminal.

Example:

$hive

Hive> show databases;