Geek Answers Handbook

How to get database username and password in the hive

I am writing a jdbc program to connect a hive database. I want the username and password to be displayed in the connection url.

I don't know how to get username and password using hive QL. Can someone help me?

Exception in thread "main" java.sql.SQLNonTransientConnectionException: [DataDirect][Hive JDBC Driver]A value was not specified for a required property: PASSWORD
    at com.ddtek.jdbc.hivebase.ddcp.b(Unknown Source)
    at com.ddtek.jdbc.hivebase.ddcp.a(Unknown Source)
    at com.ddtek.jdbc.hivebase.ddco.b(Unknown Source)
    at com.ddtek.jdbc.hivebase.ddco.a(Unknown Source)
    at com.ddtek.jdbc.hive.HiveImplConnection.b(Unknown Source)
    at com.ddtek.jdbc.hivebase.BaseConnection.b(Unknown Source)
    at com.ddtek.jdbc.hivebase.BaseConnection.k(Unknown Source)
    at com.ddtek.jdbc.hivebase.BaseConnection.b(Unknown Source)
    at com.ddtek.jdbc.hivebase.BaseConnection.a(Unknown Source)
    at com.ddtek.jdbc.hivebase.BaseDriver.connect(Unknown Source)
    at java.sql.DriverManager.getConnection(DriverManager.java:571)
    at java.sql.DriverManager.getConnection(DriverManager.java:215)
    at hivejdbcconnection.HiveJdbcConnection.main(HiveJdbcConnection.java:33)
Java Result: 1
+4
source share
2 answers

To get the username and password for the hive, go to hive-site.xmland search for javax.jdo.option.ConnectionUserNameand javax.jdo.option.ConnectionPassword. The values ​​for these properties are your hive name and password, respectively.

(The default values ​​for APPboth minethe username and password can be found in hive-default.xml)

, hive-site.xml. hive-site.xml:

<property>
<name>javax.jdo.option.ConnectionUserName</name>
<value>hiveuser</value>
</property>
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>hivepass</value>
</property>
<property>
<name>javax.jdo.option.ConnectionDriverName</name>
<value>com.mysql.jdbc.Driver</value>
</property>
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://localhost:3306/hadoop</value>
</property>

. hadoop mysql . javax.jdo.option.ConnectionURL jdbc:mysql://localhost:3306/hadoop.

:

Connection con = DriverManager.getConnection("jdbc:hive2://localhost:10000/default", "hiveuser", "hivepass");

hive database name default. , !!!!

+5

hive hive

hiveserver2

"jdbc:hive2://localhost:10000/default", "hive", ""

hiveserver1 , hiveserver2 .

jdbc:hive://localhost:10000/default

: org.apache.hadoop.hive.jdbc.HiveDriver

Beeline

0

More articles:


All Articles