Package gudusoft.gsqlparser.nodes

Class TSelectSqlNode

Object

gudusoft.gsqlparser.nodes.TParseTreeNode

gudusoft.gsqlparser.nodes.TSelectSqlNode

All Implemented Interfaces:

Visitable, Iterator<TSourceToken>

public class TSelectSqlNode
extends TParseTreeNode

Internal used by parser, reprsents raw parse tree node of select statement.

Field Summary

Fields

Modifier and Type	Field	Description
TCTEList	cteList

Fields inherited from class gudusoft.gsqlparser.nodes.TParseTreeNode

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

Constructor Summary

Constructors

Constructor	Description
TSelectSqlNode()

Method Summary

Modifier and Type	Method	Description
TClusterBy	getClusterBy()
TComputeClause	getComputeClause()
TCTEList	getCteList()
TDistributeBy	getDistributeBy()
TExpandOnClause	getExpandOnClause()
TFetchFirstClause	getFetchFirstClause()
static TSelectSqlNode	getFirstSelectSqlNode(ArrayList<TSelectSqlNode> selectSqlNodes)
TForUpdate	getForupdateClause()
TForXMLClause	getForXMLClause()
TFromTableList	getFromTableList()
TGroupBy	getGroupByClause()
THashByClause	getHashByClause()
THavingClause	getHavingClause()
THierarchical	getHierarchicalClause()
THintClause	getHintClause()
ArrayList<TParseTreeNode>	getHiveBodyList()	Deprecated. since 2.6.3.5, insert and select statement after from query is represented by getSelectSqlNodes() or TInsertSqlNode.getInsertSqlNodes()
THiveHintClause	getHiveHintClause()
TIntoClause	getIntoClause()
TIntoTableClause	getIntoTableClause()
TIsolationClause	getIsolationClause()
TLateralView	getLateralView()
TSelectSqlNode	getLeftNode()
TLimitClause	getLimitClause()
TPTNodeList<TLockingClause>	getLockingClauses()
TOffsetClause	getOffsetClause()
TOptimizeForClause	getOptimizeForClause()
TOptionClause	getOptionClause()
TOrderBy	getOrderbyClause()
int	getParenthesisCount()
int	getParenthissisCountBeforeOrder()
TQualifyClause	getQualifyClause()
TRelationExpr	getRelationExpr()
TResultColumnList	getResultColumnList()
TSelectSqlNode	getRightNode()
TSampleClause	getSampleClause()
TSelectDistinct	getSelectDistinct()
ArrayList<TSelectModifier>	getSelectModifiers()
ArrayList<TSelectSqlNode>	getSelectSqlNodes()
TSourceToken	getSelectToken()
int	getSetOperator()
TSortBy	getSortBy()
TTimeSeries	getTimeSeries()
TTimeTravel	getTimeTravel()
TTopClause	getTopClause()
THiveTransformClause	getTransformClause()
TValueClause	getValueClause()
TWhereClause	getWhereCondition()
TWindowClause	getWindowClause()
TTeradataWithClause	getWithClause()
TWithTableLock	getWithTableLock()
void	incParenthesisCount()
void	init(Object arg1, Object arg2)
boolean	isCombinedQuery()
boolean	isConsume()
boolean	isHiveFromQuery()
boolean	isSetOperatorByName()	Returns true if the set operator uses BY NAME matching (Snowflake).
void	setClauses(TPTNodeList<TParseTreeNode> clauses)
void	setClusterBy(TClusterBy clusterBy)
void	setComputeClause(TComputeClause computeClause)
void	setConsume(boolean consume)
void	setDistributeBy(TDistributeBy distributeBy)
void	setExpandOnClause(TExpandOnClause expandOnClause)
void	setFetchFirstClause(TFetchFirstClause fetchFirstClause)
void	setForupdateClause(TParseTreeNode forupdateClause)
void	setForXMLClause(TForXMLClause forXMLClause)
static void	setFromList(ArrayList<TSelectSqlNode> selectSqlNode, TFromTableList fromTables)
void	setFromTableList(TFromTableList fromTableList)
void	setGroupByClause(TGroupBy groupByClause)
void	setHashByClause(THashByClause hashByClause)
void	setHavingClause(THavingClause havingClause)
void	setHierarchicalClause(THierarchical hierarchicalClause)
void	setHintClause(THintClause hintClause)
void	setHiveBodyList(ArrayList<TParseTreeNode> hiveBodyList)
void	setHiveFromQuery(boolean hiveFromQuery)
void	setHiveHintClause(THiveHintClause hiveHintClause)
void	setIntoClause(TIntoClause intoClause)
void	setIntoTableClause(TIntoTableClause intoTableClause)
void	setIsolationClause(TIsolationClause isolationClause)
void	setLateralView(TLateralView lateralView)
void	setLimitClause(TLimitClause limitClause)
void	setLockingClauses(TPTNodeList<TLockingClause> lockingClauses)
void	setOffsetClause(TOffsetClause offsetClause)
void	setOptimizeForClause(TOptimizeForClause optimizeForClause)
void	setOptionClause(TOptionClause optionClause)
void	setOrderbyClause(TOrderBy orderbyClause)
void	setParenthesisCount(int parenthesisCount)
void	setParenthissisCountBeforeOrder()
void	setQualifyClause(TQualifyClause qualifyClause)
void	setQueryClauseList(TPTNodeList<TParseTreeNode> queryClauseList)
void	setRelationExpr(TRelationExpr relationExpr)
void	setResultColumnList(TResultColumnList resultColumnList)
void	setSampleClause(TSampleClause sampleClause)
void	setSelectDistinct(TSelectDistinct selectDistinct)
void	setSelectModifiers(ArrayList<TSelectModifier> selectModifiers)
void	setSelectSqlNodes(ArrayList<TSelectSqlNode> selectSqlNodes)
void	setSelectToken(TSourceToken selectToken)
void	setSetOperator(int setOperator)
void	setSetOperator(TSourceToken st1, TSourceToken st2)
void	setSetOperatorByName(boolean byName)	Sets whether the set operator uses BY NAME matching.
void	setSortBy(TSortBy sortBy)
void	setTimeSeries(TTimeSeries timeSeries)
void	setTopClause(TTopClause topClause)
void	setTransformClause(THiveTransformClause transformClause)
void	setValueClause(TValueClause valueClause)
void	setWhereCondition(TWhereClause whereCondition)
void	setWindowClause(TWindowClause windowClause)
void	setWithClause(TTeradataWithClause withClause)
void	setWithTableLock(TWithTableLock withTableLock)

