Tables

CQL commands that create cycling example tables and insert the corresponding data.


birthday_list

Example for maps and indexing search index map fields.

calendar

Using clustering columns to display data.

comments

Example for count, timestamps, limiting results by partition.

country_flag

Static data type examples.

cyclist_alt_stats

Removes the table and inserts data required for examples.

cyclist_base
cyclist_career_teams

Set data type example.

cyclist_category

Clustering column simple example with corresponding query.

cyclist_emails

Create and drop the cyclist emails table with its known ID.

cyclist_expenses

Empty table to demonstrate batches.

cyclist_id

Composite partition key examples.

cyclist_name

Simple single column partition key

cyclist_points

Select aggregated data using the built-in functions.

cyclist_races

Create user-defined type, insert data into UDT and time fields.

cyclist_sponsors

Races and race sponsors in collection types.

cyclist_stats

Using a UDT, inserting and updating data.

cyclist_teams

Map data type example.

events

Uses month and date of cycling races to show how to get ranges that span clustering columns. Example of copying data from a CSV into the table.

popular_count

<what is it used for?>

race_sponsors

Races and race sponsors in collection types.

race_starts

Frozen list full index example.

race_times

Field times includes duration and time, and a multicolumn primary key.

race_winners

Using a user-defined type in a table and queries.

rank_by_year_and_name

Using a composite partition key and writing conditional statements (WHERE).

team_average

Partition key with two clustering columns. Shows use of aggregate and functions.

upcoming_calendar

Find all calendar events for a particular year and month.

Cycling Materialized Views

Create materialized views from cycling tables.

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