gudusoft.gsqlparser.stmt

Class TCreateTableSqlStatement

Object

gudusoft.gsqlparser.nodes.TParseTreeNode

gudusoft.gsqlparser.TCustomSqlStatement

gudusoft.gsqlparser.stmt.TCreateTableSqlStatement

All Implemented Interfaces:

IRelation, Visitable, Iterator<TSourceToken>

public class TCreateTableSqlStatement
extends TCustomSqlStatement

SQL create table statement.
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 Classes

Modifier and Type	Class and Description
static class	TCreateTableSqlStatement.TableSourceType

Field Summary

Fields inherited from class gudusoft.gsqlparser.TCustomSqlStatement

dummytag, fromClause, fromSourceJoin, fromSourceTable, isparsed, joins, parser, plsqlparser, relationAttributes, rootNode, 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
TCreateTableSqlStatement(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)
TTable	getAsTable() Netezza, Teradata, as table name.
String	getAwsSnsTopic()
TObjectName	getCloneSourceTable()
TColumnDefinitionList	getColumnList() columns created in create table statement.
TConstant	getExecuteCmd()
TExecuteSqlStatement	getExecutePreparedStatement()
TExternalTableOption	getExternalTableOption()
String	getExternalTableOption(String optionName) sql server create external table with option.
List<String>	getExternalTableOptionNames() sql server create external table with options
String	getFileFormatName()
String	getFileFormatType()
THiveRowFormat	getHiveRowFormat() Hive, impala table row format
THiveTableBuckets	getHiveTableBuckets() Hive, Impala table buckets
THiveTableFileFormat	getHiveTableFileFormat() Hive, Impala table file format
THiveTablePartition	getHiveTablePartition() Hive, Impala table partition
THiveTableProperties	getHiveTableProperties() Hive, Impala table properties
THiveTableSkewed	getHiveTableSkewed() Hive, Impala skewed by clause.
ArrayList<TIndexDefinition>	getIndexDefinitions() Teradata index definition
TInheritsClause	getInheritsClause()
TObjectName	getLikeTableName() Greenplum, table used in like clause.
ArrayList<TConstant>	getLocationFiles()
TPTNodeList<TMySQLCreateTableOption>	getMySQLTableOptionList() MySQL, option used in create table such as engine, auto_increment and etc.
TDummy	getOnFilegroup()
TPartitionBoundSpecSqlNode	getPartitionBoundSpec()
TExpression	getPartitionByExpr() Bigquery partition by expr
TObjectNameList	getPartitionColumnList()
TPhysicalProperties	getPhysicalProperties() Oracle physical properties
String	getRegex_pattern()
TObjectName	getRowTypeName() Informix, typename used in of type clause.
TStageLocation	getStageLocation()
TSelectSqlStatement	getSubQuery() Data of the created table is derived from this select statement.
TObjectName	getSuperTableName() Informix, table name used in the under clause.
TObjectName	getTableComment() Hive, Impala, comment of the table.
TConstraintList	getTableConstraints() table level constraints.
EnumSet<ETableKind>	getTableKinds() Type of this table
TObjectName	getTableLocation() Hive, Impala, location of the table.
TObjectName	getTableName() The first table in TCustomSqlStatement.tables, this is the same table as TCustomSqlStatement.getTargetTable()
ArrayList<TCreateTableOption>	getTableOptions()
TBaseTablePartition	getTablePartition()
TTableProperties	getTableProperties()
TCreateTableSqlStatement.TableSourceType	getTableSourceType()
boolean	isExternal() Hive, Impala,Netezza,snowflake whether it is an external table
boolean	isExternalTable() Deprecated. As of v1.9.7.2 , replace by isExternal() Netezza, whether it is a external table
boolean	isIfNotExists() Hive, Impala, if not exists clause
boolean	isReadable()
boolean	isWebTable()
boolean	isWritable()
void	setAsTable(TTable asTable)
void	setAwsSnsTopic(String awsSnsTopic)
void	setColumnList(TColumnDefinitionList columnList)
void	setExecutePreparedStatement(TExecuteSqlStatement executePreparedStatement)
void	setExternal(boolean external)
void	setExternalTable(boolean externalTable)
void	setFileFormatName(String fileFormatName)
void	setFileFormatType(String fileFormatType)
void	setHiveRowFormat(THiveRowFormat hiveRowFormat)
void	setHiveTableBuckets(THiveTableBuckets hiveTableBuckets)
void	setHiveTableFileFormat(THiveTableFileFormat hiveTableFileFormat)
void	setHiveTablePartition(THiveTablePartition hiveTablePartition)
void	setHiveTableProperties(THiveTableProperties hiveTableProperties)
void	setHiveTableSkewed(THiveTableSkewed hiveTableSkewed)
void	setIfNotExists(boolean ifNotExists)
void	setIndexDefinitions(ArrayList<TIndexDefinition> indexDefinitions)
void	setLikeTableName(TObjectName likeTableName)
void	setLocationFiles(ArrayList<TConstant> locationFiles)
void	setMySQLTableOptionList(TPTNodeList<TMySQLCreateTableOption> mySQLTableOptionList)
void	setOnFilegroup(TDummy onFilegroup)
void	setPartitionBoundSpec(TPartitionBoundSpecSqlNode partitionBoundSpec)
void	setPartitionByExpr(TExpression partitionByExpr)
void	setPartitionColumnList(TObjectNameList partitionColumnList)
void	setRegex_pattern(String regex_pattern)
void	setRowTypeName(TObjectName rowTypeName)
void	setStageLocation(TStageLocation stageLocation)
void	setSubQuery(TSelectSqlStatement subQuery)
void	setSuperTableName(TObjectName superTableName)
void	setTableComment(TObjectName tableComment)
void	setTableConstraints(TConstraintList tableConstraints)
void	setTableKinds(EnumSet<ETableKind> tableKinds)
void	setTableLocation(TObjectName tableLocation)
void	setTableName(TObjectName tableName)
void	setTableOptions(ArrayList<TCreateTableOption> tableOptions)
void	setTableProperties(TTableProperties tableProperties)

