You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Igloo (JIRA)" <ji...@apache.org> on 2018/04/02 02:07:00 UTC

[jira] [Updated] (HIVE-16007) When the query does not complie the LogRunnable never stops

     [ https://issues.apache.org/jira/browse/HIVE-16007?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Igloo updated HIVE-16007:
-------------------------
    Description: 
When issuing a sql command which does not compile then the LogRunnable thread is never closed.

The issue can be easily detected when running beeline with showWarnings=true.
{code:java}
$ ./beeline -u "jdbc:hive2://localhost:10000 pvary pvary" --showWarnings=true
[..]
Connecting to jdbc:hive2://localhost:10000
Connected to: Apache Hive (version 2.2.0-SNAPSHOT)
Driver: Hive JDBC (version 2.2.0-SNAPSHOT)
Transaction isolation: TRANSACTION_REPEATABLE_READ
Beeline version 2.2.0-SNAPSHOT by Apache Hive
0: jdbc:hive2://localhost:10000> selekt;
Warning: java.sql.SQLException: Method getQueryLog() failed. Because the stmtHandle in HiveStatement is null and the statement execution might fail. (state=,code=0)
[..]
Warning: java.sql.SQLException: Can't getQueryLog after statement has been closed (state=,code=0)
[..]
{code}
 

  was:
When issuing a sql command which does not compile then the LogRunnable thread is never closed.

The issue can be easily detected when running beeline with showWarnings=true.

{code}
$ ./beeline -u "jdbc:hive2://localhost:10000 pvary pvary" --showWarnings=true
[..]
Connecting to jdbc:hive2://localhost:10000
Connected to: Apache Hive (version 2.2.0-SNAPSHOT)
Driver: Hive JDBC (version 2.2.0-SNAPSHOT)
Transaction isolation: TRANSACTION_REPEATABLE_READ
Beeline version 2.2.0-SNAPSHOT by Apache Hive
0: jdbc:hive2://localhost:10000> selekt;
Warning: java.sql.SQLException: Method getQueryLog() failed. Because the stmtHandle in HiveStatement is null and the statement execution might fail. (state=,code=0)
[..]
Warning: java.sql.SQLException: Can't getQueryLog after statement has been closed (state=,code=0)
[..]
{code}


> When the query does not complie the LogRunnable never stops
> -----------------------------------------------------------
>
>                 Key: HIVE-16007
>                 URL: https://issues.apache.org/jira/browse/HIVE-16007
>             Project: Hive
>          Issue Type: Bug
>          Components: Beeline
>    Affects Versions: 2.2.0
>            Reporter: Peter Vary
>            Assignee: Peter Vary
>            Priority: Major
>             Fix For: 2.3.0, 3.0.0
>
>         Attachments: HIVE-16007.02.patch, HIVE-16007.2.patch, HIVE-16007.3.patch, HIVE-16007.4.patch, HIVE-16007.5.patch, HIVE-16007.6.patch, HIVE-16007.patch
>
>
> When issuing a sql command which does not compile then the LogRunnable thread is never closed.
> The issue can be easily detected when running beeline with showWarnings=true.
> {code:java}
> $ ./beeline -u "jdbc:hive2://localhost:10000 pvary pvary" --showWarnings=true
> [..]
> Connecting to jdbc:hive2://localhost:10000
> Connected to: Apache Hive (version 2.2.0-SNAPSHOT)
> Driver: Hive JDBC (version 2.2.0-SNAPSHOT)
> Transaction isolation: TRANSACTION_REPEATABLE_READ
> Beeline version 2.2.0-SNAPSHOT by Apache Hive
> 0: jdbc:hive2://localhost:10000> selekt;
> Warning: java.sql.SQLException: Method getQueryLog() failed. Because the stmtHandle in HiveStatement is null and the statement execution might fail. (state=,code=0)
> [..]
> Warning: java.sql.SQLException: Can't getQueryLog after statement has been closed (state=,code=0)
> [..]
> {code}
>  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)