Package gudusoft.gsqlparser.stmt
Class TCreateTableSqlStatement
Object
gudusoft.gsqlparser.nodes.TParseTreeNode
gudusoft.gsqlparser.TCustomSqlStatement
gudusoft.gsqlparser.stmt.TCreateTableSqlStatement
- All Implemented Interfaces:
IRelation,Visitable,Iterator<TSourceToken>
SQL create table statement.
Example:
column definitions: can be fetched from
table constraints:
TCustomSqlStatement.getTargetTable() returns the created table. getColumnList() returns columns created in the table.
getTableConstraints() returns table level constraints if any.
getSubQuery() returns select statement that generate data for this table.
Example:
CREATE TABLE dbo.Employee (EmployeeID int PRIMARY KEY CLUSTERED);
Table:dbo.Employee can be fetched from TCustomSqlStatement.getTargetTable() or the first element of TCustomSqlStatement.tables
column definitions: can be fetched from
getColumnList()
table constraints:
getTableConstraints()-
Nested Class Summary
Nested ClassesNested 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, tablesFields inherited from class gudusoft.gsqlparser.nodes.TParseTreeNode
dbvendor, doubleLinkedTokenListToString, nodeActionAppend, nodeActionInsert, nodeActionRemove, nodeActionUnknown, nodeActionUpdate, nodeActionUpdateText, nodeChangeEndToken, nodeChangeStartToken -
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionvoidAccept a visitorvoidAccept a visitor to iterate this class and sub-nodes of this classintNetezza, Teradata, as table name.columns created in create table statement.getExternalTableOption(String optionName) sql server create external table with option.sql server create external table with optionsHive, impala table row formatHive, Impala table bucketsHive, Impala table file formatHive, Impala table partitionHive, Impala table propertiesHive, Impala skewed by clause.Teradata index definitionGreenplum, table used in like clause.MySQL, option used in create table such as engine, auto_increment and etc.Bigquery partition by exprOracle physical propertiesInformix, typename used in of type clause.Data of the created table is derived from this select statement.Informix, table name used in the under clause.Hive, Impala, comment of the table.table level constraints.Type of this tableHive, Impala, location of the table.The first table inTCustomSqlStatement.tables, this is the same table asTCustomSqlStatement.getTargetTable()booleanHive, Impala,Netezza,snowflake whether it is an external tablebooleanDeprecated.booleanHive, Impala, if not exists clausebooleanbooleanbooleanvoidsetAsTable(TTable asTable) voidsetAwsSnsTopic(String awsSnsTopic) voidsetColumnList(TColumnDefinitionList columnList) voidsetExecutePreparedStatement(TExecuteSqlStatement executePreparedStatement) voidsetExternal(boolean external) voidsetExternalTable(boolean externalTable) voidsetFileFormatName(String fileFormatName) voidsetFileFormatType(String fileFormatType) voidsetHiveRowFormat(THiveRowFormat hiveRowFormat) voidsetHiveTableBuckets(THiveTableBuckets hiveTableBuckets) voidsetHiveTableFileFormat(THiveTableFileFormat hiveTableFileFormat) voidsetHiveTablePartition(THiveTablePartition hiveTablePartition) voidsetHiveTableProperties(THiveTableProperties hiveTableProperties) voidsetHiveTableSkewed(THiveTableSkewed hiveTableSkewed) voidsetIfNotExists(boolean ifNotExists) voidsetIndexDefinitions(ArrayList<TIndexDefinition> indexDefinitions) voidsetLikeTableName(TObjectName likeTableName) voidsetLocationFiles(ArrayList<TConstant> locationFiles) voidsetMySQLTableOptionList(TPTNodeList<TMySQLCreateTableOption> mySQLTableOptionList) voidsetOnFilegroup(TDummy onFilegroup) voidsetPartitionBoundSpec(TPartitionBoundSpecSqlNode partitionBoundSpec) voidsetPartitionByExpr(TExpression partitionByExpr) voidsetPartitionColumnList(TObjectNameList partitionColumnList) voidsetRegex_pattern(String regex_pattern) voidsetRowTypeName(TObjectName rowTypeName) voidsetStageLocation(TStageLocation stageLocation) voidsetSubQuery(TSelectSqlStatement subQuery) voidsetSuperTableName(TObjectName superTableName) voidsetTableComment(TObjectName tableComment) voidsetTableConstraints(TConstraintList tableConstraints) voidsetTableKinds(EnumSet<ETableKind> tableKinds) voidsetTableLocation(TObjectName tableLocation) voidsetTableName(TObjectName tableName) voidsetTableOptions(ArrayList<TCreateTableOption> tableOptions) voidsetTableProperties(TTableProperties tableProperties) 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, getTargetTable, 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, VerticaStatementCanBeSeparatedByBeginEndPairMethods 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, 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, toString2Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, waitMethods inherited from interface java.util.Iterator
forEachRemaining
-
Constructor Details
-
TCreateTableSqlStatement
-
-
Method Details
-
getInheritsClause
-
getTablePartition
-
setPartitionBoundSpec
-
getPartitionBoundSpec
-
getTableProperties
-
setTableProperties
-
getExternalTableOptionNames
sql server create external table with options- Returns:
-
getExternalTableOption
sql server create external table with option.- Parameters:
optionName-- Returns:
-
getTableSourceType
-
getCloneSourceTable
-
getExternalTableOption
-
setPartitionByExpr
-
getPartitionByExpr
Bigquery partition by expr- Returns:
- expr
-
setAwsSnsTopic
-
getAwsSnsTopic
-
setPartitionColumnList
-
getPartitionColumnList
-
setFileFormatName
-
setFileFormatType
-
getFileFormatName
-
getFileFormatType
-
setRegex_pattern
-
getRegex_pattern
-
setStageLocation
-
getStageLocation
-
setTableOptions
-
getTableOptions
-
setOnFilegroup
-
getOnFilegroup
-
getPhysicalProperties
Oracle physical properties- Returns:
- Oracle physical properties
-
setTableKinds
-
getTableKinds
Type of this table- Returns:
- Type of this table
-
getAsTable
Netezza, Teradata, as table name.- Returns:
- as table name
-
isExternalTable
Deprecated.As of v1.9.7.2 , replace byisExternal()
Netezza, whether it is a external table- Returns:
- true if it's netezza create external table
-
getIndexDefinitions
Teradata index definitionUNIQUE PRIMARY INDEX (storeid, productid, salesdate)
- Returns:
- list of index definition
-
isExternal
Hive, Impala,Netezza,snowflake whether it is an external table- Returns:
- whether it is an external table
-
getHiveRowFormat
Hive, impala table row format- Returns:
- table row format
-
getHiveTableBuckets
Hive, Impala table buckets- Returns:
- table buckets
-
getHiveTableFileFormat
Hive, Impala table file format- Returns:
- table file format
-
getHiveTablePartition
Hive, Impala table partition- Returns:
- table partition
-
getHiveTableProperties
Hive, Impala table properties- Returns:
- table properties
-
getHiveTableSkewed
Hive, Impala skewed by clause.- Returns:
- skewed by clause.
-
isIfNotExists
Hive, Impala, if not exists clause- Returns:
- true if not exists clause is used in create table statement
-
getLikeTableName
Greenplum, table used in like clause.
Hive, Impala, table used in like clause.- Returns:
- table used in like clause.
-
getTableComment
Hive, Impala, comment of the table.- Returns:
- comment of the table.
-
getTableLocation
Hive, Impala, location of the table.- Returns:
- location of the table.
-
getRowTypeName
Informix, typename used in of type clause.- Returns:
- row type name
-
getSuperTableName
Informix, table name used in the under clause.- Returns:
- table name used in the under clause.
-
getSubQuery
Data of the created table is derived from this select statement.- Returns:
TSelectSqlStatementused in create table.
-
getExecutePreparedStatement
-
getMySQLTableOptionList
MySQL, option used in create table such as engine, auto_increment and etc.- Returns:
- option used in create table such as engine, auto_increment and etc.
-
getTableName
The first table inTCustomSqlStatement.tables, this is the same table asTCustomSqlStatement.getTargetTable()- Returns:
- The first table in
TCustomSqlStatement.tables
-
isWebTable
-
isReadable
-
isWritable
-
getExecuteCmd
-
setLocationFiles
-
getLocationFiles
-
doParseStatement
- Overrides:
doParseStatementin classTCustomSqlStatement
-
getTableConstraints
table level constraints.- Returns:
- List of table constraints of this table.
-
getColumnList
columns created in create table statement.- Returns:
- List of column definitions of this table.
-
accept
Description copied from class:TParseTreeNodeAccept a visitor- Specified by:
acceptin interfaceVisitable- Overrides:
acceptin classTParseTreeNode- Parameters:
v- visitor is a descendant class ofTParseTreeVisitor
-
acceptChildren
Description copied from class:TParseTreeNodeAccept a visitor to iterate this class and sub-nodes of this class- Specified by:
acceptChildrenin interfaceVisitable- Overrides:
acceptChildrenin classTParseTreeNode- Parameters:
v- visitor is a descendant class ofTParseTreeVisitor
-
setColumnList
-
setAsTable
-
setExternalTable
-
setIndexDefinitions
-
setExternal
-
setIfNotExists
-
setTableLocation
-
setTableComment
-
setHiveTableProperties
-
setHiveTablePartition
-
setHiveTableBuckets
-
setHiveTableSkewed
-
setHiveRowFormat
-
setHiveTableFileFormat
-
setLikeTableName
-
setRowTypeName
-
setSuperTableName
-
setSubQuery
-
setExecutePreparedStatement
-
setMySQLTableOptionList
-
setTableName
-
setTableConstraints
-
isExternal()Netezza, whether it is a external table