Unable to connect to beeline

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

[nikhilvemula@gw02 ~]$ hostname -f
gw02.itversity.com
[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
username:scott
password:tiger

PFA for reference

Screenshot%20from%202018-06-20%2011-20-06

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?

Hi,
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/