tajo-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From hyun...@apache.org
Subject [2/2] tajo git commit: TAJO-1823: Can't start TajoMaster.
Date Mon, 07 Sep 2015 14:06:04 GMT
TAJO-1823: Can't start TajoMaster.

Closes #740


Project: http://git-wip-us.apache.org/repos/asf/tajo/repo
Commit: http://git-wip-us.apache.org/repos/asf/tajo/commit/b1d08f89
Tree: http://git-wip-us.apache.org/repos/asf/tajo/tree/b1d08f89
Diff: http://git-wip-us.apache.org/repos/asf/tajo/diff/b1d08f89

Branch: refs/heads/master
Commit: b1d08f8961f6d9fb40b7b7993230a8c6e85127f9
Parents: c0e193d
Author: Hyunsik Choi <hyunsik@apache.org>
Authored: Mon Sep 7 21:35:41 2015 +0900
Committer: Hyunsik Choi <hyunsik@apache.org>
Committed: Mon Sep 7 23:01:19 2015 +0900

----------------------------------------------------------------------
 CHANGES                                         |    2 +
 tajo-dist/pom.xml                               |    2 +
 .../org.apache.tajo.parser.sql/SQLLexer.g4      |  513 ------
 .../org.apache.tajo.parser.sql/SQLParser.g4     | 1639 ------------------
 .../org/apache/tajo/parser/sql/SQLLexer.g4      |  513 ++++++
 .../org/apache/tajo/parser/sql/SQLParser.g4     | 1639 ++++++++++++++++++
 6 files changed, 2156 insertions(+), 2152 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/tajo/blob/b1d08f89/CHANGES
----------------------------------------------------------------------
diff --git a/CHANGES b/CHANGES
index 28957f3..f2ab3a9 100644
--- a/CHANGES
+++ b/CHANGES
@@ -249,6 +249,8 @@ Release 0.11.0 - unreleased
 
   BUG FIXES
 
+    TAJO-1823: Can't start TajoMaster. (hyunsik)
+
     TAJO-1820: Fix wrong case sensitivity rules of non-reserved keywords.
     (hyunsik)
 

