Joel Van Veluwen created ZEPPELIN-577:
-----------------------------------------
Summary: ASCII control character errors in Zeppelin
Key: ZEPPELIN-577
URL: https://issues.apache.org/jira/browse/ZEPPELIN-577
Project: Zeppelin
Issue Type: Bug
Affects Versions: 0.5.5
Reporter: Joel Van Veluwen
My Zeppelin notebook was throwing some “sql interpreter not found” exceptions
on code that has worked before.
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 ",
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
},
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
