[CASSANDRA-19965] CREATE TABLE LIKE with indexes/ triggers /ALL option

• Type: New Feature
• Status: In Progress
• Priority: Normal
• Resolution: Unresolved
• Fix Version/s: 5.x
• Component/s: Cluster/Schema, CQL/Syntax
• Change Category: Semantic
• Complexity: Normal
• Platform: All
• Assignee: Maxwell Guo
• Reporter: Maxwell Guo

Authors

Maxwell Guo

• Created: 29/Sep/24 05:12
• Updated: 1 week ago 09:50

Description

no matter Copy table with indexes or triggers under same keyspace or differenet.
The indexes and trigger name should be different from the source in case of conflict.
we need to
1.Adding cql parser for ALL/INDEXES/TRIGGER when doing create table like
2.Automatic completion of keywords(LIKE/ALL/INDEXES/TRIGGER) and function hints (the source table and target table explain_completion when doing table copy) at the cqlsh level.

in pylib/cqlshlib/cql3handling.py and the test in pylib/cqlshlib/test/test_cqlsh_completion.py.

Issue Links

• is a child of: CASSANDRA-7662 Implement templated CREATE TABLE functionality (CREATE TABLE LIKE)