http://git-wip-us.apache.org/repos/asf/tajo/blob/b1d08f89/tajo-dist/pom.xml
----------------------------------------------------------------------
diff --git a/tajo-dist/pom.xml b/tajo-dist/pom.xml
index b9d2343..fdce467 100644
--- a/tajo-dist/pom.xml
+++ b/tajo-dist/pom.xml
@@ -142,6 +142,8 @@
                       run cp -r $ROOT/tajo-cli/target/tajo-cli-${project.version}/* .
                       run cp -r $ROOT/tajo-catalog/target/tajo-catalog-${project.version}/* .
                       run cp -r $ROOT/tajo-storage/target/tajo-storage-${project.version}/* .
+                      run cp -r $ROOT/tajo-sql-parser/target/tajo-sql-parser-${project.version}/* .
+
                       run cp -r $ROOT/tajo-pullserver/target/tajo-pullserver-${project.version}.jar .
                       run cp -r $ROOT/tajo-metrics/target/tajo-metrics-${project.version}.jar .
                       run cp -r $ROOT/tajo-core/target/tajo-core-${project.version}.jar .

http://git-wip-us.apache.org/repos/asf/tajo/blob/b1d08f89/tajo-sql-parser/src/main/antlr4/org.apache.tajo.parser.sql/SQLLexer.g4
----------------------------------------------------------------------
diff --git a/tajo-sql-parser/src/main/antlr4/org.apache.tajo.parser.sql/SQLLexer.g4 b/tajo-sql-parser/src/main/antlr4/org.apache.tajo.parser.sql/SQLLexer.g4
deleted file mode 100644
index 896f627..0000000
--- a/tajo-sql-parser/src/main/antlr4/org.apache.tajo.parser.sql/SQLLexer.g4
+++ /dev/null
@@ -1,513 +0,0 @@
-/*
- Licensed to the Apache Software Foundation (ASF) under one
- or more contributor license agreements.  See the NOTICE file
- distributed with this work for additional information
- regarding copyright ownership.  The ASF licenses this file
- to you under the Apache License, Version 2.0 (the
- "License"); you may not use this file except in compliance
- with the License.  You may obtain a copy of the License at
-
-     http://www.apache.org/licenses/LICENSE-2.0
-
- Unless required by applicable law or agreed to in writing, software
- distributed under the License is distributed on an "AS IS" BASIS,
- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
- See the License for the specific language governing permissions and
- limitations under the License.
- */
-
-lexer grammar SQLLexer;
-
-@header {
-}
-
-@members {
-}
-
-
-/*
-===============================================================================
-  Tokens for Case Insensitive Keywords
-===============================================================================
-*/
-fragment A
-	:	'A' | 'a';
-
-fragment B
-	:	'B' | 'b';
-
-fragment C
-	:	'C' | 'c';
-
-fragment D
-	:	'D' | 'd';
-
-fragment E
-	:	'E' | 'e';
-
-fragment F
-	:	'F' | 'f';
-
-fragment G
-	:	'G' | 'g';
-
-fragment H
-	:	'H' | 'h';
-
-fragment I
-	:	'I' | 'i';
-
-fragment J
-	:	'J' | 'j';
-
-fragment K
-	:	'K' | 'k';
-
-fragment L
-	:	'L' | 'l';
-
-fragment M
-	:	'M' | 'm';
-
-fragment N
-	:	'N' | 'n';
-
-fragment O
-	:	'O' | 'o';
-
-fragment P
-	:	'P' | 'p';
-
-fragment Q
-	:	'Q' | 'q';
-
-fragment R
-	:	'R' | 'r';
-
-fragment S
-	:	'S' | 's';
-
-fragment T
-	:	'T' | 't';
-
-fragment U
-	:	'U' | 'u';
-
-fragment V
-	:	'V' | 'v';
-
-fragment W
-	:	'W' | 'w';
-
-fragment X
-	:	'X' | 'x';
-
-fragment Y
-	:	'Y' | 'y';
-
-fragment Z
-	:	'Z' | 'z';
-
-/*
-===============================================================================
-  Reserved Keywords
-===============================================================================
-*/
-
-AS : A S;
-ALL : A L L;
-AND : A N D;
-ANY : A N Y;
-ASYMMETRIC : A S Y M M E T R I C;
-ASC : A S C;
-
-
-BOTH : B O T H;
-
-CASE : C A S E;
-CAST : C A S T;
-CREATE : C R E A T E;
-CROSS : C R O S S;
-CURRENT_DATE: C U R R E N T UNDERLINE D A T E;
-CURRENT_TIME: C U R R E N T UNDERLINE T I M E;
-CURRENT_TIMESTAMP: C U R R E N T UNDERLINE T I M E S T A M P;
-
-DESC : D E S C;
-DISTINCT : D I S T I N C T;
-
-END : E N D;
-ELSE : E L S E;
-EXCEPT : E X C E P T;
-
-FALSE : F A L S E;
-FULL : F U L L;
-FROM : F R O M;
-
-GROUP : G R O U P;
-
-HAVING : H A V I N G;
-
-ILIKE : I L I K E;
-IN : I N;
-INNER : I N N E R;
-INTERSECT : I N T E R S E C T;
-INTO : I N T O;
-IS : I S;
-
-JOIN : J O I N;
-
-LEADING : L E A D I N G;
-LEFT : L E F T;
-LIKE : L I K E;
-LIMIT : L I M I T;
-
-NATURAL : N A T U R A L;
-NOT : N O T;
-NULL : N U L L;
-
-ON : O N;
-OR : O R;
-ORDER : O R D E R;
-OUTER : O U T E R;
-OVER : O V E R;
-RIGHT : R I G H T;
-SELECT : S E L E C T;
-SOME : S O M E;
-SYMMETRIC : S Y M M E T R I C;
-
-TABLE : T A B L E;
-THEN : T H E N;
-TRAILING : T R A I L I N G;
-TRUE : T R U E;
-
-UNION : U N I O N;
-UNIQUE : U N I Q U E;
-USING : U S I N G;
-
-WHEN : W H E N;
-WHERE : W H E R E;
-WITH : W I T H;
-WINDOW : W I N D O W;
-
-/*
-===============================================================================
-  Non Reserved Keywords
-===============================================================================
-*/
-AVG : A V G;
-ADD: A D D;
-ALTER : A L T E R;
-
-BETWEEN : B E T W E E N;
-BY : B Y;
-
-CATALOG : C A T A L O G;
-CENTURY : C E N T U R Y;
-CHARACTER : C H A R A C T E R;
-COLLECT : C O L L E C T;
-COALESCE : C O A L E S C E;
-COLUMN : C O L U M N;
-COUNT : C O U N T;
-CUBE : C U B E;
-CUME_DIST : C U M E UNDERLINE D I S T;
-CURRENT : C U R R E N T;
-
-DAY : D A Y;
-DEFAULT : D E F A U L T;
-DATABASE : D A T A B A S E;
-DEC : D E C;
-DECADE : D E C A D E;
-DENSE_RANK : D E N S E UNDERLINE R A N K;
-DOW : D O W;
-DOY : D O Y;
-DROP : D R O P;
-
-EPOCH : E P O C H;
-EVERY : E V E R Y;
-EXCLUDE : E X C L U D E;
-EXISTS : E X I S T S;
-EXPLAIN : E X P L A I N;
-EXTERNAL : E X T E R N A L;
-EXTRACT : E X T R A C T;
-
-FILTER : F I L T E R;
-FIRST : F I R S T;
-FIRST_VALUE : F I R S T UNDERLINE V A L U E;
-FOLLOWING : F O L L O W I N G;
-FORMAT : F O R M A T;
-FUSION : F U S I O N;
-
-GLOBAL : G L O B A L;
-GROUPING : G R O U P I N G;
-
-HASH : H A S H;
-HOUR : H O U R;
-
-IF : I F;
-INDEX : I N D E X;
-INSERT : I N S E R T;
-INTERSECTION : I N T E R S E C T I O N;
-ISODOW : I S O D O W;
-ISOYEAR : I S O Y E A R;
-
-LAG : L A G;
-LAST : L A S T;
-LAST_VALUE : L A S T UNDERLINE V A L U E;
-LEAD : L E A D;
-LESS : L E S S;
-LIST : L I S T;
-LOCATION : L O C A T I O N;
-
-MAP : M A P;
-MAX : M A X;
-MAXVALUE : M A X V A L U E;
-MICROSECONDS : M I C R O S E C O N D S;
-MILLENNIUM : M I L L E N N I U M;
-MILLISECONDS : M I L L I S E C O N D S;
-MIN : M I N;
-MINUTE : M I N U T E;
-MONTH : M O N T H;
-
-NATIONAL : N A T I O N A L;
-NULLIF : N U L L I F;
-NO : N O;
-
-OVERWRITE : O V E R W R I T E;
-OTHERS: O T H E R S;
-
-PARTITION : P A R T I T I O N;
-PARTITIONS : P A R T I T I O N S;
-PERCENT_RANK : P E R C E N T UNDERLINE R A N K;
-PRECEDING : P R E C E D I N G;
-PRECISION : P R E C I S I O N;
-PURGE : P U R G E;
-PROPERTY : P R O P E R T Y;
-
-QUARTER : Q U A R T E R;
-
-RANGE : R A N G E;
-RANK : R A N K;
-RECORD : R E C O R D;
-REGEXP : R E G E X P;
-RENAME : R E N A M E;
-RESET : R E S E T;
-RLIKE : R L I K E;
-ROLLUP : R O L L U P;
-ROW : R O W;
-ROWS : R O W S;
-ROW_NUMBER :  R O W UNDERLINE N U M B E R;
-
-SECOND : S E C O N D;
-SESSION : S E S S I O N;
-SET : S E T;
-SIMILAR : S I M I L A R;
-STDDEV_POP : S T D D E V UNDERLINE P O P;
-STDDEV_SAMP : S T D D E V UNDERLINE S A M P;
-SUBPARTITION : S U B P A R T I T I O N;
-SUM : S U M;
-
-TABLESPACE : T A B L E S P A C E;
-THAN : T H A N;
-TIES : T I E S;
-TIMEZONE: T I M E Z O N E;
-TIMEZONE_HOUR: T I M E Z O N E UNDERLINE H O U R;
-TIMEZONE_MINUTE: T I M E Z O N E UNDERLINE M I N U T E;
-TRIM : T R I M;
-TO : T O;
-TRUNCATE : T R U N C A T E;
-
-UNBOUNDED : U N B O U N D E D;
-UNKNOWN : U N K N O W N;
-
-VALUES : V A L U E S;
-VAR_SAMP : V A R UNDERLINE S A M P;
-VAR_POP : V A R UNDERLINE P O P;
-VARYING : V A R Y I N G;
-
-WEEK : W E E K;
-
-YEAR : Y E A R;
-
-ZONE : Z O N E;
-
-
-/*
-===============================================================================
-  Data Type Tokens
-===============================================================================
-*/
-BOOLEAN : B O O L E A N;
-BOOL : B O O L;
-BIT : B I T;
-VARBIT : V A R B I T;
-
-INT1 : I N T '1';
-INT2 : I N T '2';
-INT4 : I N T '4';
-INT8 : I N T '8';
-
-TINYINT : T I N Y I N T; // alias for INT1
-SMALLINT : S M A L L I N T; // alias for INT2
-INT : I N T; // alias for INT4
-INTEGER : I N T E G E R; // alias - INT4
-BIGINT : B I G I N T; // alias for INT8
-
-FLOAT4 : F L O A T '4';
-FLOAT8 : F L O A T '8';
-
-REAL : R E A L; // alias for FLOAT4
-FLOAT : F L O A T; // alias for FLOAT8
-DOUBLE : D O U B L E; // alias for FLOAT8
-
-NUMERIC : N U M E R I C;
-DECIMAL : D E C I M A L; // alias for number
-
-CHAR : C H A R;
-VARCHAR : V A R C H A R;
-NCHAR : N C H A R;
-NVARCHAR : N V A R C H A R;
-
-DATE : D A T E;
-INTERVAL: I N T E R V A L;
-TIME : T I M E;
-TIMETZ : T I M E T Z;
-TIMESTAMP : T I M E S T A M P;
-TIMESTAMPTZ : T I M E S T A M P T Z;
-
-TEXT : T E X T;
-
-BINARY : B I N A R Y;
-VARBINARY : V A R B I N A R Y;
-BLOB : B L O B;
-BYTEA : B Y T E A; // alias for BLOB
-
-INET4 : I N E T '4';
-
-// Operators
-Similar_To : '~';
-Not_Similar_To : '!~';
-Similar_To_Case_Insensitive : '~*';
-Not_Similar_To_Case_Insensitive : '!~*';
-
-// Cast Operator
-CAST_EXPRESSION
-  : COLON COLON
-  ;
-
-ASSIGN  : ':=';
-EQUAL  : '=';
-COLON :  ':';
-SEMI_COLON :  ';';
-COMMA : ',';
-CONCATENATION_OPERATOR : VERTICAL_BAR VERTICAL_BAR;
-NOT_EQUAL  : '<>' | '!=' | '~='| '^=' ;
-LTH : '<' ;
-LEQ : '<=';
-GTH   : '>';
-GEQ   : '>=';
-LEFT_PAREN :  '(';
-RIGHT_PAREN : ')';
-PLUS  : '+';
-MINUS : '-';
-MULTIPLY: '*';
-DIVIDE  : '/';
-MODULAR : '%';
-DOT : '.';
-UNDERLINE : '_';
-VERTICAL_BAR : '|';
-QUOTE : '\'';
-DOUBLE_QUOTE : '"';
-
-NUMBER : Digit+;
-
-fragment
-Digit : '0'..'9';
-
-REAL_NUMBER
-    :   ('0'..'9')+ '.' ('0'..'9')* EXPONENT?
-    |   '.' ('0'..'9')+ EXPONENT?
-    |   ('0'..'9')+ EXPONENT
-    ;
-
-BlockComment
-    :   '/*' .*? '*/' -> skip
-    ;
-
-LineComment
-    :   '--' ~[\r\n]* -> skip
-    ;
-
-/*
-===============================================================================
- Identifiers
-===============================================================================
-*/
-
-Regular_Identifier
-  : ('a'..'z'|'A'..'Z'|'_') ('a'..'z'|'A'..'Z'|Digit|'_')* { setText(getText().toLowerCase()); }
-  ;
-
-Quoted_Identifier
-  : DOUBLE_QUOTE ( ESC_SEQ | ~('\\'|'"') )* DOUBLE_QUOTE { setText(getText().substring(1, getText().length()-1)); }
-  ;
-
-/*
-===============================================================================
- Literal
-===============================================================================
-*/
-
-// Some Unicode Character Ranges
-fragment
-Control_Characters                  :   '\u0001' .. '\u001F';
-fragment
-Extended_Control_Characters         :   '\u0080' .. '\u009F';
-
-Character_String_Literal
-  : QUOTE ( ESC_SEQ | ~('\\'|'\'') )* QUOTE
-  ;
-
-fragment
-EXPONENT : ('e'|'E') ('+'|'-')? ('0'..'9')+ ;
-
-fragment
-HEX_DIGIT : ('0'..'9'|'a'..'f'|'A'..'F') ;
-
-fragment
-ESC_SEQ
-    :   '\\' ('b'|'t'|'n'|'f'|'r'|'\"'|'\''|'\\')
-    |   UNICODE_ESC
-    |   OCTAL_ESC
-    ;
-
-fragment
-OCTAL_ESC
-    :   '\\' ('0'..'3') ('0'..'7') ('0'..'7')
-    |   '\\' ('0'..'7') ('0'..'7')
-    |   '\\' ('0'..'7')
-    ;
-
-fragment
-UNICODE_ESC
-    :   '\\' 'u' HEX_DIGIT HEX_DIGIT HEX_DIGIT HEX_DIGIT
-    ;
-
-
-/*
-===============================================================================
- Whitespace Tokens
-===============================================================================
-*/
-
-Space
-  : ' ' -> skip
-  ;
-
-White_Space
-  :	( Control_Characters  | Extended_Control_Characters )+ -> skip
-  ;
-
-
-BAD
-  : . -> skip
-  ;

