question Re: How to configure hive so beeline does not ask for password? in Archives of Support Questions (Read Only)

How to configure hive so beeline does not ask for password?

arindam1 — Thu, 22 Nov 2018 01:34:54 GMT

Hi,

Now when I try to connect to hive, it asks me for username and password:

$ beeline 
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/usr/hdp/3.0.1.0-187/hive/lib/log4j-slf4j-impl-2.10.0.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/usr/hdp/3.0.1.0-187/hadoop/lib/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory]
Connecting to jdbc:hive2://follower-2.europe-west3-b.c.XXXXXX.internal:2181,follower-1.europe-west3-b.c.XXXXXX.internal:2181,follower-3.europe-west3-b.c.XXXXXX.internal:2181/default;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2
Enter username for jdbc:hive2://follower-2.europe-west3-b.c.XXXXXX.internal:2181,follower-1.europe-west3-b.c.XXXXXX.internal:2181,follower-3.europe-west3-b.c.XXXXXX.internal:2181/default: username
Enter password for jdbc:hive2://follower-2.europe-west3-b.c.XXXXXX.internal:2181,follower-1.europe-west3-b.c.XXXXXX.internal:2181,follower-3.europe-west3-b.c.XXXXXX.internal:2181/default: ****************
18/11/21 16:30:23 [main]: INFO jdbc.HiveConnection: Connected to leader-1.europe-west3-b.c.XXXXXX.internal:10000
Connected to: Apache Hive (version 3.1.0.3.0.1.0-187)
Driver: Hive JDBC (version 3.1.0.3.0.1.0-187)
Transaction isolation: TRANSACTION_REPEATABLE_READ
Beeline version 3.1.0.3.0.1.0-187 by Apache Hive
0: jdbc:hive2://follower-2.europe-west3-b.c.i>

How can I configure it so it does not ask for username/password?

I have several users connecting to it. Can I have different username/password for each user if disabling it is not possible?

Best Regards,

Arindam

Re: How to configure hive so beeline does not ask for password?

jknulst — Thu, 22 Nov 2018 06:16:37 GMT

@Arindam Choudhury I think the only way to do it is to set the Hiveserver2 to 'No authentication' mode.

If you really want anyone to connect anonymously that is what you could do.

Re: How to configure hive so beeline does not ask for password?

quadoss — Thu, 22 Nov 2018 06:21:21 GMT

@Arindam Choudhury ,

You can use the below link which talks about creating a file called beeline-hs2-connection.xml and providing the credentials information there.

https://cwiki.apache.org/confluence/display/Hive/HiveServer2+Clients#HiveServer2Clients-Usinghive-site.xmltoautomaticallyconnecttoHiveServer2

Re: How to configure hive so beeline does not ask for password?

jagadeesan — Thu, 22 Nov 2018 10:38:59 GMT

@Arindam Choudhury

You can use the -n & -p options to specify the username and password. For instance:

beeline -u jdbc:hive2://follower-2.europe-west3-b.c.XXXXXX.internal:10000/default -n username -p password

Also instead of passing password it in plaintext as option '-p', we read a password from a permission-protected password file instead, For instance:

beeline -u jdbc:hive2://follower-2.europe-west3-b.c.XXXXXX.internal:10000/default -n username -w password_file

In short answer for your questions, when the beeline-hs2-connection.xml is present and when no other arguments are provided, Beeline automatically connects to the URL generated using configuration files. When connection arguments (-u, -n or -p) are provided, Beeline uses them and does not use beeline-hs2-connection.xml to automatically connect.

For more details you can refer below links.

https://issues.apache.org/jira/browse/HIVE-14063

https://cwiki.apache.org/confluence/display/Hive/HiveServer2+Clients

Please accept the answer you found most useful

Re: How to configure hive so beeline does not ask for password?

arindam1 — Thu, 22 Nov 2018 18:21:57 GMT

Hi @Mahesh Balakrishnan,

How can I add beeline-hs2-connection.xml? I can not find it in ambari server page.

Thanks,

Re: How to configure hive so beeline does not ask for password?

arindam1 — Thu, 22 Nov 2018 19:07:40 GMT

I created /etc/hive/conf/beeline-hs2-connection.xml and it worked.

Thanks