org.teiid.translator.jdbc.exasol

Class ExasolExecutionFactory

java.lang.Object

org.teiid.translator.ExecutionFactory<DataSource,Connection>

org.teiid.translator.jdbc.JDBCExecutionFactory

org.teiid.translator.jdbc.exasol.ExasolExecutionFactory

@Translator(name="exasol",
            description="Translator for EXASOL database")
public class ExasolExecutionFactory
extends JDBCExecutionFactory

Translator for the EXASOL database. Acknowledgements to Nevena Tacheva from Exasol for the initial work on identifying most of pushdown and supported functions.

Nested Class Summary

Nested classes/interfaces inherited from class org.teiid.translator.jdbc.JDBCExecutionFactory

JDBCExecutionFactory.StructRetrieval

Nested classes/interfaces inherited from class org.teiid.translator.ExecutionFactory

ExecutionFactory.Format, ExecutionFactory.NullOrder, ExecutionFactory.SupportedJoinCriteria, ExecutionFactory.TransactionSupport

Field Summary

Fields

Modifier and Type	Field and Description
static String	ADD_DAYS
static String	ADD_HOURS
static String	ADD_MINUTES
static String	ADD_MONTHS
static String	ADD_SECONDS
static String	ADD_WEEKS
static String	ADD_YEARS
static String	BIT_AND
static String	BIT_LENGTH
static String	BIT_NOT
static String	BIT_OR
static String	BIT_XOR
static String	CHARACTER_LENGTH
static String	CHR
static String	COLOGNE_PHONETIC
static String	DATE_FORMAT
static String	DATE_TRUNC
static String	DATETIME_FORMAT
static String	DAY
static String	DAYS_BETWEEN
static String	EDIT_DISTANCE
static String	EXASOL
static String	FROM_POSIX_TIME
static String	HOURS_BETWEEN
static String	INSTR
static String	LN
static String	LOWER
static String	LTRIM
static String	MID
static String	MINUTES_BETWEEN
static String	MONTHS_BETWEEN
static String	OCTET_LENGTH
static String	POSIX_TIME
static String	REGEXP_INSTR
static String	REGEXP_REPLACE
static String	REGEXP_SUBSTR
static String	REPLACE
static String	REVERSE
static String	ROUND
static String	RTRIM
static String	SECONDS_BETWEEN
static String	SOUNDEX
static String	SPACE
static String	TIME_FORMAT
static String	TIMESTAMP_FORMAT
static String	TO_CHAR
static String	TO_NUMBER
static String	TO_TIMESTAMP
static String	TRUNC
static String	TRUNCATE
static String	UNICODE
static String	UNICODECHR
static String	UPPER
static String	YEARS_BETWEEN

Fields inherited from class org.teiid.translator.jdbc.JDBCExecutionFactory

DEFAULT_MAX_DEPENDENT_PREDICATES, DEFAULT_MAX_IN_CRITERIA, DEFAULT_TIME_ZONE, dialect

Fields inherited from class org.teiid.translator.ExecutionFactory

DEFAULT_MAX_FROM_GROUPS, DEFAULT_MAX_IN_CRITERIA_SIZE, DEFAULT_MAX_PROJECTED_COLUMNS

Constructor Summary

Constructors

Constructor and Description
ExasolExecutionFactory()

Method Summary

Modifier and Type	Method and Description
ExecutionFactory.NullOrder	getDefaultNullOrder() Returns the default null ordering
List<String>	getSupportedFunctions() Get list of all supported function names.
Object	retrieveValue(CallableStatement results, int parameterIndex, Class<?> expectedType) Retrieve the value for the given parameter index
Object	retrieveValue(ResultSet results, int columnIndex, Class<?> expectedType) Retrieve the value on the current resultset row for the given column index.
void	start() Initialize the connector with supplied configuration
boolean	supportsArrayType() The engine uses array types for dependent joins and for array expression.
boolean	supportsBatchedUpdates() Whether the source supports BatchedUpdates
boolean	supportsCommonTableExpressions()
boolean	supportsCompareCriteriaOrdered() Support indicates connector accepts criteria of form (element <=|>= constant) The query engine will may pushdown queries containing < or > if NOT is also supported.
boolean	supportsConvert(int fromType, int toType) Used for fine grained control of convert/cast pushdown.
boolean	supportsCorrelatedSubqueries() Support indicates connector can accept correlated subqueries wherever subqueries are accepted
boolean	supportsExcept() Support indicates that the connector supports the EXCEPT of two queries.
boolean	supportsExistsCriteria() Support indicates connector accepts the EXISTS criteria
boolean	supportsGroupByRollup()
boolean	supportsInCriteriaSubquery() Support indicates connector accepts IN criteria with a subquery on the right side
boolean	supportsInlineViews() Support indicates connector can accept inline views (subqueries in the FROM clause).
boolean	supportsIntersect() Support indicates that the connector supports the INTERSECT of two queries.
boolean	supportsOrderBy() Support indicates connector accepts ORDER BY clause, including multiple elements and ascending and descending sorts.
boolean	supportsOrderByNullOrdering() Returns whether the database supports explicit null ordering.
boolean	supportsQuantifiedCompareCriteriaAll() Support indicates connector accepts the quantified comparison criteria that use ALL
boolean	supportsQuantifiedCompareCriteriaSome() Support indicates connector accepts the quantified comparison criteria that use SOME
boolean	supportsRowLimit() Gets whether the connector can limit the number of rows returned by a query.
boolean	supportsSearchedCaseExpressions() Support indicates connector can accept queries with searched CASE WHEN criteria ...
boolean	supportsSelectWithoutFrom()

