hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Hang Chan <h...@needsystem.com>
Subject Re: beeline remote client not connecting to hiveserver2
Date Thu, 03 Jul 2014 01:08:56 GMT
It's not a dns problem.  I just substituted my real server name with
"hiveservice".  I confirmed that the hostname is indeed resolvable in dns.
 I also tried using the ip address in place of the hostname and I still get
the same error.


On Wed, Jul 2, 2014 at 5:36 PM, Andre Araujo <araujo@pythian.com> wrote:

> 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 <szehon@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 <hang@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 araujo@pythian.com @ GTalk
>
> “Success is not about standing at the top, it's the steps you leave behind.”
> — Iker Pou (rock climber)
>
> --
>
>
>
>

Mime
View raw message