...
Use ";" (semicolon) to terminate commands. Comments in scripts can be specified using the "--" prefix.
Command | *Description | |
---|---|---|
quit | Use quit or exit to come out of interactive shell. | |
set <key>=<value> | Use this to set value of particular configuration variable. One thing to note here is that if you misspell the variable name, cli will not show an error. | |
set | This will print list of configuration variables that overridden by user or hive. | |
set -v | This will give all possible hadoop/hive configuration variables. | |
add FILE <value> <value>* | Adds a file to the list of resources. | |
list FILE | list all the resources already added | |
list FILE <value>* | Check given resources are already added or not. | |
! <cmd> | execute a shell command from hive shell | |
dfs <dfs command> | execute dfs command command from hive shell | |
<query string> | executes hive query and prints results to stdout |
Sample Usage:
Code Block |
---|
hive> set mapred.reduce.tasks=32;
hive> set;
hive> select a.* from tab1;
hive> !ls;
hive> dfs -ls;
|
...