Querying data

Retrieve data sets from a table using SELECT statements.

Queries

About SELECT statements

Retrieving data from tables.

Setting consistency levels

Set the consistency level to control the accuracy of the data returned by read request.

Restricting queries using WHERE clauses

Describes restrictions of partition and clustering columns in a WHERE clause.

DSE Search index enhancements

DataStax Enterprise supports production-grade implementation of CQL Solr queries in DSE Search.

Returning data from collection columns

How to retrieve data from a collection.

Aggregating results

Using the SELECT command to return data and apply standard aggregate functions.

Using user-defined functions (UDF)

Using the SELECT command to return data and applying a UDF.

Returning the write timestamp

Using the WRITETIME function in a SELECT statement to determine when the date/time that the column was written to the database.

Formatting query results as JSON

Use the SELECT command to return JSON data.

Was this helpful?

Give Feedback

How can we improve the documentation?

© 2024 DataStax | Privacy policy | Terms of use

Apache, Apache Cassandra, Cassandra, Apache Tomcat, Tomcat, Apache Lucene, Apache Solr, Apache Hadoop, Hadoop, Apache Pulsar, Pulsar, Apache Spark, Spark, Apache TinkerPop, TinkerPop, Apache Kafka and Kafka are either registered trademarks or trademarks of the Apache Software Foundation or its subsidiaries in Canada, the United States and/or other countries. Kubernetes is the registered trademark of the Linux Foundation.

General Inquiries: +1 (650) 389-6000, info@datastax.com