[
https://issues.apache.org/jira/browse/TAJO-1238?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Hyunsik Choi updated TAJO-1238:
-------------------------------
Attachment: TAJO-1238.patch
> 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)
