cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kevin Burton (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-7662) Implement templated CREATE TABLE functionality (CREATE TABLE LIKE)
Date Mon, 18 Aug 2014 22:07:18 GMT

    [ 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)

Mime
View raw message