Skip to main content
TanHanYan
TanHanYan
Silver ⭐️
May 8, 2019
Solved

How to ensure hive session close properly in Zeppelin

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?

    Shu_ashu
    Shu_ashuAnswer
    Gold ⭐️⭐️⭐️
    May 8, 2019

    @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 in thread

    2 replies

    Shu_ashu
    Shu_ashuAnswer
    Gold ⭐️⭐️⭐️
    May 8, 2019

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

    Translate
    TanHanYan
    TanHanYanAuthor
    Silver ⭐️
    May 8, 2019

    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.

    Translate
    Terms & ConditionsAccessibility statement