Serializable
, Comparable<MainCapability>
public enum MainCapability extends Enum<MainCapability>
Enum Constant | Description |
---|---|
AGGREGATE_GROUP_BY_COLUMN |
Support aggregations with a group by clause consisting of columns.
|
AGGREGATE_GROUP_BY_EXPRESSION |
Support aggregations with a group by clause that contains expressions.
|
AGGREGATE_GROUP_BY_TUPLE |
Support aggregations with a group by clause with multiple group by columns or expressions.
|
AGGREGATE_HAVING |
Support aggregations with a having clause.
|
AGGREGATE_SINGLE_GROUP |
Support aggregations with a single group.
|
FILTER_EXPRESSIONS |
Support filter expressions.
|
JOIN |
Support for joins.
|
JOIN_CONDITION_ALL |
Support joins with any conditions.
|
JOIN_CONDITION_EQUI |
Support joins with equi-join conditions.
|
JOIN_TYPE_FULL_OUTER |
Support full outer joins.
|
JOIN_TYPE_INNER |
Support inner joins.
|
JOIN_TYPE_LEFT_OUTER |
Support left outer joins.
|
JOIN_TYPE_RIGHT_OUTER |
Support right outer joins.
|
LIMIT |
Support to limit the number of result rows.
|
LIMIT_WITH_OFFSET |
Support to limit the number of result rows including an offset.
|
ORDER_BY_COLUMN |
Support to order the result by columns.
|
ORDER_BY_EXPRESSION |
Support to order the result by expressions.
|
SELECTLIST_EXPRESSIONS |
Support expressions in the select list; Additional capabilities are required depending on the expression.
|
SELECTLIST_PROJECTION |
Support projections, i.e.
|
Modifier and Type | Method | Description |
---|---|---|
static MainCapability |
valueOf(String name) |
Returns the enum constant of this type with the specified name.
|
static MainCapability[] |
values() |
Returns an array containing the constants of this enum type, in
the order they are declared.
|
public static final MainCapability SELECTLIST_PROJECTION
Example: SELECT a FROM t;
public static final MainCapability SELECTLIST_EXPRESSIONS
Example: SELECT a+1, ucase(b) FROM t;
public static final MainCapability FILTER_EXPRESSIONS
Example: SELECT * FROM t WHERE a>2
public static final MainCapability AGGREGATE_SINGLE_GROUP
Example: SELECT min(a) FROM t;
public static final MainCapability AGGREGATE_GROUP_BY_COLUMN
Example: SELECT a, b, min(c) FROM t GROUP BY a, b;
public static final MainCapability AGGREGATE_GROUP_BY_EXPRESSION
Example: SELECT a+1, min(b) FROM t GROUP BY a+1;
public static final MainCapability AGGREGATE_GROUP_BY_TUPLE
Example: SELECT a, b, min(c) FROM t GROUP BY a, b;
public static final MainCapability AGGREGATE_HAVING
Example: SELECT a, min(b) FROM t GROUP BY a HAVING min(b)>10;
public static final MainCapability ORDER_BY_COLUMN
Attention: This includes the capability to specify NULLS FIRST/LAST and ASC/DESC.
Example: SELECT a, b FROM t ORDER BY a, b DESC NULLS FIRST;
public static final MainCapability ORDER_BY_EXPRESSION
Attention: This includes the capability to specify NULLS FIRST/LAST and ASC/DESC
Example: SELECT a FROM t ORDER BY abs(a) ASC NULLS LAST;
public static final MainCapability LIMIT
Example: SELECT * FROM t 0
public static final MainCapability LIMIT_WITH_OFFSET
Example: SELECT * FROM t LIMIT 100 OFFSET 10;
public static final MainCapability JOIN
Attention: In order to generate joins in the push-down you additionally have to return at least one capability for join type and join condition.
public static final MainCapability JOIN_TYPE_INNER
Example: SELECT * FROM t INNER JOIN u ON t.id = u.id
public static final MainCapability JOIN_TYPE_LEFT_OUTER
Example: SELECT * FROM t LEFT OUTER JOIN u ON t.id = u.id
public static final MainCapability JOIN_TYPE_RIGHT_OUTER
Example: SELECT * FROM t RIGHT OUTER JOIN u ON t.id = u.id
public static final MainCapability JOIN_TYPE_FULL_OUTER
Example: SELECT * FROM t FULL OUTER JOIN u ON t.id = u.id
public static final MainCapability JOIN_CONDITION_EQUI
Example: SELECT * FROM t INNER JOIN u ON t.id = u.id
SELECT * FROM t INNER JOIN u ON t.id = u.id + 3
public static final MainCapability JOIN_CONDITION_ALL
Example: SELECT * FROM t INNER JOIN u ON t.x between(u.x, u.y)
public static MainCapability[] values()
for (MainCapability c : MainCapability.values()) System.out.println(c);
public static MainCapability 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 nullCopyright © 2019. All rights reserved.