<div dir="ltr">Hi Merlijn,<div><br></div><div>Can you tell me if this is what you see: <a href="http://pasteboard.co/1W9RYYPF.png">http://pasteboard.co/1W9RYYPF.png</a></div><div><br></div><div>If so, the default interpreter for the top paragraph is %md, but the others, without a specification, will use %spark as the default (once the save button is clicked to bind the interpreters, that is)</div><div><br></div><div><br></div><div>Andrew</div><div><br></div><div>
<p class=""><br></p></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Fri, Nov 6, 2015 at 2:38 PM, Merlijn Sebrechts <span dir="ltr"><<a href="mailto:merlijn.sebrechts@gmail.com" target="_blank">merlijn.sebrechts@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hi Andrew<div><br></div><div><br></div><div>Thanks again for your help. The problem was that the code to create the table didn't specify which interpreter had to be used. The default interpreter was markdown, so it just printed out the lines. I'll see if I can create patch to the charm.</div><div><br></div><div><br></div><div><br></div><div>Kind regards</div><span class="HOEnZb"><font color="#888888"><div>Merlijn</div></font></span></div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br><div class="gmail_quote">2015-11-06 15:09 GMT+01:00 Andrew Mcleod <span dir="ltr"><<a href="mailto:andrew.mcleod@canonical.com" target="_blank">andrew.mcleod@canonical.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hi Merlijn,<div><br></div><div>I have seen this problem, but don't know the exact cause - I think it has to do with the default spark contexts which are created by zeppelin when it starts the interpreter, specifically the SQLContext, see (<a href="https://zeppelin.incubator.apache.org/docs/interpreter/spark.html" target="_blank">https://zeppelin.incubator.apache.org/docs/interpreter/spark.html</a>) for more details. </div><div><br></div><div>Try the following in a new paragraph (no %sql interpreter) and if it works, its probably an issue with the %sql interpreter context/binding:</div><div><br></div><div><code style="font-size:14.4px;line-height:15.84px;white-space:pre-wrap;font-family:Consolas,'Bitstream Vera Sans Mono','Courier New',Courier,monospace!important;border:0px!important;padding:0px!important;border-radius:0px!important;float:none!important;min-height:auto!important;margin:0px!important;outline:0px!important;overflow:visible!important;vertical-align:baseline!important;width:auto!important;direction:ltr!important;display:inline!important;color:black!important;background:none!important">sqlContext.sql(</code><code style="font-size:14.4px;line-height:15.84px;white-space:pre-wrap;font-family:Consolas,'Bitstream Vera Sans Mono','Courier New',Courier,monospace!important;border:0px!important;padding:0px!important;border-radius:0px!important;float:none!important;min-height:auto!important;margin:0px!important;outline:0px!important;overflow:visible!important;vertical-align:baseline!important;width:auto!important;direction:ltr!important;display:inline!important;color:rgb(42,0,255)!important;background:none!important">"SELECT * COUNT(1) from bank"</code><code style="font-size:14.4px;line-height:15.84px;white-space:pre-wrap;font-family:Consolas,'Bitstream Vera Sans Mono','Courier New',Courier,monospace!important;border:0px!important;padding:0px!important;border-radius:0px!important;float:none!important;min-height:auto!important;margin:0px!important;outline:0px!important;overflow:visible!important;vertical-align:baseline!important;width:auto!important;direction:ltr!important;display:inline!important;color:black!important;background:none!important">)</code></div><div><br></div><div>Try restarting the interpreter (interpreters tab, then the restart button next to the interpreter) - then re-run the job that creates the temp table. </div><div><br></div><div>i.e. this line: "<span style="color:inherit;font-family:Monaco,Menlo,Consolas,'Courier New',monospace;font-size:inherit;line-height:1.42857;white-space:pre-wrap">bank</span><span style="color:inherit;font-family:Monaco,Menlo,Consolas,'Courier New',monospace;font-size:inherit;line-height:1.42857;white-space:pre-wrap;font-weight:bold">.</span><span style="color:inherit;font-family:Monaco,Menlo,Consolas,'Courier New',monospace;font-size:inherit;line-height:1.42857;white-space:pre-wrap">toDF</span><span style="color:inherit;font-family:Monaco,Menlo,Consolas,'Courier New',monospace;font-size:inherit;line-height:1.42857;white-space:pre-wrap;font-weight:bold">().</span><span style="color:inherit;font-family:Monaco,Menlo,Consolas,'Courier New',monospace;font-size:inherit;line-height:1.42857;white-space:pre-wrap">registerTempTable</span><span style="color:inherit;font-family:Monaco,Menlo,Consolas,'Courier New',monospace;font-size:inherit;line-height:1.42857;white-space:pre-wrap;font-weight:bold">(</span><span style="font-family:Monaco,Menlo,Consolas,'Courier New',monospace;font-size:inherit;line-height:1.42857;white-space:pre-wrap;color:rgb(221,17,68);background-color:transparent">"bank"</span><span style="color:inherit;font-family:Monaco,Menlo,Consolas,'Courier New',monospace;font-size:inherit;line-height:1.42857;white-space:pre-wrap;font-weight:bold">)"</span></div><div><span style="color:inherit;font-family:Monaco,Menlo,Consolas,'Courier New',monospace;font-size:inherit;line-height:1.42857;white-space:pre-wrap;font-weight:bold"><br></span></div><div>If that doesn't work, try restarting zeppelin completely (/usr/lib/zeppelin/bin/zeppelin-daemon.sh restart)<span><font color="#888888"><br></font></span></div><span><font color="#888888"><div><br></div><div><br></div><div>Andrew</div></font></span></div><div><div><div class="gmail_extra"><br><div class="gmail_quote">On Fri, Nov 6, 2015 at 1:59 PM, Merlijn Sebrechts <span dir="ltr"><<a href="mailto:merlijn.sebrechts@gmail.com" target="_blank">merlijn.sebrechts@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div><div dir="ltr"><div class="gmail_quote"><div dir="ltr">Hi Andrew<div><br></div><div><br></div><div>Thanks for your help!</div><div><br></div><div>I just figured out my problem: for some reason I thought "blue" meant unselected and "white" meant selected. After selecting the spark interpreter the queries execute, but now I get another error.</div><div><br></div><div>When running the hdfs tutorial notebook, I get the error "no such table List(bank);". This is strange since the "load data into Table" note executed without any errors. I get the same error when I execute the tutorial notes one by one. Any idea what I'm doing wrong now?</div><div><br></div><div><br></div><div>Kind regards</div><span><font color="#888888"><div>Merlijn</div></font></span></div><div><div><div class="gmail_extra"><br><div class="gmail_quote">2015-11-06 14:42 GMT+01:00 Andrew Mcleod <span dir="ltr"><<a href="mailto:andrew.mcleod@canonical.com" target="_blank">andrew.mcleod@canonical.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hi Merlijn,<div><br></div><div>Have you bound the interpreters to the notebook? The first time you use the notebook, the top paragraph will be a list of interpreters. You have to save this to be able to run anything which requires an interpreter definition.</div><div><br></div><div><br></div><div>Andrew</div></div><div class="gmail_extra"><br><div class="gmail_quote"><div><div>On Fri, Nov 6, 2015 at 1:00 PM, Merlijn Sebrechts <span dir="ltr"><<a href="mailto:merlijn.sebrechts@gmail.com" target="_blank">merlijn.sebrechts@gmail.com</a>></span> wrote:<br></div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div><div dir="ltr">Hi all<div><br></div><div><br></div><div>I'm trying to get Zeppelin working. Installing works fine, but when I run the hdfs notebook, the query parts fail with following error: "sql interpreter not found".</div><div><br></div><div>I basically deployed the <a href="https://jujucharms.com/realtime-syslog-analytics/11" target="_blank">realtime rsyslog bundle</a> without the rsyslog and flume parts. I thought this bundle was working since I saw it at a demo during the summit. Any ideas to what might be wrong here?</div><div><br></div><div><br></div><div><br></div><div>Kind regards</div><span><font color="#888888"><div>Merlijn</div></font></span></div>
<br></div></div><span><font color="#888888">--<br>
Bigdata mailing list<br>
<a href="mailto:Bigdata@lists.ubuntu.com" target="_blank">Bigdata@lists.ubuntu.com</a><br>
Modify settings or unsubscribe at: <a href="https://lists.ubuntu.com/mailman/listinfo/bigdata" rel="noreferrer" target="_blank">https://lists.ubuntu.com/mailman/listinfo/bigdata</a><br>
<br></font></span></blockquote></div><br></div>
</blockquote></div><br></div>
</div></div></div><br></div>
</div></div></blockquote></div><br></div>
</div></div></blockquote></div><br></div>
</div></div></blockquote></div><br></div>