You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@tajo.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2014/12/09 10:12:12 UTC
[jira] [Commented] (TAJO-1238) Add SET SESSION and RESET statement
[ https://issues.apache.org/jira/browse/TAJO-1238?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14239169#comment-14239169 ]
ASF GitHub Bot commented on TAJO-1238:
--------------------------------------
GitHub user hyunsik opened a pull request:
https://github.com/apache/tajo/pull/294
TAJO-1238: Add SET SESSION and RESET statement.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/hyunsik/tajo TAJO-1238
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/tajo/pull/294.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #294
----
commit 021c872fbfedf90e5eb579dfe109590242fa1bae
Author: Hyunsik Choi <hy...@apache.org>
Date: 2014-12-09T01:00:24Z
Add session statement to parser.
commit 56b3016a579896e542a44289e59cc7cb769f8880
Author: Hyunsik Choi <hy...@apache.org>
Date: 2014-12-09T09:09:27Z
TAJO-1238: Add SET SESSION and RESET statement.
commit 46a99857a5adc7b30e532b6dd861157be8262d90
Author: Hyunsik Choi <hy...@apache.org>
Date: 2014-12-09T09:09:38Z
Merge branch 'master' of https://git-wip-us.apache.org/repos/asf/tajo into TAJO-1238
----
> Add SET SESSION and RESET statement
> -----------------------------------
>
> Key: TAJO-1238
> URL: https://issues.apache.org/jira/browse/TAJO-1238
> Project: Tajo
> Issue Type: New Feature
> Components: planner/optimizer, query master
> Reporter: Hyunsik Choi
> Assignee: Hyunsik Choi
> Fix For: 0.9.1
>
> Attachments: TAJO-1238.patch
>
>
> So far, there have been no session statements which enable users to set or reset session variables. We have only meta command in {{tsql}}. Here is my proposal for session statement.
> {{SET CATALOG}} and {{SET TIME ZONE}} are based on ANSI SQL 2003 standards, and others are based on PostgreSQL. Vertica and Teradata have the same syntax.
> {noformat:title=BNF}
> : SET CATALOG dbname = identifier
> | SET TIME ZONE (Character_String_Literal | signed_numerical_literal | DEFAULT)
> | SET (SESSION)? name=identifier (TO | EQUAL)?
> (Character_String_Literal | signed_numerical_literal | boolean_literal | DEFAULT)
> | RESET name=identifier
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)