@Translator(name="teiid", description="A translator for Teiid 7.0 or later") public class TeiidExecutionFactory extends JDBCExecutionFactory
JDBCExecutionFactory.StructRetrievalExecutionFactory.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, dialectDEFAULT_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, useNBindingType, useParensForJoins, useParensForSetQueries, usePreparedStatements, useSelectLimit, useStreamsForLobs, useUnicodePrefix, useWithRollupaddPushDownFunction, 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, useAnsiJoinpublic 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()
ExecutionFactorygetSupportedFunctions in class JDBCExecutionFactoryfor 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()
ExecutionFactorysupportsInlineViews in class JDBCExecutionFactorypublic boolean supportsFunctionsInGroupBy()
ExecutionFactorySupport 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()
ExecutionFactorysupportsRowLimit in class ExecutionFactory<DataSource,Connection>public boolean supportsRowOffset()
ExecutionFactorysupportsRowOffset in class ExecutionFactory<DataSource,Connection>public boolean supportsExcept()
ExecutionFactorysupportsExcept in class ExecutionFactory<DataSource,Connection>public boolean supportsIntersect()
ExecutionFactorysupportsIntersect in class ExecutionFactory<DataSource,Connection>public boolean supportsAggregatesEnhancedNumeric()
ExecutionFactorysupportsAggregatesEnhancedNumeric in class ExecutionFactory<DataSource,Connection>public ExecutionFactory.NullOrder getDefaultNullOrder()
ExecutionFactorygetDefaultNullOrder in class JDBCExecutionFactoryExecutionFactory.NullOrderpublic boolean supportsBulkUpdate()
ExecutionFactorysupportsBulkUpdate in class JDBCExecutionFactorypublic 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 JDBCExecutionFactorypublic boolean supportsInsertWithQueryExpression()
ExecutionFactorySetQuery or SelectsupportsInsertWithQueryExpression in class JDBCExecutionFactorypublic boolean supportsOrderByNullOrdering()
ExecutionFactorysupportsOrderByNullOrdering in class ExecutionFactory<DataSource,Connection>protected boolean usesDatabaseVersion()
usesDatabaseVersion in class JDBCExecutionFactorypublic boolean supportsSelectWithoutFrom()
supportsSelectWithoutFrom in class ExecutionFactory<DataSource,Connection>public boolean supportsStringAgg()
supportsStringAgg in class ExecutionFactory<DataSource,Connection>public SQLDialect getDialect()
getDialect in class JDBCExecutionFactorypublic boolean supportsGroupByRollup()
supportsGroupByRollup in class ExecutionFactory<DataSource,Connection>public boolean useScientificNotation()
useScientificNotation in class JDBCExecutionFactorypublic boolean supportsOrderByUnrelated()
ExecutionFactorysupportsOrderByUnrelated in class JDBCExecutionFactorypublic MetadataProcessor<Connection> getMetadataProcessor()
ExecutionFactorygetMetadataProcessor in class JDBCExecutionFactorypublic boolean supportsLateralJoin()
supportsLateralJoin in class ExecutionFactory<DataSource,Connection>public String getLateralKeyword()
getLateralKeyword in class JDBCExecutionFactorypublic boolean supportsProcedureTable()
supportsProcedureTable in class ExecutionFactory<DataSource,Connection>public boolean supportsArrayType()
ExecutionFactorysupportsArrayType in class ExecutionFactory<DataSource,Connection>public boolean supportsUpsert()
supportsUpsert in class ExecutionFactory<DataSource,Connection>public boolean supportsIsDistinctCriteria()
ExecutionFactorysupportsIsDistinctCriteria in class ExecutionFactory<DataSource,Connection>public SQLConversionVisitor getSQLConversionVisitor()
JDBCExecutionFactorySQLConversionVisitor 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 JDBCExecutionFactorySQLConversionVisitorpublic 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()
ExecutionFactorysupportsGeographyType in class ExecutionFactory<DataSource,Connection>public Expression translateGeometrySelect(Expression expr)
JDBCExecutionFactorytranslateGeometrySelect in class JDBCExecutionFactorypublic Expression translateGeographySelect(Expression expr)
JDBCExecutionFactorytranslateGeographySelect in class JDBCExecutionFactorypublic Object retrieveGeometryValue(ResultSet results, int paramIndex) throws SQLException
JDBCExecutionFactoryretrieveGeometryValue in class JDBCExecutionFactorySQLExceptionCopyright © 2019. All rights reserved.