gudusoft.gsqlparser.stmt

Class TCreateRoutineLoadStmt

Object

gudusoft.gsqlparser.nodes.TParseTreeNode

gudusoft.gsqlparser.TCustomSqlStatement

gudusoft.gsqlparser.stmt.TCreateRoutineLoadStmt

All Implemented Interfaces:

IRelation, Visitable, Iterator<TSourceToken>

public class TCreateRoutineLoadStmt
extends TCustomSqlStatement

CREATE ROUTINE LOAD statement for StarRocks. Syntax: CREATE ROUTINE LOAD [database.]job_name ON table_name [load_properties] [job_properties] FROM data_source [data_source_properties] load_properties: [COLUMNS TERMINATED BY ''] [ROWS TERMINATED BY ''] [COLUMNS ([, , , ...])] [WHERE ] [PARTITION ([, , ...])] job_properties: PROPERTIES ("key" = "value"[, ...]) data_source: FROM KAFKA ("key" = "value"[, ...])

Nested Class Summary

Nested classes/interfaces inherited from class gudusoft.gsqlparser.TCustomSqlStatement

TCustomSqlStatement.SqlNormalizationProfile

Field Summary

Fields inherited from class gudusoft.gsqlparser.TCustomSqlStatement

dummytag, fromClause, fromSourceJoin, fromSourceTable, isctequery, isparsed, joins, parser, plsqlparser, relationAttributes, rootNode, semicolonended, sourcetokenlist, sqlstatementtype, stmtScope, tables

Fields inherited from class gudusoft.gsqlparser.nodes.TParseTreeNode

dbvendor, doubleLinkedTokenListToString, nodeActionAppend, nodeActionInsert, nodeActionRemove, nodeActionUnknown, nodeActionUpdate, nodeActionUpdateText, nodeChangeEndToken, nodeChangeStartToken

Constructor Summary

Constructors

Constructor and Description
TCreateRoutineLoadStmt(EDbVendor dbvendor)

Method Summary

Modifier and Type	Method and Description
void	accept(TParseTreeVisitor v) Accept a visitor
void	acceptChildren(TParseTreeVisitor v) Accept a visitor to iterate this class and sub-nodes of this class
int	doParseStatement(TCustomSqlStatement psql)
TObjectNameList	getColumnList()
String	getColumnSeparator()
TPTNodeList<TFlinkTableProperty>	getDataSourceProperties()
String	getDataSourceType()
TExpression	getFilterExpression()
TObjectName	getJobName()
TPTNodeList<TFlinkTableProperty>	getJobProperties()
TObjectNameList	getPartitionList()
String	getRowSeparator()
TTable	getTargetTable() target table in the delete/insert/update/create table statement.
TObjectNameList	getTemporaryPartitionList()

Methods inherited from class gudusoft.gsqlparser.TCustomSqlStatement

addToTables, addWhereClause, analyzeFromTable, analyzeFromTable, analyzeJoin, analyzeTablename, analyzeTableOrJoin, asCanonical, checkNonQualifiedColumnReferenceInSubQueryOfUplevelStmt, clearError, computeSqlHash, dochecksyntax, findTable, fireOnMetaDatabaseTableColumn, getAncestorStmt, getAttributes, getColumnsInTable, getColumnsInTable, getCteIncludeThisStmt, getCteList, getDaxFunctionStack, getEndlabelName, getErrorCount, getErrormessage, getExpandedResultColumns, getFirstPhysicalTable, getFrameStack, getFromClause, getFromSourceJoin, getFromSourceTable, getGlobalScope, getIndexColumns, getJoins, getLabelName, getOrphanColumns, getOutputClause, getParentObjectName, getParentStmt, getQueryId, getRelationName, getRelations, getResultColumnList, getReturningClause, getSqlEnv, getSqlHash, getSqlHash, getStatements, getStmtScope, getSymbolTable, getSyntaxErrors, getSyntaxHints, getTables, getTokenList, getTopClause, getTopStatement, getUsingVariableList, getVariableStack, getWhereClause, isathenaplsql, isBigQueryplsql, isdatabricksplsql, isGaussDBStoredProcedure, isgreeplumplsql, isnzplsql, isoracleplsql, ispgplsql, isprestoplsql, issnowflakeplsql, isTableACTE, isverticaplsql, linkColumnReferenceToTable, linkColumnToTable, linkToFirstTable, locateVariableOrParameter, locateVariableOrParameter, OracleStatementCanBeSeparatedByBeginEndPair, parseerrormessagehandle, parsestatement, parsestatement, searchCTEList, searchDaxVariableInStack, searchFunctionInSQLEnv, setAlreadyAddToParent, setCteIncludeThisStmt, setCteList, setEndlabelName, setFrameStack, setFromClause, setLabelName, setOutputClause, setParentStmt, setParentStmtToNull, setQueryId, setResultColumnList, setReturningClause, setSqlHash, setStmtScope, setTargetTable, setTopClause, setUsingVariableList, setVariableStack, setWhereClause, size, toNormalizedSql, toScript, VerticaStatementCanBeSeparatedByBeginEndPair

