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 03:12:17 GMT
hive.server.read.socket.timeout=10
hive.server.tcp.keepalive=true
hive.server2.async.exec.shutdown.timeout=10
hive.server2.async.exec.threads=50
hive.server2.authentication=NONE
hive.server2.enable.doAs=true
hive.server2.table.type.mapping=CLASSIC
hive.server2.thrift.http.max.worker.threads=500
hive.server2.thrift.http.min.worker.threads=5
hive.server2.thrift.http.path=cliservice
hive.server2.thrift.http.port=10001
hive.server2.thrift.max.worker.threads=500
hive.server2.thrift.min.worker.threads=5
hive.server2.thrift.port=11000
hive.server2.thrift.sasl.qop=auth
hive.server2.transport.mode=binary


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

> 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