Re: [DISCUSS] Introduce CREATE TABLE LIKE grammer

+1 This is a CEP On Mon, Aug 19, 2024 at 10:50 AM Jon Haddad 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...@bernardobotel

Re: [DISCUSS] Introduce CREATE TABLE LIKE grammer

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

Re: [DISCUSS] Introduce CREATE TABLE LIKE grammer

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-cre

[RELEASE] Apache Cassandra 4.1.6 released

[RELEASE] Apache Cassandra 4.1.6 released The Cassandra team is pleased to announce the release of Apache Cassandra version 4.1.6. Apache Cassandra is a fully distributed database. It is the right choice when you need scalability and high availability without compromising performance. http://ca

Re: [DISCUSS] Introduce CREATE TABLE LIKE grammer

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

Re: [DISCUSS] Introduce CREATE TABLE LIKE grammer

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 be

Re: [DISCUSS] Introduce CREATE TABLE LIKE grammer

I think that one important part will be to define the boundaries of the copy. For example, will it also copy the indexes and the Materialized views or only the table schema. Can it be done in a different keyspace? If yes, how about the UDTs if the table uses some? I do not have an opinion. Just rai

[DISCUSS] Introduce CREATE TABLE LIKE grammer

Hello， everyone： As Jira 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 LIKE Before

Re: [VOTE] Release Apache Cassandra 4.1.6 - take 2

With five +1 (four binding) and no -1, the vote passes. I'll work on getting the release published. On Wed, Aug 14, 2024 at 11:54 AM Brandon Williams wrote: > > Proposing the test build of Cassandra 4.1.6 for release. > > sha1: 790de1079811278a2b431c2ced7c7ea02d290a25 > Git: https://github.com/a

Re: [VOTE] Release Apache Cassandra 4.1.6 - take 2

. > The vote will be open for 72 hours (longer if needed). Everyone who > has tested the build is invited to vote. Votes by PMC members are > considered binding. A vote passes if there are at least three binding > +1s and no -1's. > +1 Checked - signing correct - checksums are correct - so