You are viewing a plain text version of this content. The canonical link for it is here.

Posted to commits@cassandra.apache.org by "Paulo Motta (Jira)" <ji...@apache.org> on 2022/02/17 21:05:00 UTC

[jira] [Created] (CASSANDRA-17391) Allow specifying PARTITION and CLUSTERING keys explicitly on DDL

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: commits-unsubscribe@cassandra.apache.org
For additional commands, e-mail: commits-help@cassandra.apache.org