hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Hang Chan <h...@needsystem.com>
Subject beeline remote client not connecting to hiveserver2
Date Wed, 02 Jul 2014 17:16:27 GMT
beeline does not seem to be connecting remotely.  It works if I connect
using the embedded client.  I am using all the default configurations,
except I configured my hiveserver2 thrift port to 11000.  If I put in the
database name after the port number, it will prompt me for a username and
password.  I just put in anything, but that doesn't seem to work.  I
thought that by default there should be no authentication.

[hiveclient]# hive --service beeline -u jdbc:hive2://hiveservice:11000
scan complete in 2ms
Connecting to jdbc:hive2://hiveservice:11000
Error: Invalid URL: jdbc:hive2://hiveservice:11000 (state=08S01,code=0)
-hiveconf (No such file or directory)
hive.aux.jars.path=file:.............................
Beeline version 0.12.0 by Apache Hive
0: jdbc:hive2://hiveservice:11000> show tables;
No current connection

[hiveclient]# hive --service beeline -u jdbc:hive2://
scan complete in 3ms
Connecting to jdbc:hive2://
14/07/02 12:37:47 INFO service.CompositeService: HiveServer2: Async
execution pool size50
14/07/02 12:37:47 INFO service.AbstractService: Service:OperationManager is
inited.
14/07/02 12:37:47 INFO service.AbstractService: Service:SessionManager is
inited.
14/07/02 12:37:47 INFO service.AbstractService: Service:CLIService is
inited.
14/07/02 12:37:47 INFO service.AbstractService: Service:OperationManager is
started.
14/07/02 12:37:47 INFO service.AbstractService: Service:SessionManager is
started.
14/07/02 12:37:47 INFO service.AbstractService: Service:CLIService is
started.
14/07/02 12:37:47 INFO hive.metastore: Trying to connect to metastore with
URI thrift://hiveservice:9083
14/07/02 12:37:47 INFO hive.metastore: Waiting 1 seconds before next
connection attempt.
14/07/02 12:37:48 INFO hive.metastore: Connected to metastore.
14/07/02 12:37:48 INFO cli.CLIService: SessionHandle
[7e1279d9-4342-48f1-9c49-1377734062e5]: openSession()
14/07/02 12:37:48 INFO cli.CLIService: SessionHandle
[7e1279d9-4342-48f1-9c49-1377734062e5]: getInfo()
Connected to: Hive (version 0.12.0)
Driver: Hive (version 0.12.0)
Transaction isolation: TRANSACTION_REPEATABLE_READ
-hiveconf (No such file or directory)
hive.aux.jars.path=file:......
Beeline version 0.12.0 by Apache Hive
0: jdbc:hive2://> show tables;
+--------------------------------------------------------+
|                        tab_name                        |
+--------------------------------------------------------+
| abc                                                    |

731 rows selected (2.345 seconds)
14/07/02 12:38:05 INFO exec.ListSinkOperator: 0 finished. closing...
14/07/02 12:38:05 INFO exec.ListSinkOperator: 0 forwarded 0 rows
14/07/02 12:38:05 INFO ql.Driver: <PERFLOG method=releaseLocks>
14/07/02 12:38:05 INFO ql.Driver: </PERFLOG method=releaseLocks
start=1404319085209 end=1404319085209 duration=0>
14/07/02 12:38:05 INFO zookeeper.ZooKeeper: Session: 0x245f6924c200129
closed
14/07/02 12:38:05 INFO zookeeper.ClientCnxn: EventThread shut down
14/07/02 12:38:05 INFO cli.CLIService: OperationHandle
[opType=EXECUTE_STATEMENT,
getHandleIdentifier()=c05a98eb-1077-4732-9b18-c638e0b0a402]: closeOperation
0: jdbc:hive2://>

Thanks,
Hang

Mime
View raw message