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> 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.
>
>
>
