Apache Hive: Find the version from the Command Line Interface (CLI)

The version of Apache Hive can be retrieved from Command Line. You don’t have to navigate through the configuration files or browse through the User Interface.

There are two commands that can be used from Command Line to obtain the version of Apache Hive.

COMMAND #1

This command follows the popular convention used by other tools like hadoop.

hive --version

You can see the version in this screenshot is 2.3.3-mapr-1808.

COMMAND #2

This command executes the statement “select version()” in hive cli to retrieve the version without actually opening the hive shell.

hive -e "select version()"

In this screenshot, you can notice that the version is 2.3.3-mapr-1808 which is same as the one from previous screenshot. Both command print the same version.