Package gudusoft.gsqlparser.nodes

Class TCreateTableOption

Object

gudusoft.gsqlparser.nodes.TParseTreeNode

gudusoft.gsqlparser.nodes.TCreateTableOption

All Implemented Interfaces:

Visitable, Iterator<TSourceToken>

public class TCreateTableOption
extends TParseTreeNode

Field Summary

Fields

Modifier and Type	Field	Description
protected ECreateTableOption	createTableOptionType

Fields inherited from class gudusoft.gsqlparser.nodes.TParseTreeNode

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

Constructor Summary

Constructors

Constructor	Description
TCreateTableOption()

Method Summary

Modifier and Type	Method	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
void	doParse(TCustomSqlStatement psql, ESqlClause plocation)	Analyze the sub-nodes inside this node.
Boolean	getAllowJaggedRows()
Boolean	getAllowQuotedNewlines()
ArrayList<TAttributeOption>	getAttributeOptions()
String	getAwsSnsTopic()
TObjectNameList	getColumnNamelist()
TObjectName	getComment()
TSourceToken	getCommentToken()	Deprecated. since v 2.8.1.1, please use getComment() instead
String	getCompression()
TDummy	getCopyOptions()
ECreateTableOption	getCreateTableOptionType()
TSourceToken	getDateRetentionInDays()
List<String>	getDecimalTargetTypes()
String	getDescription()
TDistributeBy	getDistributeBy()
Boolean	getEnableLogicalTypes()
String	getEncoding()
String	getExpirationTimestamp()
TExpressionList	getExpressionList()
String	getExternalStageURL()
String	getFieldDelimiter()
String	getFileFormatName()
ArrayList<TNameValuePair>	getFileFormatProperties()	Get file format properties list (e.g., TYPE=CSV, FIELD_DELIMITER='|', SKIP_HEADER=1) Used in Snowflake external table file_format option
String	getFileFormatType()
String	getFormat()
String	getHivePartitionUriPrefix()
Boolean	getIgnoreUnknownValues()
Long	getMaxBadRecords()
String	getNullMarker()
TExpression	getPartitionByExpr()	Bigquery partition by expr
TObjectNameList	getPartitionColumnList()
TBaseTablePartition	getPartitionSpec()
String	getProjectionFields()
String	getQuote()
Boolean	getRequireHivePartitionFilter()
String	getSheetRange()
Long	getSkipLeadingRows()
TDummy	getStageFileFormat()
TStageLocation	getStageLocation()
List<String>	getUris()
TMultiTargetList	getValueRowItemList()
void	init(Object arg1)	Initialize a query tree node.
void	init(Object arg1, Object arg2)
ArrayList<TNameValuePair>	parseFileFormatProperties(String fileFormatString)	Parse file format string and create name-value pair list
void	setAllowJaggedRows(Boolean allowJaggedRows)
void	setAllowQuotedNewlines(Boolean allowQuotedNewlines)
void	setAwsSnsTopic(String awsSnsTopic)
void	setCommentToken(TSourceToken commentToken)
void	setCompression(String compression)
void	setCopyOptions(TDummy copyOptions)
void	setCreateTableOptionType(ECreateTableOption createTableOptionType)
void	setDateRetentionInDays(TSourceToken dateRetentionInDays)
void	setDecimalTargetTypes(List<String> decimalTargetTypes)
void	setDescription(String description)
void	setEnableLogicalTypes(Boolean enableLogicalTypes)
void	setEncoding(TSourceToken encoding)
void	setEncoding(String encoding)
void	setExpirationTimestamp(String expirationTimestamp)
void	setExpressionList(TExpressionList expressionList)
void	setExternalStageURL(String externalStageURL)
void	setFieldDelimiter(String fieldDelimiter)
void	setFileFormatName(TObjectName fileFormatName)
void	setFileFormatName(TSourceToken fileFormatName)
void	setFileFormatName(String fileFormatName)
void	setFileFormatProperties(ArrayList<TNameValuePair> fileFormatProperties)	Set file format properties list
void	setFileFormatType(TSourceToken fileFormatType)
void	setFileFormatType(String fileFormatType)
void	setFormat(String format)
void	setHivePartitionUriPrefix(String hivePartitionUriPrefix)
void	setIgnoreUnknownValues(Boolean ignoreUnknownValues)
void	setMaxBadRecords(Long maxBadRecords)
void	setNullMarker(String nullMarker)
void	setPartitionByExpr(TExpression partitionByExpr)
void	setPartitionColumnList(TObjectNameList partitionColumnList)
void	setProjectionFields(String projectionFields)
void	setQuote(String quote)
void	setRequireHivePartitionFilter(Boolean requireHivePartitionFilter)
void	setSheetRange(String sheetRange)
void	setSkipLeadingRows(Long skipLeadingRows)
void	setStageFileFormat(TDummy stageFileFormat)
void	setStageLocation(TStageLocation stageLocation)
void	setUris(List<String> uris)

