public class ListFunctions extends Object
These functions accept list objects as input parameters.
Constructor and Description |
---|
ListFunctions() |
Modifier and Type | Method and Description |
---|---|
static ScalarValuedFunction |
listConcat(List<Object> leftValue,
ScalarValuedFunction rightExpr)
Builds an expression concatenating a the value of the specified field and subexpression.
|
static ScalarValuedFunction |
listConcat(List<Object> leftValue,
String rightField)
Builds an expression concatenating a constant to the value of the specified field.
|
static ScalarValuedFunction |
listConcat(ScalarValuedFunction leftExpr,
List<Object> rightValue)
Builds an expression concatenating a constant to the value of the specified subexpression.
|
static ScalarValuedFunction |
listConcat(ScalarValuedFunction leftExpr,
ScalarValuedFunction rightExpr)
Builds an expression concatenating the values of the two specified subexpressions.
|
static ScalarValuedFunction |
listConcat(ScalarValuedFunction leftExpr,
String rightField)
Builds an expression concatenating a the value of the specified field and subexpression.
|
static ScalarValuedFunction |
listConcat(String leftField,
List<Object> rightValue)
Builds an expression concatenating a constant to the value of the specified field.
|
static ScalarValuedFunction |
listConcat(String leftField,
ScalarValuedFunction rightExpr)
Builds an expression concatenating the value of a specified field and subexpression.
|
static ScalarValuedFunction |
listConcat(String leftField,
String rightField)
Builds an expression concatenating the values of the two specified
fields.
|
static ScalarValuedFunction |
listContains(List<Object> leftValue,
ScalarValuedFunction rightExpr)
Builds an expression to check if a constant contains a value specified by an expression.
|
static ScalarValuedFunction |
listContains(List<Object> leftValue,
String rightField)
Builds an expression to check if a constant contains a value specified by other field.
|
static ScalarValuedFunction |
listContains(ScalarValuedFunction expr,
List<Object> value)
Builds an expression to check if an expression contains a value specified by a field.
|
static ScalarValuedFunction |
listContains(ScalarValuedFunction leftExpr,
ScalarValuedFunction rightExpr)
Builds an expression to check if an expression contains a value specified by a ScalarValuedFunction.
|
static ScalarValuedFunction |
listContains(ScalarValuedFunction leftExpr,
String rightField)
Builds an expression to check if an expression contains a value specified by a field.
|
static ScalarValuedFunction |
listContains(String field,
List<Object> value)
Builds an expression to check if a field contains a value specified by an expression.
|
static ScalarValuedFunction |
listContains(String leftField,
ScalarValuedFunction rightExpr)
Builds an expression to check if a field contains a value specified by an expression.
|
static ScalarValuedFunction |
listContains(String leftField,
String rightField)
Builds an expression to check if a field contains a value specified by the other field.
|
static ScalarValuedFunction |
listContainsAll(List<Object> leftValue,
ScalarValuedFunction rightExpr)
Builds an expression to check if a constant contains a value specified by an expression.
|
static ScalarValuedFunction |
listContainsAll(List<Object> leftValue,
String rightField)
Builds an expression to check if a constant contains a value specified by other field.
|
static ScalarValuedFunction |
listContainsAll(ScalarValuedFunction expr,
List<Object> value)
Builds an expression to check if an expression contains a value specified by a field.
|
static ScalarValuedFunction |
listContainsAll(ScalarValuedFunction leftExpr,
ScalarValuedFunction rightExpr)
Builds an expression to check if an expression contains a value specified by a ScalarValuedFunction.
|
static ScalarValuedFunction |
listContainsAll(ScalarValuedFunction leftExpr,
String rightField)
Builds an expression to check if an expression contains a value specified by a field.
|
static ScalarValuedFunction |
listContainsAll(String field,
List<Object> value)
Builds an expression to check if a field contains a value specified by an expression.
|
static ScalarValuedFunction |
listContainsAll(String leftField,
ScalarValuedFunction rightExpr)
Builds an expression to check if a field contains a value specified by an expression.
|
static ScalarValuedFunction |
listContainsAll(String leftField,
String rightField)
Builds an expression to check if a field contains a value specified by the other field.
|
static ScalarValuedFunction |
listDistinct(ScalarValuedFunction expr)
Builds an expression to get distinct set of elements from a ScalarValuedFunction.
|
static ScalarValuedFunction |
listDistinct(String field)
Builds an expression to get distinct set of elements from a specified field.
|
static ScalarValuedFunction |
listGet(List<Object> leftValue,
ScalarValuedFunction rightExpr)
Builds an expression to get the value at a particular index from specified field.
|
static ScalarValuedFunction |
listGet(List<Object> leftValue,
String rightField)
Builds an expression to get the value at a particular index from specified field.
|
static ScalarValuedFunction |
listGet(ScalarValuedFunction leftExpr,
int rightValue)
Builds an expression to get the value at a particular index from specified field.
|
static ScalarValuedFunction |
listGet(ScalarValuedFunction leftExpr,
ScalarValuedFunction rightExpr)
Builds an expression to get the value at a particular index from specified expression.
|
static ScalarValuedFunction |
listGet(ScalarValuedFunction leftExpr,
String rightField)
Builds an expression to get the value at a particular index from specified field.
|
static ScalarValuedFunction |
listGet(String leftField,
int rightValue)
Builds an expression to get the value at a particular index from specified field.
|
static ScalarValuedFunction |
listGet(String leftField,
ScalarValuedFunction rightExpr)
Builds an expression to get the value at a particular index from specified field.
|
static ScalarValuedFunction |
listGet(String leftField,
String rightField)
Builds an expression to get the value at a particular index from specified field.
|
static ScalarValuedFunction |
listReverse(ScalarValuedFunction expr)
Builds an expression to reverse the order of the elements in the specified expression.
|
static ScalarValuedFunction |
listReverse(String field)
Builds an expression to reverse the order of the elements in the specified field.
|
static ScalarValuedFunction |
listSize(ScalarValuedFunction expr)
Builds an expression to get the number of elements in specified ScalarValuedFunction expression.
|
static ScalarValuedFunction |
listSize(String field)
Builds an expression to get the number of elements in specified field.
|
static ScalarValuedFunction |
listSort(List<Object> leftValue,
ScalarValuedFunction rightExpr)
Builds an expression to sort elements of a constant as specified by a ScalarValuedFunction.
|
static ScalarValuedFunction |
listSort(List<Object> leftValue,
String rightField)
Builds an expression to sort elements of a constant as specified by the other.
|
static ScalarValuedFunction |
listSort(ScalarValuedFunction leftExpr,
ScalarValuedFunction rightExpr)
Builds an expression to sort elements of a ScalarValuedFunction as specified by the other.
|
static ScalarValuedFunction |
listSort(ScalarValuedFunction leftExpr,
String rightField)
Builds an expression to sort elements of a ScalarValuedFunction as specified by a field.
|
static ScalarValuedFunction |
listSort(String leftField,
ScalarValuedFunction rightExpr)
Builds an expression to sort elements of a field as specified by a ScalarValuedFunction.
|
static ScalarValuedFunction |
listSort(String leftField,
String rightField)
Builds an expression to sort elements of a field as specified by the other.
|
static ScalarValuedFunction |
listToString(ScalarValuedFunction expr)
Builds an expression to get the string representation of a ScalarValuedFunction.
|
static ScalarValuedFunction |
listToString(String field)
Builds an expression to get the string representation of a specified field.
|
static ScalarValuedFunction |
subList(List<Object> value,
ScalarValuedFunction fromIndexExpr,
ScalarValuedFunction toIndexExpr)
Builds an expression finding a view of the portion of the field between the specified
fromIndex, inclusive, and toIndex, exclusive.
|
static ScalarValuedFunction |
subList(List<Object> value,
String fromIndexField,
String toIndexField)
Builds an expression finding a view of the portion of the field between the specified
fromIndex, inclusive, and toIndex, exclusive.
|
static ScalarValuedFunction |
subList(ScalarValuedFunction expr,
int fromIndexValue,
int toIndexValue)
Builds an expression finding a view of the portion of the field between the specified
fromIndex, inclusive, and toIndex, exclusive.
|
static ScalarValuedFunction |
subList(ScalarValuedFunction expr,
ScalarValuedFunction fromIndexExpr,
ScalarValuedFunction toIndexExpr)
Builds an expression finding a view of the portion of a ScalarValuedFunction
between the specified fromIndex, inclusive, and toIndex, exclusive.
|
static ScalarValuedFunction |
subList(ScalarValuedFunction expr,
String fromIndexField,
String toIndexField)
Builds an expression finding a view of the portion of the field between the specified
fromIndex, inclusive, and toIndex, exclusive.
|
static ScalarValuedFunction |
subList(String field,
int fromIndexValue,
int toIndexValue)
Builds an expression finding a view of the portion of the field between the specified
fromIndex, inclusive, and toIndex, exclusive.
|
static ScalarValuedFunction |
subList(String field,
ScalarValuedFunction fromIndexExpr,
ScalarValuedFunction toIndexExpr)
Builds an expression finding a view of the portion of the field between the specified
fromIndex, inclusive, and toIndex, exclusive.
|
static ScalarValuedFunction |
subList(String field,
String fromIndexField,
String toIndexField)
Builds an expression finding a view of the portion of the field between the specified
fromIndex, inclusive, and toIndex, exclusive.
|
public static ScalarValuedFunction listConcat(String leftField, String rightField)
null
, the result is null
.leftField
- the record field value on the left side of concatenationrightField
- the record field value on the right side of concatenationpublic static ScalarValuedFunction listConcat(String leftField, List<Object> rightValue)
null
, the result is null
.leftField
- the record field value on the left side of concatenationrightValue
- the constant value on the right side of concatenationpublic static ScalarValuedFunction listConcat(String leftField, ScalarValuedFunction rightExpr)
null
, the result is null
.leftField
- the record field value on the left side of concatenationrightExpr
- an expression on the right side of concatenationpublic static ScalarValuedFunction listConcat(List<Object> leftValue, String rightField)
null
, the result is null
.leftValue
- the constant value on the left side of concatenationrightField
- the record field value on the right side of concatenationpublic static ScalarValuedFunction listConcat(List<Object> leftValue, ScalarValuedFunction rightExpr)
null
, the result is null
.leftValue
- the constant value on the left side of concatenationrightExpr
- an expression on the right side of concatenationpublic static ScalarValuedFunction listConcat(ScalarValuedFunction leftExpr, String rightField)
null
, the result is null
.leftExpr
- an expression on the left side of concatenationrightField
- the record field value on the right side of concatenationpublic static ScalarValuedFunction listConcat(ScalarValuedFunction leftExpr, List<Object> rightValue)
null
, the result is null
.leftExpr
- an expression on the left side of concatenationrightValue
- the constant value on the right side of concatenationpublic static ScalarValuedFunction listConcat(ScalarValuedFunction leftExpr, ScalarValuedFunction rightExpr)
null
, the result is null
.leftExpr
- an expression on the left side of concatenationrightExpr
- an expression on the right side of concatenationpublic static ScalarValuedFunction listGet(String leftField, String rightField)
null
, the result is null
.leftField
- the record field value on the left side of listGetrightField
- the record field value on the right side of listGetpublic static ScalarValuedFunction listGet(String leftField, int rightValue)
null
, the result is null
.leftField
- the record field value on the left side of listGetrightValue
- the constant value on the right side of listGetpublic static ScalarValuedFunction listGet(String leftField, ScalarValuedFunction rightExpr)
null
, the result is null
.leftField
- the record field value on the left side of listGetrightExpr
- an expression on the right side of listGetpublic static ScalarValuedFunction listGet(List<Object> leftValue, String rightField)
null
, the result is null
.leftValue
- the constant value on the left side of listGetrightField
- the record field value on the right side of listGetpublic static ScalarValuedFunction listGet(List<Object> leftValue, ScalarValuedFunction rightExpr)
null
, the result is null
.leftValue
- the constant value on the left side of listGetrightExpr
- an expression on the right side of listGetpublic static ScalarValuedFunction listGet(ScalarValuedFunction leftExpr, String rightField)
null
, the result is null
.leftExpr
- an expression on the left side of listGetrightField
- the record field value on the right side of listGetpublic static ScalarValuedFunction listGet(ScalarValuedFunction leftExpr, int rightValue)
null
, the result is null
.leftExpr
- an expression on the left side of listGetrightValue
- the constant value on the right side of listGetpublic static ScalarValuedFunction listGet(ScalarValuedFunction leftExpr, ScalarValuedFunction rightExpr)
null
, the result is null
.leftExpr
- an expression on the left side of listGetrightExpr
- an expression on the right side of listGetpublic static ScalarValuedFunction listSize(String field)
null
, the result is null
.field
- the record field valuepublic static ScalarValuedFunction listSize(ScalarValuedFunction expr)
null
, the result is null
.expr
- the ScalarValuedFunction expressionpublic static ScalarValuedFunction listToString(String field)
null
, the result is null
.field
- the record field valuepublic static ScalarValuedFunction listToString(ScalarValuedFunction expr)
null
, the result is null
.expr
- the ScalarValuedFunction expressionpublic static ScalarValuedFunction listContains(String leftField, String rightField)
null
, the result is null
.leftField
- the record field value on the left side of listContainsrightField
- the record field value on the right side of listContainspublic static ScalarValuedFunction listContains(String field, List<Object> value)
null
, the result is null
.field
- the record field value on the left side of listContainsvalue
- the constant value on the right side of listContainspublic static ScalarValuedFunction listContains(String leftField, ScalarValuedFunction rightExpr)
null
, the result is null
.leftField
- the record field value on the left side of listContainsrightExpr
- an expression on the right side of listContainspublic static ScalarValuedFunction listContains(List<Object> leftValue, String rightField)
null
, the result is null
.leftValue
- the constant value on the left side of listContainsrightField
- the record field value on the right side of listContainspublic static ScalarValuedFunction listContains(List<Object> leftValue, ScalarValuedFunction rightExpr)
null
, the result is null
.leftValue
- the constant value on the left side of listContainsrightExpr
- an expression on the right side of listContainspublic static ScalarValuedFunction listContains(ScalarValuedFunction leftExpr, String rightField)
null
, the result is null
.leftExpr
- an expression on the left side of listContainsrightField
- the record field value on the right side of listContainspublic static ScalarValuedFunction listContains(ScalarValuedFunction expr, List<Object> value)
null
, the result is null
.expr
- an expression on the left side of listContainsvalue
- the constant value on the right side of listContainspublic static ScalarValuedFunction listContains(ScalarValuedFunction leftExpr, ScalarValuedFunction rightExpr)
null
, the result is null
.leftExpr
- an expression on the left side of listContainsrightExpr
- an expression on the right side of listContainspublic static ScalarValuedFunction listContainsAll(String leftField, String rightField)
null
, the result is null
.leftField
- the record field value on the left side of listContainsAllrightField
- the record field value on the right side of listContainsAllpublic static ScalarValuedFunction listContainsAll(String field, List<Object> value)
null
, the result is null
.field
- the record field value on the left side of listContainsAllvalue
- the constant value on the right side of listContainsAllpublic static ScalarValuedFunction listContainsAll(String leftField, ScalarValuedFunction rightExpr)
null
, the result is null
.leftField
- the record field value on the left side of listContainsAllrightExpr
- an expression on the right side of listContainsAllpublic static ScalarValuedFunction listContainsAll(List<Object> leftValue, String rightField)
null
, the result is null
.leftValue
- the constant value on the left side of listContainsAllrightField
- the record field value on the right side of listContainsAllpublic static ScalarValuedFunction listContainsAll(List<Object> leftValue, ScalarValuedFunction rightExpr)
null
, the result is null
.leftValue
- the constant value on the left side of listContainsAllrightExpr
- an expression on the right side of listContainsAllpublic static ScalarValuedFunction listContainsAll(ScalarValuedFunction leftExpr, String rightField)
null
, the result is null
.leftExpr
- an expression on the left side of listContainsAllrightField
- the record field value on the right side of listContainsAllpublic static ScalarValuedFunction listContainsAll(ScalarValuedFunction expr, List<Object> value)
null
, the result is null
.expr
- an expression on the left side of listContainsAllvalue
- the constant value on the right side of listContainsAllpublic static ScalarValuedFunction listContainsAll(ScalarValuedFunction leftExpr, ScalarValuedFunction rightExpr)
null
, the result is null
.leftExpr
- an expression on the left side of listContainsAllrightExpr
- an expression on the right side of listContainsAllpublic static ScalarValuedFunction listDistinct(String field)
null
, the result is null
.field
- the record field valuepublic static ScalarValuedFunction listDistinct(ScalarValuedFunction expr)
null
, the result is null
.expr
- the ScalarValuedFunction expressionpublic static ScalarValuedFunction listReverse(String field)
null
, the result is null
.field
- the record field valuepublic static ScalarValuedFunction listReverse(ScalarValuedFunction expr)
null
, the result is null
.expr
- the ScalarValuedFunction expressionpublic static ScalarValuedFunction listSort(String leftField, String rightField)
null
, the result is null
.
If the field for sort order is null
, elements are sorted in ASCENDING order.leftField
- the record field value on the left side of sortrightField
- the record field value on the right side of sortpublic static ScalarValuedFunction listSort(String leftField, ScalarValuedFunction rightExpr)
null
, the result is null
.
If an expression for sort order evaluates to null
, elements are sorted in ASCENDING order.leftField
- the record field value on the left side of sortrightExpr
- the ScalarValuedFunction expression on the right side of sortpublic static ScalarValuedFunction listSort(List<Object> leftValue, String rightField)
null
, the result is null
.
If the field for sort order is null
, elements are sorted in ASCENDING order.leftValue
- the constant value on the left side of sortrightField
- the record field value on the right side of sortpublic static ScalarValuedFunction listSort(List<Object> leftValue, ScalarValuedFunction rightExpr)
null
, the result is null
.
If an expression for sort order is null
, elements are sorted in ASCENDING order.leftValue
- the constant value on the left side of sortrightExpr
- the ScalarValuedFunction expression on the right side of sortpublic static ScalarValuedFunction listSort(ScalarValuedFunction leftExpr, String rightField)
null
, the result is null
.
If the field for sort order is null
, elements are sorted in ASCENDING order.leftExpr
- the ScalarValuedFunction expression on the left side of sortrightField
- the record field value on the right side of sortpublic static ScalarValuedFunction listSort(ScalarValuedFunction leftExpr, ScalarValuedFunction rightExpr)
null
, the result is null
.
If an expression for sort order is null
, elements are sorted in ASCENDING order.leftExpr
- the ScalarValuedFunction on the left side of sortrightExpr
- the ScalarValuedFunction on the right side of sortpublic static ScalarValuedFunction subList(String field, String fromIndexField, String toIndexField)
null
, the result is null
.
fromIndex and toIndex should never be null.field
- the record field valuefromIndexField
- the record field value representing low endpoint (inclusive) of the subListtoIndexField
- the record field value representing high endpoint (exclusive) of the subListpublic static ScalarValuedFunction subList(String field, int fromIndexValue, int toIndexValue)
null
, the result is null
.
fromIndex and toIndex should never be null.field
- the record field valuefromIndexValue
- the constant value representing low endpoint (inclusive) of the subListtoIndexValue
- the constant value representing high endpoint (exclusive) of the subListpublic static ScalarValuedFunction subList(String field, ScalarValuedFunction fromIndexExpr, ScalarValuedFunction toIndexExpr)
null
, the result is null
.
fromIndex and toIndex should never be null.field
- the record field valuefromIndexExpr
- an expression representing low endpoint (inclusive) of the subListtoIndexExpr
- an expression representing high endpoint (exclusive) of the subListpublic static ScalarValuedFunction subList(List<Object> value, String fromIndexField, String toIndexField)
null
, the result is null
.
fromIndex and toIndex should never be null.value
- the constant valuefromIndexField
- the record field value representing low endpoint (inclusive) of the subListtoIndexField
- the record field value representing high endpoint (exclusive) of the subListpublic static ScalarValuedFunction subList(List<Object> value, ScalarValuedFunction fromIndexExpr, ScalarValuedFunction toIndexExpr)
null
, the result is null
.
fromIndex and toIndex should never be null.value
- the constant valuefromIndexExpr
- an expression representing low endpoint (inclusive) of the subListtoIndexExpr
- an expression representing high endpoint (exclusive) of the subListpublic static ScalarValuedFunction subList(ScalarValuedFunction expr, String fromIndexField, String toIndexField)
null
, the result is null
.
fromIndex and toIndex should never be null.expr
- a ScalarValuedFunction expressionfromIndexField
- the record field value representing low endpoint (inclusive) of the subListtoIndexField
- the record field value representing high endpoint (exclusive) of the subListpublic static ScalarValuedFunction subList(ScalarValuedFunction expr, int fromIndexValue, int toIndexValue)
null
, the result is null
.
fromIndex and toIndex should never be null.expr
- a ScalarValuedFunction expressionfromIndexValue
- the constant value representing low endpoint (inclusive) of the subListtoIndexValue
- the constant value representing high endpoint (exclusive) of the subListpublic static ScalarValuedFunction subList(ScalarValuedFunction expr, ScalarValuedFunction fromIndexExpr, ScalarValuedFunction toIndexExpr)
null
, the result is null
.
fromIndex and toIndex should never be null.expr
- the ScalarValuedFunction expressionfromIndexExpr
- an expression representing low endpoint (inclusive) of the subListtoIndexExpr
- an expression representing high endpoint (exclusive) of the subListCopyright © 2024 Actian Corporation. All rights reserved.