Use quit or exit to leave the interactive shell.
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).
Sets the value of a particular configuration variable (key).
Prints a list of configuration variables that are overridden by the user or Hive.
Prints all Hadoop and Hive configuration variables.
add FILE[S] <filepath> <filepath>*
Adds one or more files, jars, or archives to the list of resources in the distributed cache.
Lists the resources already added to the distributed cache.
list FILE[S] <filepath>*
Checks whether the given resources are already added to the distributed cache or not.
delete FILE[S] <filepath>*
Removes the resource(s) from the distributed cache.
Executes a shell command from the Hive shell.
dfs <dfs command>
Executes a dfs command from the Hive shell.
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.