No,I think still need some discuss on grammar detail after I finish the
first version

Patrick McFadin <pmcfa...@gmail.com>于2024年9月20日 周五上午2:24写道:

> Is this CEP ready for a VOTE thread?
>
> On Sat, Aug 24, 2024 at 8:56 PM guo Maxwell <cclive1...@gmail.com> wrote:
>
>> 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!
>>>>>>>
>>>>>>
>>>>>

Reply via email to