LinuxCommandLibrary

hive

CLI tool for Apache Hive.

TLDR

Start a Hive interactive shell

$ hive
copy


Run HiveQL
$ hive -e "[hiveql_query]"
copy


Run a HiveQL file with a variable substitution
$ hive --define [key]=[value] -f [path/to/file.sql]
copy


Run a HiveQL with HiveConfig (e.g. mapred.reduce.tasks=32)
$ hive --hiveconf [conf_name]=[conf_value]
copy

Copied to clipboard