<#-- 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. --> <#-- Add implementations of additional parser statements here. Each implementation should return an object of SqlNode type. Example of SqlShowTables() implementation: SqlNode SqlShowTables() { ...local variables... } { ... { return SqlShowTables(...) } } --> /** * Parses statement * SHOW TABLES [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] */ SqlNode SqlShowTables() : { SqlParserPos pos; SqlIdentifier db = null; SqlNode likePattern = null; SqlNode where = null; } { { pos = getPos(); } [ ( | ) { db = CompoundIdentifier(); } ] [ { likePattern = StringLiteral(); } | { where = Expression(ExprContext.ACCEPT_SUBQUERY); } ] { return new SqlShowTables(pos, db, likePattern, where); } } /** * Parses statement * SHOW FILES [{FROM | IN} schema] */ SqlNode SqlShowFiles() : { SqlParserPos pos = null; SqlIdentifier db = null; } { { pos = getPos(); } [ ( | ) { db = CompoundIdentifier(); } ] { return new SqlShowFiles(pos, db); } } /** * Parses statement SHOW {DATABASES | SCHEMAS} [LIKE 'pattern' | WHERE expr] */ SqlNode SqlShowSchemas() : { SqlParserPos pos; SqlNode likePattern = null; SqlNode where = null; } { { pos = getPos(); } ( | ) [ { likePattern = StringLiteral(); } | { where = Expression(ExprContext.ACCEPT_SUBQUERY); } ] { return new SqlShowSchemas(pos, likePattern, where); } } /** * Parses statement * { DESCRIBE | DESC } tblname [col_name | wildcard ] */ SqlNode SqlDescribeTable() : { SqlParserPos pos; SqlIdentifier table; SqlIdentifier column = null; SqlNode columnPattern = null; } { ( | ) { pos = getPos(); } table = CompoundIdentifier() ( column = CompoundIdentifier() | columnPattern = StringLiteral() | E() ) { return new DrillSqlDescribeTable(pos, table, column, columnPattern); } } SqlNode SqlUseSchema(): { SqlIdentifier schema; SqlParserPos pos; } { { pos = getPos(); } schema = CompoundIdentifier() { return new SqlUseSchema(pos, schema); } } /** Parses an optional field list and makes sure no field is a "*". */ SqlNodeList ParseOptionalFieldList(String relType) : { SqlNodeList fieldList; } { fieldList = ParseRequiredFieldList(relType) { return fieldList; } | { return SqlNodeList.EMPTY; } } /** Parses a required field list and makes sure no field is a "*". */ SqlNodeList ParseRequiredFieldList(String relType) : { Pair fieldList; } { fieldList = ParenthesizedCompoundIdentifierList() { for(SqlNode node : fieldList.left) { if (((SqlIdentifier) node).isStar()) throw new ParseException(String.format("%s's field list has a '*', which is invalid.", relType)); } return fieldList.left; } } /** * Rarses CREATE [OR REPLACE] command for VIEW, TABLE or SCHEMA. */ SqlNode SqlCreateOrReplace() : { SqlParserPos pos; String createType = "SIMPLE"; boolean isTemporary = false; } { { pos = getPos(); } [ { createType = "OR_REPLACE"; } ] [ { isTemporary = true; } ] ( { if (isTemporary) { throw new ParseException("Create view statement does not allow keyword."); } return SqlCreateView(pos, createType); } | { if (createType == "OR_REPLACE") { throw new ParseException("Create table statement does not allow ."); } return SqlCreateTable(pos, isTemporary); } | { if (isTemporary) { throw new ParseException("Create schema statement does not allow keyword."); } return SqlCreateSchema(pos, createType); } ) } /** * Parses a create view or replace existing view statement. * after CREATE OR REPLACE VIEW statement which is handled in the SqlCreateOrReplace method. * * CREATE { [OR REPLACE] VIEW | VIEW [IF NOT EXISTS] | VIEW } view_name [ (field1, field2 ...) ] AS select_statement */ SqlNode SqlCreateView(SqlParserPos pos, String createType) : { SqlIdentifier viewName; SqlNode query; SqlNodeList fieldList; } { [ { if (createType == "OR_REPLACE") { throw new ParseException("Create view statement cannot have both and clause"); } createType = "IF_NOT_EXISTS"; } ] viewName = CompoundIdentifier() fieldList = ParseOptionalFieldList("View") query = OrderedQueryOrExpr(ExprContext.ACCEPT_QUERY) { return new SqlCreateView(pos, viewName, fieldList, query, SqlLiteral.createCharString(createType, getPos())); } } /** * Parses a CTAS or CTTAS statement after CREATE [TEMPORARY] TABLE statement * which is handled in the SqlCreateOrReplace method. * * CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tblname [ (field1, field2, ...) ] AS select_statement. */ SqlNode SqlCreateTable(SqlParserPos pos, boolean isTemporary) : { SqlIdentifier tblName; SqlNodeList fieldList; SqlNodeList partitionFieldList; SqlNode query; boolean tableNonExistenceCheck = false; } { { partitionFieldList = SqlNodeList.EMPTY; } ( { tableNonExistenceCheck = true; } )? tblName = CompoundIdentifier() fieldList = ParseOptionalFieldList("Table") ( partitionFieldList = ParseRequiredFieldList("Partition") )? query = OrderedQueryOrExpr(ExprContext.ACCEPT_QUERY) { return new SqlCreateTable(pos, tblName, fieldList, partitionFieldList, query, SqlLiteral.createBoolean(isTemporary, getPos()), SqlLiteral.createBoolean(tableNonExistenceCheck, getPos())); } } /** * Parses create table schema statement after CREATE OR REPLACE SCHEMA statement * which is handled in the SqlCreateOrReplace method. * * CREATE [OR REPLACE] SCHEMA * [ * LOAD 'file:///path/to/raw_schema' * | * ( * col1 int, * col2 varchar(10) not null * ) * ] * [FOR TABLE dfs.my_table] * [PATH 'file:///path/to/schema'] * [PROPERTIES ('prop1'='val1', 'prop2'='val2')] */ SqlNode SqlCreateSchema(SqlParserPos pos, String createType) : { SqlCharStringLiteral schema = null; SqlNode load = null; SqlIdentifier table = null; SqlNode path = null; SqlNodeList properties = null; } { { token_source.pushState(); token_source.SwitchTo(SCH); } ( { load = StringLiteral(); } | { schema = SqlLiteral.createCharString(token.image, getPos()); } ) ( { table = CompoundIdentifier(); } | { path = StringLiteral(); if (createType == "OR_REPLACE") { throw new ParseException(" cannot be used with property."); } } ) [ { properties = new SqlNodeList(getPos()); addProperty(properties); } ( { addProperty(properties); } )* ] { return new SqlSchema.Create(pos, schema, load, table, path, properties, SqlLiteral.createCharString(createType, getPos())); } } /** * Helper method to add string literals divided by equals into SqlNodeList. */ void addProperty(SqlNodeList properties) : {} { { properties.add(StringLiteral()); } { properties.add(StringLiteral()); } } SKIP : { " " | "\t" | "\n" | "\r" } TOKEN : { < LOAD: "LOAD" > { popState(); } | < NUM: (" " | "\t" | "\n" | "\r")* > // once schema is found, swich back to initial lexical state // must be enclosed in the parentheses // inside may have left parenthesis only if number precededs (covers cases with varchar(10)), // if left parenthesis is present in column name, it must be escaped with backslash | < PAREN_STRING: ((~[")"]) | ( ")") | ("\\)"))+ > { popState(); } } /** * Parses DROP command for VIEW, TABLE and SCHEMA. */ SqlNode SqlDrop() : { SqlParserPos pos; } { { pos = getPos(); } ( { return SqlDropView(pos); } | { return SqlDropTable(pos); } | { return SqlDropSchema(pos); } ) } /** * Parses a drop view or drop view if exists statement * after DROP VIEW statement which is handled in SqlDrop method. * * DROP VIEW [IF EXISTS] view_name; */ SqlNode SqlDropView(SqlParserPos pos) : { boolean viewExistenceCheck = false; } { [ { viewExistenceCheck = true; } ] { return new SqlDropView(pos, CompoundIdentifier(), viewExistenceCheck); } } /** * Parses a drop table or drop table if exists statement * after DROP TABLE statement which is handled in SqlDrop method. * * DROP TABLE [IF EXISTS] table_name; */ SqlNode SqlDropTable(SqlParserPos pos) : { boolean tableExistenceCheck = false; } { [ { tableExistenceCheck = true; } ] { return new SqlDropTable(pos, CompoundIdentifier(), tableExistenceCheck); } } /** * Parses drop schema or drop schema if exists statement * after DROP SCHEMA statement which is handled in SqlDrop method. * * DROP SCHEMA [IF EXISTS] * FOR TABLE dfs.my_table */ SqlNode SqlDropSchema(SqlParserPos pos) : { SqlIdentifier table = null; boolean existenceCheck = false; } { [ { existenceCheck = true; } ] { table = CompoundIdentifier(); } { return new SqlSchema.Drop(pos, table, SqlLiteral.createBoolean(existenceCheck, getPos())); } } /** * Parse refresh table metadata statement. * REFRESH TABLE METADATA [COLUMNS ((field1, field2,..) | NONE)] tblname */ SqlNode SqlRefreshMetadata() : { SqlParserPos pos; SqlIdentifier tblName; SqlNodeList fieldList = null; SqlNode query; boolean allColumns = true; } { { pos = getPos(); } [ { allColumns = false; } ( fieldList = ParseRequiredFieldList("Table") | ) ] tblName = CompoundIdentifier() { return new SqlRefreshMetadata(pos, tblName, SqlLiteral.createBoolean(allColumns, getPos()), fieldList); } } /** * Parses statement * DESCRIBE { SCHEMA | DATABASE } name */ SqlNode SqlDescribeSchema() : { SqlParserPos pos; SqlIdentifier schema; } { { pos = getPos(); } ( | ) { schema = CompoundIdentifier(); } { return new SqlDescribeSchema(pos, schema); } } /** * Parse create UDF statement * CREATE FUNCTION USING JAR 'jar_name' */ SqlNode SqlCreateFunction() : { SqlParserPos pos; SqlNode jar; } { { pos = getPos(); } jar = StringLiteral() { return new SqlCreateFunction(pos, jar); } } /** * Parse drop UDF statement * DROP FUNCTION USING JAR 'jar_name' */ SqlNode SqlDropFunction() : { SqlParserPos pos; SqlNode jar; } { { pos = getPos(); } jar = StringLiteral() { return new SqlDropFunction(pos, jar); } } <#if !parser.includeCompoundIdentifier > /** * Parses a comma-separated list of simple identifiers. */ Pair ParenthesizedCompoundIdentifierList() : { List list = new ArrayList(); SqlIdentifier id; } { id = CompoundIdentifier() {list.add(id);} ( id = CompoundIdentifier() {list.add(id);}) * { return Pair.of(new SqlNodeList(list, getPos()), null); } } /** * Parses a analyze statement. * ANALYZE TABLE tblname {COMPUTE | ESTIMATE} | STATISTICS * [(column1, column2, ...)] [ SAMPLE numeric PERCENT ] */ SqlNode SqlAnalyzeTable() : { SqlParserPos pos; SqlIdentifier tblName; SqlLiteral estimate = null; SqlNodeList fieldList = null; SqlNumericLiteral percent = null; } { { pos = getPos(); } tblName = CompoundIdentifier() ( { estimate = SqlLiteral.createBoolean(false, pos); } | { estimate = SqlLiteral.createBoolean(true, pos); } ) [ (fieldList = ParseRequiredFieldList("Table")) ] [ percent = UnsignedNumericLiteral() { BigDecimal rate = percent.bigDecimalValue(); if (rate.compareTo(BigDecimal.ZERO) <= 0 || rate.compareTo(BigDecimal.valueOf(100L)) > 0) { throw new ParseException("Invalid percentage for ANALYZE TABLE"); } } ] { if (percent == null) { percent = SqlLiteral.createExactNumeric("100.0", pos); } return new SqlAnalyzeTable(pos, tblName, estimate, fieldList, percent); } }