[ 
https://issues.apache.org/jira/browse/CASSANDRA-7662?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14101399#comment-14101399
 ] 

Kevin Burton commented on CASSANDRA-7662:
-----------------------------------------

Nice.  This is a feature of MySQL that I really liked.. we used it in our old 
MySQL system to implement partitioned tables.  We would create one master table 
and then created partitioned tables like the previous table.

We're aware that Cassandra should generally have < 100 or so tables... which is 
find for our use case since we only have 30 of them.  They just keep rotating 
through.

This way we can just update the master table.

> Implement templated CREATE TABLE functionality (CREATE TABLE LIKE)
> ------------------------------------------------------------------
>
>                 Key: CASSANDRA-7662
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-7662
>             Project: Cassandra
>          Issue Type: Improvement
>            Reporter: Aleksey Yeschenko
>            Priority: Minor
>             Fix For: 2.1.1
>
>
> 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>



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Reply via email to