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
