beeline 命令

常用示例

说明

Beeline is a JDBC command-line client for HiveServer2, based on SQLLine CLI. It provides an interface to execute Hive queries against a HiveServer2 instance, supporting both embedded mode (running an embedded Hive) and remote mode (connecting over Thrift). Remote mode is recommended for production use as it is more secure and does not require direct HDFS or metastore access. Beeline connects to HiveServer2 which runs on port 10000 by default. The client supports various authentication methods including Kerberos, LDAP, and custom authentication. Connection URLs can include session variables, Hive configuration parameters, and connection properties. Beeline supports ZooKeeper-based service discovery, SSL/TLS connections, and HTTP transport mode for firewall-friendly deployments.

参数

-u _URL_

JDBC connection URL (e.g., jdbc:hive2://localhost:10000/default).

-n _USERNAME_

Username for authentication.

-p _PASSWORD_

Password for authentication.

-w _FILE_

Path to file containing password.

-d _DRIVER_

JDBC driver class to use.

-e _QUERY_

Execute query string. Multiple statements can be separated by semicolons.

-f _FILE_

Execute SQL script from file.

-i, --init _FILE_

Run initialization file before executing commands.

-r

Reconnect to previously used URL (since Hive 2.1.0).

--outputformat _FORMAT_

Output format: table, vertical, csv, tsv, dsv, csv2, tsv2, json, jsonfile.

--showHeader

Display column names in output (default: true).

--silent

Suppress informational messages and query logs.

--verbose

Show debug information and error details.

--hiveconf _KEY_=_VALUE_

Set Hive configuration property.

--hivevar _KEY_=_VALUE_

Define Hive session variable.

--force

Continue script execution despite errors.

--incremental

Display rows immediately as fetched.

--help

Display usage message.