Methods inherited from class gudusoft.gsqlparser.TCustomSqlStatement

addToTables, addWhereClause, analyzeFromTable, analyzeFromTable, analyzeJoin, analyzeTablename, analyzeTableOrJoin, asCanonical, checkNonQualifiedColumnReferenceInSubQueryOfUplevelStmt, clearError, 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, getRelationName, getRelations, getResultColumnList, getReturningClause, getSqlEnv, 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, setResultColumnList, setReturningClause, setStmtScope, setTargetTable, setTopClause, setUsingVariableList, setVariableStack, setWhereClause, size, 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, 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

TCreateTableSqlStatement

public TCreateTableSqlStatement(EDbVendor dbvendor)

Method Detail

getInheritsClause

public TInheritsClause getInheritsClause()

getTablePartition

public TBaseTablePartition getTablePartition()

setPartitionBoundSpec

public void setPartitionBoundSpec(TPartitionBoundSpecSqlNode partitionBoundSpec)

getPartitionBoundSpec

public TPartitionBoundSpecSqlNode getPartitionBoundSpec()

getTableProperties

public TTableProperties getTableProperties()

setTableProperties

public void setTableProperties(TTableProperties tableProperties)

getExternalTableOptionNames

public List<String> getExternalTableOptionNames()

sql server create external table with options

Returns:

getExternalTableOption

public String getExternalTableOption(String optionName)

sql server create external table with option.

Parameters:

optionName -

Returns:

getTableSourceType

public TCreateTableSqlStatement.TableSourceType getTableSourceType()

getCloneSourceTable

public TObjectName getCloneSourceTable()

getExternalTableOption

public TExternalTableOption getExternalTableOption()

setPartitionByExpr

public void setPartitionByExpr(TExpression partitionByExpr)

getPartitionByExpr

public TExpression getPartitionByExpr()

Bigquery partition by expr

Returns:

expr

setAwsSnsTopic

public void setAwsSnsTopic(String awsSnsTopic)

getAwsSnsTopic

public String getAwsSnsTopic()

setPartitionColumnList

public void setPartitionColumnList(TObjectNameList partitionColumnList)

getPartitionColumnList

public TObjectNameList getPartitionColumnList()

setFileFormatName

public void setFileFormatName(String fileFormatName)

setFileFormatType

public void setFileFormatType(String fileFormatType)

getFileFormatName

public String getFileFormatName()

getFileFormatType

public String getFileFormatType()

setRegex_pattern

public void setRegex_pattern(String regex_pattern)

getRegex_pattern

public String getRegex_pattern()

setStageLocation

public void setStageLocation(TStageLocation stageLocation)

getStageLocation

public TStageLocation getStageLocation()

setTableOptions

public void setTableOptions(ArrayList<TCreateTableOption> tableOptions)

getTableOptions

public ArrayList<TCreateTableOption> getTableOptions()

setOnFilegroup

public void setOnFilegroup(TDummy onFilegroup)

getOnFilegroup

public TDummy getOnFilegroup()

getPhysicalProperties

public TPhysicalProperties getPhysicalProperties()

Oracle physical properties

Returns:

Oracle physical properties

setTableKinds

public void setTableKinds(EnumSet<ETableKind> tableKinds)

getTableKinds

public EnumSet<ETableKind> getTableKinds()

Type of this table

Returns:

Type of this table

getAsTable

public TTable getAsTable()

Netezza, Teradata, as table name.

Returns:

as table name

isExternalTable

public boolean isExternalTable()

Deprecated. As of v1.9.7.2 , replace by isExternal()
Netezza, whether it is a external table

Returns:

true if it's netezza create external table

getIndexDefinitions

public ArrayList<TIndexDefinition> getIndexDefinitions()

Teradata index definition

UNIQUE PRIMARY INDEX (storeid, productid, salesdate)