Methods inherited from class gudusoft.gsqlparser.nodes.TParseTreeNode

addAllMyTokensToTokenList, addToTokenChain, appendNewNode, calculateTokenCount, doAppendNewNode, fastSetString, getAnchorNode, getColumnNo, getCommentAfterNode, getCommentBeforeNode, getCompactString, getDummyTag, getEndToken, getEvaluateDatatype, getEvalValue, getGsqlparser, getLineNo, getLocation, getMd5, getNodeStatus, getNodeType, getParentObjectName, getPlainText, getStartToken, getTokenCount, hasNext, 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, toScript, toString, toString2

Methods inherited from class java.lang.Object

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

Methods inherited from interface java.util.Iterator

forEachRemaining

Field Details

createTableOptionType

protected ECreateTableOption createTableOptionType

Constructor Details

TCreateTableOption

public TCreateTableOption()

Method Details

getDistributeBy

public TDistributeBy getDistributeBy()

getPartitionSpec

public TBaseTablePartition getPartitionSpec()

getComment

public TObjectName getComment()

getColumnNamelist

public TObjectNameList getColumnNamelist()

getPartitionByExpr

public TExpression getPartitionByExpr()

Bigquery partition by expr

Returns:

expr

setFileFormatName

public void setFileFormatName(TSourceToken fileFormatName)

setFileFormatName

public void setFileFormatName(TObjectName fileFormatName)

setFileFormatType

public void setFileFormatType(TSourceToken fileFormatType)

getFileFormatName

public String getFileFormatName()

getFileFormatType

public String getFileFormatType()

getFileFormatProperties

public ArrayList<TNameValuePair> getFileFormatProperties()

Get file format properties list (e.g., TYPE=CSV, FIELD_DELIMITER='|', SKIP_HEADER=1) Used in Snowflake external table file_format option

Returns:

list of name-value pairs representing file format properties

setFileFormatProperties

public void setFileFormatProperties(ArrayList<TNameValuePair> fileFormatProperties)

Set file format properties list

Parameters:

fileFormatProperties - list of name-value pairs for file format options

parseFileFormatProperties

public ArrayList<TNameValuePair> parseFileFormatProperties(String fileFormatString)

Parse file format string and create name-value pair list

Parses file format options in formats like:

• Single line: file_format=(TYPE=CSV FIELD_DELIMITER='|' SKIP_HEADER=1)
• Multi-line: FILE_FORMAT = (TYPE = CSV, FIELD_DELIMITER = ',', SKIP_HEADER = 1)

Parameters:

fileFormatString - the file_format string to parse

Returns:

ArrayList of TNameValuePair objects representing the properties

setStageLocation

public void setStageLocation(TStageLocation stageLocation)

getStageLocation

public TStageLocation getStageLocation()

getAwsSnsTopic

public String getAwsSnsTopic()

setAwsSnsTopic

public void setAwsSnsTopic(String awsSnsTopic)

getPartitionColumnList

public TObjectNameList getPartitionColumnList()

setPartitionColumnList

public void setPartitionColumnList(TObjectNameList partitionColumnList)

getCompression

public String getCompression()

setCompression

public void setCompression(String compression)

getDescription

public String getDescription()

setDescription

public void setDescription(String description)

getExpirationTimestamp

public String getExpirationTimestamp()

setExpirationTimestamp

public void setExpirationTimestamp(String expirationTimestamp)

getFieldDelimiter

public String getFieldDelimiter()

setFieldDelimiter

public void setFieldDelimiter(String fieldDelimiter)

getFormat

public String getFormat()

setFormat

public void setFormat(String format)

getDecimalTargetTypes

