DSBulk has an option that lets you specify the query ( including a WHERE clause )
See Example 19 in this blog post for details: https://www.datastax.com/blog/2019/06/datastax-bulk-loader-unloading On Fri, Jan 17, 2020 at 7:34 AM Jean Tremblay < jean.tremb...@zen-innovations.com> wrote: > Did you think about using a Materialised View to generate what you want to > keep, and then use DSBulk to extract the data? > > On 17 Jan 2020, at 14:30 , adrien ruffie <adriennolar...@hotmail.fr> > wrote: > > Sorry I come back to a quick question about the bulk loader ... > > https://www.datastax.com/blog/2018/05/introducing-datastax-bulk-loader > > I read this : "Operations such as converting strings to lowercase, > arithmetic on input columns, or filtering out rows based on some criteria, > are not supported. " > > Consequently, it's still not possible to use a WHERE clause with DSBulk, > right ? > > I don't really know how I can do it, in order to don't keep the wholeness > of business data already stored and which don't need to export... > > > > ------------------------------ > *De :* adrien ruffie <adriennolar...@hotmail.fr> > *Envoyé :* vendredi 17 janvier 2020 11:39 > *À :* Erick Ramirez <flightc...@gmail.com>; user@cassandra.apache.org < > user@cassandra.apache.org> > *Objet :* RE: COPY command with where condition > > Thank a lot ! > It's a good news for DSBulk ! I will take a look around this solution. > > best regards, > Adrian > ------------------------------ > *De :* Erick Ramirez <flightc...@gmail.com> > *Envoyé :* vendredi 17 janvier 2020 10:02 > *À :* user@cassandra.apache.org <user@cassandra.apache.org> > *Objet :* Re: COPY command with where condition > > The COPY command doesn't support filtering and it doesn't perform well for > large tables. > > Have you considered the DSBulk tool from DataStax? Previously, it only > worked with DataStax Enterprise but a few weeks ago, it was made free and > works with open-source Apache Cassandra. For details, see this blogpost > <https://www.datastax.com/blog/2019/12/tools-for-apache-cassandra>. > Cheers! > > On Fri, Jan 17, 2020 at 6:57 PM adrien ruffie <adriennolar...@hotmail.fr> > wrote: > > Hello all, > > In my company we want to export a big dataset of our cassandra's ring. > We search to use COPY command but I don't find if and how can a WHERE > condition can be use ? > > Because we need to export only several data which must be return by a > WHERE closure, specially > and unfortunately with ALLOW FILTERING due to several old tables which > were poorly conceptualized... > > Do you know a means to do that please ? > > Thank all and best regards > > Adrian > > >