Re: COPY command with where condition

2020-01-20 Thread Alex Ott
e contains more than 10.000.000 rows. >> But we need just a sub dataset of this table not the entirety ... >> ---------- >> *De :* Chris Splinter >> *Envoyé :* vendredi 17 janvier 2020 17:40 >> *À :* adrien ruffie >> *Cc :* user@cassandra.apache.org

Re: [EXTERNAL] Re: COPY command with where condition

2020-01-20 Thread Jean Carlo
> > > Sean Durity > > > > *From:* Chris Splinter > *Sent:* Friday, January 17, 2020 1:47 PM > *To:* adrien ruffie > *Cc:* user@cassandra.apache.org; Erick Ramirez > *Subject:* [EXTERNAL] Re: COPY command with where condition > > > > Do you kno

RE: [EXTERNAL] Re: COPY command with where condition

2020-01-17 Thread Durity, Sean R
: Friday, January 17, 2020 1:47 PM To: adrien ruffie Cc: user@cassandra.apache.org; Erick Ramirez Subject: [EXTERNAL] Re: COPY command with where condition Do you know your partition keys? One option could be to enumerate that list of partition keys in separate cmds to make the individual

Re: COPY command with where condition

2020-01-17 Thread Chris Splinter
> *Envoyé :* vendredi 17 janvier 2020 17:40 > *À :* adrien ruffie > *Cc :* user@cassandra.apache.org ; Erick > Ramirez > *Objet :* Re: COPY command with where condition > > What you are seeing there is a standard read timeout, how many rows do you > expect back from that query? > &

RE: COPY command with where condition

2020-01-17 Thread adrien ruffie
20 17:40 À : adrien ruffie Cc : user@cassandra.apache.org ; Erick Ramirez Objet : Re: COPY command with where condition What you are seeing there is a standard read timeout, how many rows do you expect back from that query? On Fri, Jan 17, 2020 at 9:50 AM adrien ruffie mailto:adrien

Re: COPY command with where condition

2020-01-17 Thread Michael Shuler
On 1/17/20 9:50 AM, adrien ruffie wrote: Thank you very much,  so I do this request with for example --> ./dsbulk unload --dsbulk.schema.keyspace 'dev_keyspace' -query "SELECT * FROM probe_sensors WHERE localisation_id = 208812 ALLOW FILTERING" -url /home/dump But I get the following erro

Re: COPY command with where condition

2020-01-17 Thread Chris Splinter
t; > } > } > advanced { > > auth-provider { > class = PlainTextAuthProvider > username = "superuser" > password = "mypass" > > } > } > } > -- > *

RE: COPY command with where condition

2020-01-17 Thread adrien ruffie
_ De : adrien ruffie mailto:adriennolar...@hotmail.fr>> Envoyé : vendredi 17 janvier 2020 11:39 À : Erick Ramirez mailto:flightc...@gmail.com>>; user@cassandra.apache.org<mailto:user@cassandra.apache.org> mailto:user@cassandra.apache.org>> Obje

Re: COPY command with where condition

2020-01-17 Thread Chris Splinter
ffie > *Envoyé :* vendredi 17 janvier 2020 11:39 > *À :* Erick Ramirez ; 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.

Re: COPY command with where condition

2020-01-17 Thread Jean Tremblay
> > > > De : adrien ruffie > Envoyé : vendredi 17 janvier 2020 11:39 > À : Erick Ramirez ; 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. &

RE: COPY command with where condition

2020-01-17 Thread adrien ruffie
___ De : adrien ruffie Envoyé : vendredi 17 janvier 2020 11:39 À : Erick Ramirez ; 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 :

RE: COPY command with where condition

2020-01-17 Thread adrien ruffie
Thank a lot ! It's a good news for DSBulk ! I will take a look around this solution. best regards, Adrian De : Erick Ramirez Envoyé : vendredi 17 janvier 2020 10:02 À : user@cassandra.apache.org Objet : Re: COPY command with where condition The COPY co

Re: COPY command with where condition

2020-01-17 Thread Erick Ramirez
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 b

COPY command with where condition

2020-01-16 Thread adrien ruffie
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 AL