Thank you for your replies, I will prepare a CEP later. Patrick McFadin <pmcfa...@gmail.com> 于2024年8月20日周二 02:11写道:
> +1 This is a CEP > > On Mon, Aug 19, 2024 at 10:50 AM Jon Haddad <j...@jonhaddad.com> wrote: > >> Given the fairly large surface area for this, i think it should be a CEP. >> >> — >> Jon Haddad >> Rustyrazorblade Consulting >> rustyrazorblade.com >> >> >> On Mon, Aug 19, 2024 at 10:44 AM Bernardo Botella < >> conta...@bernardobotella.com> wrote: >> >>> Definitely a nice addition to CQL. >>> >>> Looking for inspiration at how Postgres and Mysql do that may also help >>> with the final design (I like the WITH proposed by Stefan, but I would >>> definitely take a look at the INCLUDING keyword proposed by Postgres). >>> https://www.postgresql.org/docs/current/sql-createtable.html >>> https://dev.mysql.com/doc/refman/8.4/en/create-table-like.html >>> >>> On top of that, and as part of the interesting questions, I would like >>> to add the permissions to the mix. Both the question about copying them >>> over (with a WITH keyword probably), and the need for read permissions on >>> the source table as well. >>> >>> Bernardo >>> >>> On Aug 19, 2024, at 10:01 AM, Štefan Miklošovič <smikloso...@apache.org> >>> wrote: >>> >>> BTW this would be cool to do as well: >>> >>> ALTER TABLE ks.to_copy LIKE ks.tb WITH INDICES; >>> >>> This would mean that if we create a copy of a table, later we can decide >>> that we need indices too, so we might "enrich" that table with indices from >>> the old one without necessarily explicitly re-creating them on that new >>> table. >>> >>> On Mon, Aug 19, 2024 at 6:55 PM Štefan Miklošovič < >>> smikloso...@apache.org> wrote: >>> >>>> I think this is an interesting idea worth exploring. I definitely agree >>>> with Benjamin who raised important questions which needs to be answered >>>> first. Also, what about triggers? >>>> >>>> It might be rather "easy" to come up with something simple but it >>>> should be a comprehensive solution with predictable behavior we all agree >>>> on. >>>> >>>> If a keyspace of a new table does not exist we would need to create >>>> that one too before. For the simplicity, I would just make it a must to >>>> create it on same keyspace. We might iterate on that in the future. >>>> >>>> UDTs are created per keyspace so there is nothing to re-create. We just >>>> need to reference it from a new table, right? >>>> >>>> Indexes and MVs are interesting but in theory they might be re-created >>>> too. >>>> >>>> Would it be appropriate to use something like this? >>>> >>>> CREATE TABLE ks.tb_copy LIKE ks.tb WITH INDEXES AND VIEWS AND TRIGGERS >>>> .... >>>> >>>> Without "WITH" it would just copy a table with nothing else. >>>> >>>> On Mon, Aug 19, 2024 at 6:10 PM guo Maxwell <cclive1...@gmail.com> >>>> wrote: >>>> >>>>> Hello, everyone: >>>>> As Jira CASSANDRA-7662 >>>>> <https://issues.apache.org/jira/browse/CASSANDRA-7662> has described >>>>> , we would like to introduce a new grammer " CREATE TABLE LIKE " >>>>> ,which simplifies creating new tables duplicating the existing ones . >>>>> The format may be like : CREATE TABLE <new_table> LIKE <old_table> >>>>> >>>>> Before I implement this function, do you have any suggestions on this? >>>>> >>>>> Looking forward to your reply! >>>>> >>>> >>>