Methods inherited from class org.teiid.translator.jdbc.JDBCExecutionFactory

addSourceComment, afterInitialConnectionObtained, bindValue, closeConnection, convertObject, createDirectExecution, createMetadataProcessor, createProcedureExecution, createResultSetExecution, createTempTable, createUpdateExecution, executeStoredProcedure, formatDateValue, formatDateValue, getCommentFormat, getConnection, getCreateTemporaryTablePostfix, getCreateTemporaryTableString, getCreateTempTableSQL, getDatabaseCalendar, getDatabaseTimeZone, getDatabaseVersion, getDefaultSupportedFunctions, getDialect, getFunctionModifiers, getHibernateDialectClassName, getLateralKeyword, getLikeRegexString, getMaxPreparedInsertBatchSize, getMetadata, getMetadataProcessor, getRemovePushdownCharacters, getSetOperationString, getSourceComment, getSQLConversionVisitor, getStructRetrieval, getTemporaryTableName, getTimestampNanoPrecision, getVersion, hasTimeType, initCapabilities, intializeConnectionAfterCancel, isEnableDependentJoins, isExtendedAscii, isNonAscii, isNonAscii, isNonAsciiFunction, isSourceRequired, isSourceRequiredForCapabilities, isTrimStrings, loadedTemporaryTable, obtainedConnection, parseName, registerFunctionModifier, registerSpecificTypeOfOutParameter, replaceElementName, retrieveGeographyValue, retrieveGeographyValue, retrieveGeometryValue, retrieveGeometryValue, setCommentFormat, setDatabaseTimeZone, setDatabaseVersion, setDatabaseVersion, setEnableDependentJoins, setFetchSize, setMaxPreparedInsertBatchSize, setRemovePushdownCharacters, setStructRetrieval, setTrimStrings, setUseBindingsForDependentJoin, setUseBindVariables, setUseCommentsInSourceQuery, supportsAggregatesAvg, supportsAggregatesCount, supportsAggregatesCountStar, supportsAggregatesDistinct, supportsAggregatesMax, supportsAggregatesMin, supportsAggregatesSum, supportsAliasedTable, supportsBooleanExpressions, supportsBulkUpdate, supportsCompareCriteriaEquals, supportsDependentJoins, supportsFullDependentJoins, supportsGeneratedKeys, supportsGeneratedKeys, supportsGroupBy, supportsHaving, supportsInCriteria, supportsInsertWithQueryExpression, supportsIsNullCriteria, supportsLikeCriteria, supportsLikeCriteriaEscapeCharacter, supportsNotCriteria, supportsOrCriteria, supportsOrderByUnrelated, supportsScalarSubqueries, supportsSelectExpression, supportsSelfJoins, supportsSetQueryOrderBy, supportsUnions, tempTableRequiresTransaction, translate, translateCommand, translateGeographyLiteral, translateGeographyParameter, translateGeographySelect, translateGeometryLiteral, translateGeometryParameter, translateGeometrySelect, translateLimit, translateLiteralBinaryType, translateLiteralBoolean, translateLiteralDate, translateLiteralTime, translateLiteralTimestamp, useAsInGroupAlias, useBindingsForDependentJoin, useBindVariables, useColumnNamesForGeneratedKeys, useCommentsInSourceQuery, useParensForJoins, useParensForSetQueries, usePreparedStatements, useScientificNotation, usesDatabaseVersion, useSelectLimit, useStreamsForLobs, useUnicodePrefix, useWithRollup

