Running a Hive command in Data Hub
You can run most Hive commands that push configuration variables to Hive SQL scripts from the command line of a node in your cluster. You use a keyword and options to launch these commands in Beeline.
Hive supports running Hive commands from the command line. The command you enter
launches Beeline in the background. The -e
flag followed by a Hive
set
command lists system variables.
On the command line of a node in your CDP cluster, enter the
hive
command to send configuration properties to standard
output.
> hive -e set
Supported commands appear. All obsolete Hive CLI commands are supported by
Beeline except set key=value commands that configure Hive
Metastore.
The output includes the system variable
settings:
+----------------------------------------------------------------+
| set |
+----------------------------------------------------------------+
| _hive.hdfs.session.path=/tmp/hive/hive/91ecb...00a |
| _hive.local.session.path=/tmp/hive/91ecb...00a | |
...