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 > <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 > <mailto: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
smime.p7s
Description: S/MIME cryptographic signature
