THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!
Commands are non-SQL statement statements such as setting a property or adding a resource. They can be used in HiveQL scripts or directly in the CLI or Beeline.
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). Any configuration parameters that were set using the set command or -hiveconf parameter in hive commandline will get reset to default value. Note that this does not apply to configuration parameters that were set in set command using the "hiveconf:" prefix for the key name (for historic reasons). | |||
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="63c3c6f2-3fcc-4ca0-8666-d110874c34c2"><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. See Hive Resources for more information. | |||
| add FILE[S] | ]></ac:plain-text-body></ac:structured-macro><ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="6a8692c6-6cd6-4ee8-8275-954daf949512"><ac:plain-text-body><![CDATA[<ivyurl> <ivyurl>* add JAR[S] <ivyurl> <ivyurl>* add ARCHIVE[S]<ivyurl> <ivyurl>* | As of Hive 1.2.0, adds one or more files, jars or archives to the list of resources in the distributed cache using an Ivy URL of the form ivy://group:module:version?query_string. See Hive Resources for more information. | ||
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="53b95a8c-60c8-4bac-91cf-4bf2ad02ab66"><ac:plain-text-body><![CDATA[ | See Hive Resources for more information. |
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="89b9181f-177c-41c1-b0ab-d340671a16c8"><ac:plain-text-body><![CDATA[ | . See Hive Resources for more information. |
delete FILE[S] <filepath>* | Removes the resource(s) from the distributed cache. | |||
| delete FILE[S] | ]></ac:plain-text-body></ac:structured-macro><ivyurl> <ivyurl>* delete JAR[S] <ivyurl> <ivyurl>* delete ARCHIVE[S] <ivyurl> <ivyurl>* | As of Hive 1.2.0, removes the resource(s) which were added using the <ivyurl> from the distributed cache. See Hive Resources for more information. | ||
! <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). For a usage example, see Nov. 2013 Hive Contributors Meetup Presentations – Using Dynamic Compilation with Hive. |
Sample Usage:
| No Format |
|---|
hive> set mapred.reduce.tasks=32;
hive> set;
hive> select a.* from tab1;
hive> !ls;
hive> dfs -ls;
|