com.snowflake.snowpark_java

Class CaseExpr

java.lang.Object

com.snowflake.snowpark_java.Column

com.snowflake.snowpark_java.CaseExpr

public class CaseExpr
extends Column

Represents a CASE expression.

To construct this object for a CASE expression, call the com.snowflake.snowpark_java.Functions.when. specifying a condition and the corresponding result for that condition. Then, call the when and otherwise methods to specify additional conditions and results.

Since:

0.12.0

Method Summary

Modifier and Type	Method and Description
Column	otherwise(Column value) Sets the default result for this CASE expression.
CaseExpr	when(Column condition, Column value) Appends one more WHEN condition to the CASE expression.

Methods inherited from class com.snowflake.snowpark_java.Column

alias, and, as, asc_nulls_first, asc_nulls_last, asc, between, bitand, bitor, bitxor, cast, collate, desc_nulls_first, desc_nulls_last, desc, divide, equal_nan, equal_null, equal_to, geq, getName, gt, in, in, is_not_null, is_null, leq, like, lt, minus, mod, multiply, not_equal, or, over, over, plus, regexp, subField, subField, toString, unary_minus, unary_not, withinGroup

Methods inherited from class java.lang.Object

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

Method Detail

when

public CaseExpr when(Column condition,
                     Column value)

Appends one more WHEN condition to the CASE expression.

Parameters:

condition - The case condition

value - The result value in the given condition

Returns:

The result case expression

Since:

0.12.0

otherwise

public Column otherwise(Column value)

Sets the default result for this CASE expression.

Parameters:

value - The default value

Returns:

The result column

Since:

0.12.0