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.
