public interface ImplicitExpressionOperations
Expression
AST for expression
operations.
These operations must be kept in sync with the parser in
ExpressionParser
.
Modifier and Type | Method and Description |
---|---|
Abs |
abs()
Calculates the absolute value of given one.
|
Alias |
as(scala.Symbol name) |
Asc |
asc() |
Avg |
avg() |
Cast |
cast(TypeInformation<?> toType) |
Ceil |
ceil()
Calculates the smallest integer greater than or equal to a given number.
|
CharLength |
charLength()
Returns the length of a String.
|
Count |
count() |
Desc |
desc() |
Exp |
exp()
Calculates the Euler's number raised to the given power.
|
Expression |
expr() |
Floor |
floor()
Calculates the largest integer less than or equal to a given number.
|
InitCap |
initCap()
Converts the initial letter of each word in a String to uppercase.
|
IsNotNull |
isNotNull() |
IsNull |
isNull() |
Like |
like(Expression pattern)
Returns true, if a String matches the specified LIKE pattern.
|
Ln |
ln()
Calculates the natural logarithm of given value.
|
Log10 |
log10()
Calculates the base 10 logarithm of given value.
|
Lower |
lowerCase()
Returns all of the characters in a String in lower case using the rules of
the default locale.
|
Max |
max() |
Min |
min() |
Mod |
mod(Expression other)
Calculates the remainder of division the given number by another one.
|
Power |
power(Expression other)
Calculates the given number raised to the power of the other value.
|
Similar |
similar(Expression pattern)
Returns true, if a String matches the specified SQL regex pattern.
|
SubString |
substring(Expression beginIndex)
Creates a substring of the given string beginning at the given index to the end.
|
SubString |
substring(Expression beginIndex,
Expression endIndex)
Creates a substring of the given string between the given indices.
|
Sum |
sum() |
Cast |
toDate()
Parses a date String in the form "yy-mm-dd" to a SQL Date.
|
Expression |
toExpr()
Enables literals on left side of binary expressions.
|
Cast |
toTime()
Parses a time String in the form "hh:mm:ss" to a SQL Time.
|
Cast |
toTimestamp()
Parses a timestamp String in the form "yy-mm-dd hh:mm:ss.fff" to a SQL Timestamp.
|
Expression |
trim(boolean removeLeading,
boolean removeTrailing,
Expression character)
Removes leading and/or trailing characters from the given string.
|
Upper |
upperCase()
Returns all of the characters in a String in upper case using the rules of
the default locale.
|
Expression expr()
Expression toExpr()
e.g. 12.toExpr % 'a
IsNull isNull()
IsNotNull isNotNull()
Sum sum()
Min min()
Max max()
Count count()
Avg avg()
Cast cast(TypeInformation<?> toType)
Alias as(scala.Symbol name)
Asc asc()
Desc desc()
Mod mod(Expression other)
Exp exp()
Log10 log10()
Ln ln()
Power power(Expression other)
Abs abs()
Floor floor()
Ceil ceil()
SubString substring(Expression beginIndex, Expression endIndex)
beginIndex
- first character of the substring (starting at 1, inclusive)endIndex
- last character of the substring (starting at 1, inclusive)SubString substring(Expression beginIndex)
beginIndex
- first character of the substring (starting at 1, inclusive)Expression trim(boolean removeLeading, boolean removeTrailing, Expression character)
removeLeading
- if true, remove leading characters (default: true)removeTrailing
- if true, remove trailing characters (default: true)character
- String containing the character (default: " ")CharLength charLength()
Upper upperCase()
Lower lowerCase()
InitCap initCap()
Like like(Expression pattern)
e.g. "Jo_n%" matches all Strings that start with "Jo(arbitrary letter)n"
Similar similar(Expression pattern)
e.g. "A+" matches all Strings that consist of at least one A
Cast toDate()
Cast toTime()
Cast toTimestamp()
Copyright © 2014–2017 The Apache Software Foundation. All rights reserved.