Hi Joel,
It looks like a parsing problem of splitting the type of interpreters
and query or command from paragraph text. Could you please make an issue?
Regards,
Jongyoul
On Thursday, 7 January 2016, moon soo Lee <m...@apache.org> wrote:
> Hi Joel,
>
> Thanks for sharing the problem and detailed information.
> Please feel free to file an issue if you don't mind :)
>
> Best,
> moon
>
> On Wed, Jan 6, 2016 at 6:43 PM Joel Van Veluwen <
> joel.vanvelu...@quantium.com.au
> <javascript:_e(%7B%7D,'cvml','joel.vanvelu...@quantium.com.au');>> wrote:
>
>> Hey Guys,
>>
>>
>>
>> (let me know if this should be on the dev mailing list)
>>
>>
>>
>> I’m working with a Zeppelin notebook at the moment and was getting some
>> “sql interpreter not found” exceptions on code that has worked before.
>>
>>
>>
>> I’m using Zeppelin version 0.55 on cluster mode with Spark 1.5.2
>>
>>
>>
>> Investigating the issue it looks like when you paste from an ascii
>> character set the cell in Zeppelin uses the ascii control characters.
>>
>>
>>
>> This means if I go to the top of the pasted content and add my
>> interpreter and a few new lines I’ll get a “sql interpreter not found”
>> because my cell in the json file is actually:
>>
>>
>>
>> "text": "%sql\r\nSELECT\r\n STORE_NBR\r\nFROM
>> pss_subset_primary_key_hy_2\r\nWHERE START_TXN_DATE \u003d
>> \u00272015-01-03\u0027\r\nlimit 10 ",
>>
>>
>>
>> I can even get the code to work by adding a space after the interpreter
>> is defined…
>>
>>
>>
>> "text": "%sql \r\nSELECT\r\n STORE_NBR\r\nFROM
>> pss_subset_primary_key_hy_2\r\nWHERE START_TXN_DATE \u003d
>> \u00272015-01-03\u0027\r\nlimit 10 ",
>>
>>
>>
>> Can I raise this on the issue tracker or is this a known issue?
>>
>>
>>
>> The code from the note.json is below
>>
>>
>>
>> {
>>
>> "text": "%sql\r\nSELECT\r\n STORE_NBR\r\nFROM
>> pss_subset_primary_key_hy_2\r\nWHERE START_TXN_DATE \u003d
>> \u00272015-01-03\u0027\r\nlimit 10 ",
>>
>> "dateUpdated": "Jan 7, 2016 2:34:43 AM",
>>
>> "config": {
>>
>> "colWidth": 12.0,
>>
>> "graph": {
>>
>> "mode": "table",
>>
>> "height": 300.0,
>>
>> "optionOpen": false,
>>
>> "keys": [],
>>
>> "values": [],
>>
>> "groups": [],
>>
>> "scatter": {}
>>
>> }
>>
>> },
>>
>> "settings": {
>>
>> "params": {},
>>
>> "forms": {}
>>
>> },
>>
>> "jobName": "paragraph_1452133571259_-595623495",
>>
>> "id": "20160107-022611_1098349977",
>>
>> "result": {
>>
>> "code": "ERROR",
>>
>> "type": "TEXT",
>>
>> "msg": "sql\r interpreter not found"
>>
>> },
>>
>> "dateCreated": "Jan 7, 2016 2:26:11 AM",
>>
>> "status": "ERROR",
>>
>> "errorMessage": "",
>>
>> "progressUpdateIntervalMs": 500
>>
>> },
>>
>> {
>>
>> "text": "%sql \r\nSELECT\r\n STORE_NBR\r\nFROM
>> pss_subset_primary_key_hy_2\r\nWHERE START_TXN_DATE \u003d
>> \u00272015-01-03\u0027\r\nlimit 10 ",
>>
>> "dateUpdated": "Jan 7, 2016 2:34:59 AM",
>>
>> "config": {
>>
>> "colWidth": 12.0,
>>
>> "graph": {
>>
>> "mode": "table",
>>
>> "height": 300.0,
>>
>> "optionOpen": false,
>>
>> "keys": [],
>>
>> "values": [],
>>
>> "groups": [],
>>
>> "scatter": {}
>>
>> },
>>
>> "editorMode": "ace/mode/sql"
>>
>> },
>>
>> "settings": {
>>
>> "params": {},
>>
>> "forms": {}
>>
>> },
>>
>> "jobName": "paragraph_1452134083966_951017822",
>>
>> "id": "20160107-023443_1383427793",
>>
>> "result": {
>>
>> "code": "SUCCESS",
>>
>> "type": "TABLE",
>>
>> "msg":
>> "STORE_NBR\n0116\n0116\n0116\n0116\n0116\n0117\n0117\n0117\n0117\n0117\n"
>>
>> },
>>
>> "dateCreated": "Jan 7, 2016 2:34:43 AM",
>>
>> "dateStarted": "Jan 7, 2016 2:34:59 AM",
>>
>> "dateFinished": "Jan 7, 2016 2:35:01 AM",
>>
>> "status": "FINISHED",
>>
>> "progressUpdateIntervalMs": 500
>>
>> },
>>
>>
>>
>>
>>
>> Cheers,
>>
>>
>>
>> Joel
>>
>>
>>
>> Joel Van Veluwen
>> *QUANTIUM*
>> Level 25, 8 Chifley
>> 8-12 Chifley Square
>> Sydney NSW 2000
>>
>> T: +61 2 8224 8981
>> M: +61 403 153 265
>> F: +61 2 9292 6444
>>
>> W: quantium.com.au <http://www.quantium.com.au>
>> ------------------------------
>>
>> linkedin.com/company/quantium <http://www.linkedin.com/company/quantium>
>> facebook.com/QuantiumAustralia
>> <http://www.facebook.com/QuantiumAustralia>
>> twitter.com/QuantiumAU <http://www.twitter.com/QuantiumAU>
>>
>> The contents of this email, including attachments, may be confidential
>> information. If you are not the intended recipient, any use, disclosure or
>> copying of the information is unauthorised. If you have received this email
>> in error, we would be grateful if you would notify us immediately by email
>> reply, phone (+ 61 2 9292 6400) or fax (+ 61 2 9292 6444) and delete the
>> message from your system.
>>
>>
>>
>
--
이종열, Jongyoul Lee, 李宗烈
http://madeng.net
