[CASSANDRA-11873] Add duration type

• Type: Improvement
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 3.10
• Component/s: Legacy/CQL
• Labels: doc-impacting
• Impacts: Clients
• Assignee: Benjamin Lerer
• Reporter: Benjamin Lerer

Authors

Benjamin Lerer

Reviewers

Tom Hobbs

• Created: 23/May/16 09:14
• Updated: 30/Apr/23 02:20
• Resolved: 18/Oct/16 12:31

Description

For CASSANDRA-11871 or to allow queries with WHERE clause like:
... WHERE reading_time < now() - 2h, we need to support some duration type.

In my opinion, it should be represented internally as a number of microseconds.

Issue Links

• breaks: CASSANDRA-13174 Indexing is allowed on Duration type when it should not be
• is depended upon by: CASSANDRA-11936 Add support for + and - operations on dates
• is depended upon by: CASSANDRA-11871 Allow to aggregate by time intervals
• relates to: CASSANDRA-16005 sstableloader cannot parse schema of tables with CQL duration type
• relates to: CASSANDRA-16787 Copy from csv file with duration type fields fails to import