Class VerticaExecutionFactory
- java.lang.Object
-
- org.teiid.translator.ExecutionFactory<DataSource,Connection>
-
- org.teiid.translator.jdbc.JDBCExecutionFactory
-
- org.teiid.translator.jdbc.vertica.VerticaExecutionFactory
-
@Translator(name="vertica", description="A translator for read/write HP Vertica Analytic Database Server") public class VerticaExecutionFactory extends JDBCExecutionFactory
-
-
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 Description static String
ADD_MONTHS
static String
AGE_IN_MONTHS
static String
AGE_IN_YEARS
static String
BIT_LENGTH
static String
BITCOUNT
static String
BITSTRING_TO_BINARY
static String
BTRIM
static String
CBRT
static String
CHR
static String
CURRENT_DATE
static String
CURRENT_TIME
static String
DATE_NAME
static String
DATEDIFF
static String
DAY
static String
GETDATE
static String
GETUTCDATE
static String
GREATEST
static String
GREATESTB
static String
HEX_TO_BINARY
static String
HEX_TO_INTEGER
static String
INITCAP
static String
INSERT
static String
ISFINITE
static String
ISUTF8
static String
LN
static String
LOCALTIME
static String
LOCALTIMESTAMP
static String
LOWER
static String
MD5
static String
MONTHS_BETWEEN
static String
OVERLAPS
static String
PI
static String
RANDOM
static String
SPACE
static String
TIMESTAMPDIFF
static String
TO_HEX
static String
TRUNC
static String
UPPER
static String
VERTICA
static String
WEEK_ISO
-
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 Description VerticaExecutionFactory()
-
Method Summary
All Methods Instance Methods Concrete Methods Modifier and Type Method Description ExecutionFactory.NullOrder
getDefaultNullOrder()
Returns the default null orderingList<String>
getSupportedFunctions()
Get list of all supported function names.void
start()
Initialize the connector with supplied configurationboolean
supportsCompareCriteriaEquals()
Support indicates connector accepts criteria of form (element = constant)boolean
supportsInCriteria()
Support indicates connector accepts criteria of form (element IN set)boolean
supportsIntersect()
Support indicates that the connector supports the INTERSECT of two queries.List<?>
translate(LanguageObject obj, ExecutionContext context)
Return a List of translated parts (LanguageObject
s and Objects), or null if to rely on the default translation.-
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, isCharacterType, isDefaultTimeZone, isEnableDependentJoins, isExtendedAscii, isNonAscii, isNonAscii, isNonAsciiFunction, isSourceRequired, isSourceRequiredForCapabilities, isTrimStrings, loadedTemporaryTable, obtainedConnection, preserveNullTyping, registerFunctionModifier, registerSpecificTypeOfOutParameter, replaceElementName, retrieveGeographyValue, retrieveGeographyValue, retrieveGeometryValue, retrieveGeometryValue, retrieveValue, retrieveValue, setCommentFormat, setDatabaseTimeZone, setDatabaseVersion, setDatabaseVersion, setEnableDependentJoins, setFetchSize, setMaxPreparedInsertBatchSize, setRemovePushdownCharacters, setStructRetrieval, setTrimStrings, setUseBindingsForDependentJoin, setUseBindVariables, setUseCommentsInSourceQuery, supportsAggregatesAvg, supportsAggregatesCount, supportsAggregatesCountStar, supportsAggregatesDistinct, supportsAggregatesMax, supportsAggregatesMin, supportsAggregatesSum, supportsAliasedTable, supportsBatchedUpdates, supportsBooleanExpressions, supportsBulkUpdate, supportsCompareCriteriaOrdered, supportsCorrelatedSubqueries, supportsDependentJoins, supportsExistsCriteria, supportsFullDependentJoins, supportsGeneratedKeys, supportsGeneratedKeys, supportsGroupBy, supportsHaving, supportsInCriteriaSubquery, supportsInlineViews, supportsInsertWithQueryExpression, supportsIsNullCriteria, supportsLikeCriteria, supportsLikeCriteriaEscapeCharacter, supportsNotCriteria, supportsOrCriteria, supportsOrderByUnrelated, supportsProcedureParameterExpression, supportsQuantifiedCompareCriteriaAll, supportsQuantifiedCompareCriteriaSome, supportsScalarSubqueries, supportsSearchedCaseExpressions, supportsSelectExpression, supportsSelfJoins, supportsSetQueryOrderBy, supportsUnions, tempTableRequiresTransaction, translateCommand, translateGeographyLiteral, translateGeographyParameter, translateGeographySelect, translateGeometryLiteral, translateGeometryParameter, translateGeometrySelect, translateLimit, translateLiteralBinaryType, translateLiteralBoolean, translateLiteralDate, translateLiteralTime, translateLiteralTimestamp, useAsInGroupAlias, useBindingsForDependentJoin, useBindVariables, useColumnNamesForGeneratedKeys, useCommentsInSourceQuery, useNBindingType, 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, supportsArrayType, supportsCommonTableExpressions, supportsCompareCriteriaOrderedExclusive, supportsConvert, supportsCorrelatedSubqueryLimit, supportsDirectQueryProcedure, supportsElementaryOlapOperations, supportsExcept, supportsFormatLiteral, supportsFullOuterJoins, supportsFunctionsInGroupBy, supportsGeographyType, supportsGroupByMultipleDistinctAggregates, supportsGroupByRollup, supportsInnerJoins, supportsIsDistinctCriteria, supportsLateralJoin, supportsLateralJoinCondition, supportsLikeRegex, supportsListAgg, supportsMultipleOpenExecutions, supportsNativeQueries, supportsOnlyCorrelatedSubqueries, supportsOnlyFormatLiterals, supportsOnlyLateralJoinProcedure, supportsOnlyLiteralComparison, supportsOnlyRelationshipStyleJoins, supportsOnlySingleTableGroupBy, supportsOnlyTimestampAddLiteral, supportsOrderBy, supportsOrderByNullOrdering, supportsOrderByWithExtendedGrouping, supportsOuterJoins, supportsPartialFiltering, supportsProcedureTable, supportsRecursiveCommonTableExpressions, supportsRowLimit, supportsRowOffset, supportsScalarSubqueryProjection, supportsSelectDistinct, supportsSelectExpressionArrayType, supportsSelectWithoutFrom, supportsSetQueryLimitOffset, supportsSimilarTo, supportsStringAgg, supportsSubqueryCommonTableExpressions, supportsSubqueryInOn, supportsUpsert, supportsWindowDistinctAggregates, supportsWindowFrameClause, supportsWindowFunctionCumeDist, supportsWindowFunctionNthValue, supportsWindowFunctionNtile, supportsWindowFunctionPercentRank, supportsWindowOrderByWithAggregates, useAnsiJoin
-
-
-
-
Field Detail
-
VERTICA
public static final String VERTICA
- See Also:
- Constant Field Values
-
BIT_LENGTH
public static final String BIT_LENGTH
- See Also:
- Constant Field Values
-
BITCOUNT
public static final String BITCOUNT
- See Also:
- Constant Field Values
-
BITSTRING_TO_BINARY
public static final String BITSTRING_TO_BINARY
- See Also:
- Constant Field Values
-
BTRIM
public static final String BTRIM
- See Also:
- Constant Field Values
-
CHR
public static final String CHR
- See Also:
- Constant Field Values
-
GREATEST
public static final String GREATEST
- See Also:
- Constant Field Values
-
GREATESTB
public static final String GREATESTB
- See Also:
- Constant Field Values
-
HEX_TO_BINARY
public static final String HEX_TO_BINARY
- See Also:
- Constant Field Values
-
HEX_TO_INTEGER
public static final String HEX_TO_INTEGER
- See Also:
- Constant Field Values
-
INITCAP
public static final String INITCAP
- See Also:
- Constant Field Values
-
INSERT
public static final String INSERT
- See Also:
- Constant Field Values
-
ISUTF8
public static final String ISUTF8
- See Also:
- Constant Field Values
-
LOWER
public static final String LOWER
- See Also:
- Constant Field Values
-
MD5
public static final String MD5
- See Also:
- Constant Field Values
-
SPACE
public static final String SPACE
- See Also:
- Constant Field Values
-
TO_HEX
public static final String TO_HEX
- See Also:
- Constant Field Values
-
UPPER
public static final String UPPER
- See Also:
- Constant Field Values
-
CBRT
public static final String CBRT
- See Also:
- Constant Field Values
-
LN
public static final String LN
- See Also:
- Constant Field Values
-
PI
public static final String PI
- See Also:
- Constant Field Values
-
RANDOM
public static final String RANDOM
- See Also:
- Constant Field Values
-
TRUNC
public static final String TRUNC
- See Also:
- Constant Field Values
-
ADD_MONTHS
public static final String ADD_MONTHS
- See Also:
- Constant Field Values
-
AGE_IN_MONTHS
public static final String AGE_IN_MONTHS
- See Also:
- Constant Field Values
-
AGE_IN_YEARS
public static final String AGE_IN_YEARS
- See Also:
- Constant Field Values
-
CURRENT_DATE
public static final String CURRENT_DATE
- See Also:
- Constant Field Values
-
CURRENT_TIME
public static final String CURRENT_TIME
- See Also:
- Constant Field Values
-
WEEK_ISO
public static final String WEEK_ISO
- See Also:
- Constant Field Values
-
DATE_NAME
public static final String DATE_NAME
- See Also:
- Constant Field Values
-
DATEDIFF
public static final String DATEDIFF
- See Also:
- Constant Field Values
-
DAY
public static final String DAY
- See Also:
- Constant Field Values
-
GETDATE
public static final String GETDATE
- See Also:
- Constant Field Values
-
GETUTCDATE
public static final String GETUTCDATE
- See Also:
- Constant Field Values
-
ISFINITE
public static final String ISFINITE
- See Also:
- Constant Field Values
-
LOCALTIME
public static final String LOCALTIME
- See Also:
- Constant Field Values
-
LOCALTIMESTAMP
public static final String LOCALTIMESTAMP
- See Also:
- Constant Field Values
-
MONTHS_BETWEEN
public static final String MONTHS_BETWEEN
- See Also:
- Constant Field Values
-
OVERLAPS
public static final String OVERLAPS
- See Also:
- Constant Field Values
-
TIMESTAMPDIFF
public static final String TIMESTAMPDIFF
- See Also:
- Constant Field Values
-
-
Method Detail
-
start
public void start() throws TranslatorException
Description copied from class:ExecutionFactory
Initialize the connector with supplied configuration- Overrides:
start
in classJDBCExecutionFactory
- 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 classJDBCExecutionFactory
- 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.
-
supportsCompareCriteriaEquals
public boolean supportsCompareCriteriaEquals()
Description copied from class:ExecutionFactory
Support indicates connector accepts criteria of form (element = constant)- Overrides:
supportsCompareCriteriaEquals
in classJDBCExecutionFactory
-
supportsInCriteria
public boolean supportsInCriteria()
Description copied from class:ExecutionFactory
Support indicates connector accepts criteria of form (element IN set)- Overrides:
supportsInCriteria
in classJDBCExecutionFactory
-
supportsIntersect
public boolean supportsIntersect()
Description copied from class:ExecutionFactory
Support indicates that the connector supports the INTERSECT of two queries.- Overrides:
supportsIntersect
in classExecutionFactory<DataSource,Connection>
-
translate
public List<?> translate(LanguageObject obj, ExecutionContext context)
Description copied from class:JDBCExecutionFactory
Return a List of translated parts (LanguageObject
s and Objects), or null if to rely on the default translation. Override with care.- Overrides:
translate
in classJDBCExecutionFactory
- Returns:
- list of translated parts
-
getDefaultNullOrder
public ExecutionFactory.NullOrder getDefaultNullOrder()
Description copied from class:ExecutionFactory
Returns the default null ordering- Overrides:
getDefaultNullOrder
in classJDBCExecutionFactory
- Returns:
- the
ExecutionFactory.NullOrder
-
-