[jira] [Commented] (IMPALA-11233) reset all query option

["ASF subversion and git services (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/IMPALA-11233?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17557970#comment-17557970 ] 

ASF subversion and git services commented on IMPALA-11233:
----------------------------------------------------------

Commit f5fc08573352d0a1943296209791a4db17268086 in impala's branch refs/heads/master from gaoxq
[ https://gitbox.apache.org/repos/asf?p=impala.git;h=f5fc08573 ]

IMPALA-11233: Unset all query option

When using jdbc connection pool, a connection set some query options,
after query finished, connection is closed and put back to the connection
pool. When connection used again, the last query option also come into
effect. We need a feature that a set statement can reset all query option
without recreating a new connection.

Support UNSET statements in SQL dialect. UNSET ALL can unset all query
option.

Testing:
  - add unset all query option in test_hs2.py

Change-Id: Iabf23622daab733ddab20dd3ca73af6c9bd5c250
Reviewed-on: http://gerrit.cloudera.org:8080/18430
Reviewed-by: Impala Public Jenkins <im...@cloudera.com>
Tested-by: Impala Public Jenkins <im...@cloudera.com>


> reset all query option
> ----------------------
>
>                 Key: IMPALA-11233
>                 URL: https://issues.apache.org/jira/browse/IMPALA-11233
>             Project: IMPALA
>          Issue Type: New Feature
>            Reporter: gaoxiaoqing
>            Assignee: gaoxiaoqing
>            Priority: Minor
>
> when we using jdbc connection pool, a connection set some query option, after query finished, connection is closed and put back to the connection pool. when connection using again, the last query option also come into affect.
> we need a feature that a set statement can reset all query option without restart impalad. 
> i decide to define a set statement 'set reset_all_option'. it can reset all query option.



--
This message was sent by Atlassian Jira
(v8.20.7#820007)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org