Package gudusoft.gsqlparser.nodes
Class TCreateTableOption
Object
gudusoft.gsqlparser.nodes.TParseTreeNode
gudusoft.gsqlparser.nodes.TCreateTableOption
- All Implemented Interfaces:
Visitable,Iterator<TSourceToken>
-
Field Summary
FieldsFields 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 classvoiddoParse(TCustomSqlStatement psql, ESqlClause plocation) Analyze the sub-nodes inside this node.Deprecated.Get file format properties list (e.g., TYPE=CSV, FIELD_DELIMITER='|', SKIP_HEADER=1) Used in Snowflake external table file_format optionBigquery partition by exprgetQuote()getUris()voidInitialize a query tree node.voidparseFileFormatProperties(String fileFormatString) Parse file format string and create name-value pair listvoidsetAllowJaggedRows(Boolean allowJaggedRows) voidsetAllowQuotedNewlines(Boolean allowQuotedNewlines) voidsetAwsSnsTopic(String awsSnsTopic) voidsetCommentToken(TSourceToken commentToken) voidsetCompression(String compression) voidsetCopyOptions(TDummy copyOptions) voidsetCreateTableOptionType(ECreateTableOption createTableOptionType) voidsetDateRetentionInDays(TSourceToken dateRetentionInDays) voidsetDecimalTargetTypes(List<String> decimalTargetTypes) voidsetDescription(String description) voidsetEnableLogicalTypes(Boolean enableLogicalTypes) voidsetEncoding(TSourceToken encoding) voidsetEncoding(String encoding) voidsetExpirationTimestamp(String expirationTimestamp) voidsetExpressionList(TExpressionList expressionList) voidsetExternalStageURL(String externalStageURL) voidsetFieldDelimiter(String fieldDelimiter) voidsetFileFormatName(TObjectName fileFormatName) voidsetFileFormatName(TSourceToken fileFormatName) voidsetFileFormatName(String fileFormatName) voidsetFileFormatProperties(ArrayList<TNameValuePair> fileFormatProperties) Set file format properties listvoidsetFileFormatType(TSourceToken fileFormatType) voidsetFileFormatType(String fileFormatType) voidvoidsetHivePartitionUriPrefix(String hivePartitionUriPrefix) voidsetIgnoreUnknownValues(Boolean ignoreUnknownValues) voidsetMaxBadRecords(Long maxBadRecords) voidsetNullMarker(String nullMarker) voidsetPartitionByExpr(TExpression partitionByExpr) voidsetPartitionColumnList(TObjectNameList partitionColumnList) voidsetProjectionFields(String projectionFields) voidvoidsetRequireHivePartitionFilter(Boolean requireHivePartitionFilter) voidsetSheetRange(String sheetRange) voidsetSkipLeadingRows(Long skipLeadingRows) voidsetStageFileFormat(TDummy stageFileFormat) voidsetStageLocation(TStageLocation stageLocation) voidMethods 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, toString2Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, waitMethods inherited from interface java.util.Iterator
forEachRemaining
-
Field Details
-
createTableOptionType
-
-
Constructor Details
-
TCreateTableOption
public TCreateTableOption()
-
-
Method Details
-
getDistributeBy
-
getPartitionSpec
-
getComment
-
getColumnNamelist
-
getPartitionByExpr
Bigquery partition by expr- Returns:
- expr
-
setFileFormatName
-
setFileFormatName
-
setFileFormatType
-
getFileFormatName
-
getFileFormatType
-
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
Set file format properties list- Parameters:
fileFormatProperties- list of name-value pairs for file format options
-
parseFileFormatProperties
Parse file format string and create name-value pair listParses 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
-
getStageLocation
-
getAwsSnsTopic
-
setAwsSnsTopic
-
getPartitionColumnList
-
setPartitionColumnList
-
getCompression
-
setCompression
-
getDescription
-
setDescription
-
getExpirationTimestamp
-
setExpirationTimestamp
-
getFieldDelimiter
-
setFieldDelimiter
-
getFormat
-
setFormat
-
getDecimalTargetTypes
-
setDecimalTargetTypes
-
getHivePartitionUriPrefix
-
setHivePartitionUriPrefix
-
getIgnoreUnknownValues
-
setIgnoreUnknownValues
-
getMaxBadRecords
-
setMaxBadRecords
-
setRequireHivePartitionFilter
-
getNullMarker
-
setNullMarker
-
getProjectionFields
-
setProjectionFields
-
getQuote
-
setQuote
-
getRequireHivePartitionFilter
-
getSheetRange
-
setSheetRange
-
getSkipLeadingRows
-
setSkipLeadingRows
-
getUris
-
setUris
-
getAllowJaggedRows
-
setAllowJaggedRows
-
getAllowQuotedNewlines
-
setAllowQuotedNewlines
-
getEnableLogicalTypes
-
setEnableLogicalTypes
-
getEncoding
-
setEncoding
-
setEncoding
-
getExternalStageURL
-
setExternalStageURL
-
setPartitionByExpr
-
setFileFormatName
-
setFileFormatType
-
setDateRetentionInDays
-
setCommentToken
-
setStageFileFormat
-
setCopyOptions
-
setExpressionList
-
getDateRetentionInDays
-
getCommentToken
Deprecated.since v 2.8.1.1, please usegetComment()instead- Returns:
-
getCopyOptions
-
setCreateTableOptionType
-
getCreateTableOptionType
-
init
Description copied from class:TParseTreeNodeInitialize a query tree node. Used internally- Overrides:
initin classTParseTreeNode- Parameters:
arg1- first argument
-
getExpressionList
-
getStageFileFormat
-
init
- Overrides:
initin classTParseTreeNode
-
getValueRowItemList
-
getAttributeOptions
-
doParse
Description copied from class:TParseTreeNodeAnalyze the sub-nodes inside this node. Such as build the relationship between table and column.- Overrides:
doParsein classTParseTreeNode- Parameters:
psql- SQL statement this node belongs toplocation- SQL clause this node belongs to
-
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
-
getComment()instead