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