hive

CLI tool for Apache Hive. More information: https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Cli.

• Start a Hive interactive shell:

hive

• Run HiveQL:

hive -e "hiveql_query"

• Run a HiveQL file with a variable substitution:

hive --define key=value -f path/to/file.sql

• Run a HiveQL with HiveConfig (e.g. mapred.reduce.tasks=32):

hive --hiveconf conf_name=conf_value