...
The Beeline CLI supports these command line options:
Option | Usage | Description | |
---|---|---|---|
-u <database URL>beeline -u db_URL | The JDBC URL to connect to. Usage: | ||
-n <username> | -n <username> | beeline -n user1 | The username to connect as. Usage: |
-p <password> | -p <password> | beeline -p user1_password | The password to connect as. Usage: |
-d <driver class> | The driver class to use. Usage: | The driver class to use. | |
-e <query> | Query that should be executed. Usage: Query that should be executed. Version: 0.13.0 (HIVE-5765) | ||
-f <file>beeline -f filepath | Script file that should be executed.executed. Usage: Version: 0.12.0 (HIVE-4268) | ||
--hiveconf property=value | Use value for the given property. Usage: Use value for the given property. Version: 0.13.0 (HIVE-6173) | ||
--hivevar name=valuebeeline --hivevar var1= value1 | Hive variable name and value. This is a Hive-specific setting in which variables can be set Usage: | ||
--color=[true/false]beeline --color=true | Control whether color is used for display. Default is false. Usage:
| ||
beeline --showHeader=[true/false] | Show column names in query results (true) or not (false). Default is true. Usage:
| ||
beeline --headerInterval=50ROWS | The interval for redisplaying column headers, in number of rows, when outputformat is table. Usage: | ||
--fastConnect=[true/false]beeline --fastConnect=false | When connecting, skip building a list of all tables and columns for tab-completion of Usage:
| ||
beeline --autoCommit=[true/false] | Enable/disable automatic transaction commit. Default is false. Usage:
| ||
beeline --verbose=[true/false] | Show verbose error messages and debug information (true) or do not show (false). false. Usage: | ||
--showWarnings=[true/false]beeline --showWarnings=true | Display warnings that are reported on the connection after issuing any HiveQL commands. Usage:
| ||
beeline --showNestedErrs=[true/false] | Display nested errors. Default is false. Usage: | ||
--numberFormat=[pattern] | Format numbers using a DecimalFormat pattern. Usage: | ||
--force=[true/false]beeline--force=true true/false] | Continue running script even after errors (true) or do not continue (false). Default is false. Usage:
| ||
beeline --maxWidth=150MAXWIDTH | The maximum width to display before truncating data, in characters, when outputformat is table. Usage:
| ||
beeline --maxColumnWidth=25MAXCOLWIDTH | The maximum column width, in characters, when outputformat is table. Default is 15. Usage: | ||
--silent=[true/false]beeline --silent=true | Reduce the amount of informational messages displayed (true) or not (false). Default is false. Usage:
| ||
beeline --autosave=[true/false] | Automatically save preferences (true) or do not autosave (false). Default is false. Usage: | ||
--outputformat=[table/vertical/csv/tsv]beeline --outputformat=tsv | Format mode for result display. Default is table. Usage:
| ||
beeline --isolation= SERIALIZABLELEVEL | Set the transaction isolation level to TRANSACTION_READ_COMMITTED Usage: | ||
--nullemptystring=[true/false]beeline --nullemptystring=false | Use historic behavior of printing null as empty string (true) or use current behavior of printing Usage: Version: 0.13.0 (HIVE-4485) | --help||
beeline --help | Display a usage message. Usage: |
JDBC
HiveServer2 has a new JDBC driver. It supports both embedded and remote access to HiveServer2.
...