...
Info | ||
---|---|---|
| ||
If you'd like to connect via NOSASL mode, you must specify the authentication mode explicitly: % bin/beeline |
Beeline Commands
Use ";" (semicolon) to terminate commands. Comments in scripts can be specified using the "--" prefix.
Command | Description |
---|---|
!<SQLLine command> | List of SQLLine commands available at http://sqlline.sourceforge.net/. Example: !quit exits the beeline client. |
Beeline Hive Commands
Hive specific commands (same as hive cli commands) can be run from beeline, when the hive jdbc driver is used.
Use ";" (semicolon) to terminate commands. Comments in scripts can be specified using the "--" prefix.
Command | Description |
---|---|
reset | Resets the configuration to the default values. |
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. |
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 below for more information. |
list FILE[S] | Lists the resources already added to the distributed cache. See Hive Resources below for more information. (As of Hive 0.14.0: HIVE-7592). |
list FILE[S] <filepath>* | Checks whether the given resources are already added to the distributed cache or not. See Hive Resources below for more information. |
delete FILE[S] <filepath>* | Removes the resource(s) from the distributed cache. |
dfs <dfs command> | Executes a dfs command. |
<query string> | Executes a Hive query and prints results to standard output. |
Beeline Command Options
The Beeline CLI supports these command line options:
...