...
- Hive configuration can be manipulated by:
- Editing hive-site.xml and defining any desired variables (including Hadoop variables) in it
- From the CLI using the set command (see below)
- Invoking hive using the syntax:
$ bin/hive --hiveconf x1=y1 --hiveconf x2=y2
this sets the variables x1 and x2 to y1 and y2 respectively
- Setting the
HIVE_OPTS
environment variable to "--hiveconf x1=y1 --hiveconf x2=y2" which does the same as above.
...
If the user wishes, the logs can be emitted to the console by adding the arguments shown below:
bin/hive --hiveconf hive.root.logger=INFO,console
Alternatively, the user can change the logging level only by using:
bin/hive --hiveconf hive.root.logger=INFO,DRFA
...