[prev in list] [next in list] [prev in thread] [next in thread]
List: hadoop-user
Subject: =?gb2312?B?u9i4sjogWmVwcGVsaW4gMC44LjAgd2l0aCBKREJDIHRvIEhpdmUgc2V0dGlu?= =?gb2312?Q?gs?=
From: Lee Ming-Ta <lmtc1111 () hotmail ! com>
Date: 2018-10-26 1:29:27
Message-ID: HK0PR01MB200455B4D4C9477EAC02C402D9F00 () HK0PR01MB2004 ! apcprd01 ! prod ! exchangelabs ! com
[Download RAW message or body]
[Attachment #2 (text/plain)]
Thank you, I will post the question there.
________________________________
¼Ä¼þÕß: Jeff Zhang <zjffdu@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 <zjffdu@gmail.com<mailto:zjffdu@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 <lmtc1111@hotmail.com<mailto:lmtc1111@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
[Attachment #3 (text/html)]
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} \
</style> </head>
<body dir="ltr">
<div style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; \
color:rgb(0,0,0)"> Thank you, I will post the question there.</div>
<div style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; \
color:rgb(0,0,0)"> </div>
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" color="#000000" \
style="font-size:11pt"><b>¼Ä¼þÕß:</b> Jeff Zhang <zjffdu@gmail.com><br> \
<b>¼Ä¼þÈÕÆÚ:</b> 2018Äê10Ô 25ÈÕ Ï Îç 09:01<br> <b>ÊÕ¼þÕß:</b> Lee Ming-Ta<br>
<b>¸±±¾:</b> user@hadoop.apache.org<br>
<b>Ö÷Ö¼:</b> Re: Zeppelin 0.8.0 with JDBC to Hive settings</font>
<div> </div>
</div>
<meta content="text/html; charset=utf-8">
<div>
<div dir="ltr">BTW, please ask this kind of question in zeppelin user mail list \
instead of hadoop mail list. <div><br>
</div>
</div>
<br>
<div class="x_gmail_quote">
<div dir="ltr">Jeff Zhang <<a \
href="mailto:zjffdu@gmail.com">zjffdu@gmail.com</a>>ÓÚ2018Äê10Ô 25ÈÕÖÜËÄ Ï \
Îç9:01дµÀ£º<br> </div>
<blockquote class="x_gmail_quote" style="margin:0 0 0 .8ex; border-left:1px #ccc \
solid; padding-left:1ex"> <div dir="ltr">>>> <span \
style="font-family:Calibri,Helvetica,sans-serif; \
font-size:16px">java.sql.SQLException: Could not open client transport with JDBC Uri: \
jdbc:hive2://localhost:10000: java.net.ConnectException: Connection refused \
(Connection refused)</span> <div><span \
style="font-family:Calibri,Helvetica,sans-serif; font-size:16px"><br> </span></div>
</div>
<div dir="ltr">
<div><span style="font-family:Calibri,Helvetica,sans-serif; font-size:16px">It looks \
like due to hive connection issue, Can you first verify whether you can connect to \
hive in beeline ?</span></div> <div><span \
style="font-family:Calibri,Helvetica,sans-serif; font-size:16px"><br> </span></div>
</div>
<br>
<div class="x_gmail_quote">
<div dir="ltr">Lee Ming-Ta <<a href="mailto:lmtc1111@hotmail.com" \
target="_blank">lmtc1111@hotmail.com</a>>ÓÚ2018Äê10Ô 25ÈÕÖÜËÄ Ï Îç6:01дµÀ£º<br> \
</div> </div>
<div class="x_gmail_quote">
<blockquote class="x_gmail_quote" style="margin:0 0 0 .8ex; border-left:1px #ccc \
solid; padding-left:1ex"> <div dir="ltr">
<div style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; \
color:rgb(0,0,0)"> Dear all, I'm wondering whether anyone would help me with the \
settings for Zeppelin 0.8.0 using Hive.</div> <div \
style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)"> \
<br> </div>
<div style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; \
color:rgb(0,0,0)"> 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".</div> <div \
style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)"> \
<br> </div>
<div style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; \
color:rgb(0,0,0)"> I've tried following this website: <a \
href="https://zeppelin.apache.org/docs/0.8.0/interpreter/jdbc.html#apache-hive" \
id="x_m_-6232233935839951098m_8373806572866352426LPNoLP759270" \
target="_blank">https://zeppelin.apache.org/docs/0.8.0/interpreter/jdbc.html#apache-hive</a> <span \
style="color:rgb(0,0,0); font-family:Calibri,Helvetica,sans-serif; \
font-size:12pt">and change the interpreter settings for jdbc (except </span><span \
style="color:rgb(0,0,0); font-family:Calibri,Helvetica,sans-serif; \
font-size:12pt">default.user and </span><span style="color:rgb(0,0,0); \
font-family:Calibri,Helvetica,sans-serif; font-size:12pt">default.password). I \
also made two links:</span></div> <div \
style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)"> \
<span style="color:rgb(0,0,0); font-family:Calibri,Helvetica,sans-serif; \
font-size:12pt"><br> </span></div>
<div style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; \
color:rgb(0,0,0)"> <span style="color:rgb(0,0,0); \
font-family:Calibri,Helvetica,sans-serif; font-size:12pt">hadoop-common.jar -> \
/usr/local/hadoop/share/hadoop/common/hadoop-common-3.1.1.jar<br> </span></div>
<div style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; \
color:rgb(0,0,0)"> <span style="color:rgb(0,0,0); \
font-family:Calibri,Helvetica,sans-serif; font-size:12pt">hive-jdbc.jar -> \
/usr/local/apache-hive-3.1.0-bin/jdbc/hive-jdbc-3.1.0-standalone.jar<br> \
</span></div> <div style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; \
color:rgb(0,0,0)"> <span style="color:rgb(0,0,0); \
font-family:Calibri,Helvetica,sans-serif; font-size:12pt"><br> </span></div>
<div style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; \
color:rgb(0,0,0)"> <span style="color:rgb(0,0,0); \
font-family:Calibri,Helvetica,sans-serif; \
font-size:12pt">in /usr/local/zeppelin/interpreter/jdbc/</span><span \
style="color:rgb(0,0,0); font-family:Calibri,Helvetica,sans-serif; \
font-size:12pt">.</span></div> <div style="font-family:Calibri,Helvetica,sans-serif; \
font-size:12pt; color:rgb(0,0,0)"> <span style="color:rgb(0,0,0); \
font-family:Calibri,Helvetica,sans-serif; font-size:12pt"><br> </span></div>
<div style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; \
color:rgb(0,0,0)"> <span style="color:rgb(0,0,0); \
font-family:Calibri,Helvetica,sans-serif; font-size:12pt">However, this time I got a \
different error:</span></div> <div style="font-family:Calibri,Helvetica,sans-serif; \
font-size:12pt; color:rgb(0,0,0)"> <br>
</div>
<div style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; \
color:rgb(0,0,0)">
java.sql.SQLException: Could not open client transport with JDBC Uri: \
jdbc:hive2://localhost:10000: java.net.ConnectException: Connection refused \
(Connection refused)</div> <div style="font-family:Calibri,Helvetica,sans-serif; \
font-size:12pt; color:rgb(0,0,0)"> <br>
</div>
<div style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; \
color:rgb(0,0,0)"> Is there anything I shoud do?</div>
<div style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; \
color:rgb(0,0,0)"> <br>
</div>
<div style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; \
color:rgb(0,0,0)"> Thanks for help!</div>
</div>
<div dir="ltr">
<div style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; \
color:rgb(0,0,0)"> <br>
</div>
<div style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; \
color:rgb(0,0,0)"> Ming</div>
</div>
</blockquote>
</div>
</blockquote>
</div>
</div>
</body>
</html>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic