[CASSANDRA-7662] Implement templated CREATE TABLE functionality (CREATE TABLE LIKE)

• Type: Task
• Status: In Progress
• Priority: Normal
• Resolution: Unresolved
• Fix Version/s: 5.x
• Component/s: Cluster/Schema, CQL/Syntax, Legacy/CQL
• Labels: AdventCalendar2021 lhf
• Complexity: Normal

Source Control Link

CEP-43

• Assignee: Maxwell Guo
• Reporter: Aleksey Yeschenko

Authors

Maxwell Guo

• Created: 31/Jul/14 20:09
• Updated: 29/Nov/24 09:02

Description

Implement templated CREATE TABLE functionality (CREATE TABLE LIKE) to simplify creating new tables duplicating existing ones (see parent_table part of http://www.postgresql.org/docs/9.1/static/sql-createtable.html).

CREATE TABLE <new_table> LIKE <old_table>; - would create a new table with the same columns and options as <old_table>

Additional info for newcomers:

In order to implement this change you will need to change the Parser.g ANTLR file located in the src/antlr directory and the java classes corresponding to the CREATE statement located in the org.apache.cassandra.cql3.statements.schema package.
The unit test for the CQL logic are located under org.apache.cassandra.cql3.validation
cqlsh parsing will need to be modified to support the new LIKE syntax. The logic is in pylib/cqlshlib/cql3handling.py and the test in pylib/cqlshlib/test/test_cqlsh_completion.py

Issue Links

• is a parent of: CASSANDRA-19965 CREATE TABLE LIKE with indexes/ triggers /ALL option
• is a parent of: CASSANDRA-19966 CREATE TABLE LIKE for table for UDT
• is a parent of: CASSANDRA-20120 Add doc for CREATE TABLE LIKE
• is a parent of: CASSANDRA-20111 Add Guardrail for CREATE TABLE LIKE
• is a parent of: CASSANDRA-19964 CREATE TABLE LIKE for copying Basic Table definition
• is duplicated by: CASSANDRA-7643 Cassandra Schema Template
• is duplicated by: CASSANDRA-5194 LIKE Operator in CQL When Creating Column Families