I believe you should be able to put in anything by default. The hive jdbc url is of the form jdbc:hive2://<host>:<port>, is the url correct?
Thanks, Szehon On Wed, Jul 2, 2014 at 10:16 AM, Hang Chan <h...@needsystem.com> wrote: > 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 > >
