public class Select extends BuiltStatement
Modifier and Type | Class and Description |
---|---|
static class |
Select.Builder
An in-construction SELECT statement.
|
static class |
Select.Selection
An Selection clause for an in-construction SELECT statement.
|
static class |
Select.SelectionOrAlias
An Selection clause for an in-construction SELECT statement.
|
static class |
Select.Where
The
WHERE clause of a SELECT statement. |
idempotent, NULL_PAYLOAD_VALUE
Modifier and Type | Method and Description |
---|---|
Select |
allowFiltering()
Adds an
ALLOW FILTERING directive to this statement. |
Select |
groupBy(Object... columns)
Adds a
GROUP BY clause to this statement. |
Select |
limit(BindMarker marker)
Adds a prepared
LIMIT clause to this statement. |
Select |
limit(int limit)
Adds a
LIMIT clause to this statement. |
Select |
orderBy(Ordering... orderings)
Adds an
ORDER BY clause to this statement. |
Select |
perPartitionLimit(BindMarker marker)
Adds a prepared
PER PARTITION LIMIT clause to this statement. |
Select |
perPartitionLimit(int perPartitionLimit)
Adds a
PER PARTITION LIMIT clause to this statement. |
Select.Where |
where()
Returns a
WHERE statement for this query without adding clause. |
Select.Where |
where(Clause clause)
Adds a
WHERE clause to this statement. |
escapeId, getKeyspace, getNamedValues, getObject, getObject, getQueryString, getRoutingKey, getValues, hasValues, isIdempotent, setForceNoValues, toString, usesNamedValues
getQueryString, hasValues
disableTracing, enableTracing, getConsistencyLevel, getDefaultTimestamp, getFetchSize, getOutgoingPayload, getReadTimeoutMillis, getRetryPolicy, getSerialConsistencyLevel, isBatchIdempotent, isTracing, setConsistencyLevel, setDefaultTimestamp, setFetchSize, setIdempotent, setOutgoingPayload, setPagingState, setPagingState, setPagingStateUnsafe, setReadTimeoutMillis, setRetryPolicy, setSerialConsistencyLevel
public Select.Where where(Clause clause)
WHERE
clause to this statement.
This is a shorter/more readable version for where().and(clause)
.clause
- the clause to add.public Select.Where where()
WHERE
statement for this query without adding clause.public Select orderBy(Ordering... orderings)
ORDER BY
clause to this statement.orderings
- the orderings to define for this query.IllegalStateException
- if an ORDER BY
clause has already been
provided.public Select groupBy(Object... columns)
GROUP BY
clause to this statement.
Note: support for GROUP BY
clause is only available from
Cassandra 3.10 onwards.columns
- the columns to group by.IllegalStateException
- if a GROUP BY
clause has already been provided.public Select limit(int limit)
LIMIT
clause to this statement.limit
- the limit to set.IllegalArgumentException
- if limit <= 0
.IllegalStateException
- if a LIMIT
clause has already been
provided.public Select limit(BindMarker marker)
LIMIT
clause to this statement.marker
- the marker to use for the limit.IllegalStateException
- if a LIMIT
clause has already been
provided.public Select perPartitionLimit(int perPartitionLimit)
PER PARTITION LIMIT
clause to this statement.
Note: support for PER PARTITION LIMIT
clause is only available from
Cassandra 3.6 onwards.perPartitionLimit
- the limit to set per partition.IllegalArgumentException
- if perPartitionLimit <= 0
.IllegalStateException
- if a PER PARTITION LIMIT
clause has already been
provided.IllegalStateException
- if this statement is a SELECT DISTINCT
statement.public Select perPartitionLimit(BindMarker marker)
PER PARTITION LIMIT
clause to this statement.
Note: support for PER PARTITION LIMIT
clause is only available from
Cassandra 3.6 onwards.marker
- the marker to use for the limit per partition.IllegalStateException
- if a PER PARTITION LIMIT
clause has already been
provided.IllegalStateException
- if this statement is a SELECT DISTINCT
statement.public Select allowFiltering()
ALLOW FILTERING
directive to this statement.Copyright © 2012–2018. All rights reserved.