You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@zeppelin.apache.org by Joel Van Veluwen <Jo...@quantium.com.au> on 2016/01/07 03:42:34 UTC
Copy and paste ASCII control character errors in Zeppelin
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.
RE: Copy and paste ASCII control character errors in Zeppelin
Posted by Joel Van Veluwen <Jo...@quantium.com.au>.
Thanks Jongyoul, Moon
I've raised an issue here - https://issues.apache.org/jira/browse/ZEPPELIN-577https://issues.apache.org/jira/browse/ZEPPELIN-577
Let me know if you need any additional information.
Cheers,
Joel
________________________________
From: Jongyoul Lee [jongyoul@gmail.com]
Sent: Saturday, 9 January 2016 12:22 PM
To: users@zeppelin.incubator.apache.org
Subject: Re: Copy and paste ASCII control character errors in Zeppelin
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 <mo...@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.VanVeluwen@quantium.com.au<UrlBlockedError.aspx>> 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
Re: Copy and paste ASCII control character errors in Zeppelin
Posted by Jongyoul Lee <jo...@gmail.com>.
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 <mo...@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.VanVeluwen@quantium.com.au
> <javascript:_e(%7B%7D,'cvml','Joel.VanVeluwen@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
Re: Copy and paste ASCII control character errors in Zeppelin
Posted by moon soo Lee <mo...@apache.org>.
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.VanVeluwen@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.
>
>
>