Re: Cqlsh copy command on a larger data set

2020-07-16 Thread Jai Bheemsen Rao Dhanwada
thank you On Thu, Jul 16, 2020 at 12:29 PM Alex Ott wrote: > look into a series of the blog posts that I sent, I think that it should > be in the 4th post > > On Thu, Jul 16, 2020 at 8:27 PM Jai Bheemsen Rao Dhanwada < > jaibheem...@gmail.com> wrote: > >> okay, is there a way to export the TTL

Re: Cqlsh copy command on a larger data set

2020-07-16 Thread Alex Ott
look into a series of the blog posts that I sent, I think that it should be in the 4th post On Thu, Jul 16, 2020 at 8:27 PM Jai Bheemsen Rao Dhanwada < jaibheem...@gmail.com> wrote: > okay, is there a way to export the TTL using CQLsh or DSBulk? > > On Thu, Jul 16, 2020 at 11:20 AM Alex Ott

Re: Cqlsh copy command on a larger data set

2020-07-16 Thread Jai Bheemsen Rao Dhanwada
okay, is there a way to export the TTL using CQLsh or DSBulk? On Thu, Jul 16, 2020 at 11:20 AM Alex Ott wrote: > if you didn't export TTL explicitly, and didn't load it back, then you'll > get not expirable data. > > On Thu, Jul 16, 2020 at 7:48 PM Jai Bheemsen Rao Dhanwada < >

Re: Cqlsh copy command on a larger data set

2020-07-16 Thread Alex Ott
if you didn't export TTL explicitly, and didn't load it back, then you'll get not expirable data. On Thu, Jul 16, 2020 at 7:48 PM Jai Bheemsen Rao Dhanwada < jaibheem...@gmail.com> wrote: > In tried verify metadata, In case of writetime it is setting it as insert > time but the TTL value is

Re: Cqlsh copy command on a larger data set

2020-07-16 Thread Jai Bheemsen Rao Dhanwada
In tried verify metadata, In case of writetime it is setting it as insert time but the TTL value is showing as null. Is this expected? Does this mean this record will never expire after the insert? Is there any alternative to preserve the TTL ? In the new Table inserted with Cqlsh and Dsbulk

Re: what is allowed and not allowed w.r.t altering cassandra table schema

2020-07-16 Thread Alex Ott
Hi This is a quite big topic, maybe it should be a topic for a blog post, etc. I've spent some time working with customers on that, so here is my TLDR: - You can add regular columns (not part of the primary key) to a table. You must not to add the column with the same name as another