Methods inherited from class gudusoft.gsqlparser.nodes.TParseTreeNode

accept, acceptChildren, addAllMyTokensToTokenList, addToTokenChain, appendNewNode, calculateTokenCount, doAppendNewNode, doParse, 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, 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

cteList

public TCTEList cteList

Constructor Details

TSelectSqlNode

public TSelectSqlNode()

Method Details

setForXMLClause

public void setForXMLClause(TForXMLClause forXMLClause)

getForXMLClause

public TForXMLClause getForXMLClause()

setRelationExpr

public void setRelationExpr(TRelationExpr relationExpr)

getRelationExpr

public TRelationExpr getRelationExpr()

setClusterBy

public void setClusterBy(TClusterBy clusterBy)

getClusterBy

public TClusterBy getClusterBy()

setConsume

public void setConsume(boolean consume)

isConsume

public boolean isConsume()

setHiveFromQuery

public void setHiveFromQuery(boolean hiveFromQuery)

isHiveFromQuery

public boolean isHiveFromQuery()

setHiveBodyList

public void setHiveBodyList(ArrayList<TParseTreeNode> hiveBodyList)

getHiveBodyList

public ArrayList<TParseTreeNode> getHiveBodyList()

Deprecated.

since 2.6.3.5, insert and select statement after from query is represented by getSelectSqlNodes() or TInsertSqlNode.getInsertSqlNodes()

Returns:

setHashByClause

public void setHashByClause(THashByClause hashByClause)

getHashByClause

public THashByClause getHashByClause()

setHavingClause

public void setHavingClause(THavingClause havingClause)

getHavingClause

public THavingClause getHavingClause()

setQueryClauseList

public void setQueryClauseList(TPTNodeList<TParseTreeNode> queryClauseList)

setSelectModifiers

public void setSelectModifiers(ArrayList<TSelectModifier> selectModifiers)

getSelectModifiers

public ArrayList<TSelectModifier> getSelectModifiers()

setWithTableLock

public void setWithTableLock(TWithTableLock withTableLock)

getWithTableLock

public TWithTableLock getWithTableLock()

setTimeSeries

public void setTimeSeries(TTimeSeries timeSeries)

getTimeSeries

public TTimeSeries getTimeSeries()

getTimeTravel

public TTimeTravel getTimeTravel()

setClauses

public void setClauses(TPTNodeList<TParseTreeNode> clauses)

setHintClause

public void setHintClause(THintClause hintClause)

getHintClause

public THintClause getHintClause()

getParenthesisCount

public int getParenthesisCount()

incParenthesisCount

public void incParenthesisCount()

setParenthesisCount

public void setParenthesisCount(int parenthesisCount)

setParenthissisCountBeforeOrder

public void setParenthissisCountBeforeOrder()

getParenthissisCountBeforeOrder

public int getParenthissisCountBeforeOrder()

setOffsetClause

public void setOffsetClause(TOffsetClause offsetClause)

getOffsetClause

public TOffsetClause getOffsetClause()

setOptionClause

public void setOptionClause(TOptionClause optionClause)

getOptionClause

public TOptionClause getOptionClause()

setLateralView

public void setLateralView(TLateralView lateralView)

getLateralView

public TLateralView getLateralView()

setSortBy

public void setSortBy(TSortBy sortBy)

getSortBy

public TSortBy getSortBy()

setDistributeBy

public void setDistributeBy(TDistributeBy distributeBy)

getDistributeBy

public TDistributeBy getDistributeBy()

getTransformClause

