Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: change hiveconf to --hiveconf per discussion in dev@hive "-hiveconf vs -hiveconf" March 7-8, 2014

...

  • 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

...