Paulo Motta created CASSANDRA-17391:
---------------------------------------
Summary: Allow specifying PARTITION and CLUSTERING keys explicitly
on DDL
Key: CASSANDRA-17391
URL: https://issues.apache.org/jira/browse/CASSANDRA-17391
Project: Cassandra
Issue Type: Improvement
Reporter: Paulo Motta
The distinction between primary key and partition/clustering key may be
potentially confusing to users so I would like to propose an addition to the to
*CREATE TABLE* DDL to specify partition and clustering keys explicitly:
CREATE TABLE events (
sensor_id UUID,
event_time TIMESTAMP,
event TEXT,
PARTITION KEY (sensor_id),
CLUSTERING KEY (event_time)
)
This would be optional and supported in addition to the current *PRIMARY KEY
((partition_key), clustering_key)* construct.
One downside is it can get potentially confusing to users if we provide
multiple ways to specify partition and clustering keys.
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
