答复: beeline can not connect to hive server2 in hive2 action

[Huang Meilong <im...@outlook.com>]

hi Andrey, where to specify the hiveserver2 url?

________________________________
发件人: MyGmail <am...@gmail.com>
发送时间: 2016年12月7日 16:08:27
收件人: user@oozie.apache.org
主题: Re: beeline can not connect to hive server2 in hive2 action

Hi, check if oozie is launching on the same host where hiveserver2 is running. Try pointing full hostname, not localhost.

Regards,
Andrey

> 7 дек. 2016 г., в 11:03, Huang Meilong <im...@outlook.com> написал(а):
>
> Hi,
>
>
> I have a simple hive2 action in oozie workflow,  the strerr logs indicate that this action can not connect to hiveserver2:
>
>
> INFO: Binding org.apache.hadoop.yarn.webapp.GenericExceptionHandler to GuiceManagedComponentProvider with the scope "Singleton"
> Dec 07, 2016 3:48:52 PM com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory getComponentProvider
> INFO: Binding org.apache.hadoop.mapreduce.v2.app.webapp.AMWebServices to GuiceManagedComponentProvider with the scope "PerRequest"
> Connecting to jdbc:hive2://localhost:10000/default
> Error: Could not open client transport with JDBC Uri: jdbc:hive2://localhost:10000/default: java.net.ConnectException: Connection refused (state=08S01,code=0)
> No current connection
> Intercepting System.exit(2)
> Failing Oozie Launcher, Main class [org.apache.oozie.action.hadoop.Hive2Main], exit code [2]
> log4j:WARN No appenders could be found for logger (org.apache.hadoop.mapreduce.v2.app.MRAppMaster).
> log4j:WARN Please initialize the log4j system properly.
>
>
>
> but the hiveserver2 is on and I can connect to it:
>
>
> [hadoop@emr-header-1 logs]$ beeline -u jdbc:hive2://localhost:10000/default
>
> Connecting to jdbc:hive2://localhost:10000/default
>
> 16/12/07 16:01:41 INFO jdbc.Utils: Supplied authorities: localhost:10000
>
> 16/12/07 16:01:41 INFO jdbc.Utils: Resolved authority: localhost:10000
>
> 16/12/07 16:01:41 INFO jdbc.HiveConnection: Will try to open client transport with JDBC Uri: jdbc:hive2://localhost:10000/default
>
> Connected to: Apache Hive (version 2.0.0)
>
> Driver: Spark Project Core (version 1.6.1)
>
> Transaction isolation: TRANSACTION_REPEATABLE_READ
>
> Beeline version 1.6.1 by Apache Hive
>
> 0: jdbc:hive2://localhost:10000/default>
>
>
>
> What's the problem, do you have any idea?