If the name "hiveserver" is not resolved correctly, that's the exact error you'd getting. Does "nslookup hiveservice" resolve the name successfully?
Try using the fully qualified name instead. On 3 July 2014 07:01, Szehon Ho <sze...@cloudera.com> wrote: > 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 >> >> > -- André Araújo Big Data Consultant/Solutions Architect The Pythian Group - Australia - www.pythian.com Office (calls from within Australia): 1300 366 021 x1270 Office (international): +61 2 8016 7000 x270 *OR* +1 613 565 8696 x1270 Mobile: +61 410 323 559 Fax: +61 2 9805 0544 IM: pythianaraujo @ AIM/MSN/Y! or ara...@pythian.com @ GTalk “Success is not about standing at the top, it's the steps you leave behind.” — Iker Pou (rock climber) -- --
