org.teiid.translator.jdbc.vertica

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 and 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

Constructor Summary

Constructors

Constructor and Description
VerticaExecutionFactory()

Method Summary

Modifier and Type	Method and Description
List<String>	getSupportedFunctions() Get list of all supported function names.
void	start() Initialize the connector with supplied configuration
boolean	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 (LanguageObjects 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, getDefaultNullOrder, getDefaultSupportedFunctions, getDialect, getFunctionModifiers, getHibernateDialectClassName, getLateralKeyword, getLikeRegexString, getMaxPreparedInsertBatchSize, getMetadata, getMetadataProcessor, getRemovePushdownCharacters, getSetOperationString, getSourceComment, getSQLConversionVisitor, getStructRetrieval, getTemporaryTableName, getTimestampNanoPrecision, getVersion, hasTimeType, initCapabilities, intializeConnectionAfterCancel, isEnableDependentJoins, isSourceRequired, isSourceRequiredForCapabilities, isTrimStrings, loadedTemporaryTable, obtainedConnection, parseName, registerFunctionModifier, registerSpecificTypeOfOutParameter, replaceElementName, 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, supportsQuantifiedCompareCriteriaAll, supportsQuantifiedCompareCriteriaSome, supportsScalarSubqueries, supportsSearchedCaseExpressions, supportsSelectExpression, supportsSelfJoins, supportsSetQueryOrderBy, supportsUnions, tempTableRequiresTransaction, translateCommand, 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, 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, supportsAggregatesEnhancedNumeric, supportsArrayAgg, supportsArrayType, supportsCommonTableExpressions, supportsCompareCriteriaOrderedExclusive, supportsConvert, supportsCorrelatedSubqueryLimit, supportsDirectQueryProcedure, supportsElementaryOlapOperations, supportsExcept, supportsFormatLiteral, supportsFullOuterJoins, supportsFunctionsInGroupBy, supportsGroupByMultipleDistinctAggregates, supportsGroupByRollup, supportsInnerJoins, supportsIsDistinctCriteria, supportsLateralJoin, supportsLateralJoinCondition, supportsLikeRegex, supportsNativeQueries, supportsOnlyCorrelatedSubqueries, supportsOnlyFormatLiterals, supportsOnlyLateralJoinProcedure, supportsOnlyLiteralComparison, supportsOnlySingleTableGroupBy, supportsOrderBy, supportsOrderByNullOrdering, supportsOrderByWithExtendedGrouping, supportsOuterJoins, supportsPartialFiltering, supportsProcedureTable, supportsRecursiveCommonTableExpressions, supportsRowLimit, supportsRowOffset, supportsScalarSubqueryProjection, supportsSelectDistinct, supportsSelectExpressionArrayType, supportsSelectWithoutFrom, supportsSetQueryLimitOffset, supportsSimilarTo, supportsStringAgg, supportsSubqueryCommonTableExpressions, supportsSubqueryInOn, supportsUpsert, supportsWindowDistinctAggregates, supportsWindowOrderByWithAggregates, useAnsiJoin

Methods inherited from class java.lang.Object

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

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

Constructor Detail

VerticaExecutionFactory

public VerticaExecutionFactory()

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.

supportsCompareCriteriaEquals

public boolean supportsCompareCriteriaEquals()

Description copied from class: ExecutionFactory

Support indicates connector accepts criteria of form (element = constant)

Overrides:

supportsCompareCriteriaEquals in class JDBCExecutionFactory

supportsInCriteria

public boolean supportsInCriteria()

Description copied from class: ExecutionFactory

Support indicates connector accepts criteria of form (element IN set)

Overrides:

supportsInCriteria 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>

translate

public List<?> translate(LanguageObject obj,
                         ExecutionContext context)

Description copied from class: JDBCExecutionFactory

Return a List of translated parts (LanguageObjects and Objects), or null if to rely on the default translation. Override with care.

Overrides:

translate in class JDBCExecutionFactory

Returns:

list of translated parts