Support Questions
Find answers, ask questions, and share your expertise

How to ensure hive session close properly in Zeppelin

Solved Go to solution
Highlighted

How to ensure hive session close properly in Zeppelin

New Contributor

Hi, i am new to hadoop, just start exploring in Zeppelin Hive. I had tried to create temporarily table as simple as below

%jdbc(hive)

CREATE TEMPORARY TABLE tmp1 (c1 string);


Then I logout and re-login, I still able to view the table. How to close the HIVE session properly?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: How to ensure hive session close properly in Zeppelin

Super Guru

@HanYan Tan

Could you look into zeppelin-4140 jira is reported for the same issue.

Checkout the comments associated with the jira for more details, as mentioned in jira comments

"jdbc interpreter Binding Mode Per User Scoped and isolated mode per user the temporary table is dropped"

Try with the above setting and check does the issue resolved or not :-)

View solution in original post

2 REPLIES 2
Highlighted

Re: How to ensure hive session close properly in Zeppelin

Super Guru

@HanYan Tan

Could you look into zeppelin-4140 jira is reported for the same issue.

Checkout the comments associated with the jira for more details, as mentioned in jira comments

"jdbc interpreter Binding Mode Per User Scoped and isolated mode per user the temporary table is dropped"

Try with the above setting and check does the issue resolved or not :-)

View solution in original post

Highlighted

Re: How to ensure hive session close properly in Zeppelin

New Contributor

Hi @Shu , thanks for your reply. I did looked into zeppelin-4140, indeed similar issues.

https://issues.apache.org/jira/browse/ZEPPELIN-4140

I did tried change the JDBC Interpreter Binding Mode Per User Scoped and isolated mode per user but not working. Still required to restart the interpreter only can work.

By the way, Thanks.