Unable to connect to beeline

hive

#1

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)>

Where to find Hive Beeline credentials
#2

@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


#3

Thanks @BaLu_SaI

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