Zeppelin "sql interpreter not found"

[Andrew Mcleod]

Hi Merlijn,

Can you tell me if this is what you see: http://pasteboard.co/1W9RYYPF.png

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)


Andrew



On Fri, Nov 6, 2015 at 2:38 PM, Merlijn Sebrechts <
merlijn.sebrechts at gmail.com> wrote:

> Hi Andrew
>
>
> 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.
>
>
>
> Kind regards
> Merlijn
>
> 2015-11-06 15:09 GMT+01:00 Andrew Mcleod <andrew.mcleod at canonical.com>:
>
>> Hi Merlijn,
>>
>> 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   (
>> https://zeppelin.incubator.apache.org/docs/interpreter/spark.html) for
>> more details.
>>
>> Try the following in a new paragraph (no %sql interpreter) and if it
>> works, its probably an issue with the %sql interpreter context/binding:
>>
>> sqlContext.sql("SELECT * COUNT(1) from bank")
>>
>> Try restarting the interpreter (interpreters tab, then the restart button
>> next to the interpreter) - then re-run the job that creates the temp table.
>>
>> i.e. this line: "bank.toDF().registerTempTable("bank")"
>>
>> If that doesn't work, try restarting zeppelin completely
>> (/usr/lib/zeppelin/bin/zeppelin-daemon.sh restart)
>>
>>
>> Andrew
>>
>> On Fri, Nov 6, 2015 at 1:59 PM, Merlijn Sebrechts <
>> merlijn.sebrechts at gmail.com> wrote:
>>
>>> Hi Andrew
>>>
>>>
>>> Thanks for your help!
>>>
>>> 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.
>>>
>>> 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?
>>>
>>>
>>> Kind regards
>>> Merlijn
>>>
>>> 2015-11-06 14:42 GMT+01:00 Andrew Mcleod <andrew.mcleod at canonical.com>:
>>>
>>>> Hi Merlijn,
>>>>
>>>> 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.
>>>>
>>>>
>>>> Andrew
>>>>
>>>> On Fri, Nov 6, 2015 at 1:00 PM, Merlijn Sebrechts <
>>>> merlijn.sebrechts at gmail.com> wrote:
>>>>
>>>>> Hi all
>>>>>
>>>>>
>>>>> 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".
>>>>>
>>>>> I basically deployed the realtime rsyslog bundle
>>>>> <https://jujucharms.com/realtime-syslog-analytics/11> 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?
>>>>>
>>>>>
>>>>>
>>>>> Kind regards
>>>>> Merlijn
>>>>>
>>>>> --
>>>>> Bigdata mailing list
>>>>> Bigdata at lists.ubuntu.com
>>>>> Modify settings or unsubscribe at:
>>>>> https://lists.ubuntu.com/mailman/listinfo/bigdata
>>>>>
>>>>>
>>>>
>>>
>>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.ubuntu.com/archives/bigdata/attachments/20151106/9dfc564f/attachment-0001.html>