Commands are non-SQL statement such as setting a property or adding a resource. They can be used in HiveQL scripts or directly in the CLI.
Command |
Description |
||
---|---|---|---|
quit |
Use quit or exit to leave the interactive shell. |
||
reset |
Resets the configuration to the default values (as of Hive 0.10: see HIVE-3202). |
||
set <key>=<value> |
Sets the value of a particular configuration variable (key). |
||
set |
Prints a list of configuration variables that are overridden by the user or Hive. |
||
set -v |
Prints all Hadoop and Hive configuration variables. |
||
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="2f5ce2a8-b12e-4c79-92a3-39a26103ac57"><ac:plain-text-body><![CDATA[ |
add FILE[S] <filepath> <filepath>* |
Adds one or more files, jars, or archives to the list of resources in the distributed cache. |
]]></ac:plain-text-body></ac:structured-macro> |
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="1d7cb130-80f6-4571-b2b9-380afcf2d94f"><ac:plain-text-body><![CDATA[ |
list FILE[S] |
Lists the resources already added to the distributed cache. |
]]></ac:plain-text-body></ac:structured-macro> |
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="8a0fadce-964d-4b69-9e8d-a07e06e78d3f"><ac:plain-text-body><![CDATA[ |
list FILE[S] <filepath>* |
Checks whether the given resources are already added to the distributed cache or not. |
]]></ac:plain-text-body></ac:structured-macro> |
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="03d523ff-1ada-43b0-b6f6-ceb39f68045d"><ac:plain-text-body><![CDATA[ |
delete FILE[S] <filepath>* |
Removes the resource(s) from the distributed cache. |
]]></ac:plain-text-body></ac:structured-macro> |
! <command> |
Executes a shell command from the Hive shell. |
||
dfs <dfs command> |
Executes a dfs command from the Hive shell. |
||
<query string> |
Executes a Hive query and prints results to standard output. |
||
source FILE <filepath> |
Executes a script file inside the CLI. |
||
compile `<groovy string>` AS GROOVY NAMED <name> |
This allows inline Groovy code to be compiled and be used as a UDF (as of Hive 0.13.0) |
Sample Usage:
hive> set mapred.reduce.tasks=32; hive> set; hive> select a.* from tab1; hive> !ls; hive> dfs -ls;