public class Select extends BuiltStatement
| Modifier and Type | Class and Description | 
|---|---|
| static class  | Select.BuilderAn in-construction SELECT statement. | 
| static class  | Select.SelectionAn Selection clause for an in-construction SELECT statement. | 
| static class  | Select.SelectionOrAliasAn Selection clause for an in-construction SELECT statement. | 
| static class  | Select.WhereThe  WHEREclause of aSELECTstatement. | 
idempotent, NULL_PAYLOAD_VALUE| Modifier and Type | Method and Description | 
|---|---|
| Select | allowFiltering()Adds an  ALLOW FILTERINGdirective to this statement. | 
| Select | groupBy(Object... columns)Adds a  GROUP BYclause to this statement. | 
| Select | limit(BindMarker marker)Adds a prepared  LIMITclause to this statement. | 
| Select | limit(int limit)Adds a  LIMITclause to this statement. | 
| Select | orderBy(Ordering... orderings)Adds an  ORDER BYclause to this statement. | 
| Select | perPartitionLimit(BindMarker marker)Adds a prepared  PER PARTITION LIMITclause to this statement. | 
| Select | perPartitionLimit(int perPartitionLimit)Adds a  PER PARTITION LIMITclause to this statement. | 
| Select.Where | where()Returns a  WHEREstatement for this query without adding clause. | 
| Select.Where | where(Clause clause)Adds a  WHEREclause to this statement. | 
escapeId, getKeyspace, getNamedValues, getObject, getObject, getQueryString, getRoutingKey, getValues, hasValues, isIdempotent, setForceNoValues, toString, usesNamedValuesgetQueryString, hasValues, requestSizeInBytesdisableTracing, enableTracing, getConsistencyLevel, getDefaultTimestamp, getFetchSize, getHost, getLastHost, getOutgoingPayload, getPartitioner, getReadTimeoutMillis, getRetryPolicy, getSerialConsistencyLevel, isBatchIdempotent, isLWT, isTracing, setConsistencyLevel, setDefaultTimestamp, setFetchSize, setHost, setIdempotent, setLastHost, setOutgoingPayload, setPagingState, setPagingState, setPagingStateUnsafe, setReadTimeoutMillis, setRetryPolicy, setSerialConsistencyLevelpublic 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–2025. All rights reserved.