question How to ensure hive session close properly in Zeppelin in Support Questions

How to ensure hive session close properly in Zeppelin

TanHanYan — Wed, 08 May 2019 09:17:32 GMT

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?

Re: How to ensure hive session close properly in Zeppelin

Shu_ashu — Wed, 08 May 2019 09:39:05 GMT

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

Re: How to ensure hive session close properly in Zeppelin

TanHanYan — Wed, 08 May 2019 10:22:15 GMT

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.