hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andre Araujo <ara...@pythian.com>
Subject Re: beeline remote client not connecting to hiveserver2
Date Thu, 03 Jul 2014 02:55:29 GMT
Did you explicitly change the HiveServer2 port to 11000? The default is
10000.

Can you provide the output of the following ?

hive -e set | grep hive.server



On 3 July 2014 11:08, Hang Chan <hang@needsystem.com> wrote:

> 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)
>>
>> --
>>
>>
>>
>>
>


-- 
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