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

Reply via email to