# Example Schema Generated from a test fixture of zipcodes. # Query (Table) a dataset with a derived schema

Field	Type	Description
toSql	[String](#string)!	[Compile to](https://ibis-project.org/reference/expression-tables#ibis.expr.types.relations.Table.to_sql) a formatted SQL string.
dialect	[String](#string)	output SQL dialect; defaults to the backend's native dialect
pretty	[Boolean](#boolean)!	whether to use pretty formatting
type	[String](#string)!	[ibis table](https://ibis-project.org/reference/expression-table) or [arrow dataset](https://arrow.apache.org/docs/python/api/dataset.html)
schema	[Schema](#schema)!	[table schema](https://ibis-project.org/reference/schemas#ibis.expr.schema.Schema)
cast	[Table](#table)!	[Cast](https://ibis-project.org/reference/expression-tables#ibis.expr.types.relations.Table.cast) the columns of a table.
schema	[[Field](#field)!]!	field names and types
try	[Boolean](#boolean)!	return null if cast fails
optional	[Table](#table)	Nullable field to stop error propagation, enabling partial query results.
count	[BigInt](#bigint)!	[Count](https://ibis-project.org/reference/expression-tables#ibis.expr.types.relations.Table.count) the number of rows.
any	[Boolean](#boolean)!	Whether there are at least `limit` rows. May be significantly faster than `count` for out-of-core data.
limit	[BigInt](#bigint)!
column	[Column](#column)	Column of any type by name. If the column is in the schema, [columns](../reference/Dataset.md#graphique.Dataset.columns) can be used instead.
name	[[String](#string)!]!	column name(s); multiple names access nested struct fields
cast	[String](#string)!	cast expression to indicated [data type](https://ibis-project.org/reference/datatypes)
try	[Boolean](#boolean)!	return null if cast fails
index	[[BigInt](#bigint)!]!	column index(es); may access array offsets
slice	[Table](#table)!	[Limit](https://ibis-project.org/reference/expression-tables#ibis.expr.types.relations.Table.limit) row selection.
offset	[BigInt](#bigint)!	number of rows to skip; negative value skips from the end
limit	[BigInt](#bigint)	maximum number of rows to return
distinct	[Table](#table)!	[Remove duplicate](https://ibis-project.org/reference/expression-tables#ibis.expr.types.relations.Table.distinct) rows from table. Differs from [group](../reference/Dataset.md#graphique.Dataset.group) by keeping all columns, and defaulting to all keys.
on	[[String](#string)!]	column names to deduplicate on; defaults to all
keep	[String](#string)	which duplicates to keep
counts	[String](#string)!	[value counts](https://ibis-project.org/reference/expression-tables#ibis.expr.types.relations.Table.value_counts); incompatible with `keep: null`
order	[String](#string)!	optionally include and order by first row number; incompatible with `on: null`
group	[Table](#table)!	[Group](https://ibis-project.org/reference/expression-tables#ibis.expr.types.relations.Table.group_by) table by columns.
by	[[String](#string)!]!	column names; empty will aggregate into a single row table
counts	[String](#string)!	optionally include counts in an aliased column
order	[String](#string)!	optionally include and order by first row number
aggregate	[Aggregates](#aggregates)!	aggregation functions applied to other columns
order	[Table](#table)!	[Sort](https://ibis-project.org/reference/expression-tables#ibis.expr.types.relations.Table.order_by) table by columns.
by	[[String](#string)!]!	column names; prefix with `-` for descending order
limit	[BigInt](#bigint)	maximum number of rows to return; optimized for partitioned dataset keys
over	[[String](#string)!]!	column names; `limit` applies separately over each grouping window
first	[Table](#table)!	Provisionally sort and filter by rank.
by	[[String](#string)!]!	column names; prefix with `-` for descending order
rank	[Int](#int)!	maximum rank of rows to return; optimized for partitioned dataset keys
dense	[Boolean](#boolean)!	use dense rank (all ties) or sparse rank (only ties at the boundary)
over	[[String](#string)!]!	column names; `rank` applies separately over each grouping window
unnest	[Table](#table)!	[Unnest](https://ibis-project.org/reference/expression-tables#ibis.expr.types.relations.Table.unnest) an array column from a table.
name	[String](#string)!	column name
offset	[String](#string)!	optionally include index column
keepEmpty	[Boolean](#boolean)!	keep empty array values as null
order	[String](#string)!	optionally include and order by row number; optionally by `offset` too
unpack	[Table](#table)!	[Unpack](https://ibis-project.org/reference/expression-tables#ibis.expr.types.relations.Table.unpack) the struct fields of each column.
names	[[String](#string)!]!	column names
join	[Table](#table)!	[Join](https://ibis-project.org/reference/expression-tables#ibis.expr.types.relations.Table.join) two tables.
right	[String](#string)!	name of right table; must be on root Query type
keys	[[String](#string)!]!	column names used as keys on the left side
rkeys	[[String](#string)!]!	column names used as keys on the right side; defaults to left side
how	[String](#string)!	the kind of join: 'inner', 'left', 'outer', 'semi', …
lname	[String](#string)!	format string to use to rename overlapping columns in the left table
rname	[String](#string)!	format string to use to rename overlapping columns in the right table
asofJoin	[Table](#table)!	[As-of join](https://ibis-project.org/reference/expression-tables#ibis.expr.types.relations.Table.asof_join) on nearest key rather than equal keys.
right	[String](#string)!	name of right table; must be on root Query type
on	[String](#string)!	column name for closest-match inequality (e.g. timestamp)
keys	[[String](#string)!]!	column names used as keys on the left side
rkeys	[[String](#string)!]!	column names used as keys on the right side; defaults to left side
tolerance	[JSON](#json)	optional look-back window for the as-of match
scalar	[Scalars](#scalars)!	typed scalar for `tolerance
lname	[String](#string)!	format string to rename overlapping columns in the left table
rname	[String](#string)!	format string to rename overlapping columns in the right table
crossJoin	[Table](#table)!	[Cross join](https://ibis-project.org/reference/expression-tables#ibis.expr.types.relations.Table.cross_join) with one or more tables.
right	[[String](#string)!]!	name(s) of right table; must be on root Query type
lname	[String](#string)!	format string to rename overlapping columns in the left table
rname	[String](#string)!	format string to rename overlapping columns in the right table
difference	[Table](#table)!	[Set difference](https://ibis-project.org/reference/expression-tables#ibis.expr.types.relations.Table.difference) of tables.
table	[[String](#string)!]!	name(s) of other table; must be on root Query type
distinct	[Boolean](#boolean)!	use set difference (true) or multiset difference (false)
intersect	[Table](#table)!	[Set intersection](https://ibis-project.org/reference/expression-tables#ibis.expr.types.relations.Table.intersect) of tables.
table	[[String](#string)!]!	name(s) of other table; must be on root Query type
distinct	[Boolean](#boolean)!	use set difference (true) or multiset difference (false)
union	[Table](#table)!	[Set union](https://ibis-project.org/reference/expression-tables#ibis.expr.types.relations.Table.union) of tables.
table	[[String](#string)!]!	name(s) of other table; must be on root Query type
distinct	[Boolean](#boolean)!	use set difference (true) or multiset difference (false)
take	[Table](#table)!	[Take](https://arrow.apache.org/docs/python/generated/pyarrow.dataset.Dataset.html#pyarrow.dataset.Dataset.take) rows by index.
indices	[[BigInt](#bigint)!]!
dropNull	[Table](#table)!	[Drop](https://ibis-project.org/reference/expression-tables#ibis.expr.types.relations.Table.drop_null) rows with null values.
subset	[[String](#string)!]	columns names; defaults to all
how	[String](#string)!	remove if [any](../reference/Dataset.md#graphique.Dataset.any) or `all` are null
fillNull	[Table](#table)!	[Fill null](https://ibis-project.org/reference/expression-tables.html#ibis.expr.types.relations.Table.fill_null) values.
name	[[String](#string)!]	column name(s); defaults to all
value	[JSON](#json)	JSON scalar
scalar	[Scalars](#scalars)!	typed scalar
project	[Table](#table)!	[Mutate](https://ibis-project.org/reference/expression-tables#ibis.expr.types.relations.Table.mutate) columns by expressions. Renamed to not be confused with a mutation.
columns	[[Projection](#projection)!]!
runs	[Table](#table)!	Provisionally group table by adjacent values in columns.
by	[[String](#string)!]!	column names to compare by equality
split	[[Expression](#expression)!]!	boolean column expressions to split on true values
counts	[String](#string)!	optionally include counts in an aliased column
order	[String](#string)!	alias of row number to maintain order
aggregate	[Aggregates](#aggregates)!	aggregation functions applied to other columns
sql	[Table](#table)!	[Run a SQL](https://ibis-project.org/reference/expression-tables#ibis.expr.types.relations.Table.sql) query against a table expression.
query	[String](#string)!	SQL query string
alias	[String](#string)!	[alias](https://ibis-project.org/reference/expression-tables#ibis.expr.types.relations.Table.alias) of the table expression referenced in the query
dialect	[String](#string)	input SQL dialect; defaults to the backend's native dialect
columns	[Columns](#columns)!	fields for each column
row	[Row](#row)	Return scalar values at index.
index	[BigInt](#bigint)!
filter	[Table](#table)!	[Filter](https://ibis-project.org/reference/expression-tables#ibis.expr.types.relations.Table.filter) rows by predicates. Schema derived fields provide syntax for simple queries; `where` supports complex queries.
latitude	[FloatFilter](#floatfilter)!
longitude	[FloatFilter](#floatfilter)!
state	[StrFilter](#strfilter)!
city	[StrFilter](#strfilter)!
county	[StrFilter](#strfilter)!
zipcode	[IntFilter](#intfilter)!
where	[Expression](#expression)

# Objects ## ArrayColumn [array column](https://ibis-project.org/reference/expression-collections)

Field	Type	Description
type	[String](#string)!	[data type](https://ibis-project.org/reference/datatypes)
count	[BigInt](#bigint)!	Compute the number of rows in an expression.
nunique	[BigInt](#bigint)!	Compute the number of distinct rows in an expression.
approx	[Boolean](#boolean)!
unnest	[Column](#column)!	Unnest an array into a column. Combine with `length` to efficiently regroup.
length	[[BigInt](#bigint)]!	Compute the length of an array.

## Base64Column [generic column](https://ibis-project.org/reference/expression-generic)

Field	Type	Description
type	[String](#string)!	[data type](https://ibis-project.org/reference/datatypes)
count	[BigInt](#bigint)!	Compute the number of rows in an expression.
nunique	[BigInt](#bigint)!	Compute the number of distinct rows in an expression.
approx	[Boolean](#boolean)!
values	[[Base64](#base64)]!	list of values
distinct	[Base64Set](#base64set)!	distinct values and counts
first	[Base64](#base64)	Return the first value of a column.
last	[Base64](#base64)	Return the last value of a column.
dropNull	[[Base64](#base64)!]!	non-null values
fillNull	[[Base64](#base64)!]!	Replace `NULL`s with the given value. Does NOT affect `NaN` and `inf` values.
value	[Base64](#base64)!
mode	[Base64](#base64)	Return the mode of a column.
min	[Base64](#base64)	Return the minimum of a column.
max	[Base64](#base64)	Return the maximum of a column.
quantile	[[Base64](#base64)!]	Return value at the given quantile.
q	[[Float](#float)!]!

## Base64Set distinct values and counts

Field	Argument	Type	Description
values		[[Base64](#base64)]!	distinct values
counts		[[BigInt](#bigint)!]!	corresponding counts

## BigIntColumn [integer column](https://ibis-project.org/reference/expression-numeric#ibis.expr.types.numeric.IntegerColumn)

Field	Type	Description
type	[String](#string)!	[data type](https://ibis-project.org/reference/datatypes)
count	[BigInt](#bigint)!	Compute the number of rows in an expression.
nunique	[BigInt](#bigint)!	Compute the number of distinct rows in an expression.
approx	[Boolean](#boolean)!
values	[[BigInt](#bigint)]!	list of values
distinct	[BigIntSet](#bigintset)!	distinct values and counts
first	[BigInt](#bigint)	Return the first value of a column.
last	[BigInt](#bigint)	Return the last value of a column.
dropNull	[[BigInt](#bigint)!]!	non-null values
fillNull	[[BigInt](#bigint)!]!	Replace `NULL`s with the given value. Does NOT affect `NaN` and `inf` values.
value	[BigInt](#bigint)!
mode	[BigInt](#bigint)	Return the mode of a column.
min	[BigInt](#bigint)	Return the minimum of a column.
max	[BigInt](#bigint)	Return the maximum of a column.
quantile	[[Float](#float)!]	Return value at the given quantile.
q	[[Float](#float)!]!
approx	[Boolean](#boolean)!
sum	[BigInt](#bigint)	Return the sum of a numeric column.
mean	[Float](#float)	Return the mean of a numeric column.
std	[Float](#float)	Return the standard deviation of a numeric column.
how	[String](#string)!
var	[Float](#float)	Return the variance of a numeric column.
how	[String](#string)!
takeFrom	[Dataset](#dataset)	Select indices from a table on the root Query type.
field	[String](#string)!

## BigIntSet distinct values and counts

Field	Argument	Type	Description
values		[[BigInt](#bigint)]!	distinct values
counts		[[BigInt](#bigint)!]!	corresponding counts

## BoolSet distinct values and counts

Field	Argument	Type	Description
values		[[Boolean](#boolean)]!	distinct values
counts		[[BigInt](#bigint)!]!	corresponding counts

## BooleanColumn [boolean column](https://ibis-project.org/reference/expression-numeric#ibis.expr.types.logical.BooleanColumn)

Field	Type	Description
type	[String](#string)!	[data type](https://ibis-project.org/reference/datatypes)
count	[BigInt](#bigint)!	Compute the number of rows in an expression.
nunique	[BigInt](#bigint)!	Compute the number of distinct rows in an expression.
approx	[Boolean](#boolean)!
values	[[Boolean](#boolean)]!	list of values
distinct	[BoolSet](#boolset)!	distinct values and counts
first	[Boolean](#boolean)	Return the first value of a column.
last	[Boolean](#boolean)	Return the last value of a column.
dropNull	[[Boolean](#boolean)!]!	non-null values
fillNull	[[Boolean](#boolean)!]!	Replace `NULL`s with the given value. Does NOT affect `NaN` and `inf` values.
value	[Boolean](#boolean)!
mode	[Boolean](#boolean)	Return the mode of a column.
min	[Boolean](#boolean)	Return the minimum of a column.
max	[Boolean](#boolean)	Return the maximum of a column.
quantile	[[Float](#float)!]	Return value at the given quantile.
q	[[Float](#float)!]!
approx	[Boolean](#boolean)!
sum	[Boolean](#boolean)	Return the sum of a numeric column.
mean	[Float](#float)	Return the mean of a numeric column.
std	[Float](#float)	Return the standard deviation of a numeric column.
how	[String](#string)!
var	[Float](#float)	Return the variance of a numeric column.
how	[String](#string)!
any	[Boolean](#boolean)	Return whether at least one element is `True`.
all	[Boolean](#boolean)	Return whether all elements are `True`.

## Columns fields for each column

Field	Argument	Type	Description
latitude		[FloatColumn](#floatcolumn)
longitude		[FloatColumn](#floatcolumn)
state		[StringColumn](#stringcolumn)
city		[StringColumn](#stringcolumn)
county		[StringColumn](#stringcolumn)
zipcode		[IntColumn](#intcolumn)

## DateColumn [temporal column](https://ibis-project.org/reference/expression-temporal)

Field	Type	Description
type	[String](#string)!	[data type](https://ibis-project.org/reference/datatypes)
count	[BigInt](#bigint)!	Compute the number of rows in an expression.
nunique	[BigInt](#bigint)!	Compute the number of distinct rows in an expression.
approx	[Boolean](#boolean)!
values	[[Date](#date)]!	list of values
distinct	[DateSet](#dateset)!	distinct values and counts
first	[Date](#date)	Return the first value of a column.
last	[Date](#date)	Return the last value of a column.
dropNull	[[Date](#date)!]!	non-null values
fillNull	[[Date](#date)!]!	Replace `NULL`s with the given value. Does NOT affect `NaN` and `inf` values.
value	[Date](#date)!
mode	[Date](#date)	Return the mode of a column.
min	[Date](#date)	Return the minimum of a column.
max	[Date](#date)	Return the maximum of a column.
quantile	[[Date](#date)!]	Return value at the given quantile.
q	[[Float](#float)!]!

## DateSet distinct values and counts

Field	Argument	Type	Description
values		[[Date](#date)]!	distinct values
counts		[[BigInt](#bigint)!]!	corresponding counts

## DatetimeColumn [temporal column](https://ibis-project.org/reference/expression-temporal)

Field	Type	Description
type	[String](#string)!	[data type](https://ibis-project.org/reference/datatypes)
count	[BigInt](#bigint)!	Compute the number of rows in an expression.
nunique	[BigInt](#bigint)!	Compute the number of distinct rows in an expression.
approx	[Boolean](#boolean)!
values	[[DateTime](#datetime)]!	list of values
distinct	[DatetimeSet](#datetimeset)!	distinct values and counts
first	[DateTime](#datetime)	Return the first value of a column.
last	[DateTime](#datetime)	Return the last value of a column.
dropNull	[[DateTime](#datetime)!]!	non-null values
fillNull	[[DateTime](#datetime)!]!	Replace `NULL`s with the given value. Does NOT affect `NaN` and `inf` values.
value	[DateTime](#datetime)!
mode	[DateTime](#datetime)	Return the mode of a column.
min	[DateTime](#datetime)	Return the minimum of a column.
max	[DateTime](#datetime)	Return the maximum of a column.
quantile	[[DateTime](#datetime)!]	Return value at the given quantile.
q	[[Float](#float)!]!

## DatetimeSet distinct values and counts

Field	Argument	Type	Description
values		[[DateTime](#datetime)]!	distinct values
counts		[[BigInt](#bigint)!]!	corresponding counts

## DecimalColumn [numeric column](https://ibis-project.org/reference/expression-numeric)

Field	Type	Description
type	[String](#string)!	[data type](https://ibis-project.org/reference/datatypes)
count	[BigInt](#bigint)!	Compute the number of rows in an expression.
nunique	[BigInt](#bigint)!	Compute the number of distinct rows in an expression.
approx	[Boolean](#boolean)!
values	[[Decimal](#decimal)]!	list of values
distinct	[DecimalSet](#decimalset)!	distinct values and counts
first	[Decimal](#decimal)	Return the first value of a column.
last	[Decimal](#decimal)	Return the last value of a column.
dropNull	[[Decimal](#decimal)!]!	non-null values
fillNull	[[Decimal](#decimal)!]!	Replace `NULL`s with the given value. Does NOT affect `NaN` and `inf` values.
value	[Decimal](#decimal)!
mode	[Decimal](#decimal)	Return the mode of a column.
min	[Decimal](#decimal)	Return the minimum of a column.
max	[Decimal](#decimal)	Return the maximum of a column.
quantile	[[Float](#float)!]	Return value at the given quantile.
q	[[Float](#float)!]!
approx	[Boolean](#boolean)!
sum	[Decimal](#decimal)	Return the sum of a numeric column.
mean	[Float](#float)	Return the mean of a numeric column.
std	[Float](#float)	Return the standard deviation of a numeric column.
how	[String](#string)!
var	[Float](#float)	Return the variance of a numeric column.
how	[String](#string)!

## DecimalSet distinct values and counts

Field	Argument	Type	Description
values		[[Decimal](#decimal)]!	distinct values
counts		[[BigInt](#bigint)!]!	corresponding counts

## DurationColumn provisional [interval column](https://ibis-project.org/reference/expression-temporal#ibis.expr.types.temporal.IntervalValue) Interval support varies by backend; durations may still be useful for computation and as scalar inputs.

Field	Type	Description
type	[String](#string)!	[data type](https://ibis-project.org/reference/datatypes)
count	[BigInt](#bigint)!	Compute the number of rows in an expression.
nunique	[BigInt](#bigint)!	Compute the number of distinct rows in an expression.
approx	[Boolean](#boolean)!
values	[[Duration](#duration)]!	list of values
distinct	[DurationSet](#durationset)!	distinct values and counts
first	[Duration](#duration)	Return the first value of a column.
last	[Duration](#duration)	Return the last value of a column.
dropNull	[[Duration](#duration)!]!	non-null values
fillNull	[[Duration](#duration)!]!	Replace `NULL`s with the given value. Does NOT affect `NaN` and `inf` values.
value	[Duration](#duration)!
mode	[Duration](#duration)	Return the mode of a column.
min	[Duration](#duration)	Return the minimum of a column.
max	[Duration](#duration)	Return the maximum of a column.
quantile	[[Duration](#duration)!]	Return value at the given quantile.
q	[[Float](#float)!]!

## DurationSet distinct values and counts

Field	Argument	Type	Description
values		[[Duration](#duration)]!	distinct values
counts		[[BigInt](#bigint)!]!	corresponding counts

## FloatColumn [numeric column](https://ibis-project.org/reference/expression-numeric)

Field	Type	Description
type	[String](#string)!	[data type](https://ibis-project.org/reference/datatypes)
count	[BigInt](#bigint)!	Compute the number of rows in an expression.
nunique	[BigInt](#bigint)!	Compute the number of distinct rows in an expression.
approx	[Boolean](#boolean)!
values	[[Float](#float)]!	list of values
distinct	[FloatSet](#floatset)!	distinct values and counts
first	[Float](#float)	Return the first value of a column.
last	[Float](#float)	Return the last value of a column.
dropNull	[[Float](#float)!]!	non-null values
fillNull	[[Float](#float)!]!	Replace `NULL`s with the given value. Does NOT affect `NaN` and `inf` values.
value	[Float](#float)!
mode	[Float](#float)	Return the mode of a column.
min	[Float](#float)	Return the minimum of a column.
max	[Float](#float)	Return the maximum of a column.
quantile	[[Float](#float)!]	Return value at the given quantile.
q	[[Float](#float)!]!
approx	[Boolean](#boolean)!
sum	[Float](#float)	Return the sum of a numeric column.
mean	[Float](#float)	Return the mean of a numeric column.
std	[Float](#float)	Return the standard deviation of a numeric column.
how	[String](#string)!
var	[Float](#float)	Return the variance of a numeric column.
how	[String](#string)!

## FloatSet distinct values and counts

Field	Argument	Type	Description
values		[[Float](#float)]!	distinct values
counts		[[BigInt](#bigint)!]!	corresponding counts

## IntColumn [integer column](https://ibis-project.org/reference/expression-numeric#ibis.expr.types.numeric.IntegerColumn)

Field	Type	Description
type	[String](#string)!	[data type](https://ibis-project.org/reference/datatypes)
count	[BigInt](#bigint)!	Compute the number of rows in an expression.
nunique	[BigInt](#bigint)!	Compute the number of distinct rows in an expression.
approx	[Boolean](#boolean)!
values	[[Int](#int)]!	list of values
distinct	[IntSet](#intset)!	distinct values and counts
first	[Int](#int)	Return the first value of a column.
last	[Int](#int)	Return the last value of a column.
dropNull	[[Int](#int)!]!	non-null values
fillNull	[[Int](#int)!]!	Replace `NULL`s with the given value. Does NOT affect `NaN` and `inf` values.
value	[Int](#int)!
mode	[Int](#int)	Return the mode of a column.
min	[Int](#int)	Return the minimum of a column.
max	[Int](#int)	Return the maximum of a column.
quantile	[[Float](#float)!]	Return value at the given quantile.
q	[[Float](#float)!]!
approx	[Boolean](#boolean)!
sum	[Int](#int)	Return the sum of a numeric column.
mean	[Float](#float)	Return the mean of a numeric column.
std	[Float](#float)	Return the standard deviation of a numeric column.
how	[String](#string)!
var	[Float](#float)	Return the variance of a numeric column.
how	[String](#string)!
takeFrom	[Dataset](#dataset)	Select indices from a table on the root Query type.
field	[String](#string)!

## IntSet distinct values and counts

Field	Argument	Type	Description
values		[[Int](#int)]!	distinct values
counts		[[BigInt](#bigint)!]!	corresponding counts

## JSONColumn [struct column](https://ibis-project.org/reference/expression-collections#ibis.expr.types.structs.StructValue)

Field	Type	Description
type	[String](#string)!	[data type](https://ibis-project.org/reference/datatypes)
count	[BigInt](#bigint)!	Compute the number of rows in an expression.
nunique	[BigInt](#bigint)!	Compute the number of distinct rows in an expression.
approx	[Boolean](#boolean)!
values	[[JSON](#json)]!	list of values
distinct	[JSONSet](#jsonset)!	distinct values and counts
first	[JSON](#json)	Return the first value of a column.
last	[JSON](#json)	Return the last value of a column.
dropNull	[[JSON](#json)!]!	non-null values
fillNull	[[JSON](#json)!]!	Replace `NULL`s with the given value. Does NOT affect `NaN` and `inf` values.
value	[JSON](#json)!
mode	[JSON](#json)	Return the mode of a column.
min	[JSON](#json)	Return the minimum of a column.
max	[JSON](#json)	Return the maximum of a column.
quantile	[[JSON](#json)!]	Return value at the given quantile.
q	[[Float](#float)!]!
names	[[String](#string)!]!	field names
types	[[String](#string)!]!	field types

## JSONSet distinct values and counts

Field	Argument	Type	Description
values		[[JSON](#json)]!	distinct values
counts		[[BigInt](#bigint)!]!	corresponding counts

## Row scalar fields

Field	Argument	Type	Description
latitude		[Float](#float)
longitude		[Float](#float)
state		[String](#string)
city		[String](#string)
county		[String](#string)
zipcode		[Int](#int)

## Schema [table schema](https://ibis-project.org/reference/schemas#ibis.expr.schema.Schema)

Field	Type	Description
names	[[String](#string)!]!	field names
types	[[String](#string)!]!	[data type](https://ibis-project.org/reference/datatypes), corresponding to `names`
partitioning	[[String](#string)!]!	partition keys

## StrSet distinct values and counts

Field	Argument	Type	Description
values		[[String](#string)]!	distinct values
counts		[[BigInt](#bigint)!]!	corresponding counts

## StringColumn [string column](https://ibis-project.org/reference/expression-strings)

Field	Type	Description
type	[String](#string)!	[data type](https://ibis-project.org/reference/datatypes)
count	[BigInt](#bigint)!	Compute the number of rows in an expression.
nunique	[BigInt](#bigint)!	Compute the number of distinct rows in an expression.
approx	[Boolean](#boolean)!
values	[[String](#string)]!	list of values
distinct	[StrSet](#strset)!	distinct values and counts
first	[String](#string)	Return the first value of a column.
last	[String](#string)	Return the last value of a column.
dropNull	[[String](#string)!]!	non-null values
fillNull	[[String](#string)!]!	Replace `NULL`s with the given value. Does NOT affect `NaN` and `inf` values.
value	[String](#string)!
mode	[String](#string)	Return the mode of a column.
min	[String](#string)	Return the minimum of a column.
max	[String](#string)	Return the maximum of a column.
quantile	[[String](#string)!]	Return value at the given quantile.
q	[[Float](#float)!]!

## TimeColumn [temporal column](https://ibis-project.org/reference/expression-temporal)

Field	Type	Description
type	[String](#string)!	[data type](https://ibis-project.org/reference/datatypes)
count	[BigInt](#bigint)!	Compute the number of rows in an expression.
nunique	[BigInt](#bigint)!	Compute the number of distinct rows in an expression.
approx	[Boolean](#boolean)!
values	[[Time](#time)]!	list of values
distinct	[TimeSet](#timeset)!	distinct values and counts
first	[Time](#time)	Return the first value of a column.
last	[Time](#time)	Return the last value of a column.
dropNull	[[Time](#time)!]!	non-null values
fillNull	[[Time](#time)!]!	Replace `NULL`s with the given value. Does NOT affect `NaN` and `inf` values.
value	[Time](#time)!
mode	[Time](#time)	Return the mode of a column.
min	[Time](#time)	Return the minimum of a column.
max	[Time](#time)	Return the maximum of a column.
quantile	[[Time](#time)!]	Return value at the given quantile.
q	[[Float](#float)!]!

## TimeSet distinct values and counts

Field	Argument	Type	Description
values		[[Time](#time)]!	distinct values
counts		[[BigInt](#bigint)!]!	corresponding counts

# Inputs ## Aggregate name and optional alias for aggregation

Field	Type	Description
name	[String](#string)!	column name
alias	[String](#string)!	output column name
where	[Expression](#expression)

## Aggregates aggregation [expressions](https://ibis-project.org/reference/expression-generic)

Field	Type	Description
all	[[Aggregate](#aggregate)!]!	Return whether all elements are `True`.
any	[[Aggregate](#aggregate)!]!	Return whether at least one element is `True`.
argmax	[[ArgAggregate](#argaggregate)!]!	Return the value of `self` that maximizes `key`.
argmin	[[ArgAggregate](#argaggregate)!]!	Return the value of `self` that minimizes `key`.
collect	[[CollectAggregate](#collectaggregate)!]!	Aggregate this expression's elements into an array.
concat	[[ConcatAggregate](#concataggregate)!]!	Concatenate values using the indicated separator to produce a string.
count	[[Aggregate](#aggregate)!]!	Compute the number of rows in an expression.
first	[[OrderAggregate](#orderaggregate)!]!	Return the first value of a column.
kurtosis	[[VarAggregate](#varaggregate)!]!	Return the kurtosis of a numeric column.
last	[[OrderAggregate](#orderaggregate)!]!	Return the last value of a column.
max	[[Aggregate](#aggregate)!]!	Return the maximum of a column.
mean	[[Aggregate](#aggregate)!]!	Return the mean of a numeric column.
min	[[Aggregate](#aggregate)!]!	Return the minimum of a column.
mode	[[Aggregate](#aggregate)!]!	Return the mode of a column.
nunique	[[UniqueAggregate](#uniqueaggregate)!]!	Compute the number of distinct rows in an expression.
quantile	[[QuantileAggregate](#quantileaggregate)!]!	Return value at the given quantile.
std	[[VarAggregate](#varaggregate)!]!	Return the standard deviation of a numeric column.
sum	[[Aggregate](#aggregate)!]!	Return the sum of a numeric column.
var	[[VarAggregate](#varaggregate)!]!	Return the variance of a numeric column.

## ArgAggregate

Field	Type	Description
name	[String](#string)!	column name
alias	[String](#string)!	output column name
where	[Expression](#expression)
key	[String](#string)!

## Arrays array [expressions](https://ibis-project.org/reference/expression-collections)

Field	Type	Description
alls	[Expression](#expression)	Return whether all elements (ignoring nulls) in the array are true.
anys	[Expression](#expression)	Return whether any element in the array is true.
flatten	[Expression](#expression)	Remove one level of nesting from an array expression.
length	[Expression](#expression)	Compute the length of an array.
maxs	[Expression](#expression)	Return the maximum value in the array.
means	[Expression](#expression)	Return the mean of the values in the array.
modes	[Expression](#expression)	Return the mode of the values in the array.
mins	[Expression](#expression)	Return the minimum value in the array.
sort	[Expression](#expression)	Sort the elements in an array.
sums	[Expression](#expression)	Return the sum of the values in the array.
unique	[Expression](#expression)	Return the unique values in an array.
concat	[[Expression](#expression)!]!	Concatenate this array with one or more arrays.
contains	[[Expression](#expression)!]!	Return whether the array contains `other`.
index	[[Expression](#expression)!]!	Return the position of `other` in an array.
intersect	[[Expression](#expression)!]!	Intersect two arrays.
remove	[[Expression](#expression)!]!	Remove `other` from `self`.
union	[[Expression](#expression)!]!	Union two arrays.
zip	[[Expression](#expression)!]!	Zip two or more arrays together.
slice	[Expression](#expression)	array slice
value	[Expression](#expression)	value at offset
offset	[Int](#int)!
limit	[Int](#int)
join	[Expression](#expression)	Join the elements of this array expression with `sep`.
sep	[String](#string)!
repeat	[Expression](#expression)	Repeat this array `n` times.
n	[Int](#int)!

## CollectAggregate

Field	Type	Description
name	[String](#string)!	column name
alias	[String](#string)!	output column name
where	[Expression](#expression)
orderBy	[[String](#string)!]!
includeNull	[Boolean](#boolean)!
distinct	[Boolean](#boolean)!

## ConcatAggregate

Field	Type	Description
name	[String](#string)!	column name
alias	[String](#string)!	output column name
where	[Expression](#expression)
sep	[String](#string)!
orderBy	[[String](#string)!]!

## Expression [expression API](https://ibis-project.org/reference/#expression-api)

Field	Type	Description
name	[[String](#string)!]!	column name(s)
value	[JSON](#json)	JSON scalar
scalar	[Scalars](#scalars)	typed scalar
eq	[[Expression](#expression)!]!	==
ne	[[Expression](#expression)!]!	!=
lt	[[Expression](#expression)!]!	<
le	[[Expression](#expression)!]!	<=
gt	[[Expression](#expression)!]!	>
ge	[[Expression](#expression)!]!	>=
isin	[[Expression](#expression)!]!	Check whether this expression is in `values`.
notin	[[Expression](#expression)!]!	Check whether this expression is not in `values`.
inv	[Expression](#expression)	~
and	[[Expression](#expression)!]!	&
or	[[Expression](#expression)!]!
xor	[[Expression](#expression)!]!	^
add	[[Expression](#expression)!]!
sub	[[Expression](#expression)!]!
mul	[[Expression](#expression)!]!
div	[[Expression](#expression)!]!	/
coalesce	[[Expression](#expression)!]!	Return the first non-null value from `args`.
cummax	[Expression](#expression)	Return the cumulative max over a window.
cummin	[Expression](#expression)	Return the cumulative min over a window.
ifelse	[[Expression](#expression)!]!	Construct a ternary conditional expression.
array	[Arrays](#arrays)	array value functions
numeric	[Numeric](#numeric)	numeric functions
string	[Strings](#strings)	string functions
temporal	[Temporal](#temporal)	temporal functions
window	[Window](#window)	window functions

## Field a schema field

Field		Type	Description
name		[String](#string)!
type		[String](#string)!

## FloatFilter predicates for scalars

Field	Type	Description
eq	[[Float](#float)!]	== or `isin`
ne	[[Float](#float)!]	!= or `notin`
lt	[Float](#float)	<
le	[Float](#float)	<=
gt	[Float](#float)	>
ge	[Float](#float)	>=

## IntFilter predicates for scalars

Field	Type	Description
eq	[[Int](#int)!]	== or `isin`
ne	[[Int](#int)!]	!= or `notin`
lt	[Int](#int)	<
le	[Int](#int)	<=
gt	[Int](#int)	>
ge	[Int](#int)	>=

## Numeric numeric [expressions](https://ibis-project.org/reference/expression-numeric)

Field	Type	Description
abs	[Expression](#expression)	Return the absolute value of `self`.
acos	[Expression](#expression)	Compute the arc cosine of `self`.
asin	[Expression](#expression)	Compute the arc sine of `self`.
atan	[Expression](#expression)	Compute the arc tangent of `self`.
atan2	[[Expression](#expression)!]!	Compute the two-argument version of arc tangent.
ceil	[Expression](#expression)	Return the ceiling of `self`.
cos	[Expression](#expression)	Compute the cosine of `self`.
exp	[Expression](#expression)	Compute \(e^\texttt{self}\).
floor	[Expression](#expression)	Return the floor of an expression.
isinf	[Expression](#expression)	Return whether the value is +/-inf. Does NOT detect `NULL` and `inf` values.
isnan	[Expression](#expression)	Return whether the value is NaN. Does NOT detect `NULL` and `inf` values.
log	[[Expression](#expression)!]!	Compute \(\log_{\texttt{base}}\left(\texttt{self}\right)\).
negate	[Expression](#expression)	Negate a numeric expression.
round	[[Expression](#expression)!]!	Round values to an indicated number of decimal places.
sign	[Expression](#expression)	Return the sign of the input.
sin	[Expression](#expression)	Compute the sine of `self`.
sqrt	[Expression](#expression)	Compute the square root of `self`.
tan	[Expression](#expression)	Compute the tangent of `self`.
bucket	[Expression](#expression)	Compute a discrete binning of a numeric array.
cummean	[Expression](#expression)	Return the cumulative mean of the input.
cumsum	[Expression](#expression)	Return the cumulative sum of the input.
buckets	[[JSON](#json)!]!
closed	[String](#string)!
closeExtreme	[Boolean](#boolean)!
includeUnder	[Boolean](#boolean)!
includeOver	[Boolean](#boolean)!

## OrderAggregate

Field	Type	Description
name	[String](#string)!	column name
alias	[String](#string)!	output column name
where	[Expression](#expression)
orderBy	[[String](#string)!]!
includeNull	[Boolean](#boolean)!

## Projection an `Expression` with an optional alias

Field	Type	Description
name	[[String](#string)!]!	column name(s)
value	[JSON](#json)	JSON scalar
scalar	[Scalars](#scalars)	typed scalar
eq	[[Expression](#expression)!]!	==
ne	[[Expression](#expression)!]!	!=
lt	[[Expression](#expression)!]!	<
le	[[Expression](#expression)!]!	<=
gt	[[Expression](#expression)!]!	>
ge	[[Expression](#expression)!]!	>=
isin	[[Expression](#expression)!]!	Check whether this expression is in `values`.
notin	[[Expression](#expression)!]!	Check whether this expression is not in `values`.
inv	[Expression](#expression)	~
and	[[Expression](#expression)!]!	&
or	[[Expression](#expression)!]!
xor	[[Expression](#expression)!]!	^
add	[[Expression](#expression)!]!
sub	[[Expression](#expression)!]!
mul	[[Expression](#expression)!]!
div	[[Expression](#expression)!]!	/
coalesce	[[Expression](#expression)!]!	Return the first non-null value from `args`.
cummax	[Expression](#expression)	Return the cumulative max over a window.
cummin	[Expression](#expression)	Return the cumulative min over a window.
ifelse	[[Expression](#expression)!]!	Construct a ternary conditional expression.
array	[Arrays](#arrays)	array value functions
numeric	[Numeric](#numeric)	numeric functions
string	[Strings](#strings)	string functions
temporal	[Temporal](#temporal)	temporal functions
window	[Window](#window)	window functions
alias	[String](#string)!	name of projected column

## QuantileAggregate

Field	Type	Description
name	[String](#string)!	column name
alias	[String](#string)!	output column name
where	[Expression](#expression)
approx	[Boolean](#boolean)!
q	[Float](#float)!

## Scalars typed scalars

Field	Type	Description
base64	[Base64](#base64)	binary scalar
date	[Date](#date)	date scalar
datetime	[DateTime](#datetime)	datetime scalar
decimal	[Decimal](#decimal)	decimal scalar
duration	[Duration](#duration)	duration scalar
time	[Time](#time)	time scalar

## StrFilter predicates for scalars

Field	Type	Description
eq	[[String](#string)!]	== or `isin`
ne	[[String](#string)!]	!= or `notin`
lt	[String](#string)	<
le	[String](#string)	<=
gt	[String](#string)	>
ge	[String](#string)	>=

## Strings string [expressions](https://ibis-project.org/reference/expression-strings)

Field	Type	Description
capitalize	[Expression](#expression)	Uppercase the first letter, lowercase the rest.
contains	[[Expression](#expression)!]!	Return whether the expression contains `substr`.
endswith	[[Expression](#expression)!]!	Determine if `self` ends with `end`.
find	[[Expression](#expression)!]!	Return the position of the first occurrence of substring.
length	[Expression](#expression)	Compute the length of a string.
lower	[Expression](#expression)	Convert string to all lowercase.
lpad	[[Expression](#expression)!]!	Pad `arg` by truncating on the right or padding on the left.
lstrip	[[Expression](#expression)!]!	Remove whitespace from the left side of string.
reExtract	[[Expression](#expression)!]!	Return the specified match at `index` from a regex `pattern`.
reSearch	[[Expression](#expression)!]!	Return whether `self` contains the regex `pattern`.
reSplit	[[Expression](#expression)!]!	Split a string by a regular expression `pattern`.
replace	[[Expression](#expression)!]!	Replace each exact match of `pattern` with `replacement`.
reverse	[Expression](#expression)	Reverse the characters of a string.
rpad	[[Expression](#expression)!]!	Pad `self` by truncating or padding on the right.
rstrip	[[Expression](#expression)!]!	Remove whitespace from the right side of string.
split	[[Expression](#expression)!]!	Split as string on `delimiter`.
startswith	[[Expression](#expression)!]!	Determine whether `self` starts with `start`.
strip	[[Expression](#expression)!]!	Remove whitespace from left and right sides of a string.
upper	[Expression](#expression)	Convert string to all uppercase.

## Temporal temporal [expressions](https://ibis-project.org/reference/expression-temporal)

Field	Type	Description
date	[Expression](#expression)	Return the date component of the expression.
day	[Expression](#expression)	Extract the day component.
dayOfYear	[Expression](#expression)	Extract the day of the year component.
delta	[[Expression](#expression)!]!	Compute the number of `part`s between two timestamps.
epochSeconds	[Expression](#expression)	Extract UNIX epoch in seconds.
hour	[Expression](#expression)	Extract the hour component.
microsecond	[Expression](#expression)	Extract the microsecond component.
millisecond	[Expression](#expression)	Extract the millisecond component.
minute	[Expression](#expression)	Extract the minute component.
month	[Expression](#expression)	Extract the month component.
quarter	[Expression](#expression)	Extract the quarter component.
second	[Expression](#expression)	Extract the second component.
strftime	[Expression](#expression)	Format a timestamp according to `format_str`.
time	[Expression](#expression)	Return the time component of the expression.
truncate	[Expression](#expression)	Truncate timestamp expression to units of `unit`.
weekOfYear	[Expression](#expression)	Extract the week of the year component.
year	[Expression](#expression)	Extract the year component.
formatStr	[String](#string)!
unit	[String](#string)!

## UniqueAggregate

Field	Type	Description
name	[String](#string)!	column name
alias	[String](#string)!	output column name
where	[Expression](#expression)
approx	[Boolean](#boolean)!

## VarAggregate

Field	Type	Description
name	[String](#string)!	column name
alias	[String](#string)!	output column name
where	[Expression](#expression)
how	[String](#string)!

## Window window [expressions](https://ibis-project.org/reference/expression-tables.html#ibis.window)

Field	Type	Description
over	[[String](#string)!]!	partition column names
by	[[String](#string)!]!	order column names within each partition
lag	[Expression](#expression)	Return the row located at `offset` rows before the current row.
lead	[Expression](#expression)	Return the row located at `offset` rows after the current row.
eq	[Expression](#expression)	pairwise ==
ne	[Expression](#expression)	pairwise !=
lt	[Expression](#expression)	pairwise <
le	[Expression](#expression)	pairwise <=
gt	[Expression](#expression)	pairwise >
ge	[Expression](#expression)	pairwise >=
sub	[Expression](#expression)	pairwise -
count	[Expression](#expression)	Compute the number of rows in an expression.
sum	[Expression](#expression)	Return the sum of a numeric column.
mean	[Expression](#expression)	Return the mean of a numeric column.
min	[Expression](#expression)	Return the minimum of a column.
max	[Expression](#expression)	Return the maximum of a column.
rowNumber	[Void](#void)	Return an analytic function expression for the current row number.
rank	[Void](#void)	Compute position of first element within each equal-value group in sorted order.
denseRank	[Void](#void)	Position of first element within each group of equal values.
percentRank	[Void](#void)	Return the relative rank of the values in the column.
cumeDist	[Void](#void)	Return the cumulative distribution over a window.
ntile	[Int](#int)!	Return the integer number of a partitioning of the column values.
preceding	[Int](#int)	number of preceding rows in the window
following	[Int](#int)	number of following rows in the window
range	[Boolean](#boolean)!	aggregate rows based upon differences in the order by values
offset	[Int](#int)!	offset for lag and lead
default	[JSON](#json)	default JSON scalar
scalar	[Scalars](#scalars)	default typed scalar

# Scalars ## Base64 Represents binary data as Base64-encoded strings, using the standard alphabet. ## BigInt 64-bit int ## Boolean The `Boolean` scalar type represents `true` or `false`. ## Date Date (isoformat) ## DateTime Date with time (isoformat) ## Decimal Decimal (fixed-point) ## Duration Duration (isoformat) ## Float The `Float` scalar type represents signed double-precision fractional values as specified by [IEEE 754](https://en.wikipedia.org/wiki/IEEE_floating_point). ## Int The `Int` scalar type represents non-fractional signed whole numeric values. Int can represent values between -(2^31) and 2^31 - 1. ## JSON The `JSON` scalar type represents JSON values as specified by [ECMA-404](https://ecma-international.org/wp-content/uploads/ECMA-404_2nd_edition_december_2017.pdf). ## String The `String` scalar type represents textual data, represented as UTF-8 character sequences. The String type is most often used by GraphQL to represent free-form human-readable text. ## Time Time (isoformat) ## Void Represents NULL values # Interfaces ## Column ibis column interface

Field	Type	Description
type	[String](#string)!	[data type](https://ibis-project.org/reference/datatypes)
count	[BigInt](#bigint)!	Compute the number of rows in an expression.
nunique	[BigInt](#bigint)!	Compute the number of distinct rows in an expression.
approx	[Boolean](#boolean)!

**Possible Types:** [ArrayColumn](#arraycolumn), [Base64Column](#base64column), [BigIntColumn](#bigintcolumn), [BooleanColumn](#booleancolumn), [DateColumn](#datecolumn), [DatetimeColumn](#datetimecolumn), [DecimalColumn](#decimalcolumn), [DurationColumn](#durationcolumn), [FloatColumn](#floatcolumn), [IntColumn](#intcolumn), [JSONColumn](#jsoncolumn), [StringColumn](#stringcolumn), [TimeColumn](#timecolumn) ## Dataset ibis `Table` or arrow [Dataset](../reference/Dataset.md#graphique.Dataset)

Field	Type	Description
toSql	[String](#string)!	[Compile to](https://ibis-project.org/reference/expression-tables#ibis.expr.types.relations.Table.to_sql) a formatted SQL string.
dialect	[String](#string)	output SQL dialect; defaults to the backend's native dialect
pretty	[Boolean](#boolean)!	whether to use pretty formatting
type	[String](#string)!	[ibis table](https://ibis-project.org/reference/expression-table) or [arrow dataset](https://arrow.apache.org/docs/python/api/dataset.html)
schema	[Schema](#schema)!	[table schema](https://ibis-project.org/reference/schemas#ibis.expr.schema.Schema)
cast	[Dataset](#dataset)!	[Cast](https://ibis-project.org/reference/expression-tables#ibis.expr.types.relations.Table.cast) the columns of a table.
schema	[[Field](#field)!]!	field names and types
try	[Boolean](#boolean)!	return null if cast fails
optional	[Dataset](#dataset)	Nullable field to stop error propagation, enabling partial query results.
count	[BigInt](#bigint)!	[Count](https://ibis-project.org/reference/expression-tables#ibis.expr.types.relations.Table.count) the number of rows.
any	[Boolean](#boolean)!	Whether there are at least `limit` rows. May be significantly faster than `count` for out-of-core data.
limit	[BigInt](#bigint)!
column	[Column](#column)	Column of any type by name. If the column is in the schema, [columns](../reference/Dataset.md#graphique.Dataset.columns) can be used instead.
name	[[String](#string)!]!	column name(s); multiple names access nested struct fields
cast	[String](#string)!	cast expression to indicated [data type](https://ibis-project.org/reference/datatypes)
try	[Boolean](#boolean)!	return null if cast fails
index	[[BigInt](#bigint)!]!	column index(es); may access array offsets
slice	[Dataset](#dataset)!	[Limit](https://ibis-project.org/reference/expression-tables#ibis.expr.types.relations.Table.limit) row selection.
offset	[BigInt](#bigint)!	number of rows to skip; negative value skips from the end
limit	[BigInt](#bigint)	maximum number of rows to return
distinct	[Dataset](#dataset)!	[Remove duplicate](https://ibis-project.org/reference/expression-tables#ibis.expr.types.relations.Table.distinct) rows from table. Differs from [group](../reference/Dataset.md#graphique.Dataset.group) by keeping all columns, and defaulting to all keys.
on	[[String](#string)!]	column names to deduplicate on; defaults to all
keep	[String](#string)	which duplicates to keep
counts	[String](#string)!	[value counts](https://ibis-project.org/reference/expression-tables#ibis.expr.types.relations.Table.value_counts); incompatible with `keep: null`
order	[String](#string)!	optionally include and order by first row number; incompatible with `on: null`
group	[Dataset](#dataset)!	[Group](https://ibis-project.org/reference/expression-tables#ibis.expr.types.relations.Table.group_by) table by columns.
by	[[String](#string)!]!	column names; empty will aggregate into a single row table
counts	[String](#string)!	optionally include counts in an aliased column
order	[String](#string)!	optionally include and order by first row number
aggregate	[Aggregates](#aggregates)!	aggregation functions applied to other columns
order	[Dataset](#dataset)!	[Sort](https://ibis-project.org/reference/expression-tables#ibis.expr.types.relations.Table.order_by) table by columns.
by	[[String](#string)!]!	column names; prefix with `-` for descending order
limit	[BigInt](#bigint)	maximum number of rows to return; optimized for partitioned dataset keys
over	[[String](#string)!]!	column names; `limit` applies separately over each grouping window
first	[Dataset](#dataset)!	Provisionally sort and filter by rank.
by	[[String](#string)!]!	column names; prefix with `-` for descending order
rank	[Int](#int)!	maximum rank of rows to return; optimized for partitioned dataset keys
dense	[Boolean](#boolean)!	use dense rank (all ties) or sparse rank (only ties at the boundary)
over	[[String](#string)!]!	column names; `rank` applies separately over each grouping window
unnest	[Dataset](#dataset)!	[Unnest](https://ibis-project.org/reference/expression-tables#ibis.expr.types.relations.Table.unnest) an array column from a table.
name	[String](#string)!	column name
offset	[String](#string)!	optionally include index column
keepEmpty	[Boolean](#boolean)!	keep empty array values as null
order	[String](#string)!	optionally include and order by row number; optionally by `offset` too
unpack	[Dataset](#dataset)!	[Unpack](https://ibis-project.org/reference/expression-tables#ibis.expr.types.relations.Table.unpack) the struct fields of each column.
names	[[String](#string)!]!	column names
join	[Dataset](#dataset)!	[Join](https://ibis-project.org/reference/expression-tables#ibis.expr.types.relations.Table.join) two tables.
right	[String](#string)!	name of right table; must be on root Query type
keys	[[String](#string)!]!	column names used as keys on the left side
rkeys	[[String](#string)!]!	column names used as keys on the right side; defaults to left side
how	[String](#string)!	the kind of join: 'inner', 'left', 'outer', 'semi', …
lname	[String](#string)!	format string to use to rename overlapping columns in the left table
rname	[String](#string)!	format string to use to rename overlapping columns in the right table
asofJoin	[Dataset](#dataset)!	[As-of join](https://ibis-project.org/reference/expression-tables#ibis.expr.types.relations.Table.asof_join) on nearest key rather than equal keys.
right	[String](#string)!	name of right table; must be on root Query type
on	[String](#string)!	column name for closest-match inequality (e.g. timestamp)
keys	[[String](#string)!]!	column names used as keys on the left side
rkeys	[[String](#string)!]!	column names used as keys on the right side; defaults to left side
tolerance	[JSON](#json)	optional look-back window for the as-of match
scalar	[Scalars](#scalars)!	typed scalar for `tolerance
lname	[String](#string)!	format string to rename overlapping columns in the left table
rname	[String](#string)!	format string to rename overlapping columns in the right table
crossJoin	[Dataset](#dataset)!	[Cross join](https://ibis-project.org/reference/expression-tables#ibis.expr.types.relations.Table.cross_join) with one or more tables.
right	[[String](#string)!]!	name(s) of right table; must be on root Query type
lname	[String](#string)!	format string to rename overlapping columns in the left table
rname	[String](#string)!	format string to rename overlapping columns in the right table
difference	[Dataset](#dataset)!	[Set difference](https://ibis-project.org/reference/expression-tables#ibis.expr.types.relations.Table.difference) of tables.
table	[[String](#string)!]!	name(s) of other table; must be on root Query type
distinct	[Boolean](#boolean)!	use set difference (true) or multiset difference (false)
intersect	[Dataset](#dataset)!	[Set intersection](https://ibis-project.org/reference/expression-tables#ibis.expr.types.relations.Table.intersect) of tables.
table	[[String](#string)!]!	name(s) of other table; must be on root Query type
distinct	[Boolean](#boolean)!	use set difference (true) or multiset difference (false)
union	[Dataset](#dataset)!	[Set union](https://ibis-project.org/reference/expression-tables#ibis.expr.types.relations.Table.union) of tables.
table	[[String](#string)!]!	name(s) of other table; must be on root Query type
distinct	[Boolean](#boolean)!	use set difference (true) or multiset difference (false)
take	[Dataset](#dataset)!	[Take](https://arrow.apache.org/docs/python/generated/pyarrow.dataset.Dataset.html#pyarrow.dataset.Dataset.take) rows by index.
indices	[[BigInt](#bigint)!]!
dropNull	[Dataset](#dataset)!	[Drop](https://ibis-project.org/reference/expression-tables#ibis.expr.types.relations.Table.drop_null) rows with null values.
subset	[[String](#string)!]	columns names; defaults to all
how	[String](#string)!	remove if [any](../reference/Dataset.md#graphique.Dataset.any) or `all` are null
fillNull	[Dataset](#dataset)!	[Fill null](https://ibis-project.org/reference/expression-tables.html#ibis.expr.types.relations.Table.fill_null) values.
name	[[String](#string)!]	column name(s); defaults to all
value	[JSON](#json)	JSON scalar
scalar	[Scalars](#scalars)!	typed scalar
project	[Dataset](#dataset)!	[Mutate](https://ibis-project.org/reference/expression-tables#ibis.expr.types.relations.Table.mutate) columns by expressions. Renamed to not be confused with a mutation.
columns	[[Projection](#projection)!]!
runs	[Dataset](#dataset)!	Provisionally group table by adjacent values in columns.
by	[[String](#string)!]!	column names to compare by equality
split	[[Expression](#expression)!]!	boolean column expressions to split on true values
counts	[String](#string)!	optionally include counts in an aliased column
order	[String](#string)!	alias of row number to maintain order
aggregate	[Aggregates](#aggregates)!	aggregation functions applied to other columns
sql	[Dataset](#dataset)!	[Run a SQL](https://ibis-project.org/reference/expression-tables#ibis.expr.types.relations.Table.sql) query against a table expression.
query	[String](#string)!	SQL query string
alias	[String](#string)!	[alias](https://ibis-project.org/reference/expression-tables#ibis.expr.types.relations.Table.alias) of the table expression referenced in the query
dialect	[String](#string)	input SQL dialect; defaults to the backend's native dialect

**Possible Types:** [Table](#table)