Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

How to ensure hive session close properly in Zeppelin

Solved Go to solution

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

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 :-)

2 REPLIES 2

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 :-)

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.