Methods inherited from class org.teiid.translator.ExecutionFactory

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, supportsAdvancedOlapOperations, supportsAggregatesCountBig, supportsAggregatesEnhancedNumeric, supportsArrayAgg, supportsCompareCriteriaOrderedExclusive, supportsCorrelatedSubqueryLimit, supportsDirectQueryProcedure, supportsElementaryOlapOperations, supportsFormatLiteral, supportsFullOuterJoins, supportsFunctionsInGroupBy, supportsGeographyType, supportsGroupByMultipleDistinctAggregates, supportsInnerJoins, supportsIsDistinctCriteria, supportsLateralJoin, supportsLateralJoinCondition, supportsLikeRegex, supportsListAgg, supportsMultipleOpenExecutions, supportsNativeQueries, supportsOnlyCorrelatedSubqueries, supportsOnlyFormatLiterals, supportsOnlyLateralJoinProcedure, supportsOnlyLiteralComparison, supportsOnlySingleTableGroupBy, supportsOnlyTimestampAddLiteral, supportsOrderByWithExtendedGrouping, supportsOuterJoins, supportsPartialFiltering, supportsProcedureTable, supportsRecursiveCommonTableExpressions, supportsRowOffset, supportsScalarSubqueryProjection, supportsSelectDistinct, supportsSelectExpressionArrayType, supportsSetQueryLimitOffset, supportsSimilarTo, supportsStringAgg, supportsSubqueryCommonTableExpressions, supportsSubqueryInOn, supportsUpsert, supportsWindowDistinctAggregates, supportsWindowFrameClause, supportsWindowFunctionCumeDist, supportsWindowFunctionNthValue, supportsWindowFunctionNtile, supportsWindowFunctionPercentRank, supportsWindowOrderByWithAggregates, useAnsiJoin

Methods inherited from class java.lang.Object

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

Field Detail

EXASOL

public static final String EXASOL

See Also:

Constant Field Values

TIME_FORMAT

public static final String TIME_FORMAT

See Also:

Constant Field Values

DATE_FORMAT

public static final String DATE_FORMAT

See Also:

Constant Field Values

DATETIME_FORMAT

public static final String DATETIME_FORMAT

See Also:

Constant Field Values

TIMESTAMP_FORMAT

public static final String TIMESTAMP_FORMAT

See Also:

Constant Field Values

LN

public static final String LN

See Also:

Constant Field Values

BIT_AND

public static final String BIT_AND

See Also:

Constant Field Values

BIT_NOT

public static final String BIT_NOT

See Also:

Constant Field Values

BIT_OR

public static final String BIT_OR

See Also:

Constant Field Values

BIT_XOR

public static final String BIT_XOR

See Also:

Constant Field Values

BIT_LENGTH

public static final String BIT_LENGTH

See Also:

Constant Field Values

CHARACTER_LENGTH

public static final String CHARACTER_LENGTH

See Also:

Constant Field Values

CHR

public static final String CHR

See Also:

Constant Field Values

COLOGNE_PHONETIC

public static final String COLOGNE_PHONETIC

See Also:

Constant Field Values

EDIT_DISTANCE

public static final String EDIT_DISTANCE

See Also:

Constant Field Values

INSTR

public static final String INSTR

See Also:

Constant Field Values

LOWER

public static final String LOWER

See Also:

Constant Field Values

LTRIM

public static final String LTRIM

See Also:

Constant Field Values

MID

public static final String MID

See Also:

Constant Field Values

OCTET_LENGTH

public static final String OCTET_LENGTH

See Also:

Constant Field Values

REGEXP_INSTR

public static final String REGEXP_INSTR

See Also:

Constant Field Values

REGEXP_REPLACE

public static final String REGEXP_REPLACE

See Also:

Constant Field Values

REGEXP_SUBSTR

public static final String REGEXP_SUBSTR

See Also:

Constant Field Values

REPLACE

public static final String REPLACE

See Also:

Constant Field Values

REVERSE

public static final String REVERSE

See Also:

Constant Field Values

RTRIM

public static final String RTRIM

See Also:

Constant Field Values

SOUNDEX

public static final String SOUNDEX

See Also:

Constant Field Values

SPACE

public static final String SPACE

See Also:

Constant Field Values

TO_NUMBER

public static final String TO_NUMBER

See Also:

Constant Field Values

UNICODE

public static final String UNICODE

See Also:

Constant Field Values

UNICODECHR

public static final String UNICODECHR

See Also:

Constant Field Values

