回覆: Zeppelin 0.8.0 with JDBC to Hive settings
Thank you, I will post the question there. 寄件者: Jeff Zhang 寄件日期: 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 mailto:zjf...@gmail.com>>于2018年10月25日周四 下午9:01写道： >>> java.sql.SQLException: Could not open client transport with JDBC Uri: >>> jdbc:hive2://localhost:1: 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 mailto:lmtc1...@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:1: java.net.ConnectException: Connection refused (Connection refused) Is there anything I shoud do? Thanks for help! Ming
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 于2018年10月25日周四 下午9:01写道： > >>> java.sql.SQLException: Could not open client transport with JDBC Uri: > jdbc:hive2://localhost:1: 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 于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:1: java.net.ConnectException: Connection refused >> (Connection refused) >> >> Is there anything I shoud do? >> >> Thanks for help! >> >> Ming >> >
Re: Zeppelin 0.8.0 with JDBC to Hive settings
>>> java.sql.SQLException: Could not open client transport with JDBC Uri: jdbc:hive2://localhost:1: 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 于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:1: java.net.ConnectException: Connection refused > (Connection refused) > > Is there anything I shoud do? > > Thanks for help! > > Ming >
Zeppelin 0.8.0 with JDBC to Hive settings
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:1: java.net.ConnectException: Connection refused (Connection refused) Is there anything I shoud do? Thanks for help! Ming
