How to ensure hive session close properly in Zeppelin

[#1]

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?

[#2 · Accepted solution]

@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 🙂

[#3]

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.