Package com.datastax.driver.core.querybuilder

Class Select

java.lang.Object

com.datastax.driver.core.Statement

com.datastax.driver.core.RegularStatement

com.datastax.driver.core.querybuilder.BuiltStatement

com.datastax.driver.core.querybuilder.Select

public class Select
extends BuiltStatement

A built SELECT statement.

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
static class	Select.Builder	An in-construction SELECT statement.
static class	Select.Options	The options of a 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.

Field Summary

Fields inherited from class com.datastax.driver.core.Statement

idempotent, NULL_PAYLOAD_VALUE

Method Summary

Modifier and Type	Method	Description
Select	allowFiltering()	Adds an ALLOW FILTERING directive to this statement.
Select	bypassCache()	Adds on BYPASS CACHE clause to this statement.
Select	groupBy(Object... columns)	Adds a GROUP BY clause to this statement.
Select	limit(int limit)	Adds a LIMIT clause to this statement.
Select	limit(BindMarker marker)	Adds a prepared LIMIT clause to this statement.
Select	orderBy(Ordering... orderings)	Adds an ORDER BY clause to this statement.
Select	perPartitionLimit(int perPartitionLimit)	Adds a PER PARTITION LIMIT clause to this statement.
Select	perPartitionLimit(BindMarker marker)	Adds a prepared PER PARTITION LIMIT clause to this statement.
Select.Options	using(Using using)	Adds a new options for this SELECT 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.

Methods inherited from class com.datastax.driver.core.querybuilder.BuiltStatement

escapeId, getKeyspace, getNamedValues, getObject, getObject, getQueryString, getRoutingKey, getValues, hasValues, isIdempotent, setForceNoValues, toString, usesNamedValues

Methods inherited from class com.datastax.driver.core.RegularStatement

getQueryString, hasValues, requestSizeInBytes

Methods inherited from class com.datastax.driver.core.Statement

disableTracing, enableTracing, getConsistencyLevel, getDefaultTimestamp, getFetchSize, getHost, getLastHost, getNowInSeconds, getOutgoingPayload, getPartitioner, getReadTimeoutMillis, getRetryPolicy, getSerialConsistencyLevel, isBatchIdempotent, isLWT, isTracing, setConsistencyLevel, setDefaultTimestamp, setFetchSize, setHost, setIdempotent, setLastHost, setNowInSeconds, setOutgoingPayload, setPagingState, setPagingState, setPagingStateUnsafe, setReadTimeoutMillis, setRetryPolicy, setSerialConsistencyLevel

Methods inherited from class java.lang.Object

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

Method Detail

where

public Select.Where where(Clause clause)

Adds a WHERE clause to this statement.

This is a shorter/more readable version for where().and(clause).

Parameters:

clause - the clause to add.

Returns:

the where clause of this query to which more clause can be added.

where

public Select.Where where()

Returns a WHERE statement for this query without adding clause.

Returns:

the where clause of this query to which more clause can be added.

using

public Select.Options using(Using using)

Adds a new options for this SELECT statement.

Parameters:

using - the option to add.

Returns:

the options of this SELECT statement.

orderBy

public Select orderBy(Ordering... orderings)

Adds an ORDER BY clause to this statement.

Parameters:

orderings - the orderings to define for this query.

Returns:

this statement.

Throws:

IllegalStateException - if an ORDER BY clause has already been provided.

groupBy

public Select groupBy(Object... columns)

Adds a GROUP BY clause to this statement.

Note: support for GROUP BY clause is only available from Cassandra 3.10 onwards.

Parameters:

columns - the columns to group by.

Returns:

this statement.

Throws:

IllegalStateException - if a GROUP BY clause has already been provided.

limit

public Select limit(int limit)

Adds a LIMIT clause to this statement.

Parameters:

limit - the limit to set.

Returns:

this statement.

Throws:

IllegalArgumentException - if limit <= 0.

IllegalStateException - if a LIMIT clause has already been provided.

limit

public Select limit(BindMarker marker)

Adds a prepared LIMIT clause to this statement.

Parameters:

marker - the marker to use for the limit.

Returns:

this statement.

Throws:

IllegalStateException - if a LIMIT clause has already been provided.

perPartitionLimit

public Select perPartitionLimit(int perPartitionLimit)

Adds a PER PARTITION LIMIT clause to this statement.

Note: support for PER PARTITION LIMIT clause is only available from Cassandra 3.6 onwards.

Parameters:

perPartitionLimit - the limit to set per partition.

Returns:

this statement.

Throws:

IllegalArgumentException - if perPartitionLimit <= 0.

IllegalStateException - if a PER PARTITION LIMIT clause has already been provided.

IllegalStateException - if this statement is a SELECT DISTINCT statement.

perPartitionLimit

public Select perPartitionLimit(BindMarker marker)

Adds a prepared PER PARTITION LIMIT clause to this statement.

Note: support for PER PARTITION LIMIT clause is only available from Cassandra 3.6 onwards.

Parameters:

marker - the marker to use for the limit per partition.

Returns:

this statement.

Throws:

IllegalStateException - if a PER PARTITION LIMIT clause has already been provided.

IllegalStateException - if this statement is a SELECT DISTINCT statement.

allowFiltering

public Select allowFiltering()

Adds an ALLOW FILTERING directive to this statement.

Returns:

this statement.

bypassCache

public Select bypassCache()

Adds on BYPASS CACHE clause to this statement.

Returns:

this statement.