public static class Select.SelectionOrAlias extends Select.Selection
Select.Selection in that you can add an
alias for the previously selected item through as(java.lang.String).| Constructor and Description |
|---|
SelectionOrAlias() |
| Modifier and Type | Method and Description |
|---|---|
Select.Builder |
all()
Selects all columns (i.e.
|
Select.Selection |
as(String alias)
Adds an alias for the just selected item.
|
Select.SelectionOrAlias |
avg(Object column)
Creates an
avg(x) built-in function call. |
Select.SelectionOrAlias |
cast(Object column,
DataType targetType)
Creates a cast of an expression to a given CQL type.
|
Select.SelectionOrAlias |
column(String name)
Selects the provided column.
|
Select.SelectionOrAlias |
count(Object column)
Creates a
count(x) built-in function call. |
Select.Builder |
countAll()
Selects the count of all returned rows (i.e.
|
Select.SelectionOrAlias |
fcall(String name,
Object... parameters)
Creates a function call.
|
Select |
from(String keyspace,
String table)
Adds the table to select from.
|
Select |
from(TableMetadata table)
Adds the table to select from.
|
Select.SelectionOrAlias |
max(Object column)
Creates a
max(x) built-in function call. |
Select.SelectionOrAlias |
min(Object column)
Creates a
min(x) built-in function call. |
Select.SelectionOrAlias |
path(String... segments)
Selects the provided path.
|
Select.SelectionOrAlias |
raw(String rawString)
Selects the provided raw expression.
|
Select.SelectionOrAlias |
sum(Object column)
Creates a
sum(x) built-in function call. |
Select.SelectionOrAlias |
toJson(String name)
Creates a
toJson() function call. |
Select.SelectionOrAlias |
ttl(String name)
Selects the ttl of provided column.
|
Select.SelectionOrAlias |
writeTime(String name)
Selects the write time of provided column.
|
distinct, jsonfrompublic Select.Selection as(String alias)
alias - the name of the alias to use.public Select.Builder all()
Select.Selectionall in class Select.Selectionpublic Select.Builder countAll()
Select.SelectioncountAll in class Select.Selectionpublic Select.SelectionOrAlias column(String name)
Select.Selectioncolumn in class Select.Selectionname - the new column name to add.public Select.SelectionOrAlias writeTime(String name)
Select.Selectionfcall("writetime", QueryBuilder.column(name)).writeTime in class Select.Selectionname - the name of the column to select the write time of.public Select.SelectionOrAlias ttl(String name)
Select.Selectionfcall("ttl", QueryBuilder.column(name)).ttl in class Select.Selectionname - the name of the column to select the ttl of.public Select.SelectionOrAlias fcall(String name, Object... parameters)
Select.Selectionfcall("textToBlob", "foo") will generate the string
"textToBlob('foo')". If you want to generate
"textToBlob(foo)", i.e. if the argument must be interpreted
as a column name (in a select clause), you will need to use the
QueryBuilder.column(java.lang.String) method, and so
fcall("textToBlob", QueryBuilder.column(foo).fcall in class Select.Selectionname - the name of the function.parameters - the parameters for the function call.public Select.SelectionOrAlias cast(Object column, DataType targetType)
Select.Selectioncast in class Select.Selectioncolumn - the expression to cast. It can be a complex expression like a
function call.targetType - the target CQL type to cast to. Use static methods such as DataType.text().public Select.SelectionOrAlias raw(String rawString)
Select.Selectionraw in class Select.SelectionrawString - the raw expression to add.public Select.SelectionOrAlias path(String... segments)
Select.Selectionsegments will be concatenated together with dots.
If any segment contains an identifier that needs quoting,
caller code is expected to call QueryBuilder.quote(String) prior to
invoking this method.
This method is currently only useful when accessing individual fields of a
user-defined type (UDT),
which is only possible since CASSANDRA-7423.
Note that currently nested UDT fields are not supported and
will be rejected by the server as a
syntax error.path in class Select.Selectionsegments - the segments of the path to create.public Select.SelectionOrAlias toJson(String name)
Select.SelectiontoJson() function call.
This is a shortcut for fcall("toJson", QueryBuilder.column(name)).
Support for JSON functions has been added in Cassandra 2.2.
The toJson() function is similar to SELECT JSON statements,
but applies to a single column value instead of the entire row,
and produces a JSON-encoded string representing the normal Cassandra column value.
It may only be used in the selection clause of a SELECT statement.toJson in class Select.Selectionname - the column to retrieve JSON from.public Select.SelectionOrAlias count(Object column)
Select.Selectioncount(x) built-in function call.count in class Select.Selectionpublic Select.SelectionOrAlias max(Object column)
Select.Selectionmax(x) built-in function call.max in class Select.Selectionpublic Select.SelectionOrAlias min(Object column)
Select.Selectionmin(x) built-in function call.min in class Select.Selectionpublic Select.SelectionOrAlias sum(Object column)
Select.Selectionsum(x) built-in function call.sum in class Select.Selectionpublic Select.SelectionOrAlias avg(Object column)
Select.Selectionavg(x) built-in function call.avg in class Select.Selectionpublic Select from(String keyspace, String table)
Select.Builderfrom in class Select.Builderkeyspace - the name of the keyspace to select from.table - the name of the table to select from.keyspace.table.public Select from(TableMetadata table)
Select.Builderfrom in class Select.Buildertable - the table to select from.table.Copyright © 2012–2018. All rights reserved.