public List<String> getDecimalTargetTypes()

setDecimalTargetTypes

public void setDecimalTargetTypes(List<String> decimalTargetTypes)

getHivePartitionUriPrefix

public String getHivePartitionUriPrefix()

setHivePartitionUriPrefix

public void setHivePartitionUriPrefix(String hivePartitionUriPrefix)

getIgnoreUnknownValues

public Boolean getIgnoreUnknownValues()

setIgnoreUnknownValues

public void setIgnoreUnknownValues(Boolean ignoreUnknownValues)

getMaxBadRecords

public Long getMaxBadRecords()

setMaxBadRecords

public void setMaxBadRecords(Long maxBadRecords)

setRequireHivePartitionFilter

public void setRequireHivePartitionFilter(Boolean requireHivePartitionFilter)

getNullMarker

public String getNullMarker()

setNullMarker

public void setNullMarker(String nullMarker)

getProjectionFields

public String getProjectionFields()

setProjectionFields

public void setProjectionFields(String projectionFields)

getQuote

public String getQuote()

setQuote

public void setQuote(String quote)

getRequireHivePartitionFilter

public Boolean getRequireHivePartitionFilter()

getSheetRange

public String getSheetRange()

setSheetRange

public void setSheetRange(String sheetRange)

getSkipLeadingRows

public Long getSkipLeadingRows()

setSkipLeadingRows

public void setSkipLeadingRows(Long skipLeadingRows)

getUris

public List<String> getUris()

setUris

public void setUris(List<String> uris)

getAllowJaggedRows

public Boolean getAllowJaggedRows()

setAllowJaggedRows

public void setAllowJaggedRows(Boolean allowJaggedRows)

getAllowQuotedNewlines

public Boolean getAllowQuotedNewlines()

setAllowQuotedNewlines

public void setAllowQuotedNewlines(Boolean allowQuotedNewlines)

getEnableLogicalTypes

public Boolean getEnableLogicalTypes()

setEnableLogicalTypes

public void setEnableLogicalTypes(Boolean enableLogicalTypes)

getEncoding

public String getEncoding()

setEncoding

public void setEncoding(String encoding)

setEncoding

public void setEncoding(TSourceToken encoding)

getExternalStageURL

public String getExternalStageURL()

setExternalStageURL

public void setExternalStageURL(String externalStageURL)

setPartitionByExpr

public void setPartitionByExpr(TExpression partitionByExpr)

setFileFormatName

public void setFileFormatName(String fileFormatName)

setFileFormatType

public void setFileFormatType(String fileFormatType)

setDateRetentionInDays

public void setDateRetentionInDays(TSourceToken dateRetentionInDays)

setCommentToken

public void setCommentToken(TSourceToken commentToken)

setStageFileFormat

public void setStageFileFormat(TDummy stageFileFormat)

setCopyOptions

public void setCopyOptions(TDummy copyOptions)

setExpressionList

public void setExpressionList(TExpressionList expressionList)

getDateRetentionInDays

public TSourceToken getDateRetentionInDays()

getCommentToken

public TSourceToken getCommentToken()

Deprecated.

since v 2.8.1.1, please use getComment() instead

Returns:

getCopyOptions

public TDummy getCopyOptions()

setCreateTableOptionType

public void setCreateTableOptionType(ECreateTableOption createTableOptionType)

getCreateTableOptionType

public ECreateTableOption getCreateTableOptionType()

init

public void init(Object arg1)

Description copied from class: TParseTreeNode

Initialize a query tree node. Used internally

Overrides:

init in class TParseTreeNode

Parameters:

arg1 - first argument

getExpressionList

public TExpressionList getExpressionList()

getStageFileFormat

public TDummy getStageFileFormat()

init

public void init(Object arg1,
 Object arg2)

Overrides:

init in class TParseTreeNode

getValueRowItemList

public TMultiTargetList getValueRowItemList()

getAttributeOptions

public ArrayList<TAttributeOption> getAttributeOptions()

doParse

public void doParse(TCustomSqlStatement psql,
 ESqlClause plocation)

Description copied from class: TParseTreeNode

Analyze the sub-nodes inside this node. Such as build the relationship between table and column.

Overrides:

doParse in class TParseTreeNode

Parameters:

psql - SQL statement this node belongs to

plocation - SQL clause this node belongs to

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