UPPER

public static final String UPPER

See Also:

Constant Field Values

ADD_DAYS

public static final String ADD_DAYS

See Also:

Constant Field Values

ADD_HOURS

public static final String ADD_HOURS

See Also:

Constant Field Values

ADD_MINUTES

public static final String ADD_MINUTES

See Also:

Constant Field Values

ADD_MONTHS

public static final String ADD_MONTHS

See Also:

Constant Field Values

ADD_SECONDS

public static final String ADD_SECONDS

See Also:

Constant Field Values

ADD_WEEKS

public static final String ADD_WEEKS

See Also:

Constant Field Values

ADD_YEARS

public static final String ADD_YEARS

See Also:

Constant Field Values

DATE_TRUNC

public static final String DATE_TRUNC

See Also:

Constant Field Values

DAY

public static final String DAY

See Also:

Constant Field Values

DAYS_BETWEEN

public static final String DAYS_BETWEEN

See Also:

Constant Field Values

FROM_POSIX_TIME

public static final String FROM_POSIX_TIME

See Also:

Constant Field Values

HOURS_BETWEEN

public static final String HOURS_BETWEEN

See Also:

Constant Field Values

MINUTES_BETWEEN

public static final String MINUTES_BETWEEN

See Also:

Constant Field Values

MONTHS_BETWEEN

public static final String MONTHS_BETWEEN

See Also:

Constant Field Values

POSIX_TIME

public static final String POSIX_TIME

See Also:

Constant Field Values

ROUND

public static final String ROUND

See Also:

Constant Field Values

SECONDS_BETWEEN

public static final String SECONDS_BETWEEN

See Also:

Constant Field Values

TO_CHAR

public static final String TO_CHAR

See Also:

Constant Field Values

TO_TIMESTAMP

public static final String TO_TIMESTAMP

See Also:

Constant Field Values

TRUNC

public static final String TRUNC

See Also:

Constant Field Values

TRUNCATE

public static final String TRUNCATE

See Also:

Constant Field Values

YEARS_BETWEEN

public static final String YEARS_BETWEEN

See Also:

Constant Field Values

Constructor Detail

ExasolExecutionFactory

public ExasolExecutionFactory()

Method Detail

start

public void start()
           throws TranslatorException

Description copied from class: ExecutionFactory

Initialize the connector with supplied configuration

Overrides:

start in class JDBCExecutionFactory

Throws:

TranslatorException

getSupportedFunctions

public List<String> getSupportedFunctions()

Description copied from class: ExecutionFactory

Get list of all supported function names. Arithmetic functions have names like "+".

Overrides:

getSupportedFunctions in class JDBCExecutionFactory

See Also:

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.

retrieveValue

public Object retrieveValue(CallableStatement results,
                            int parameterIndex,
                            Class<?> expectedType)
                     throws SQLException

Description copied from class: JDBCExecutionFactory

Retrieve the value for the given parameter index

Overrides:

retrieveValue in class JDBCExecutionFactory

Returns:

the value

Throws:

SQLException

retrieveValue

public Object retrieveValue(ResultSet results,
                            int columnIndex,
                            Class<?> expectedType)
                     throws SQLException

Description copied from class: JDBCExecutionFactory

Retrieve the value on the current resultset row for the given column index.

Overrides:

retrieveValue in class JDBCExecutionFactory

Returns:

the value

Throws:

SQLException

supportsConvert

public boolean supportsConvert(int fromType,
                               int toType)

Description copied from class: ExecutionFactory

Used for fine grained control of convert/cast pushdown. The ExecutionFactory.getSupportedFunctions() should contain SourceSystemFunctions.CONVERT. This method can then return false to indicate a lack of specific support. The engine will does not care about an unnecessary conversion where fromType == toType. By default lob conversion is disabled.

Overrides:

supportsConvert in class ExecutionFactory<DataSource,Connection>

Parameters:

fromType - @see RUNTIME_CODES

toType - @see RUNTIME_CODES

Returns:

true if the given conversion is supported.

getDefaultNullOrder

public ExecutionFactory.NullOrder getDefaultNullOrder()

Description copied from class: ExecutionFactory

Returns the default null ordering

Overrides:

getDefaultNullOrder in class JDBCExecutionFactory

Returns:

the ExecutionFactory.NullOrder

supportsOrderBy

public boolean supportsOrderBy()

Description copied from class: ExecutionFactory

Support indicates connector accepts ORDER BY clause, including multiple elements and ascending and descending sorts.

Overrides:

supportsOrderBy in class ExecutionFactory<DataSource,Connection>

