回覆: Zeppelin 0.8.0 with JDBC to Hive settings

[Lee Ming-Ta <lm...@hotmail.com>]

Thank you, I will post the question there.
________________________________
寄件者: Jeff Zhang <zj...@gmail.com>
寄件日期: 2018年10月25日 下午 09:01
收件者: Lee Ming-Ta
副本: user@hadoop.apache.org
主旨: Re: Zeppelin 0.8.0 with JDBC to Hive settings

BTW, please ask this kind of question in zeppelin user mail list instead of hadoop mail list.


Jeff Zhang <zj...@gmail.com>>于2018年10月25日周四 下午9:01写道：
>>> java.sql.SQLException: Could not open client transport with JDBC Uri: jdbc:hive2://localhost:10000: java.net.ConnectException: Connection refused (Connection refused)

It looks like due to hive connection issue, Can you first verify whether you can connect to hive in beeline ?


Lee Ming-Ta <lm...@hotmail.com>>于2018年10月25日周四 下午6:01写道：
Dear all, I'm wondering whether anyone would help me with the settings for Zeppelin 0.8.0 using Hive.

As indicated by Apache on Zeppelin website, the interpreter for Hive has been deprecated and merged with JDBC.  However, I cannot use %jdbc(hive) to initiate it in Zeppelin.  All I got is "InterpreterNotFoundException: Either no interpreter named hive or it is not binded to this note".

I've tried following this website: https://zeppelin.apache.org/docs/0.8.0/interpreter/jdbc.html#apache-hive and change the interpreter settings for jdbc (except default.user and default.password).  I also made two links:

hadoop-common.jar -> /usr/local/hadoop/share/hadoop/common/hadoop-common-3.1.1.jar
hive-jdbc.jar -> /usr/local/apache-hive-3.1.0-bin/jdbc/hive-jdbc-3.1.0-standalone.jar

in /usr/local/zeppelin/interpreter/jdbc/.

However, this time I got a different error:

java.sql.SQLException: Could not open client transport with JDBC Uri: jdbc:hive2://localhost:10000: java.net.ConnectException: Connection refused (Connection refused)

Is there anything I shoud do?

Thanks for help!

Ming