[jira] [Created] (ZEPPELIN-577) ASCII control character errors in Zeppelin

["Joel Van Veluwen (JIRA)" <ji...@apache.org>]

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)