Unable to connect to beeline

I am trying to connect to beeline. It throws the following error.

[nikhilvemula@gw02 ~]$ hostname -f
[nikhilvemula@gw02 ~]$ beeline
Beeline version 1.2.1.spark2 by Apache Hive
beeline> !connect jdbc:hive2://gw02.itversity.com/
Connecting to jdbc:hive2://gw02.itversity.com/
Enter username for jdbc:hive2://gw02.itversity.com/: nikhilvemula
Enter password for jdbc:hive2://gw02.itversity.com/: ********************************
2018-06-19 12:54:17 INFO  Utils:310 - Supplied authorities: gw02.itversity.com
2018-06-19 12:54:17 INFO  Utils:397 - Resolved authority: gw02.itversity.com
2018-06-19 12:54:17 INFO  HiveConnection:203 - Will try to open client transport with JDBC Uri: jdbc:hive2://gw02.itversity.com/
2018-06-19 12:54:17 INFO  HiveConnection:208 - Could not open client transport with JDBC Uri: jdbc:hive2://gw02.itversity.com/
2018-06-19 12:54:17 INFO  HiveConnection:229 - Transport Used for JDBC connection: nullError: Could not open client transport with JDBC Uri: jdbc:hive2://gw02.itversity.com/: Cannot open without port. (state=08S01,code=0)
0: jdbc:hive2://gw02.itversity.com/ (closed)>

@nikhil23 You have to use the host nn01.itversity.com, username scott and password is tiger

!connect jdbc:hive2://nn01.itversity.com:10000

PFA for reference


Thanks @BaLu_SaI

Is the username and password same for all? or by default ?

was password get changed? I am trying to login same way but not working

Hello @Vikrant_Singh_Rana the host is changed. please use bellow connection URL with username ‘scott’ and password ‘tiger’.

!connect jdbc:hive2://rm01.itversity.com:10000

1 Like

Thanks. I am able to connect now. Just curious to know that why I am not able to see or run any query on Hive tables. probably they are on other server. is it?

I can access to only those tables which are present there in beeline server.

can we also create table on hive using beeline… is there specific settings there?

I am trying to connect to hive through beeline using this command:

beeline -u jdbc:hive2://

but its not getting connect properly and throwing errors while executing any command inside it. Pls help with the right way to connect.

Hi @deeptii,

First enter into beeline by just typing beeline
then use the following url to connect to hive

!connect jdbc:hive2://gw02.itversity.com:10000/

1 Like

What is the id and password to connect? If I try to use my DB it is giving permission delined error. I tried Scott

Hi @das.nabarun,

Please use your lab login credentials.