@Translator(name="teiid", description="A translator for Teiid 7.0 or later") public class TeiidExecutionFactory extends JDBCExecutionFactory
JDBCExecutionFactory.StructRetrieval
ExecutionFactory.Format, ExecutionFactory.NullOrder, ExecutionFactory.SupportedJoinCriteria, ExecutionFactory.TransactionSupport
Modifier and Type | Field and Description |
---|---|
static Version |
EIGHT_1 |
static Version |
EIGHT_10 |
static Version |
EIGHT_3 |
static Version |
EIGHT_4 |
static Version |
EIGHT_5 |
static Version |
ELEVEN_1 |
static Version |
ELEVEN_2 |
static Version |
NINE_0 |
static Version |
NINE_1 |
static Version |
NINE_2 |
static Version |
SEVEN_0 |
static Version |
SEVEN_1 |
static Version |
SEVEN_2 |
static Version |
SEVEN_3 |
static Version |
SEVEN_4 |
static Version |
SEVEN_5 |
static Version |
SEVEN_6 |
static Version |
TEN_0 |
DEFAULT_MAX_DEPENDENT_PREDICATES, DEFAULT_MAX_IN_CRITERIA, DEFAULT_TIME_ZONE, dialect
DEFAULT_MAX_FROM_GROUPS, DEFAULT_MAX_IN_CRITERIA_SIZE, DEFAULT_MAX_PROJECTED_COLUMNS
Constructor and Description |
---|
TeiidExecutionFactory() |
Modifier and Type | Method and Description |
---|---|
ExecutionFactory.NullOrder |
getDefaultNullOrder()
Returns the default null ordering
|
SQLDialect |
getDialect() |
String |
getLateralKeyword() |
MetadataProcessor<Connection> |
getMetadataProcessor()
Get a MetadataProcessor for the translator to read the metadata.
|
SQLConversionVisitor |
getSQLConversionVisitor()
Create the
SQLConversionVisitor that will perform translation. |
List<String> |
getSupportedFunctions()
Get list of all supported function names.
|
Object |
retrieveGeometryValue(ResultSet results,
int paramIndex)
The default strategy assumes a blob value containing wkb
|
boolean |
supportsAdvancedOlapOperations() |
boolean |
supportsAggregatesCountBig() |
boolean |
supportsAggregatesEnhancedNumeric()
Support indicates connector can accept STDDEV_POP, STDDEV_VAR, VAR_POP, VAR_SAMP
|
boolean |
supportsArrayAgg() |
boolean |
supportsArrayType()
The engine uses array types for dependent joins and for array expression.
|
boolean |
supportsBulkUpdate()
Whether the source supports updates with multiple value sets
|
boolean |
supportsCommonTableExpressions() |
boolean |
supportsElementaryOlapOperations() |
boolean |
supportsExcept()
Support indicates that the connector supports the EXCEPT of two queries.
|
boolean |
supportsFormatLiteral(String literal,
ExecutionFactory.Format format) |
boolean |
supportsFunctionsInGroupBy()
Support indicates that the connector supports non-column expressions in GROUP BY, such as:
SELECT dayofmonth(theDate), COUNT(*) FROM table GROUP BY dayofmonth(theDate) |
boolean |
supportsGeneratedKeys() |
boolean |
supportsGeographyType()
If the geography type is supported by the standard ST_ geospatial functions
|
boolean |
supportsGroupByRollup() |
boolean |
supportsInlineViews()
Support indicates connector can accept inline views (subqueries
in the FROM clause).
|
boolean |
supportsInsertWithQueryExpression()
|
boolean |
supportsIntersect()
Support indicates that the connector supports the INTERSECT of two queries.
|
boolean |
supportsIsDistinctCriteria()
Support indicates connector accepts criteria of form (exp1 IS DISTINCT exp2)
|
boolean |
supportsLateralJoin() |
boolean |
supportsLikeRegex() |
boolean |
supportsOrderByNullOrdering()
Returns whether the database supports explicit null ordering.
|
boolean |
supportsOrderByUnrelated()
Support indicates connector accepts ORDER BY clause with columns not from the select
|
boolean |
supportsProcedureTable() |
boolean |
supportsRecursiveCommonTableExpressions() |
boolean |
supportsRowLimit()
Gets whether the connector can limit the number of rows returned by a query.
|
boolean |
supportsRowOffset()
Gets whether the connector supports a SQL clause (similar to the LIMIT with an offset) that can return
result sets that start in the middle of the resulting rows returned by a query
|
boolean |
supportsSelectWithoutFrom() |
boolean |
supportsSimilarTo() |
boolean |
supportsStringAgg() |
boolean |
supportsUpsert() |
boolean |
supportsWindowDistinctAggregates() |
boolean |
supportsWindowFrameClause() |
boolean |
supportsWindowFunctionCumeDist() |
boolean |
supportsWindowFunctionNthValue() |
boolean |
supportsWindowFunctionNtile() |
boolean |
supportsWindowFunctionPercentRank() |
boolean |
supportsWindowOrderByWithAggregates() |
Expression |
translateGeographySelect(Expression expr)
Translate GEOGRAPHY column reference into an expression that
will return WKB and possibly the SRID.
|
Expression |
translateGeometrySelect(Expression expr)
Translate GEOMETRY column reference into an expression that
will return WKB and possibly the SRID.
|
boolean |
useScientificNotation() |
protected boolean |
usesDatabaseVersion() |
addSourceComment, afterInitialConnectionObtained, bindValue, closeConnection, convertObject, createDirectExecution, createMetadataProcessor, createProcedureExecution, createResultSetExecution, createTempTable, createUpdateExecution, executeStoredProcedure, formatDateValue, formatDateValue, getCommentFormat, getConnection, getCreateTemporaryTablePostfix, getCreateTemporaryTableString, getCreateTempTableSQL, getDatabaseCalendar, getDatabaseTimeZone, getDatabaseVersion, getDefaultSupportedFunctions, getFunctionModifiers, getHibernateDialectClassName, getLikeRegexString, getMaxPreparedInsertBatchSize, getMetadata, getRemovePushdownCharacters, getSetOperationString, getSourceComment, getStructRetrieval, getTemporaryTableName, getTimestampNanoPrecision, getVersion, hasTimeType, initCapabilities, intializeConnectionAfterCancel, isCharacterType, isDefaultTimeZone, isEnableDependentJoins, isExtendedAscii, isNonAscii, isNonAscii, isNonAsciiFunction, isSourceRequired, isSourceRequiredForCapabilities, isTrimStrings, loadedTemporaryTable, obtainedConnection, registerFunctionModifier, registerSpecificTypeOfOutParameter, replaceElementName, retrieveGeographyValue, retrieveGeographyValue, retrieveGeometryValue, retrieveValue, retrieveValue, setCommentFormat, setDatabaseTimeZone, setDatabaseVersion, setDatabaseVersion, setEnableDependentJoins, setFetchSize, setMaxPreparedInsertBatchSize, setRemovePushdownCharacters, setStructRetrieval, setTrimStrings, setUseBindingsForDependentJoin, setUseBindVariables, setUseCommentsInSourceQuery, start, supportsAggregatesAvg, supportsAggregatesCount, supportsAggregatesCountStar, supportsAggregatesDistinct, supportsAggregatesMax, supportsAggregatesMin, supportsAggregatesSum, supportsAliasedTable, supportsBatchedUpdates, supportsBooleanExpressions, supportsCompareCriteriaEquals, supportsCompareCriteriaOrdered, supportsCorrelatedSubqueries, supportsDependentJoins, supportsExistsCriteria, supportsFullDependentJoins, supportsGeneratedKeys, supportsGroupBy, supportsHaving, supportsInCriteria, supportsInCriteriaSubquery, supportsIsNullCriteria, supportsLikeCriteria, supportsLikeCriteriaEscapeCharacter, supportsNotCriteria, supportsOrCriteria, supportsQuantifiedCompareCriteriaAll, supportsQuantifiedCompareCriteriaSome, supportsScalarSubqueries, supportsSearchedCaseExpressions, supportsSelectExpression, supportsSelfJoins, supportsSetQueryOrderBy, supportsUnions, tempTableRequiresTransaction, translate, translateCommand, translateGeographyLiteral, translateGeographyParameter, translateGeometryLiteral, translateGeometryParameter, translateLimit, translateLiteralBinaryType, translateLiteralBoolean, translateLiteralDate, translateLiteralTime, translateLiteralTimestamp, useAsInGroupAlias, useBindingsForDependentJoin, useBindVariables, useColumnNamesForGeneratedKeys, useCommentsInSourceQuery, useParensForJoins, useParensForSetQueries, usePreparedStatements, useSelectLimit, useStreamsForLobs, useUnicodePrefix, useWithRollup
addPushDownFunction, areLobsUsableAfterClose, createExecution, getCacheDirective, getCollationLocale, getConnection, getDirectQueryProcedureName, getExcludedCommonTableExpressionName, getInstance, getLanguageFactory, getMaxDependentInPredicates, getMaxFromGroups, getMaxInCriteriaSize, getMaxProjectedColumns, getNativeQueryProcedureName, getPushDownFunctions, getRequiredLikeEscape, getSupportedJoinCriteria, getTransactionSupport, getTypeFacility, isCopyLobs, isForkable, isImmutable, isSourceRequiredForMetadata, isThreadBound, requiresCriteria, returnsSingleUpdateCount, setCollationLocale, setCopyLobs, setDirectQueryProcedureName, setExcludedCommonTableExpressionName, setImmutable, setMaxDependentInPredicates, setMaxInCriteriaSize, setNativeQueryProcedureName, setRequiresCriteria, setSourceRequired, setSourceRequiredForMetadata, setSupportedJoinCriteria, setSupportsDirectQueryProcedure, setSupportsFullOuterJoins, setSupportsInnerJoins, setSupportsNativeQueries, setSupportsOrderBy, setSupportsOuterJoins, setSupportsSelectDistinct, setThreadBound, setTransactionSupport, supportsCompareCriteriaOrderedExclusive, supportsConvert, supportsCorrelatedSubqueryLimit, supportsDirectQueryProcedure, supportsFullOuterJoins, supportsGroupByMultipleDistinctAggregates, supportsInnerJoins, supportsLateralJoinCondition, supportsListAgg, supportsMultipleOpenExecutions, supportsNativeQueries, supportsOnlyCorrelatedSubqueries, supportsOnlyFormatLiterals, supportsOnlyLateralJoinProcedure, supportsOnlyLiteralComparison, supportsOnlySingleTableGroupBy, supportsOnlyTimestampAddLiteral, supportsOrderBy, supportsOrderByWithExtendedGrouping, supportsOuterJoins, supportsPartialFiltering, supportsScalarSubqueryProjection, supportsSelectDistinct, supportsSelectExpressionArrayType, supportsSetQueryLimitOffset, supportsSubqueryCommonTableExpressions, supportsSubqueryInOn, useAnsiJoin
public static final Version SEVEN_0
public static final Version SEVEN_1
public static final Version SEVEN_2
public static final Version SEVEN_3
public static final Version SEVEN_4
public static final Version SEVEN_5
public static final Version SEVEN_6
public static final Version EIGHT_1
public static final Version EIGHT_3
public static final Version EIGHT_4
public static final Version EIGHT_5
public static final Version EIGHT_10
public static final Version NINE_0
public static final Version NINE_1
public static final Version NINE_2
public static final Version TEN_0
public static final Version ELEVEN_1
public static final Version ELEVEN_2
public List<String> getSupportedFunctions()
ExecutionFactory
getSupportedFunctions
in class JDBCExecutionFactory
for a listing of system pushdown functions. Note that
not all system functions are listed as some functions will use a common name
such as CONCAT vs. the || operator, and other functions will be rewritten and
not pushed down, such as SPACE.
Note: User defined functions should be specified fully qualified.
public boolean supportsInlineViews()
ExecutionFactory
supportsInlineViews
in class JDBCExecutionFactory
public boolean supportsFunctionsInGroupBy()
ExecutionFactory
Support indicates that the connector supports non-column expressions in GROUP BY, such as:
SELECT dayofmonth(theDate), COUNT(*) FROM table GROUP BY dayofmonth(theDate)
supportsFunctionsInGroupBy
in class ExecutionFactory<DataSource,Connection>
public boolean supportsRowLimit()
ExecutionFactory
supportsRowLimit
in class ExecutionFactory<DataSource,Connection>
public boolean supportsRowOffset()
ExecutionFactory
supportsRowOffset
in class ExecutionFactory<DataSource,Connection>
public boolean supportsExcept()
ExecutionFactory
supportsExcept
in class ExecutionFactory<DataSource,Connection>
public boolean supportsIntersect()
ExecutionFactory
supportsIntersect
in class ExecutionFactory<DataSource,Connection>
public boolean supportsAggregatesEnhancedNumeric()
ExecutionFactory
supportsAggregatesEnhancedNumeric
in class ExecutionFactory<DataSource,Connection>
public ExecutionFactory.NullOrder getDefaultNullOrder()
ExecutionFactory
getDefaultNullOrder
in class JDBCExecutionFactory
ExecutionFactory.NullOrder
public boolean supportsBulkUpdate()
ExecutionFactory
supportsBulkUpdate
in class JDBCExecutionFactory
public boolean supportsCommonTableExpressions()
supportsCommonTableExpressions
in class ExecutionFactory<DataSource,Connection>
public boolean supportsRecursiveCommonTableExpressions()
supportsRecursiveCommonTableExpressions
in class ExecutionFactory<DataSource,Connection>
public boolean supportsAdvancedOlapOperations()
supportsAdvancedOlapOperations
in class ExecutionFactory<DataSource,Connection>
public boolean supportsElementaryOlapOperations()
supportsElementaryOlapOperations
in class ExecutionFactory<DataSource,Connection>
public boolean supportsWindowFrameClause()
supportsWindowFrameClause
in class ExecutionFactory<DataSource,Connection>
public boolean supportsWindowFunctionNtile()
supportsWindowFunctionNtile
in class ExecutionFactory<DataSource,Connection>
ExecutionFactory.supportsElementaryOlapOperations()
public boolean supportsWindowFunctionPercentRank()
supportsWindowFunctionPercentRank
in class ExecutionFactory<DataSource,Connection>
ExecutionFactory.supportsElementaryOlapOperations()
public boolean supportsWindowFunctionCumeDist()
supportsWindowFunctionCumeDist
in class ExecutionFactory<DataSource,Connection>
ExecutionFactory.supportsElementaryOlapOperations()
public boolean supportsWindowFunctionNthValue()
supportsWindowFunctionNthValue
in class ExecutionFactory<DataSource,Connection>
ExecutionFactory.supportsElementaryOlapOperations()
public boolean supportsArrayAgg()
supportsArrayAgg
in class ExecutionFactory<DataSource,Connection>
public boolean supportsLikeRegex()
supportsLikeRegex
in class ExecutionFactory<DataSource,Connection>
public boolean supportsSimilarTo()
supportsSimilarTo
in class ExecutionFactory<DataSource,Connection>
public boolean supportsWindowDistinctAggregates()
supportsWindowDistinctAggregates
in class ExecutionFactory<DataSource,Connection>
public boolean supportsWindowOrderByWithAggregates()
supportsWindowOrderByWithAggregates
in class ExecutionFactory<DataSource,Connection>
public boolean supportsFormatLiteral(String literal, ExecutionFactory.Format format)
supportsFormatLiteral
in class ExecutionFactory<DataSource,Connection>
public boolean supportsGeneratedKeys()
supportsGeneratedKeys
in class JDBCExecutionFactory
public boolean supportsInsertWithQueryExpression()
ExecutionFactory
SetQuery
or Select
supportsInsertWithQueryExpression
in class JDBCExecutionFactory
public boolean supportsOrderByNullOrdering()
ExecutionFactory
supportsOrderByNullOrdering
in class ExecutionFactory<DataSource,Connection>
protected boolean usesDatabaseVersion()
usesDatabaseVersion
in class JDBCExecutionFactory
public boolean supportsSelectWithoutFrom()
supportsSelectWithoutFrom
in class ExecutionFactory<DataSource,Connection>
public boolean supportsStringAgg()
supportsStringAgg
in class ExecutionFactory<DataSource,Connection>
public SQLDialect getDialect()
getDialect
in class JDBCExecutionFactory
public boolean supportsGroupByRollup()
supportsGroupByRollup
in class ExecutionFactory<DataSource,Connection>
public boolean useScientificNotation()
useScientificNotation
in class JDBCExecutionFactory
public boolean supportsOrderByUnrelated()
ExecutionFactory
supportsOrderByUnrelated
in class JDBCExecutionFactory
public MetadataProcessor<Connection> getMetadataProcessor()
ExecutionFactory
getMetadataProcessor
in class JDBCExecutionFactory
public boolean supportsLateralJoin()
supportsLateralJoin
in class ExecutionFactory<DataSource,Connection>
public String getLateralKeyword()
getLateralKeyword
in class JDBCExecutionFactory
public boolean supportsProcedureTable()
supportsProcedureTable
in class ExecutionFactory<DataSource,Connection>
public boolean supportsArrayType()
ExecutionFactory
supportsArrayType
in class ExecutionFactory<DataSource,Connection>
public boolean supportsUpsert()
supportsUpsert
in class ExecutionFactory<DataSource,Connection>
public boolean supportsIsDistinctCriteria()
ExecutionFactory
supportsIsDistinctCriteria
in class ExecutionFactory<DataSource,Connection>
public SQLConversionVisitor getSQLConversionVisitor()
JDBCExecutionFactory
SQLConversionVisitor
that will perform translation. Typical custom
JDBC connectors will not need to create custom conversion visitors, rather implementors
should override existing JDBCExecutionFactory
methods.getSQLConversionVisitor
in class JDBCExecutionFactory
SQLConversionVisitor
public boolean supportsAggregatesCountBig()
supportsAggregatesCountBig
in class ExecutionFactory<DataSource,Connection>
ExecutionFactory.supportsAggregatesCount()
will be consulted by the engine, this capability
only affects the name of the pushed count function if a long value is expectedpublic boolean supportsGeographyType()
ExecutionFactory
supportsGeographyType
in class ExecutionFactory<DataSource,Connection>
public Expression translateGeometrySelect(Expression expr)
JDBCExecutionFactory
translateGeometrySelect
in class JDBCExecutionFactory
public Expression translateGeographySelect(Expression expr)
JDBCExecutionFactory
translateGeographySelect
in class JDBCExecutionFactory
public Object retrieveGeometryValue(ResultSet results, int paramIndex) throws SQLException
JDBCExecutionFactory
retrieveGeometryValue
in class JDBCExecutionFactory
SQLException
Copyright © 2019. All rights reserved.