supportsOrderByNullOrdering

public boolean supportsOrderByNullOrdering()

Description copied from class: ExecutionFactory

Returns whether the database supports explicit null ordering.

Overrides:

supportsOrderByNullOrdering in class ExecutionFactory<DataSource,Connection>

Returns:

true if nulls first/last can be specified

supportsSearchedCaseExpressions

public boolean supportsSearchedCaseExpressions()

Description copied from class: ExecutionFactory

Support indicates connector can accept queries with searched CASE WHEN criteria ... END

Overrides:

supportsSearchedCaseExpressions in class JDBCExecutionFactory

supportsQuantifiedCompareCriteriaSome

public boolean supportsQuantifiedCompareCriteriaSome()

Description copied from class: ExecutionFactory

Support indicates connector accepts the quantified comparison criteria that use SOME

Overrides:

supportsQuantifiedCompareCriteriaSome in class JDBCExecutionFactory

supportsQuantifiedCompareCriteriaAll

public boolean supportsQuantifiedCompareCriteriaAll()

Description copied from class: ExecutionFactory

Support indicates connector accepts the quantified comparison criteria that use ALL

Overrides:

supportsQuantifiedCompareCriteriaAll in class JDBCExecutionFactory

supportsIntersect

public boolean supportsIntersect()

Description copied from class: ExecutionFactory

Support indicates that the connector supports the INTERSECT of two queries.

Overrides:

supportsIntersect in class ExecutionFactory<DataSource,Connection>

supportsExcept

public boolean supportsExcept()

Description copied from class: ExecutionFactory

Support indicates that the connector supports the EXCEPT of two queries.

Overrides:

supportsExcept in class ExecutionFactory<DataSource,Connection>

supportsSelectWithoutFrom

public boolean supportsSelectWithoutFrom()

Overrides:

supportsSelectWithoutFrom in class ExecutionFactory<DataSource,Connection>

Returns:

true if the translator support SELECT without a FROM clause

supportsGroupByRollup

public boolean supportsGroupByRollup()

Overrides:

supportsGroupByRollup in class ExecutionFactory<DataSource,Connection>

Returns:

true if the translator support GROUP BY ROLLUP

supportsArrayType

public boolean supportsArrayType()

Description copied from class: ExecutionFactory

The engine uses array types for dependent joins and for array expression.

Overrides:

supportsArrayType in class ExecutionFactory<DataSource,Connection>

Returns:

true if an array type is supported.

supportsCommonTableExpressions

public boolean supportsCommonTableExpressions()

Overrides:

supportsCommonTableExpressions in class ExecutionFactory<DataSource,Connection>

Returns:

true if the WITH clause is supported

supportsBatchedUpdates

public boolean supportsBatchedUpdates()

Description copied from class: ExecutionFactory

Whether the source supports BatchedUpdates

Overrides:

supportsBatchedUpdates in class JDBCExecutionFactory

supportsRowLimit

public boolean supportsRowLimit()

Description copied from class: ExecutionFactory

Gets whether the connector can limit the number of rows returned by a query.

Overrides:

supportsRowLimit in class ExecutionFactory<DataSource,Connection>

supportsExistsCriteria

public boolean supportsExistsCriteria()

Description copied from class: ExecutionFactory

Support indicates connector accepts the EXISTS criteria

Overrides:

supportsExistsCriteria in class JDBCExecutionFactory

supportsInCriteriaSubquery

public boolean supportsInCriteriaSubquery()

Description copied from class: ExecutionFactory

Support indicates connector accepts IN criteria with a subquery on the right side

Overrides:

supportsInCriteriaSubquery in class JDBCExecutionFactory

supportsCompareCriteriaOrdered

public boolean supportsCompareCriteriaOrdered()

Description copied from class: ExecutionFactory

Support indicates connector accepts criteria of form (element <=|>= constant)
The query engine will may pushdown queries containing < or > if NOT is also supported.

Overrides:

supportsCompareCriteriaOrdered in class JDBCExecutionFactory

supportsInlineViews

public boolean supportsInlineViews()

Description copied from class: ExecutionFactory

Support indicates connector can accept inline views (subqueries in the FROM clause).

Overrides:

supportsInlineViews in class JDBCExecutionFactory

supportsCorrelatedSubqueries

public boolean supportsCorrelatedSubqueries()

Description copied from class: ExecutionFactory

Support indicates connector can accept correlated subqueries wherever subqueries are accepted

Overrides:

supportsCorrelatedSubqueries in class JDBCExecutionFactory