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.