Support Questions

Find answers, ask questions, and share your expertise

Zeppelin paragraph delete

avatar
New Contributor

Hello 

 

While using the livy2.sql interpreter in the paragraph and performed select query for example I have done  this :

 %livy2.sql

    select count(*) FROM xxxxxxxxxxxxxxx

 

When you go to run the paragraph does not run , page refreshes and the code in the paragraph gets wiped out .

 

Can someone please assist on this issue.

 

Thanks!

 

 

 

 

 

2 REPLIES 2

avatar
Cloudera Employee

@venkatadach ,

 

Please share below details :

 

1. Screenshots of the issue

2. Are you able to get any results while running the query

3. Zeppelin logs and livy interpreter logs

 

Regards,

Aditya

avatar
New Contributor

Aditya 

 

 1) I dint get a chance to get the screen shot because the page is getting refresh and code gets deleted .

 2 ) After writing the code the page gets refreshes and most recent paragraph gets wiped out after 10 seconds  so I dint have a chance to run code .

As a workaround I tried to removing the parenthesis after count  the code was executed successfully ,with parenthesis count () the page refreshes and code gets wiped out .

%sql
SELECT COUNT * FROM

 

3) I see the below error in logs and couldn't see any other errors while adding the pargaraph.

INFO [2021-06-03 16:58:03,697] xxxxxxxxxxxxxx} NotebookServer.java[onOpen]:150) - New connection from xxxxxxxxxxxxxx: xxxxxxxxxxxxxx
INFO [2021-06-03 16:58:03,753] ({xxxxxxxxxxxxxx} NotebookServer.java[sendNote]:814) - New operation from xxxxxxxxxxxxxx: xxxxxxxxxxxxxx : test-xxxxxxxxxxxxxx
: GET_NOTE : xxxxxxxxxxxxxx
INFO [2021-06-03 16:58:03,759] xxxxxxxxxxxxxx} NotebookServer.java[sendNote]:814) - New operation from xxxxxxxxxxxxxx: xxxxxxxxxxxxxx : test-xxxxxxxxxxxxxx
: GET_NOTE : xxxxxxxxxxxxxx
WARN [2021-06-03 16:58:03,838] ({xxxxxxxxxxxxxx} KnoxJwtRealm.java[validateExpiration]:225) - SSO expiration date validation failed.
WARN [2021-06-03 16:58:03,839] ({xxxxxxxxxxxxxx} KnoxJwtRealm.java[validateToken]:139) - Expiration time validation of JWT token failed.
INFO [2021-06-03 16:58:03,934] xxxxxxxxxxxxxx} NotebookServer.java[onClose]:371) - Closed connection to xxxxxxxxxxxxxx: 36160. (1001) Shutdown
WARN [2021-06-03 16:58:04,171] ({xxxxxxxxxxxxxx} KnoxJwtRealm.java[validateExpiration]:225) - SSO expiration date validation failed.
WARN [2021-06-03 16:58:04,171] ({xxxxxxxxxxxxxx} KnoxJwtRealm.java[validateToken]:139) - Expiration time validation of JWT token failed.
WARN [2021-06-03 16:58:04,183] ({xxxxxxxxxxxxxx} KnoxJwtRealm.java[validateExpiration]:225) - SSO expiration date validation failed.
WARN [2021-06-03 16:58:04,183] ({xxxxxxxxxxxxxx} KnoxJwtRealm.java[validateToken]:139) - Expiration time validation of JWT token failed.
WARN [2021-06-03 16:58:04,560] ({xxxxxxxxxxxxxx} KnoxJwtRealm.java[validateExpiration]:225) - SSO expiration date validation failed.
WARN [2021-06-03 16:58:04,560] ({xxxxxxxxxxxxxx} KnoxJwtRealm.java[validateToken]:139) - Expiration time validation of JWT token failed.