public THiveTransformClause getTransformClause()

setTransformClause

public void setTransformClause(THiveTransformClause transformClause)

setHiveHintClause

public void setHiveHintClause(THiveHintClause hiveHintClause)

getHiveHintClause

public THiveHintClause getHiveHintClause()

setIntoTableClause

public void setIntoTableClause(TIntoTableClause intoTableClause)

getIntoTableClause

public TIntoTableClause getIntoTableClause()

setSelectToken

public void setSelectToken(TSourceToken selectToken)

getSelectToken

public TSourceToken getSelectToken()

getSelectDistinct

public TSelectDistinct getSelectDistinct()

setSelectDistinct

public void setSelectDistinct(TSelectDistinct selectDistinct)

setTopClause

public void setTopClause(TTopClause topClause)

getTopClause

public TTopClause getTopClause()

setComputeClause

public void setComputeClause(TComputeClause computeClause)

getComputeClause

public TComputeClause getComputeClause()

getResultColumnList

public TResultColumnList getResultColumnList()

getFromTableList

public TFromTableList getFromTableList()

getWhereCondition

public TWhereClause getWhereCondition()

setResultColumnList

public void setResultColumnList(TResultColumnList resultColumnList)

setFromTableList

public void setFromTableList(TFromTableList fromTableList)

setWhereCondition

public void setWhereCondition(TWhereClause whereCondition)

getCteList

public TCTEList getCteList()

getSetOperator

public int getSetOperator()

setSetOperator

public void setSetOperator(int setOperator)

isSetOperatorByName

public boolean isSetOperatorByName()

Returns true if the set operator uses BY NAME matching (Snowflake). When BY NAME is used, columns are matched by their names rather than positions.

setSetOperatorByName

public void setSetOperatorByName(boolean byName)

Sets whether the set operator uses BY NAME matching.

setSetOperator

public void setSetOperator(TSourceToken st1,
 TSourceToken st2)

getLeftNode

public TSelectSqlNode getLeftNode()

getRightNode

public TSelectSqlNode getRightNode()

init

public void init(Object arg1,
 Object arg2)

Overrides:

init in class TParseTreeNode

isCombinedQuery

public boolean isCombinedQuery()

getOrderbyClause

public TOrderBy getOrderbyClause()

setOrderbyClause

public void setOrderbyClause(TOrderBy orderbyClause)

getForupdateClause

public TForUpdate getForupdateClause()

setForupdateClause

public void setForupdateClause(TParseTreeNode forupdateClause)

getHierarchicalClause

public THierarchical getHierarchicalClause()

setHierarchicalClause

public void setHierarchicalClause(THierarchical hierarchicalClause)

getGroupByClause

public TGroupBy getGroupByClause()

setGroupByClause

public void setGroupByClause(TGroupBy groupByClause)

setIntoClause

public void setIntoClause(TIntoClause intoClause)

getIntoClause

public TIntoClause getIntoClause()

setQualifyClause

public void setQualifyClause(TQualifyClause qualifyClause)

getQualifyClause

public TQualifyClause getQualifyClause()

setSampleClause

public void setSampleClause(TSampleClause sampleClause)

getSampleClause

public TSampleClause getSampleClause()

getWithClause

public TTeradataWithClause getWithClause()

setWithClause

public void setWithClause(TTeradataWithClause withClause)

setLimitClause

public void setLimitClause(TLimitClause limitClause)

getLimitClause

public TLimitClause getLimitClause()

setFetchFirstClause

public void setFetchFirstClause(TFetchFirstClause fetchFirstClause)

getFetchFirstClause

public TFetchFirstClause getFetchFirstClause()

setOptimizeForClause

public void setOptimizeForClause(TOptimizeForClause optimizeForClause)

getOptimizeForClause

public TOptimizeForClause getOptimizeForClause()

setIsolationClause

public void setIsolationClause(TIsolationClause isolationClause)

getIsolationClause

public TIsolationClause getIsolationClause()

setValueClause

public void setValueClause(TValueClause valueClause)

getValueClause

public TValueClause getValueClause()

getLockingClauses

public TPTNodeList<TLockingClause> getLockingClauses()

setLockingClauses

public void setLockingClauses(TPTNodeList<TLockingClause> lockingClauses)

setWindowClause

public void setWindowClause(TWindowClause windowClause)

getWindowClause

public TWindowClause getWindowClause()

getExpandOnClause

public TExpandOnClause getExpandOnClause()

setExpandOnClause

public void setExpandOnClause(TExpandOnClause expandOnClause)

setFromList

public static void setFromList(ArrayList<TSelectSqlNode> selectSqlNode,
 TFromTableList fromTables)

getSelectSqlNodes

public ArrayList<TSelectSqlNode> getSelectSqlNodes()

setSelectSqlNodes

public void setSelectSqlNodes(ArrayList<TSelectSqlNode> selectSqlNodes)

getFirstSelectSqlNode

public static TSelectSqlNode getFirstSelectSqlNode(ArrayList<TSelectSqlNode> selectSqlNodes)