Hive - URI (Connection URL )

Card Puncher Data Processing

is the corresponding HTTP endpoint. Default value is cliservice or /. See conf hive.server2.thrift.http.path
  • transportMode : Hive - Transport Mode. Default port for HTTP transport mode is 10001. See conf hive.server2.thrift.http.port
Embedded
In the embedded mode, the client runs an embedded Hive (similar to Hive CLI)
jdbc:hive2:///;initFile=<file> (no host or port).
If the Hadoop cluster uses SSL or TLS authentication, you must add ssl=true to the JDBC connectionURI.
jdbc:hive2://<hostname>:<port>/<db>;ssl=true
Example
Azure
Zookeeper Quorum
  • Zookeeper Quorum
jdbc:hive2://zk0-hi-clu.3qy32mhqlj1ubaea5iyw5joamf.ax.internal.cloudapp.net:2181,zk1-hi-clu.3qy32mhqlj1ubaea5iyw5joamf.ax.internal.cloudapp.net:2181,zk6-hi-clu.3qy32mhqlj1ubaea5iyw5joamf.ax.internal.cloudapp.net:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2
Headnode
  • Headnode (Example Azure with default database)
jdbc:hive2://headnode:10001/default/;transportMode=http;httpPath=/hive2
Support
Invalid status 72 (state=08S01,code=0)
beeline> !connect jdbc:hive2://localhost:10001/default; user pwd
Connecting to jdbc:hive2://localhost:10001/default;
18/05/28 10:38:09 [main]: WARN jdbc.HiveConnection: Failed to connect to localhost:10001
Error: Could not open client transport with JDBC Uri: jdbc:hive2://localhost:10001/default;: Invalid status 72 (state=08S01,code=0)

Error 72 is a bad url issueTry to add the transport mode, it 's mandatory if you are in http transport mode
jdbc:hive2://headnode:10001/default/;transportMode=http;httpPath=/hive2

Documentation / Reference





Discover More
Card Puncher Data Processing
Hive - Authentication

hive.server2.authentication - property NONE: no authentication check –...
Card Puncher Data Processing
Hive - Beeline

Beeline is a JDBC client that is based on the SQLLine CLI The Beeline shell works in both embedded mode as well as remote mode. bash beeline with connect beeline URL in environment variable...
Card Puncher Data Processing
Hive - Connection

A connection is made through: a client via an See for instance Beeline
Card Puncher Data Processing
Hive - Database

All table in hive are in a database. The database: has a namespaces function are used to enforce security for a user or group of users. Qualify the table names db_name.table_name Set it...
Card Puncher Data Processing
Hive - JDBC

JDBC information on Hive Example: hadoop-core-1.2.1.jar hive-jdbc-2.3.2.jar hive-jdbc--standalone.jar. Example: ...
Card Puncher Data Processing
Hive - Transport Mode

The transport mode is the network protcol used to made a connection HTTP mode is required when a proxy is needed between the client and server (for example, for load balancing or security reasons)....
Card Puncher Data Processing
Hive - Variable (hivevar)

Hive variables are variables that can be set at the session level and referenced in Hive commands or queries. --hivevar options hivevar Example with and a URL Select with substituion...



Share this page:
Follow us:
Task Runner