Beeline sample with -u -f -n -p

[#1]

Client tries to execute hive sql inside a file via Beeline.

Anyone has working sample of how to use "beeline -u <url> -n <user> -f <file> -p <password>"? I have tried this, but does not work.

[#2]

/usr/hdp/current/hive-client/bin/beeline -n hrt_qa -p pwd -u "jdbc:hive2://host:2181,host2:2181,host3:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2" --outputformat=tsv -f /grid/0/hadoopqe/artifacts/tmp-820871

[#3]

Forgot to mention, user does not want to show his password in plaintext, he wants to type in prompt...

[#4]

@rxu@hortonworks.com

This worked for me

[root@nsfed01 ~]# beeline -u jdbc:hive2://n2:10000/default -n hive -p hive -f f.sql

SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.

SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]

Connecting to jdbc:hive2://n2:10000/default

Connected to: Apache Hive (version 1.2.1.2.3.2.0-2950)

Driver: Hive JDBC (version 1.2.1.2.3.2.0-2950)

Transaction isolation: TRANSACTION_REPEATABLE_READ

0: jdbc:hive2://n2:10000/default> select * from test;

+----------+-----------+--+

| test.id | test.val |

+----------+-----------+--+

+----------+-----------+--+

No rows selected (0.767 seconds)

0: jdbc:hive2://n2:10000/default>

Closing: 0: jdbc:hive2://n2:10000/default

[root@nsfed01 ~]#

[#5]

Forgot to mention, user does not want to show his password in plaintext, he wants to type in prompt...

[#6 · Accepted solution]

@rxu@hortonworks.com

You can use this

and if you want to prompt for password only then here you go

[root@nsfed01 ~]# cat r1.sh

#read -p "enter HS2 hostname: " HS2

#read -p "enter username: " username

echo "enter password"

read -s passwd

#read -p "enter filename: " filename

beeline -u jdbc:hive2://n3:10000/default -n neeraj -p $passwd -f f.sql

[root@nsfed01 ~]#