Methods inherited from class gudusoft.gsqlparser.nodes.TParseTreeNode

addAllMyTokensToTokenList, addToTokenChain, appendNewNode, calculateTokenCount, doAppendNewNode, doParse, fastSetString, getAnchorNode, getColumnNo, getCommentAfterNode, getCommentBeforeNode, getCompactString, getDummyTag, getEndToken, getEvaluateDatatype, getEvalValue, getGsqlparser, getLineNo, getLocation, getMd5, getNodeStatus, getNodeType, getPlainText, getStartToken, getTokenCount, hasNext, init, init, init, init, init, init, init, init, init, init, insertAfterAToken, insertNewNodeBeforeMe, isChanged, isTokensInChain, next, refreshAllNodesTokenCount, remove, removeAllMyTokensFromTokenList, removeTokens, removeTokensBetweenNodes, removeTokensBetweenToken, replaceWithNewNode, resetIterator, setAnchorNode, setChanged, setDummyTag, setEndToken, setEndToken, setEndToken, setEndToken, setEndToken, setEndTokenDirectly, setEvaluateDatatype, setEvalValue, setGsqlparser, setIncludingComment, setLocation, setNewSubNode, setNodeStatus, setNodeType, setParent, setPlainText, setStartToken, setStartToken, setStartToken, setStartToken, setStartTokenDirectly, setString, setString2, subNodeInNode, toString, toString2

Methods inherited from class Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Methods inherited from interface Iterator

forEachRemaining

Constructor Detail

TCreateRoutineLoadStmt

public TCreateRoutineLoadStmt(EDbVendor dbvendor)

Method Detail

getJobName

public TObjectName getJobName()

getTargetTable

public TTable getTargetTable()

Description copied from class: TCustomSqlStatement

target table in the delete/insert/update/create table statement.

Overrides:

getTargetTable in class TCustomSqlStatement

See Also:

TCustomSqlStatement.joins, TSelectSqlStatement, TDeleteSqlStatement, TUpdateSqlStatement, TCreateTableSqlStatement, TMergeSqlStatement

getColumnSeparator

public String getColumnSeparator()

getRowSeparator

public String getRowSeparator()

getColumnList

public TObjectNameList getColumnList()

getFilterExpression

public TExpression getFilterExpression()

getPartitionList

public TObjectNameList getPartitionList()

getTemporaryPartitionList

public TObjectNameList getTemporaryPartitionList()

getJobProperties

public TPTNodeList<TFlinkTableProperty> getJobProperties()

getDataSourceType

public String getDataSourceType()

getDataSourceProperties

public TPTNodeList<TFlinkTableProperty> getDataSourceProperties()

doParseStatement

public int doParseStatement(TCustomSqlStatement psql)

Overrides:

doParseStatement in class TCustomSqlStatement

accept

public void accept(TParseTreeVisitor v)

Description copied from class: TParseTreeNode

Accept a visitor

Specified by:

accept in interface Visitable

Overrides:

accept in class TParseTreeNode

Parameters:

v - visitor is a descendant class of TParseTreeVisitor

acceptChildren

public void acceptChildren(TParseTreeVisitor v)

Description copied from class: TParseTreeNode

Accept a visitor to iterate this class and sub-nodes of this class

Specified by:

acceptChildren in interface Visitable

Overrides:

acceptChildren in class TParseTreeNode

Parameters:

v - visitor is a descendant class of TParseTreeVisitor