Uses of Class
com.snowflake.snowpark_java.Column

Packages that use Column

Package	Description
com.snowflake.snowpark_java

Uses of Column in com.snowflake.snowpark_java

Methods in com.snowflake.snowpark_java that return Column

Modifier and Type	Method	Description
static Column	Functions.abs(Column column)
Column	Column.alias(String alias)
Column	Column.and(Column other)
Column	Column.as(String alias)
Column	Column.asc()
Column	Column.asc_nulls_first()
Column	Column.asc_nulls_last()
static Column	Functions.avg(Column column)
Column	Column.between(Column lower, Column upper)	BETWEEN, inclusive on both ends as in SQL.
Column	Column.bitand(Column other)
Column	Column.bitor(Column other)
Column	Column.bitxor(Column other)
static Column	Functions.callBuiltin(String functionName, Column... arguments)	Any built-in by name, so a function this class does not spell out is still reachable.
static Column	Functions.callUDF(String udfName, Column... arguments)	A user-defined function by name.
Column	Column.cast(DataType to)
static Column	Functions.ceil(Column column)
static Column	Functions.coalesce(Column... columns)
Column	DataFrame.col(String columnName)	A column of this frame, by name.
static Column	Functions.col(String name)
Column	Column.collate(String collationSpecification)
static Column	Functions.column(String name)
static Column	Functions.concat(Column... columns)
static Column	Functions.count(Column column)
static Column	Functions.count_distinct(Column... columns)
static Column	Functions.current_date()
static Column	Functions.current_timestamp()
Column	Column.desc()
Column	Column.desc_nulls_first()
Column	Column.desc_nulls_last()
Column	Column.divide(Column other)
Column	Column.equal_null(Column other)	NULL-safe equality — two NULLs compare equal, unlike =.
Column	Column.equal_to(Column other)
static Column	Functions.floor(Column column)
Column	Column.geq(Column other)
Column	Column.gt(Column other)
static Column	Functions.iff(Column condition, Column whenTrue, Column whenFalse)
Column	Column.in(Column... values)
Column	Column.is_not_null()
Column	Column.is_null()
Column	Column.isNull()	The real Column carries BOTH spellings; is_null() is the other one.
static Column	Functions.length(Column column)
Column	Column.leq(Column other)
Column	Column.like(Column pattern)
static Column	Functions.lit(Object value)	A literal.
static Column	Functions.lower(Column column)
Column	Column.lt(Column other)
static Column	Functions.max(Column column)
static Column	Functions.mean(Column column)
static Column	Functions.min(Column column)
Column	Column.minus(Column other)
Column	Column.mod(Column other)
Column	Column.multiply(Column other)
Column	Column.not_equal(Column other)
Column	Column.or(Column other)
Column	Column.plus(Column other)
Column	Column.regexp(Column pattern)
static Column	Functions.round(Column column)
static Column	Functions.sqlExpr(String sql)	Raw SQL, passed through untouched.
static Column	Functions.stddev(Column column)
Column	Column.subField(int index)	An element of a semi-structured array: v[0].
Column	Column.subField(String field)	A field of a semi-structured value: v['name'].
static Column	Functions.substring(Column column, Column start, Column count)
static Column	Functions.sum(Column column)
static Column	Functions.to_date(Column column)
static Column	Functions.trim(Column column)
Column	Column.unary_minus()
Column	Column.unary_not()
static Column	Functions.upper(Column column)

Methods in com.snowflake.snowpark_java with parameters of type Column

Modifier and Type	Method	Description
static Column	Functions.abs(Column column)
DataFrame	DataFrame.agg(Column... aggregates)	Aggregate the whole frame, with no grouping.
Column	Column.and(Column other)
static Column	Functions.avg(Column column)
Column	Column.between(Column lower, Column upper)	BETWEEN, inclusive on both ends as in SQL.
Column	Column.bitand(Column other)
Column	Column.bitor(Column other)
Column	Column.bitxor(Column other)
static Column	Functions.callBuiltin(String functionName, Column... arguments)	Any built-in by name, so a function this class does not spell out is still reachable.
static Column	Functions.callUDF(String udfName, Column... arguments)	A user-defined function by name.
static Column	Functions.ceil(Column column)
static Column	Functions.coalesce(Column... columns)
static Column	Functions.concat(Column... columns)
static Column	Functions.count(Column column)
static Column	Functions.count_distinct(Column... columns)
Column	Column.divide(Column other)
Column	Column.equal_null(Column other)	NULL-safe equality — two NULLs compare equal, unlike =.
Column	Column.equal_to(Column other)
DataFrame	DataFrame.filter(Column condition)	Keep the rows the condition holds for.
static Column	Functions.floor(Column column)
Column	Column.geq(Column other)
Column	Column.gt(Column other)
static Column	Functions.iff(Column condition, Column whenTrue, Column whenFalse)
Column	Column.in(Column... values)
static Column	Functions.length(Column column)
Column	Column.leq(Column other)
Column	Column.like(Column pattern)
static Column	Functions.lower(Column column)
Column	Column.lt(Column other)
static Column	Functions.max(Column column)
static Column	Functions.mean(Column column)
static Column	Functions.min(Column column)
Column	Column.minus(Column other)
Column	Column.mod(Column other)
Column	Column.multiply(Column other)
Column	Column.not_equal(Column other)
Column	Column.or(Column other)
Column	Column.plus(Column other)
Column	Column.regexp(Column pattern)
DataFrame	DataFrame.rename(String newName, Column column)	Rename one column, leaving the rest and their order alone — SELECT * RENAME (…).
static Column	Functions.round(Column column)
DataFrame	DataFrame.select(Column... columns)	Project the given columns — a PLAN operation, so nothing runs until an action asks for rows.
DataFrame	DataFrame.sort(Column... columns)	ORDER BY, taking the ordering columns as asc() / desc_nulls_last() etc.
static Column	Functions.stddev(Column column)
static Column	Functions.substring(Column column, Column start, Column count)
static Column	Functions.sum(Column column)
static Column	Functions.to_date(Column column)
static Column	Functions.trim(Column column)
static Column	Functions.upper(Column column)
DataFrame	DataFrame.where(Column condition)	Snowpark's spelling of DataFrame.filter(com.snowflake.snowpark_java.Column); both exist on the real DataFrame.
DataFrame	DataFrame.withColumn(String columnName, Column value)	Append a computed column, keeping the ones already there.