public static enum SourceCapabilities.Capability extends Enum<SourceCapabilities.Capability>
Enum Constant and Description |
---|
ADVANCED_OLAP |
ARRAY_TYPE |
BATCHED_UPDATES |
BULK_UPDATE |
COLLATION_LOCALE |
COMMON_TABLE_EXPRESSIONS |
CONNECTOR_ID
The connector ID, which is used by the optimizer to determine when two models are bound to the same connector
|
CRITERIA_BETWEEN
Support indicates connector accepts criteria of form (element BETWEEN constant AND constant)
|
CRITERIA_COMPARE_EQ
Support indicates connector accepts criteria of form (element operator constant)
|
CRITERIA_COMPARE_ORDERED |
CRITERIA_COMPARE_ORDERED_EXCLUSIVE |
CRITERIA_EXISTS
Support indicates connector accepts the EXISTS criteria
|
CRITERIA_IN
Support indicates connector accepts criteria of form (element IN set)
|
CRITERIA_IN_SUBQUERY
Support indicates connector accepts IN criteria with a subquery on the right side
|
CRITERIA_IS_DISTINCT |
CRITERIA_ISNULL
Support indicates connector accepts criteria of form (element IS NULL)
|
CRITERIA_LIKE
Support indicates connector accepts criteria of form (element LIKE constant)
|
CRITERIA_LIKE_ESCAPE
Support indicates connector accepts criteria of form (element LIKE constant ESCAPE char) - CURRENTLY NOT USED
|
CRITERIA_LIKE_REGEX |
CRITERIA_NOT
Support indicates connector accepts logical criteria NOT
|
CRITERIA_ON_SUBQUERY |
CRITERIA_ONLY_LITERAL_COMPARE |
CRITERIA_OR
Support indicates connector accepts logical criteria connected by OR
|
CRITERIA_QUANTIFIED_ALL
Support indicates connector accepts the quantified comparison criteria that use ALL
|
CRITERIA_QUANTIFIED_SOME
Support indicates connector accepts the quantified comparison criteria that use SOME
|
CRITERIA_SIMILAR |
DEPENDENT_JOIN |
DEPENDENT_JOIN_BINDINGS |
ELEMENTARY_OLAP |
EXCLUDE_COMMON_TABLE_EXPRESSION_NAME |
FULL_DEPENDENT_JOIN |
GEOGRAPHY_TYPE |
INSERT_WITH_ITERATOR |
INSERT_WITH_QUERYEXPRESSION |
INVALID_EXCEPTION |
JOIN_CRITERIA_ALLOWED |
MAX_DEPENDENT_PREDICATES |
MAX_IN_CRITERIA_SIZE
The Maximum number of values allowed in an IN criteria (Integer)
|
MAX_QUERY_FROM_GROUPS
Max number of groups appearing in a from clause
|
MAX_QUERY_PROJECTED_COLUMNS
Max number of columns appearing in a select clause
|
NO_PROJECTION |
ONLY_FORMAT_LITERALS |
ONLY_TIMESTAMPADD_LITERAL |
PARTIAL_FILTERS |
QUERY_AGGREGATES
Composite support for group by and having - not
used by the connector layer
|
QUERY_AGGREGATES_ARRAY |
QUERY_AGGREGATES_AVG
Support indicates connector can accept the AVG aggregate function
|
QUERY_AGGREGATES_COUNT
Support indicates connector can accept the COUNT aggregate function
|
QUERY_AGGREGATES_COUNT_BIG |
QUERY_AGGREGATES_COUNT_STAR
Support indicates connector can accept the COUNT(*) aggregate function
|
QUERY_AGGREGATES_DISTINCT
Support indicates connector can accept DISTINCT within aggregate functions
|
QUERY_AGGREGATES_ENHANCED_NUMERIC
Support indicates connector can accept the enhanced numeric aggregates
|
QUERY_AGGREGATES_LIST |
QUERY_AGGREGATES_MAX
Support indicates connector can accept the MAX aggregate function
|
QUERY_AGGREGATES_MIN
Support indicates connector can accept the MIN aggregate function
|
QUERY_AGGREGATES_STRING |
QUERY_AGGREGATES_SUM
Support indicates connector can accept the SUM aggregate function
|
QUERY_CASE
Support indicates connector can accept queries with non-searched CASE
|
QUERY_EXCEPT
Support indicates connector can accept EXCEPT
|
QUERY_FROM_ANSI_JOIN
Indicates that the source prefers ANSI style joins
|
QUERY_FROM_GROUP_ALIAS
Support indicates connector can accept joins where groups have aliases (required for QUERY_FROM_JOIN_SELFJOIN)
|
QUERY_FROM_INLINE_VIEWS
Support indicates connector can push down inline views
|
QUERY_FROM_JOIN_INNER
Support indicates connector can accept inner joins
|
QUERY_FROM_JOIN_LATERAL |
QUERY_FROM_JOIN_LATERAL_CONDITION |
QUERY_FROM_JOIN_OUTER
Support indicates connector can accept right or left outer joins
|
QUERY_FROM_JOIN_OUTER_FULL
Support indicates connector can accept full outer joins
|
QUERY_FROM_JOIN_SELFJOIN
Support indicates connector can accept self-joins where a group is joined to itself with aliases
|
QUERY_FROM_PROCEDURE_TABLE |
QUERY_FUNCTIONS_IN_GROUP_BY
Support indicates connector can accept GROUP BY with functions in it.
|
QUERY_GROUP_BY |
QUERY_GROUP_BY_MULTIPLE_DISTINCT_AGGREGATES |
QUERY_GROUP_BY_ROLLUP |
QUERY_HAVING |
QUERY_INTERSECT
Support indicates connector can accept INTERSECT
|
QUERY_ONLY_FROM_JOIN_LATERAL_PROCEDURE |
QUERY_ONLY_SINGLE_TABLE_GROUP_BY |
QUERY_ORDERBY
Support indicates connector accepts ORDER BY clause
|
QUERY_ORDERBY_DEFAULT_NULL_ORDER |
QUERY_ORDERBY_EXTENDED_GROUPING |
QUERY_ORDERBY_NULL_ORDERING |
QUERY_ORDERBY_UNRELATED |
QUERY_SEARCHED_CASE
Support indicates connector can accept queries with searched CASE WHEN
|
QUERY_SELECT_DISTINCT
Support indicates connector can accept queries with SELECT DISTINCT
|
QUERY_SELECT_EXPRESSION
Support indicates connector can accept queries non-elements in the SELECT
|
QUERY_SELECT_EXPRESSION_ARRAY_TYPE |
QUERY_SET_LIMIT_OFFSET |
QUERY_SET_ORDER_BY
Support indicates connector can accept SET QUERY with an ORDER BY clause
|
QUERY_SUBQUERIES_CORRELATED
Support indicates connector can accept correalted subqueries wherever subqueries are accepted
|
QUERY_SUBQUERIES_ONLY_CORRELATED |
QUERY_SUBQUERIES_SCALAR
Support indicates connector can accept scalar subqueries in the SELECT, WHERE, and HAVING clauses
|
QUERY_SUBQUERIES_SCALAR_PROJECTION |
QUERY_UNION
Support indicates connector can accept UNION and UNION ALL
|
QUERY_WINDOW_FUNCTION_CUME_DIST |
QUERY_WINDOW_FUNCTION_NTH_VALUE |
QUERY_WINDOW_FUNCTION_NTILE |
QUERY_WINDOW_FUNCTION_PERCENT_RANK |
RECURSIVE_COMMON_TABLE_EXPRESSIONS |
REQUIRED_LIKE_ESCAPE |
REQUIRES_CRITERIA |
ROW_LIMIT
Support indicates connector can limit result rows
|
ROW_OFFSET
Support indicates connector support a SQL clause whose output rows offset from the query's result rows (similar to
LIMIT with offset)
|
SELECT_WITHOUT_FROM |
SUBQUERY_COMMON_TABLE_EXPRESSIONS |
SUBQUERY_CORRELATED_LIMIT |
TRANSACTION_SUPPORT |
UPSERT |
WINDOW_FUNCTION_DISTINCT_AGGREGATES |
WINDOW_FUNCTION_FRAME_CLAUSE |
WINDOW_FUNCTION_ORDER_BY_AGGREGATES |
Modifier and Type | Method and Description |
---|---|
String |
toString() |
static SourceCapabilities.Capability |
valueOf(String name)
Returns the enum constant of this type with the specified name.
|
static SourceCapabilities.Capability[] |
values()
Returns an array containing the constants of this enum type, in
the order they are declared.
|
public static final SourceCapabilities.Capability QUERY_SELECT_DISTINCT
public static final SourceCapabilities.Capability QUERY_SELECT_EXPRESSION
public static final SourceCapabilities.Capability QUERY_FROM_GROUP_ALIAS
public static final SourceCapabilities.Capability MAX_QUERY_FROM_GROUPS
public static final SourceCapabilities.Capability MAX_QUERY_PROJECTED_COLUMNS
public static final SourceCapabilities.Capability JOIN_CRITERIA_ALLOWED
public static final SourceCapabilities.Capability QUERY_FROM_JOIN_INNER
public static final SourceCapabilities.Capability QUERY_FROM_ANSI_JOIN
public static final SourceCapabilities.Capability QUERY_FROM_JOIN_SELFJOIN
public static final SourceCapabilities.Capability QUERY_FROM_JOIN_OUTER
public static final SourceCapabilities.Capability QUERY_FROM_INLINE_VIEWS
public static final SourceCapabilities.Capability QUERY_FROM_JOIN_OUTER_FULL
public static final SourceCapabilities.Capability CRITERIA_BETWEEN
public static final SourceCapabilities.Capability CRITERIA_COMPARE_EQ
public static final SourceCapabilities.Capability CRITERIA_COMPARE_ORDERED
public static final SourceCapabilities.Capability CRITERIA_IS_DISTINCT
public static final SourceCapabilities.Capability CRITERIA_LIKE
public static final SourceCapabilities.Capability CRITERIA_LIKE_ESCAPE
public static final SourceCapabilities.Capability CRITERIA_IN
public static final SourceCapabilities.Capability CRITERIA_IN_SUBQUERY
public static final SourceCapabilities.Capability CRITERIA_ISNULL
public static final SourceCapabilities.Capability CRITERIA_OR
public static final SourceCapabilities.Capability CRITERIA_NOT
public static final SourceCapabilities.Capability CRITERIA_EXISTS
public static final SourceCapabilities.Capability CRITERIA_QUANTIFIED_SOME
public static final SourceCapabilities.Capability CRITERIA_QUANTIFIED_ALL
public static final SourceCapabilities.Capability CRITERIA_ONLY_LITERAL_COMPARE
public static final SourceCapabilities.Capability QUERY_ORDERBY
public static final SourceCapabilities.Capability QUERY_ORDERBY_UNRELATED
public static final SourceCapabilities.Capability QUERY_ORDERBY_NULL_ORDERING
public static final SourceCapabilities.Capability QUERY_ORDERBY_DEFAULT_NULL_ORDER
public static final SourceCapabilities.Capability QUERY_AGGREGATES
public static final SourceCapabilities.Capability QUERY_GROUP_BY
public static final SourceCapabilities.Capability QUERY_HAVING
public static final SourceCapabilities.Capability QUERY_AGGREGATES_SUM
public static final SourceCapabilities.Capability QUERY_AGGREGATES_AVG
public static final SourceCapabilities.Capability QUERY_AGGREGATES_MIN
public static final SourceCapabilities.Capability QUERY_AGGREGATES_MAX
public static final SourceCapabilities.Capability QUERY_AGGREGATES_ENHANCED_NUMERIC
public static final SourceCapabilities.Capability QUERY_AGGREGATES_COUNT
public static final SourceCapabilities.Capability QUERY_AGGREGATES_COUNT_STAR
public static final SourceCapabilities.Capability QUERY_AGGREGATES_DISTINCT
public static final SourceCapabilities.Capability QUERY_SUBQUERIES_SCALAR
public static final SourceCapabilities.Capability QUERY_SUBQUERIES_CORRELATED
public static final SourceCapabilities.Capability QUERY_CASE
public static final SourceCapabilities.Capability QUERY_SEARCHED_CASE
public static final SourceCapabilities.Capability QUERY_UNION
public static final SourceCapabilities.Capability QUERY_INTERSECT
public static final SourceCapabilities.Capability QUERY_EXCEPT
public static final SourceCapabilities.Capability QUERY_SET_ORDER_BY
public static final SourceCapabilities.Capability QUERY_SET_LIMIT_OFFSET
public static final SourceCapabilities.Capability QUERY_FUNCTIONS_IN_GROUP_BY
public static final SourceCapabilities.Capability BATCHED_UPDATES
public static final SourceCapabilities.Capability BULK_UPDATE
public static final SourceCapabilities.Capability ROW_LIMIT
public static final SourceCapabilities.Capability ROW_OFFSET
public static final SourceCapabilities.Capability MAX_IN_CRITERIA_SIZE
public static final SourceCapabilities.Capability CONNECTOR_ID
public static final SourceCapabilities.Capability REQUIRES_CRITERIA
public static final SourceCapabilities.Capability INSERT_WITH_QUERYEXPRESSION
public static final SourceCapabilities.Capability INSERT_WITH_ITERATOR
public static final SourceCapabilities.Capability COMMON_TABLE_EXPRESSIONS
public static final SourceCapabilities.Capability MAX_DEPENDENT_PREDICATES
public static final SourceCapabilities.Capability ADVANCED_OLAP
public static final SourceCapabilities.Capability QUERY_AGGREGATES_ARRAY
public static final SourceCapabilities.Capability ELEMENTARY_OLAP
public static final SourceCapabilities.Capability WINDOW_FUNCTION_ORDER_BY_AGGREGATES
public static final SourceCapabilities.Capability CRITERIA_SIMILAR
public static final SourceCapabilities.Capability CRITERIA_LIKE_REGEX
public static final SourceCapabilities.Capability DEPENDENT_JOIN
public static final SourceCapabilities.Capability WINDOW_FUNCTION_DISTINCT_AGGREGATES
public static final SourceCapabilities.Capability QUERY_ONLY_SINGLE_TABLE_GROUP_BY
public static final SourceCapabilities.Capability ONLY_FORMAT_LITERALS
public static final SourceCapabilities.Capability CRITERIA_ON_SUBQUERY
public static final SourceCapabilities.Capability ARRAY_TYPE
public static final SourceCapabilities.Capability QUERY_SUBQUERIES_ONLY_CORRELATED
public static final SourceCapabilities.Capability QUERY_AGGREGATES_STRING
public static final SourceCapabilities.Capability FULL_DEPENDENT_JOIN
public static final SourceCapabilities.Capability SELECT_WITHOUT_FROM
public static final SourceCapabilities.Capability QUERY_GROUP_BY_ROLLUP
public static final SourceCapabilities.Capability QUERY_ORDERBY_EXTENDED_GROUPING
public static final SourceCapabilities.Capability INVALID_EXCEPTION
public static final SourceCapabilities.Capability COLLATION_LOCALE
public static final SourceCapabilities.Capability RECURSIVE_COMMON_TABLE_EXPRESSIONS
public static final SourceCapabilities.Capability EXCLUDE_COMMON_TABLE_EXPRESSION_NAME
public static final SourceCapabilities.Capability CRITERIA_COMPARE_ORDERED_EXCLUSIVE
public static final SourceCapabilities.Capability PARTIAL_FILTERS
public static final SourceCapabilities.Capability DEPENDENT_JOIN_BINDINGS
public static final SourceCapabilities.Capability SUBQUERY_COMMON_TABLE_EXPRESSIONS
public static final SourceCapabilities.Capability SUBQUERY_CORRELATED_LIMIT
public static final SourceCapabilities.Capability NO_PROJECTION
public static final SourceCapabilities.Capability REQUIRED_LIKE_ESCAPE
public static final SourceCapabilities.Capability QUERY_SUBQUERIES_SCALAR_PROJECTION
public static final SourceCapabilities.Capability TRANSACTION_SUPPORT
public static final SourceCapabilities.Capability QUERY_FROM_JOIN_LATERAL
public static final SourceCapabilities.Capability QUERY_FROM_JOIN_LATERAL_CONDITION
public static final SourceCapabilities.Capability QUERY_FROM_PROCEDURE_TABLE
public static final SourceCapabilities.Capability QUERY_GROUP_BY_MULTIPLE_DISTINCT_AGGREGATES
public static final SourceCapabilities.Capability UPSERT
public static final SourceCapabilities.Capability QUERY_SELECT_EXPRESSION_ARRAY_TYPE
public static final SourceCapabilities.Capability QUERY_ONLY_FROM_JOIN_LATERAL_PROCEDURE
public static final SourceCapabilities.Capability ONLY_TIMESTAMPADD_LITERAL
public static final SourceCapabilities.Capability QUERY_WINDOW_FUNCTION_NTILE
public static final SourceCapabilities.Capability QUERY_WINDOW_FUNCTION_PERCENT_RANK
public static final SourceCapabilities.Capability QUERY_WINDOW_FUNCTION_CUME_DIST
public static final SourceCapabilities.Capability QUERY_WINDOW_FUNCTION_NTH_VALUE
public static final SourceCapabilities.Capability WINDOW_FUNCTION_FRAME_CLAUSE
public static final SourceCapabilities.Capability QUERY_AGGREGATES_LIST
public static final SourceCapabilities.Capability QUERY_AGGREGATES_COUNT_BIG
public static final SourceCapabilities.Capability GEOGRAPHY_TYPE
public static SourceCapabilities.Capability[] values()
for (SourceCapabilities.Capability c : SourceCapabilities.Capability.values()) System.out.println(c);
public static SourceCapabilities.Capability valueOf(String name)
name
- the name of the enum constant to be returned.IllegalArgumentException
- if this enum type has no constant with the specified nameNullPointerException
- if the argument is nullpublic String toString()
toString
in class Enum<SourceCapabilities.Capability>
Copyright © 2019. All rights reserved.