http://git-wip-us.apache.org/repos/asf/tajo/blob/b1d08f89/tajo-sql-parser/src/main/antlr4/org.apache.tajo.parser.sql/SQLParser.g4
----------------------------------------------------------------------
diff --git a/tajo-sql-parser/src/main/antlr4/org.apache.tajo.parser.sql/SQLParser.g4 b/tajo-sql-parser/src/main/antlr4/org.apache.tajo.parser.sql/SQLParser.g4
deleted file mode 100644
index 41de218..0000000
--- a/tajo-sql-parser/src/main/antlr4/org.apache.tajo.parser.sql/SQLParser.g4
+++ /dev/null
@@ -1,1639 +0,0 @@
-/**
- * Licensed to the Apache Software Foundation (ASF) under one
- * or more contributor license agreements.  See the NOTICE file
- * distributed with this work for additional information
- * regarding copyright ownership.  The ASF licenses this file
- * to you under the Apache License, Version 2.0 (the
- * "License"); you may not use this file except in compliance
- * with the License.  You may obtain a copy of the License at
- *
- *     http://www.apache.org/licenses/LICENSE-2.0
- *
- * Unless required by applicable law or agreed to in writing, software
- * distributed under the License is distributed on an "AS IS" BASIS,
- * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
- * See the License for the specific language governing permissions and
- * limitations under the License.
- */
-
-parser grammar SQLParser;
-
-options {
-	language=Java;
-	tokenVocab=SQLLexer;
-}
-
-@header {
-}
-
-@members {
-}
-
-/*
-===============================================================================
-  SQL statement (Start Symbol)
-===============================================================================
-*/
-sql
-  : (explain_clause)? statement (SEMI_COLON)? EOF
-  ;
-
-explain_clause
-  : EXPLAIN (GLOBAL)?
-  ;
-
-statement
-  : session_statement
-  | data_statement
-  | data_change_statement
-  | schema_statement
-  | index_statement
-  ;
-
-session_statement
-  : SET CATALOG dbname = identifier
-  | SET TIME ZONE (TO | EQUAL)? (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
-  ;
-
-data_statement
-  : query_expression
-  ;
-
-data_change_statement
-  : insert_statement
-  ;
-
-schema_statement
-  : database_definition
-  | drop_database_statement
-  | create_table_statement
-  | drop_table_statement
-  | alter_tablespace_statement
-  | alter_table_statement
-  | truncate_table_statement
-  ;
-
-index_statement
-  : create_index_statement
-  | drop_index_statement
-  ;
-
-create_index_statement
-  : CREATE (u=UNIQUE)? INDEX index_name = identifier ON table_name (method_specifier)?
-    LEFT_PAREN sort_specifier_list RIGHT_PAREN param_clause? (where_clause)? (LOCATION path=Character_String_Literal)?
-  ;
-
-drop_index_statement
-  : DROP INDEX index_name = identifier
-  ;
-
-database_definition
-  : CREATE DATABASE (if_not_exists)? dbname = identifier
-  ;
-
-if_not_exists
-  : IF NOT EXISTS
-  ;
-
-drop_database_statement
-  : DROP DATABASE (if_exists)? dbname = identifier
-  ;
-
-if_exists
-  : IF EXISTS
-  ;
-
-create_table_statement
-  : CREATE EXTERNAL TABLE (if_not_exists)? table_name table_elements (TABLESPACE spacename=identifier)? USING storage_type=identifier
-    (param_clause)? (table_partitioning_clauses)? (LOCATION uri=Character_String_Literal)?
-  | CREATE TABLE (if_not_exists)? table_name table_elements (TABLESPACE spacename=identifier)? (USING storage_type=identifier)?
-    (param_clause)? (table_partitioning_clauses)? (AS query_expression)?
-  | CREATE TABLE (if_not_exists)? table_name (TABLESPACE spacename=identifier)? (USING storage_type=identifier)?
-    (param_clause)? (table_partitioning_clauses)? AS query_expression
-  | CREATE TABLE (if_not_exists)? table_name LIKE like_table_name=table_name
-  ;
-
-table_elements
-  : LEFT_PAREN field_element (COMMA field_element)* RIGHT_PAREN
-  ;
-
-field_element
-  : name=identifier field_type
-  ;
-
-field_type
-  : data_type
-  ;
-
-param_clause
-  : WITH LEFT_PAREN param (COMMA param)* RIGHT_PAREN
-  ;
-
-param
-  : key=Character_String_Literal EQUAL value=numeric_value_expression
-  ;
-
-method_specifier
-  : USING m=identifier
-  ;
-
-table_space_specifier
-  : TABLESPACE table_space_name
-  ;
-
-table_space_name
-  : identifier
-  ;
-
-table_partitioning_clauses
-  : range_partitions
-  | hash_partitions
-  | list_partitions
-  | column_partitions
-  ;
-
-range_partitions
-  : PARTITION BY RANGE LEFT_PAREN column_reference_list RIGHT_PAREN
-    LEFT_PAREN range_value_clause_list RIGHT_PAREN
-  ;
-
-range_value_clause_list
-  : range_value_clause (COMMA range_value_clause)*
-  ;
-
-range_value_clause
-  : PARTITION partition_name VALUES LESS THAN (LEFT_PAREN value_expression RIGHT_PAREN | LEFT_PAREN? MAXVALUE RIGHT_PAREN?)
-  ;
-
-hash_partitions
-  : PARTITION BY HASH LEFT_PAREN column_reference_list RIGHT_PAREN
-    (LEFT_PAREN individual_hash_partitions RIGHT_PAREN | hash_partitions_by_quantity)
-  ;
-
-individual_hash_partitions
-  : individual_hash_partition (COMMA individual_hash_partition)*
-  ;
-
-individual_hash_partition
-  : PARTITION partition_name
-  ;
-
-hash_partitions_by_quantity
-  : PARTITIONS quantity = numeric_value_expression
-  ;
-
-list_partitions
-  : PARTITION BY LIST LEFT_PAREN column_reference_list RIGHT_PAREN LEFT_PAREN  list_value_clause_list RIGHT_PAREN
-  ;
-
-list_value_clause_list
-  : list_value_partition (COMMA list_value_partition)*
-  ;
-
-list_value_partition
-  : PARTITION partition_name VALUES (IN)? LEFT_PAREN in_value_list RIGHT_PAREN
-  ;
-
-column_partitions
-  : PARTITION BY COLUMN table_elements
-  ;
-
-partition_name
-  : identifier
-  ;
-
-truncate_table_statement
-  : TRUNCATE (TABLE)? table_name (COMMA table_name)*
-  ;
-
-/*
-===============================================================================
-  11.21 <data types>
-===============================================================================
-*/
-
-drop_table_statement
-  : DROP TABLE (if_exists)? table_name (PURGE)?
-  ;
-
-/*
-===============================================================================
-  5.2 <token and separator>
-
-  Specifying lexical units (tokens and separators) that participate in SQL language
-===============================================================================
-*/
-
-identifier
-  : Regular_Identifier
-  | nonreserved_keywords
-  | Quoted_Identifier
-  ;
-
-nonreserved_keywords
-  : ADD
-  | AVG
-  | ALTER
-  | BETWEEN
-  | BY
-  | CATALOG
-  | CENTURY
-  | CHARACTER
-  | COALESCE
-  | COLLECT
-  | COLUMN
-  | COUNT
-  | CUBE
-  | CUME_DIST
-  | CURRENT
-  | DAY
-  | DEC
-  | DECADE
-  | DEFAULT
-  | DENSE_RANK
-  | DOW
-  | DOY
-  | DROP
-  | EPOCH
-  | EVERY
-  | EXISTS
-  | EXCLUDE
-  | EXPLAIN
-  | EXTERNAL
-  | EXTRACT
-  | FILTER
-  | FIRST
-  | FIRST_VALUE
-  | FOLLOWING
-  | FORMAT
-  | FUSION
-  | GROUPING
-  | HASH
-  | INDEX
-  | INSERT
-  | INTERSECTION
-  | ISODOW
-  | ISOYEAR
-  | LAST
-  | LAST_VALUE
-  | LESS
-  | LIST
-  | LOCATION
-  | MAP
-  | MAX
-  | MAXVALUE
-  | MICROSECONDS
-  | MILLENNIUM
-  | MILLISECONDS
-  | MIN
-  | MINUTE
-  | MONTH
-  | NATIONAL
-  | NO
-  | NULLIF
-  | OVERWRITE
-  | OTHERS
-  | PARTITION
-  | PARTITIONS
-  | PERCENT_RANK
-  | PRECEDING
-  | PRECISION
-  | PURGE
-  | QUARTER
-  | RANGE
-  | RANK
-  | RECORD
-  | REGEXP
-  | RENAME
-  | RESET
-  | RLIKE
-  | ROLLUP
-  | ROW
-  | ROWS
-  | ROW_NUMBER
-  | SECOND
-  | SET
-  | SESSION
-  | SIMILAR
-  | STDDEV_POP
-  | STDDEV_SAMP
-  | SUBPARTITION
-  | SUM
-  | TABLESPACE
-  | THAN
-  | TIES
-  | TIMEZONE
-  | TIMEZONE_HOUR
-  | TIMEZONE_MINUTE
-  | TRIM
-  | TO
-  | UNBOUNDED
-  | UNKNOWN
-  | VALUES
-  | VAR_POP
-  | VAR_SAMP
-  | VARYING
-  | WEEK
-  | YEAR
-  | ZONE
-
-  | BIGINT
-  | BIT
-  | BLOB
-  | BOOL
-  | BOOLEAN
-  | BYTEA
-  | CHAR
-  | DATE
-  | DECIMAL
-  | DOUBLE
-  | FLOAT
-  | FLOAT4
-  | FLOAT8
-  | INET4
-  | INT
-  | INT1
-  | INT2
-  | INT4
-  | INT8
-  | INTEGER
-  | INTERVAL
-  | NCHAR
-  | NUMERIC
-  | NVARCHAR
-  | REAL
-  | SMALLINT
-  | TEXT
-  | TIME
-  | TIMESTAMP
-  | TIMESTAMPTZ
-  | TIMETZ
-  | TINYINT
-  | VARBINARY
-  | VARBIT
-  | VARCHAR
-  ;
-
-/*
-===============================================================================
-  5.3 <literal>
-===============================================================================
-*/
-
-unsigned_literal
-  : unsigned_numeric_literal
-  | general_literal
-  ;
-
-general_literal
-  : Character_String_Literal
-  | datetime_literal
-  | boolean_literal
-  ;
-
-datetime_literal
-  : timestamp_literal
-  | time_literal
-  | date_literal
-  | interval_literal
-  ;
-
-time_literal
-  : TIME time_string=Character_String_Literal
-  ;
-
-timestamp_literal
-  : TIMESTAMP timestamp_string=Character_String_Literal
-  ;
-
-date_literal
-  : DATE date_string=Character_String_Literal
-  ;
-
-interval_literal
-  : INTERVAL interval_string=Character_String_Literal
-  ;
-
-boolean_literal
-  : TRUE | FALSE | UNKNOWN
-  ;
-
-/*
-===============================================================================
-  6.1 <data types>
-===============================================================================
-*/
-
-data_type
-  : predefined_type
-  ;
-
-predefined_type
-  : character_string_type
-  | national_character_string_type
-  | binary_large_object_string_type
-  | numeric_type
-  | boolean_type
-  | datetime_type
-  | bit_type
-  | binary_type
-  | network_type
-  | record_type
-  | map_type
-  ;
-
-character_string_type
-  : CHARACTER type_length?
-  | CHAR type_length?
-  | CHARACTER VARYING type_length?
-  | CHAR VARYING type_length?
-  | VARCHAR type_length?
-  | TEXT
-  ;
-
-type_length
-  : LEFT_PAREN NUMBER RIGHT_PAREN
-  ;
-
-national_character_string_type
-  : NATIONAL CHARACTER type_length?
-  | NATIONAL CHAR type_length?
-  | NCHAR type_length?
-  | NATIONAL CHARACTER VARYING type_length?
-  | NATIONAL CHAR VARYING type_length?
-  | NCHAR VARYING type_length?
-  | NVARCHAR type_length?
-  ;
-
-binary_large_object_string_type
-  : BLOB type_length?
-  | BYTEA type_length?
-  ;
-
-numeric_type
-  : exact_numeric_type | approximate_numeric_type
-  ;
-
-exact_numeric_type
-  : NUMERIC (precision_param)?
-  | DECIMAL (precision_param)?
-  | DEC (precision_param)?
-  | INT1
-  | TINYINT
-  | INT2
-  | SMALLINT
-  | INT4
-  | INT
-  | INTEGER
-  | INT8
-  | BIGINT
-  ;
-
-approximate_numeric_type
-  : FLOAT (precision_param)?
-  | FLOAT4
-  | REAL
-  | FLOAT8
-  | DOUBLE
-  | DOUBLE PRECISION
-  ;
-
-precision_param
-  : LEFT_PAREN precision=NUMBER RIGHT_PAREN
-  | LEFT_PAREN precision=NUMBER COMMA scale=NUMBER RIGHT_PAREN
-  ;
-
-boolean_type
-  : BOOLEAN
-  | BOOL
-  ;
-
-datetime_type
-  : DATE
-  | INTERVAL
-  | TIME
-  | TIME WITH TIME ZONE
-  | TIMETZ
-  | TIMESTAMP
-  | TIMESTAMP WITH TIME ZONE
-  | TIMESTAMPTZ
-  ;
-
-bit_type
-  : BIT type_length?
-  | VARBIT type_length?
-  | BIT VARYING type_length?
-  ;
-
-binary_type
-  : BINARY type_length?
-  | BINARY VARYING type_length?
-  | VARBINARY type_length?
-  ;
-
-network_type
-  : INET4
-  ;
-
-record_type
-  : RECORD table_elements
-  ;
-
-map_type
-  : MAP LTH key_type=data_type COMMA value_type=data_type GTH
-  ;
-
-/*
-===============================================================================
-  6.3 <value_expression_primary>
-===============================================================================
-*/
-value_expression_primary
-  : parenthesized_value_expression
-  | nonparenthesized_value_expression_primary
-  ;
-
-parenthesized_value_expression
-  : LEFT_PAREN value_expression RIGHT_PAREN
-  ;
-
-nonparenthesized_value_expression_primary
-  : unsigned_value_specification
-  | column_reference
-  | set_function_specification
-  | window_function
-  | scalar_subquery
-  | case_expression
-  | cast_specification
-  | routine_invocation
-  ;
-
-/*
-===============================================================================
-  6.4 <unsigned value specification>
-===============================================================================
-*/
-
-unsigned_value_specification
-  : unsigned_literal
-  ;
-
-unsigned_numeric_literal
-  : NUMBER
-  | REAL_NUMBER
-  ;
-
-signed_numerical_literal
-  : sign? unsigned_numeric_literal
-  ;
-
-/*
-===============================================================================
-  6.9 <set function specification>
-
-  Invoke an SQL-invoked routine.
-===============================================================================
-*/
-set_function_specification
-  : aggregate_function
-  ;
-
-aggregate_function
-  : COUNT LEFT_PAREN MULTIPLY RIGHT_PAREN
-  | general_set_function filter_clause?
-  ;
-
-general_set_function
-  : set_function_type LEFT_PAREN set_qualifier? value_expression RIGHT_PAREN
-  ;
-
-set_function_type
-  : AVG
-  | MAX
-  | MIN
-  | SUM
-  | EVERY
-  | ANY
-  | SOME
-  | COUNT
-  | STDDEV_POP
-  | STDDEV_SAMP
-  | VAR_SAMP
-  | VAR_POP
-  | COLLECT
-  | FUSION
-  | INTERSECTION
-  ;
-
-filter_clause
-  : FILTER LEFT_PAREN WHERE search_condition RIGHT_PAREN
-  ;
-
-grouping_operation
-  : GROUPING LEFT_PAREN column_reference_list RIGHT_PAREN
-  ;
-
-/*
-===============================================================================
-  6.10 window function
-===============================================================================
-*/
-
-window_function
-  : window_function_type OVER window_name_or_specification
-  ;
-
-window_function_type
-  : rank_function_type LEFT_PAREN RIGHT_PAREN
-  | ROW_NUMBER LEFT_PAREN RIGHT_PAREN
-  | aggregate_function
-  | FIRST_VALUE LEFT_PAREN column_reference RIGHT_PAREN
-  | LAST_VALUE LEFT_PAREN column_reference RIGHT_PAREN
-  | LAG LEFT_PAREN column_reference ( COMMA numeric_value_expression ( COMMA common_value_expression )? )? RIGHT_PAREN
-  | LEAD LEFT_PAREN column_reference ( COMMA numeric_value_expression ( COMMA common_value_expression )? )? RIGHT_PAREN
-  ;
-
-rank_function_type
-  : RANK | DENSE_RANK | PERCENT_RANK | CUME_DIST
-  ;
-
-
-window_name_or_specification
-  : window_name
-  | window_specification
-  ;
-
-/*
-===============================================================================
-  6.11 <case expression>
-===============================================================================
-*/
-
-case_expression
-  : case_specification
-  ;
-
-case_abbreviation
-  : NULLIF LEFT_PAREN numeric_value_expression COMMA boolean_value_expression  RIGHT_PAREN
-  | COALESCE LEFT_PAREN numeric_value_expression ( COMMA boolean_value_expression  )+ RIGHT_PAREN
-  ;
-
-case_specification
-  : simple_case
-  | searched_case
-  ;
-
-simple_case
-  : CASE boolean_value_expression ( simple_when_clause )+ ( else_clause  )? END
-  ;
-
-searched_case
-  : CASE (searched_when_clause)+ (else_clause)? END
-  ;
-
-simple_when_clause : WHEN search_condition THEN result ;
-
-searched_when_clause
-  : WHEN c=search_condition THEN r=result
-  ;
-
-else_clause
-  : ELSE r=result
-  ;
-
-result
-  : value_expression | NULL
-  ;
-
-/*
-===============================================================================
-  6.12 <cast specification>
-===============================================================================
-*/
-
-cast_specification
-  : CAST LEFT_PAREN cast_operand AS cast_target RIGHT_PAREN
-  ;
-
-cast_operand
-  : value_expression
-  ;
-
-cast_target
-  : data_type
-  ;
-
-/*
-===============================================================================
-  6.25 <value expression>
-===============================================================================
-*/
-value_expression
-  : common_value_expression
-  | row_value_expression
-  | boolean_value_expression
-  ;
-
-common_value_expression
-  : numeric_value_expression
-  | string_value_expression
-  | datetime_value_expression
-  | NULL
-  ;
-
-/*
-===============================================================================
-  6.26 <numeric value expression>
-
-  Specify a comparison of two row values.
-===============================================================================
-*/
-
-numeric_value_expression
-  : left=term ((PLUS|MINUS) right=term)*
-  ;
-
-term
-  : left=factor ((MULTIPLY|DIVIDE|MODULAR) right=factor)*
-  ;
-
-factor
-  : (sign)? numeric_primary
-  ;
-
-array
-  : LEFT_PAREN numeric_value_expression (COMMA numeric_value_expression )* RIGHT_PAREN
-  ;
-
-numeric_primary
-  : value_expression_primary (CAST_EXPRESSION cast_target)*
-  | numeric_value_function
-  ;
-
-sign
-  : PLUS | MINUS
-  ;
-
-/*
-===============================================================================
-  6.27 <numeric value function>
-===============================================================================
-*/
-
-numeric_value_function
-  : extract_expression
-  | datetime_value_function
-  ;
-
-extract_expression
-  : EXTRACT LEFT_PAREN extract_field_string=extract_field FROM extract_source RIGHT_PAREN
-  ;
-
-extract_field
-  : primary_datetime_field
-  | time_zone_field
-  | extended_datetime_field
-  ;
-
-time_zone_field
-  : TIMEZONE | TIMEZONE_HOUR | TIMEZONE_MINUTE
-  ;
-
-extract_source
-  : datetime_value_expression
-  ;
-
-/*
-===============================================================================
-  6.28 <string value expression>
-===============================================================================
-*/
-
-string_value_expression
-  : character_value_expression
-  ;
-
-character_value_expression
-  : character_factor (CONCATENATION_OPERATOR character_factor)*
-  ;
-
-character_factor
-  : character_primary
-  ;
-
-character_primary
-  : value_expression_primary
-  | string_value_function
-  ;
-
-/*
-===============================================================================
-  6.29 <string value function>
-===============================================================================
-*/
-
-string_value_function
-  : trim_function
-  ;
-
-trim_function
-  : TRIM LEFT_PAREN trim_operands RIGHT_PAREN
-  ;
-
-trim_operands
-  : ((trim_specification)? (trim_character=character_value_expression)? FROM)? trim_source=character_value_expression
-  | trim_source=character_value_expression COMMA trim_character=character_value_expression
-  ;
-
-trim_specification
-  : LEADING | TRAILING | BOTH
-  ;
-
-/*
-===============================================================================
-  6.30 <datetime_value_expression>
-===============================================================================
-*/
-datetime_value_expression
-  : datetime_term
-  ;
-datetime_term
-  : datetime_factor
-  ;
-
-datetime_factor
-  : datetime_primary
-  ;
-
-datetime_primary
-  : value_expression_primary
-  | datetime_value_function
-  ;
-
-/*
-===============================================================================
-  6.31 <datetime_value_function>
-===============================================================================
-*/
-
-datetime_value_function
-  : current_date_value_function
-  | current_time_value_function
-  | current_timestamp_value_function
-  ;
-
-current_date_value_function
-  : CURRENT_DATE
-  | CURRENT_DATE LEFT_PAREN RIGHT_PAREN
-  ;
-
-current_time_value_function
-  : CURRENT_TIME
-  | CURRENT_TIME LEFT_PAREN RIGHT_PAREN
-  ;
-
-current_timestamp_value_function
-  : CURRENT_TIMESTAMP
-  ;
-
-/*
-===============================================================================
-  6.34 <boolean value expression>
-===============================================================================
-*/
-
-boolean_value_expression
-  : or_predicate
-  ;
-
-or_predicate
-  : and_predicate (OR or_predicate)*
-  ;
-
-and_predicate
-  : boolean_factor (AND and_predicate)*
-  ;
-
-boolean_factor
-  : boolean_test
-  | NOT boolean_test
-  ;
-
-boolean_test
-  : boolean_primary is_clause?
-  ;
-
-is_clause
-  : IS NOT? t=truth_value
-  ;
-
-truth_value
-  : TRUE | FALSE | UNKNOWN
-  ;
-
-boolean_primary
-  : predicate
-  | boolean_predicand
-  ;
-
-boolean_predicand
-  : parenthesized_boolean_value_expression
-  | nonparenthesized_value_expression_primary
-  ;
-
-parenthesized_boolean_value_expression
-  : LEFT_PAREN boolean_value_expression RIGHT_PAREN
-  ;
-
-/*
-===============================================================================
-  7.2 <row value expression>
-===============================================================================
-*/
-row_value_expression
-  : row_value_special_case
-  | explicit_row_value_constructor
-  ;
-
-row_value_special_case
-  : nonparenthesized_value_expression_primary
-  ;
-
-explicit_row_value_constructor
-  : NULL
-  ;
-
-row_value_predicand
-  : row_value_special_case
-  | row_value_constructor_predicand
-  ;
-
-row_value_constructor_predicand
-  : common_value_expression
-  | boolean_predicand
-//  | explicit_row_value_constructor
-  ;
-
-/*
-===============================================================================
-  7.4 <table expression>
-===============================================================================
-*/
-
-table_expression
-  : from_clause
-    where_clause?
-    groupby_clause?
-    having_clause?
-    orderby_clause?
-    window_clause?
-    limit_clause?
-  ;
-
-/*
-===============================================================================
-  7.5 <from clause>
-===============================================================================
-*/
-
-from_clause
-  : FROM table_reference_list
-  ;
-
-table_reference_list
-  :table_reference (COMMA table_reference)*
-  ;
-
-/*
-===============================================================================
-  7.6 <table reference>
-===============================================================================
-*/
-
-table_reference
-  : joined_table
-  | table_primary
-  ;
-
-/*
-===============================================================================
-  7.7 <joined table>
-===============================================================================
-*/
-
-joined_table
-  : table_primary joined_table_primary+
-  ;
-
-joined_table_primary
-  : CROSS JOIN right=table_primary
-  | (t=join_type)? JOIN right=table_primary s=join_specification
-  | NATURAL (t=join_type)? JOIN right=table_primary
-  | UNION JOIN right=table_primary
-  ;
-
-cross_join
-  : CROSS JOIN r=table_primary
-  ;
-
-qualified_join
-  : (t=join_type)? JOIN r=table_primary s=join_specification
-  ;
-
-natural_join
-  : NATURAL (t=join_type)? JOIN r=table_primary
-  ;
-
-union_join
-  : UNION JOIN r=table_primary
-  ;
-
-join_type
-  : INNER
-  | t=outer_join_type
-  ;
-
-outer_join_type
-  : outer_join_type_part2 OUTER?
-  ;
-
-outer_join_type_part2
-  : LEFT
-  | RIGHT
-  | FULL
-  ;
-
-join_specification
-  : join_condition
-  | named_columns_join
-  ;
-
-join_condition
-  : ON search_condition
-  ;
-
-named_columns_join
-  : USING LEFT_PAREN f=column_reference_list RIGHT_PAREN
-  ;
-
-table_primary
-  : table_or_query_name ((AS)? alias=identifier)? (LEFT_PAREN column_name_list RIGHT_PAREN)?
-  | derived_table (AS)? name=identifier (LEFT_PAREN column_name_list RIGHT_PAREN)?
-  ;
-
-column_name_list
-  :  identifier  ( COMMA identifier  )*
-  ;
-
-derived_table
-  : table_subquery
-  ;
-
-/*
-===============================================================================
-  7.8 <where clause>
-===============================================================================
-*/
-where_clause
-  : WHERE search_condition
-  ;
-
-search_condition
-  : value_expression // instead of boolean_value_expression, we use value_expression for more flexibility.
-  ;
-
-/*
-===============================================================================
-  7.9 <group by clause>
-===============================================================================
-*/
-groupby_clause
-  : GROUP BY g=grouping_element_list
-  ;
-
-grouping_element_list
-  : grouping_element (COMMA grouping_element)*
-  ;
-
-grouping_element
-  : rollup_list
-  | cube_list
-  | empty_grouping_set
-  | ordinary_grouping_set
-  ;
-
-ordinary_grouping_set
-  : row_value_predicand
-  | LEFT_PAREN row_value_predicand_list RIGHT_PAREN
-  ;
-
-ordinary_grouping_set_list
-  : ordinary_grouping_set (COMMA ordinary_grouping_set)*
-  ;
-
-rollup_list
-  : ROLLUP LEFT_PAREN c=ordinary_grouping_set_list RIGHT_PAREN
-  ;
-
-cube_list
-  : CUBE LEFT_PAREN c=ordinary_grouping_set_list RIGHT_PAREN
-  ;
-
-empty_grouping_set
-  : LEFT_PAREN RIGHT_PAREN
-  ;
-
-having_clause
-  : HAVING boolean_value_expression
-  ;
-
-row_value_predicand_list
-  : row_value_predicand (COMMA row_value_predicand)*
-  ;
-
-
- /*
- ===============================================================================
-   7.11 <window clause> (p331)
- ===============================================================================
- */
-
-window_clause
-  : WINDOW window_definition_list;
-
-window_definition_list
-  : window_definition (COMMA window_definition)*
-  ;
-
-window_definition
-  : window_name AS window_specification
-  ;
-
-window_name
-  : identifier
-  ;
-
-window_specification
-  : LEFT_PAREN window_specification_details RIGHT_PAREN
-  ;
-
-window_specification_details
-  : (existing_window_name)? (window_partition_clause)? (window_order_clause)? (window_frame_clause)?
-  ;
-
-existing_window_name
-  : window_name
-  ;
-
-window_partition_clause
-  : PARTITION BY row_value_predicand_list
-  ;
-
-window_order_clause
-  : orderby_clause
-  ;
-
-window_frame_clause
-  : window_frame_units window_frame_extent (window_frame_exclusion)?
-  ;
-
-window_frame_units
-  : ROWS | RANGE
-  ;
-
-window_frame_extent
-  : window_frame_start_bound
-  | window_frame_between
-  ;
-
-window_frame_start_bound
-  : UNBOUNDED PRECEDING
-  | unsigned_value_specification PRECEDING // window_frame_preceding
-  | CURRENT ROW
-  ;
-
-window_frame_between
-  : BETWEEN bound1=window_frame_start_bound AND bound2=window_frame_end_bound
-  ;
-
-window_frame_end_bound
-  : UNBOUNDED FOLLOWING
-  | unsigned_value_specification FOLLOWING // window_frame_following FOLLOWING
-  | CURRENT ROW
-  ;
-
-window_frame_exclusion
-  : EXCLUDE CURRENT ROW
-  | EXCLUDE GROUP
-  | EXCLUDE TIES
-  | EXCLUDE NO OTHERS
-  ;
-
-/*
-===============================================================================
-  7.13 <query expression>
-===============================================================================
-*/
-query_expression
-  : query_expression_body
-  ;
-
-query_expression_body
-  : non_join_query_expression
-  | joined_table
-  ;
-
-non_join_query_expression
-  : (non_join_query_term
-  | joined_table (UNION | EXCEPT) (ALL|DISTINCT)? query_term)
-    ((UNION | EXCEPT) (ALL|DISTINCT)? query_term)*
-  ;
-
-query_term
-  : non_join_query_term
-  | joined_table
-  ;
-
-non_join_query_term
-  : ( non_join_query_primary
-  | joined_table INTERSECT (ALL|DISTINCT)? query_primary)
-    (INTERSECT (ALL|DISTINCT)? query_primary)*
-  ;
-
-query_primary
-  : non_join_query_primary
-  | joined_table
-  ;
-
-non_join_query_primary
-  : simple_table
-  | LEFT_PAREN non_join_query_expression RIGHT_PAREN
-  ;
-
-simple_table
-  : query_specification
-  | explicit_table
-  ;
-
-explicit_table
-  : TABLE table_or_query_name
-  ;
-
-table_or_query_name
-  : table_name
-  | identifier
-  ;
-
-table_name
-  : identifier (DOT identifier ( DOT identifier)? )?
-  ;
-
-column_name
-  : identifier
-  ;
-
-query_specification
-  : SELECT set_qualifier? select_list table_expression?
-  ;
-
-select_list
-  : select_sublist (COMMA select_sublist)*
-  ;
-
-select_sublist
-  : derived_column
-  | qualified_asterisk
-  ;
-
-derived_column
-  : value_expression as_clause?
-  ;
-
-qualified_asterisk
-  : (tb_name=identifier DOT)? MULTIPLY
-  ;
-
-set_qualifier
-  : DISTINCT
-  | ALL
-  ;
-
-column_reference
-  : identifier (DOT identifier)*
-  ;
-
-as_clause
-  : (AS)? identifier
-  ;
-
-column_reference_list
-  : column_reference (COMMA column_reference)*
-  ;
-
-/*
-==============================================================================================
-  7.15 <subquery>
-
-  Specify a scalar value, a row, or a table derived from a query_expression .
-==============================================================================================
-*/
-
-scalar_subquery
-  :  subquery
-  ;
-
-row_subquery
-  :  subquery
-  ;
-
-table_subquery
-  : subquery
-  ;
-
-subquery
-  :  LEFT_PAREN query_expression RIGHT_PAREN
-  ;
-
-/*
-===============================================================================
-  8.1 <predicate>
-===============================================================================
-*/
-
-predicate
-  : comparison_predicate
-  | between_predicate
-  | in_predicate
-  | pattern_matching_predicate // like predicate and other similar predicates
-  | null_predicate
-  | exists_predicate
-  ;
-
-/*
-===============================================================================
-  8.2 <comparison predicate>
-
-  Specify a comparison of two row values.
-===============================================================================
-*/
-comparison_predicate
-  : left=row_value_predicand c=comp_op right=row_value_predicand
-  ;
-
-comp_op
-  : EQUAL
-  | NOT_EQUAL
-  | LTH
-  | LEQ
-  | GTH
-  | GEQ
-  ;
-
-/*
-===============================================================================
-  8.3 <between predicate>
-===============================================================================
-*/
-
-between_predicate
-  : predicand=row_value_predicand between_predicate_part_2
-  ;
-
-between_predicate_part_2
-  : (NOT)? BETWEEN (ASYMMETRIC | SYMMETRIC)? begin=row_value_predicand AND end=row_value_predicand
-  ;
-
-
-/*
-===============================================================================
-  8.4 <in predicate>
-===============================================================================
-*/
-
-in_predicate
-  : predicand=numeric_value_expression  NOT? IN in_predicate_value
-  ;
-
-in_predicate_value
-  : table_subquery
-  | LEFT_PAREN in_value_list RIGHT_PAREN
-  ;
-
-in_value_list
-  : row_value_predicand  ( COMMA row_value_predicand )*
-  ;
-
-/*
-===============================================================================
-  8.5, 8.6 <pattern matching predicate>
-
-  Specify a pattern-matching comparison.
-===============================================================================
-*/
-
-pattern_matching_predicate
-  : f=row_value_predicand pattern_matcher s=Character_String_Literal
-  ;
-
-pattern_matcher
-  : NOT? negativable_matcher
-  | regex_matcher
-  ;
-
-negativable_matcher
-  : LIKE
-  | ILIKE
-  | SIMILAR TO
-  | REGEXP
-  | RLIKE
-  ;
-
-regex_matcher
-  : Similar_To
-  | Not_Similar_To
-  | Similar_To_Case_Insensitive
-  | Not_Similar_To_Case_Insensitive
-  ;
-
-/*
-===============================================================================
-  8.7 <null predicate>
-
-  Specify a test for a null value.
-===============================================================================
-*/
-
-null_predicate
-  : predicand=row_value_predicand IS (n=NOT)? NULL
-  ;
-
-/*
-==============================================================================================
-  8.8 <quantified comparison predicate>
-
-  Specify a quantified comparison.
-==============================================================================================
-*/
-
-quantified_comparison_predicate
-  : l=numeric_value_expression  c=comp_op q=quantifier s=table_subquery
-  ;
-
-quantifier : all  | some ;
-
-all : ALL;
-
-some : SOME | ANY;
-
-/*
-==============================================================================================
-  8.9 <exists predicate>
-
-  Specify a test for a non_empty set.
-==============================================================================================
-*/
-
-exists_predicate
-  : NOT? EXISTS s=table_subquery
-  ;
-
-
-/*
-==============================================================================================
-  8.10 <unique predicate>
-
-  Specify a test for the absence of duplicate rows
-==============================================================================================
-*/
-
-unique_predicate
-  : UNIQUE s=table_subquery
-  ;
-
-/*
-===============================================================================
-  10.1 <interval qualifier>
-
-  Specify the precision of an interval data type.
-===============================================================================
-*/
-
-primary_datetime_field
-	:	non_second_primary_datetime_field
-	|	SECOND
-	;
-
-non_second_primary_datetime_field
-  : YEAR | MONTH | DAY | HOUR | MINUTE
-  ;
-
-extended_datetime_field
-  : CENTURY | DECADE | DOW | DOY | EPOCH | ISODOW | ISOYEAR | MICROSECONDS | MILLENNIUM | MILLISECONDS | QUARTER | WEEK
-  ;
-
-/*
-===============================================================================
-  10.4 <routine invocation>
-
-  Invoke an SQL-invoked routine.
-===============================================================================
-*/
-
-routine_invocation
-  : function_name LEFT_PAREN sql_argument_list? RIGHT_PAREN
-  ;
-
-function_names_for_reserved_words
-  : LEFT
-  | RIGHT
-  ;
-
-function_name
-  : identifier
-  | function_names_for_reserved_words
-  ;
-
-sql_argument_list
-  : value_expression (COMMA value_expression)*
-  ;
-
-/*
-===============================================================================
-  14.1 <declare cursor>
-===============================================================================
-*/
-
-orderby_clause
-  : ORDER BY sort_specifier_list
-  ;
-
-sort_specifier_list
-  : sort_specifier (COMMA sort_specifier)*
-  ;
-
-sort_specifier
-  : key=row_value_predicand order=order_specification? null_order=null_ordering?
-  ;
-
-order_specification
-  : ASC
-  | DESC
-  ;
-
-limit_clause
-  : LIMIT e=numeric_value_expression
-  ;
-
-null_ordering
-  : NULL FIRST
-  | NULL LAST
-  ;
-
-/*
-===============================================================================
-  14.8 <insert statement>
-===============================================================================
-*/
-
-insert_statement
-  : INSERT (OVERWRITE)? INTO table_name (LEFT_PAREN column_reference_list RIGHT_PAREN)? query_expression
-  | INSERT (OVERWRITE)? INTO LOCATION path=Character_String_Literal (USING storage_type=identifier (param_clause)?)? query_expression
-  ;
-
-/*
-===============================================================================
-  <alter table>
-===============================================================================
-*/
-
-alter_tablespace_statement
-  : ALTER TABLESPACE space_name=identifier LOCATION uri=Character_String_Literal
-  ;
-
-alter_table_statement
-  : ALTER TABLE table_name RENAME TO table_name
-  | ALTER TABLE table_name RENAME COLUMN column_name TO column_name
-  | ALTER TABLE table_name ADD COLUMN field_element
-  | ALTER TABLE table_name ADD (if_not_exists)? PARTITION LEFT_PAREN partition_column_value_list RIGHT_PAREN (LOCATION path=Character_String_Literal)?
-  | ALTER TABLE table_name DROP (if_exists)? PARTITION LEFT_PAREN partition_column_value_list RIGHT_PAREN (PURGE)?
-  | ALTER TABLE table_name SET PROPERTY property_list
-  ;
-
-partition_column_value_list
-  : partition_column_value (COMMA partition_column_value)*
-  ;
-
-partition_column_value
-  : identifier EQUAL row_value_predicand
-  ;
-
-property_list
-  : property (COMMA property)*
-  ;
-
-property
-  : key=Character_String_Literal EQUAL value=Character_String_Literal
-  ;

http://git-wip-us.apache.org/repos/asf/tajo/blob/b1d08f89/tajo-sql-parser/src/main/antlr4/org/apache/tajo/parser/sql/SQLLexer.g4
----------------------------------------------------------------------
diff --git a/tajo-sql-parser/src/main/antlr4/org/apache/tajo/parser/sql/SQLLexer.g4 b/tajo-sql-parser/src/main/antlr4/org/apache/tajo/parser/sql/SQLLexer.g4
new file mode 100644
index 0000000..896f627
--- /dev/null
+++ b/tajo-sql-parser/src/main/antlr4/org/apache/tajo/parser/sql/SQLLexer.g4
@@ -0,0 +1,513 @@
+/*
+ Licensed to the Apache Software Foundation (ASF) under one
+ or more contributor license agreements.  See the NOTICE file
+ distributed with this work for additional information
+ regarding copyright ownership.  The ASF licenses this file
+ to you under the Apache License, Version 2.0 (the
+ "License"); you may not use this file except in compliance
+ with the License.  You may obtain a copy of the License at
+
+     http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing, software
+ distributed under the License is distributed on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ See the License for the specific language governing permissions and
+ limitations under the License.
+ */
+
+lexer grammar SQLLexer;
+
+@header {
+}
+
+@members {
+}
+
+
+/*
+===============================================================================
+  Tokens for Case Insensitive Keywords
+===============================================================================
+*/
+fragment A
+	:	'A' | 'a';
+
+fragment B
+	:	'B' | 'b';
+
+fragment C
+	:	'C' | 'c';
+
+fragment D
+	:	'D' | 'd';
+
+fragment E
+	:	'E' | 'e';
+
+fragment F
+	:	'F' | 'f';
+
+fragment G
+	:	'G' | 'g';
+
+fragment H
+	:	'H' | 'h';
+
+fragment I
+	:	'I' | 'i';
+
+fragment J
+	:	'J' | 'j';
+
+fragment K
+	:	'K' | 'k';
+
+fragment L
+	:	'L' | 'l';
+
+fragment M
+	:	'M' | 'm';
+
+fragment N
+	:	'N' | 'n';
+
+fragment O
+	:	'O' | 'o';
+
+fragment P
+	:	'P' | 'p';
+
+fragment Q
+	:	'Q' | 'q';
+
+fragment R
+	:	'R' | 'r';
+
+fragment S
+	:	'S' | 's';
+
+fragment T
+	:	'T' | 't';
+
+fragment U
+	:	'U' | 'u';
+
+fragment V
+	:	'V' | 'v';
+
+fragment W
+	:	'W' | 'w';
+
+fragment X
+	:	'X' | 'x';
+
+fragment Y
+	:	'Y' | 'y';
+
+fragment Z
+	:	'Z' | 'z';
+
+/*
+===============================================================================
+  Reserved Keywords
+===============================================================================
+*/
+
+AS : A S;
+ALL : A L L;
+AND : A N D;
+ANY : A N Y;
+ASYMMETRIC : A S Y M M E T R I C;
+ASC : A S C;
+
+
+BOTH : B O T H;
+
+CASE : C A S E;
+CAST : C A S T;
+CREATE : C R E A T E;
+CROSS : C R O S S;
+CURRENT_DATE: C U R R E N T UNDERLINE D A T E;
+CURRENT_TIME: C U R R E N T UNDERLINE T I M E;
+CURRENT_TIMESTAMP: C U R R E N T UNDERLINE T I M E S T A M P;
+
+DESC : D E S C;
+DISTINCT : D I S T I N C T;
+
+END : E N D;
+ELSE : E L S E;
+EXCEPT : E X C E P T;
+
+FALSE : F A L S E;
+FULL : F U L L;
+FROM : F R O M;
+
+GROUP : G R O U P;
+
+HAVING : H A V I N G;
+
+ILIKE : I L I K E;
+IN : I N;
+INNER : I N N E R;
+INTERSECT : I N T E R S E C T;
+INTO : I N T O;
+IS : I S;
+
+JOIN : J O I N;
+
+LEADING : L E A D I N G;
+LEFT : L E F T;
+LIKE : L I K E;
+LIMIT : L I M I T;
+
+NATURAL : N A T U R A L;
+NOT : N O T;
+NULL : N U L L;
+
+ON : O N;
+OR : O R;
+ORDER : O R D E R;
+OUTER : O U T E R;
+OVER : O V E R;
+RIGHT : R I G H T;
+SELECT : S E L E C T;
+SOME : S O M E;
+SYMMETRIC : S Y M M E T R I C;
+
+TABLE : T A B L E;
+THEN : T H E N;
+TRAILING : T R A I L I N G;
+TRUE : T R U E;
+
+UNION : U N I O N;
+UNIQUE : U N I Q U E;
+USING : U S I N G;
+
+WHEN : W H E N;
+WHERE : W H E R E;
+WITH : W I T H;
+WINDOW : W I N D O W;
+
+/*
+===============================================================================
+  Non Reserved Keywords
+===============================================================================
+*/
+AVG : A V G;
+ADD: A D D;
+ALTER : A L T E R;
+
+BETWEEN : B E T W E E N;
+BY : B Y;
+
+CATALOG : C A T A L O G;
+CENTURY : C E N T U R Y;
+CHARACTER : C H A R A C T E R;
+COLLECT : C O L L E C T;
+COALESCE : C O A L E S C E;
+COLUMN : C O L U M N;
+COUNT : C O U N T;
+CUBE : C U B E;
+CUME_DIST : C U M E UNDERLINE D I S T;
+CURRENT : C U R R E N T;
+
+DAY : D A Y;
+DEFAULT : D E F A U L T;
+DATABASE : D A T A B A S E;
+DEC : D E C;
+DECADE : D E C A D E;
+DENSE_RANK : D E N S E UNDERLINE R A N K;
+DOW : D O W;
+DOY : D O Y;
+DROP : D R O P;
+
+EPOCH : E P O C H;
+EVERY : E V E R Y;
+EXCLUDE : E X C L U D E;
+EXISTS : E X I S T S;
+EXPLAIN : E X P L A I N;
+EXTERNAL : E X T E R N A L;
+EXTRACT : E X T R A C T;
+
+FILTER : F I L T E R;
+FIRST : F I R S T;
+FIRST_VALUE : F I R S T UNDERLINE V A L U E;
+FOLLOWING : F O L L O W I N G;
+FORMAT : F O R M A T;
+FUSION : F U S I O N;
+
+GLOBAL : G L O B A L;
+GROUPING : G R O U P I N G;
+
+HASH : H A S H;
+HOUR : H O U R;
+
+IF : I F;
+INDEX : I N D E X;
+INSERT : I N S E R T;
+INTERSECTION : I N T E R S E C T I O N;
+ISODOW : I S O D O W;
+ISOYEAR : I S O Y E A R;
+
+LAG : L A G;
+LAST : L A S T;
+LAST_VALUE : L A S T UNDERLINE V A L U E;
+LEAD : L E A D;
+LESS : L E S S;
+LIST : L I S T;
+LOCATION : L O C A T I O N;
+
+MAP : M A P;
+MAX : M A X;
+MAXVALUE : M A X V A L U E;
+MICROSECONDS : M I C R O S E C O N D S;
+MILLENNIUM : M I L L E N N I U M;
+MILLISECONDS : M I L L I S E C O N D S;
+MIN : M I N;
+MINUTE : M I N U T E;
+MONTH : M O N T H;
+
+NATIONAL : N A T I O N A L;
+NULLIF : N U L L I F;
+NO : N O;
+
+OVERWRITE : O V E R W R I T E;
+OTHERS: O T H E R S;
+
+PARTITION : P A R T I T I O N;
+PARTITIONS : P A R T I T I O N S;
+PERCENT_RANK : P E R C E N T UNDERLINE R A N K;
+PRECEDING : P R E C E D I N G;
+PRECISION : P R E C I S I O N;
+PURGE : P U R G E;
+PROPERTY : P R O P E R T Y;
+
+QUARTER : Q U A R T E R;
+
+RANGE : R A N G E;
+RANK : R A N K;
+RECORD : R E C O R D;
+REGEXP : R E G E X P;
+RENAME : R E N A M E;
+RESET : R E S E T;
+RLIKE : R L I K E;
+ROLLUP : R O L L U P;
+ROW : R O W;
+ROWS : R O W S;
+ROW_NUMBER :  R O W UNDERLINE N U M B E R;
+
+SECOND : S E C O N D;
+SESSION : S E S S I O N;
+SET : S E T;
+SIMILAR : S I M I L A R;
+STDDEV_POP : S T D D E V UNDERLINE P O P;
+STDDEV_SAMP : S T D D E V UNDERLINE S A M P;
+SUBPARTITION : S U B P A R T I T I O N;
+SUM : S U M;
+
+TABLESPACE : T A B L E S P A C E;
+THAN : T H A N;
+TIES : T I E S;
+TIMEZONE: T I M E Z O N E;
+TIMEZONE_HOUR: T I M E Z O N E UNDERLINE H O U R;
+TIMEZONE_MINUTE: T I M E Z O N E UNDERLINE M I N U T E;
+TRIM : T R I M;
+TO : T O;
+TRUNCATE : T R U N C A T E;
+
+UNBOUNDED : U N B O U N D E D;
+UNKNOWN : U N K N O W N;
+
+VALUES : V A L U E S;
+VAR_SAMP : V A R UNDERLINE S A M P;
+VAR_POP : V A R UNDERLINE P O P;
+VARYING : V A R Y I N G;
+
+WEEK : W E E K;
+
+YEAR : Y E A R;
+
+ZONE : Z O N E;
+
+
+/*
+===============================================================================
+  Data Type Tokens
+===============================================================================
+*/
+BOOLEAN : B O O L E A N;
+BOOL : B O O L;
+BIT : B I T;
+VARBIT : V A R B I T;
+
+INT1 : I N T '1';
+INT2 : I N T '2';
+INT4 : I N T '4';
+INT8 : I N T '8';
+
+TINYINT : T I N Y I N T; // alias for INT1
+SMALLINT : S M A L L I N T; // alias for INT2
+INT : I N T; // alias for INT4
+INTEGER : I N T E G E R; // alias - INT4
+BIGINT : B I G I N T; // alias for INT8
+
+FLOAT4 : F L O A T '4';
+FLOAT8 : F L O A T '8';
+
+REAL : R E A L; // alias for FLOAT4
+FLOAT : F L O A T; // alias for FLOAT8
+DOUBLE : D O U B L E; // alias for FLOAT8
+
+NUMERIC : N U M E R I C;
+DECIMAL : D E C I M A L; // alias for number
+
+CHAR : C H A R;
+VARCHAR : V A R C H A R;
+NCHAR : N C H A R;
+NVARCHAR : N V A R C H A R;
+
+DATE : D A T E;
+INTERVAL: I N T E R V A L;
+TIME : T I M E;
+TIMETZ : T I M E T Z;
+TIMESTAMP : T I M E S T A M P;
+TIMESTAMPTZ : T I M E S T A M P T Z;
+
+TEXT : T E X T;
+
+BINARY : B I N A R Y;
+VARBINARY : V A R B I N A R Y;
+BLOB : B L O B;
+BYTEA : B Y T E A; // alias for BLOB
+
+INET4 : I N E T '4';
+
+// Operators
+Similar_To : '~';
+Not_Similar_To : '!~';
+Similar_To_Case_Insensitive : '~*';
+Not_Similar_To_Case_Insensitive : '!~*';
+
+// Cast Operator
+CAST_EXPRESSION
+  : COLON COLON
+  ;
+
+ASSIGN  : ':=';
+EQUAL  : '=';
+COLON :  ':';
+SEMI_COLON :  ';';
+COMMA : ',';
+CONCATENATION_OPERATOR : VERTICAL_BAR VERTICAL_BAR;
+NOT_EQUAL  : '<>' | '!=' | '~='| '^=' ;
+LTH : '<' ;
+LEQ : '<=';
+GTH   : '>';
+GEQ   : '>=';
+LEFT_PAREN :  '(';
+RIGHT_PAREN : ')';
+PLUS  : '+';
+MINUS : '-';
+MULTIPLY: '*';
+DIVIDE  : '/';
+MODULAR : '%';
+DOT : '.';
+UNDERLINE : '_';
+VERTICAL_BAR : '|';
+QUOTE : '\'';
+DOUBLE_QUOTE : '"';
+
+NUMBER : Digit+;
+
+fragment
+Digit : '0'..'9';
+
+REAL_NUMBER
+    :   ('0'..'9')+ '.' ('0'..'9')* EXPONENT?
+    |   '.' ('0'..'9')+ EXPONENT?
+    |   ('0'..'9')+ EXPONENT
+    ;
+
+BlockComment
+    :   '/*' .*? '*/' -> skip
+    ;
+
+LineComment
+    :   '--' ~[\r\n]* -> skip
+    ;
+
+/*
+===============================================================================
+ Identifiers
+===============================================================================
+*/
+
+Regular_Identifier
+  : ('a'..'z'|'A'..'Z'|'_') ('a'..'z'|'A'..'Z'|Digit|'_')* { setText(getText().toLowerCase()); }
+  ;
+
+Quoted_Identifier
+  : DOUBLE_QUOTE ( ESC_SEQ | ~('\\'|'"') )* DOUBLE_QUOTE { setText(getText().substring(1, getText().length()-1)); }
+  ;
+
+/*
+===============================================================================
+ Literal
+===============================================================================
+*/
+
+// Some Unicode Character Ranges
+fragment
+Control_Characters                  :   '\u0001' .. '\u001F';
+fragment
+Extended_Control_Characters         :   '\u0080' .. '\u009F';
+
+Character_String_Literal
+  : QUOTE ( ESC_SEQ | ~('\\'|'\'') )* QUOTE
+  ;
+
+fragment
+EXPONENT : ('e'|'E') ('+'|'-')? ('0'..'9')+ ;
+
+fragment
+HEX_DIGIT : ('0'..'9'|'a'..'f'|'A'..'F') ;
+
+fragment
+ESC_SEQ
+    :   '\\' ('b'|'t'|'n'|'f'|'r'|'\"'|'\''|'\\')
+    |   UNICODE_ESC
+    |   OCTAL_ESC
+    ;
+
+fragment
+OCTAL_ESC
+    :   '\\' ('0'..'3') ('0'..'7') ('0'..'7')
+    |   '\\' ('0'..'7') ('0'..'7')
+    |   '\\' ('0'..'7')
+    ;
+
+fragment
+UNICODE_ESC
+    :   '\\' 'u' HEX_DIGIT HEX_DIGIT HEX_DIGIT HEX_DIGIT
+    ;
+
+
+/*
+===============================================================================
+ Whitespace Tokens
+===============================================================================
+*/
+
+Space
+  : ' ' -> skip
+  ;
+
+White_Space
+  :	( Control_Characters  | Extended_Control_Characters )+ -> skip
+  ;
+
+
+BAD
+  : . -> skip
+  ;


Mime
View raw message