Returns:

list of index definition

isExternal

public boolean isExternal()

Hive, Impala,Netezza,snowflake whether it is an external table

Returns:

whether it is an external table

getHiveRowFormat

public THiveRowFormat getHiveRowFormat()

Hive, impala table row format

Returns:

table row format

getHiveTableBuckets

public THiveTableBuckets getHiveTableBuckets()

Hive, Impala table buckets

Returns:

table buckets

getHiveTableFileFormat

public THiveTableFileFormat getHiveTableFileFormat()

Hive, Impala table file format

Returns:

table file format

getHiveTablePartition

public THiveTablePartition getHiveTablePartition()

Hive, Impala table partition

Returns:

table partition

getHiveTableProperties

public THiveTableProperties getHiveTableProperties()

Hive, Impala table properties

Returns:

table properties

getHiveTableSkewed

public THiveTableSkewed getHiveTableSkewed()

Hive, Impala skewed by clause.

Returns:

skewed by clause.

isIfNotExists

public boolean isIfNotExists()

Hive, Impala, if not exists clause

Returns:

true if not exists clause is used in create table statement

getLikeTableName

public TObjectName getLikeTableName()

Greenplum, table used in like clause.
Hive, Impala, table used in like clause.

Returns:

table used in like clause.

getTableComment

public TObjectName getTableComment()

Hive, Impala, comment of the table.

Returns:

comment of the table.

getTableLocation

public TObjectName getTableLocation()

Hive, Impala, location of the table.

Returns:

location of the table.

getRowTypeName

public TObjectName getRowTypeName()

Informix, typename used in of type clause.

Returns:

row type name

getSuperTableName

public TObjectName getSuperTableName()

Informix, table name used in the under clause.

Returns:

table name used in the under clause.

getSubQuery

public TSelectSqlStatement getSubQuery()

Data of the created table is derived from this select statement.

Returns:

TSelectSqlStatement used in create table.

getExecutePreparedStatement

public TExecuteSqlStatement getExecutePreparedStatement()

getMySQLTableOptionList

public TPTNodeList<TMySQLCreateTableOption> 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

public TObjectName getTableName()

The first table in TCustomSqlStatement.tables, this is the same table as TCustomSqlStatement.getTargetTable()

Returns:

The first table in TCustomSqlStatement.tables

isWebTable

public boolean isWebTable()

isReadable

public boolean isReadable()

isWritable

public boolean isWritable()

getExecuteCmd

public TConstant getExecuteCmd()

setLocationFiles

public void setLocationFiles(ArrayList<TConstant> locationFiles)

getLocationFiles

public ArrayList<TConstant> getLocationFiles()

doParseStatement

public int doParseStatement(TCustomSqlStatement psql)

Overrides:

doParseStatement in class TCustomSqlStatement

getTableConstraints

public TConstraintList getTableConstraints()

table level constraints.

Returns:

List of table constraints of this table.

getColumnList

public TColumnDefinitionList getColumnList()

columns created in create table statement.

Returns:

List of column definitions of this table.

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

setColumnList

public void setColumnList(TColumnDefinitionList columnList)

setAsTable

public void setAsTable(TTable asTable)

setExternalTable

public void setExternalTable(boolean externalTable)

setIndexDefinitions

public void setIndexDefinitions(ArrayList<TIndexDefinition> indexDefinitions)

setExternal

public void setExternal(boolean external)

setIfNotExists

public void setIfNotExists(boolean ifNotExists)

setTableLocation

public void setTableLocation(TObjectName tableLocation)

setTableComment

public void setTableComment(TObjectName tableComment)

setHiveTableProperties

public void setHiveTableProperties(THiveTableProperties hiveTableProperties)

setHiveTablePartition

public void setHiveTablePartition(THiveTablePartition hiveTablePartition)

setHiveTableBuckets

public void setHiveTableBuckets(THiveTableBuckets hiveTableBuckets)

setHiveTableSkewed

public void setHiveTableSkewed(THiveTableSkewed hiveTableSkewed)

setHiveRowFormat

public void setHiveRowFormat(THiveRowFormat hiveRowFormat)

setHiveTableFileFormat

public void setHiveTableFileFormat(THiveTableFileFormat hiveTableFileFormat)

setLikeTableName

public void setLikeTableName(TObjectName likeTableName)

setRowTypeName

public void setRowTypeName(TObjectName rowTypeName)

setSuperTableName

public void setSuperTableName(TObjectName superTableName)

setSubQuery

public void setSubQuery(TSelectSqlStatement subQuery)

setExecutePreparedStatement

public void setExecutePreparedStatement(TExecuteSqlStatement executePreparedStatement)

setMySQLTableOptionList

public void setMySQLTableOptionList(TPTNodeList<TMySQLCreateTableOption> mySQLTableOptionList)

setTableName

public void setTableName(TObjectName tableName)

setTableConstraints

public void setTableConstraints(TConstraintList tableConstraints)