[jira] [Created] (TAJO-1238) Add SET SESSION and RESET statement

[Hyunsik Choi (JIRA)]

Hyunsik Choi created TAJO-1238:
----------------------------------

             Summary: 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


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)