RE: Some questions to updating and tombstone

2016-11-17 Thread Lu, Boying
Very appreciate to all of you, I’ll study the blog. From: Alain RODRIGUEZ [mailto:arodr...@gmail.com] Sent: 2016年11月16日 23:26 To: user@cassandra.apache.org Cc: Fabrice Facorat Subject: Re: Some questions to updating and tombstone Hi Boying, Old value is not tombstone, but remains until

Re: Some questions to updating and tombstone

2016-11-16 Thread Alain RODRIGUEZ
bstoneSca >> nnedHistogram,scope=,type=ColumnFamily Max/Count/99thPercentile/Mean >> >> >> 2016-11-15 10:05 GMT+01:00 Lu, Boying : >> >>> Thanks a lot for your help. >>> >>> >>> >>> We are using STCS strategy and not using TTL >>>

Re: Some questions to updating and tombstone

2016-11-16 Thread Shalom Sagges
; 2016-11-15 10:05 GMT+01:00 Lu, Boying : > >> Thanks a lot for your help. >> >> >> >> We are using STCS strategy and not using TTL >> >> >> >> Is there any API that we can use to query the current number of >> tombstones in a CF? >&

Re: Some questions to updating and tombstone

2016-11-15 Thread Fabrice Facorat
lot for your help. > > > > We are using STCS strategy and not using TTL > > > > Is there any API that we can use to query the current number of tombstones > in a CF? > > > > > > > > *From:* Anuj Wadehra [mailto:anujw_2...@yahoo.co.in] > *Sent:* 2

RE: Some questions to updating and tombstone

2016-11-15 Thread Lu, Boying
Thanks a lot for your help. We are using STCS strategy and not using TTL Is there any API that we can use to query the current number of tombstones in a CF? From: Anuj Wadehra [mailto:anujw_2...@yahoo.co.in] Sent: 2016年11月14日 22:20 To: user@cassandra.apache.org Subject: Re: Some questions to

Re: Some questions to updating and tombstone

2016-11-14 Thread Anuj Wadehra
Hi Boying, I agree with Vladimir.If compaction is not compacting the two sstables with updates soon, disk space issues will be wasted. For example, if the updates are not closer in time, first update might be in a big table by the time second update is being written in a new small table. STCS wo

Re: Some questions to updating and tombstone

2016-11-14 Thread Vladimir Yudovin
Hi Boying, UPDATE write new value with new time stamp. Old value is not tombstone, but remains until compaction. gc_grace_period is not related to this. Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Mon, 14 Nov 2016 03:02:21

Some questions to updating and tombstone

2016-11-14 Thread Lu, Boying
Hi, All, Will the Cassandra generates a new tombstone when updating a column by using CQL update statement? And is there any way to get the number of tombstones of a column family since we want to void generating too many tombstones within gc_grace_period? Thanks Boying

Re: some questions

2016-06-30 Thread Jens Rantil
You forgot FROM in your CQL query. Jens Den sön 26 juni 2016 08:30lowping skrev: > Hi : > > > question 1: > > I got a error about this cql, have you fix it already ??? > select collection_type where id in (‘a’,’b’) > > question 2: > > I want use UDF in update, but this cql can’t execute. have

some questions

2016-06-25 Thread lowping
Hi : question 1: I got a error about this cql, have you fix it already ??? select collection_type where id in (‘a’,’b’) question 2: I want use UDF in update, but this cql can’t execute. have some advise??? update table_name set field=my_function(field) where… tnk u so much

Some questions about setting public/private IP-Addresses in Cassandra Cluster

2015-10-23 Thread Ajay Garg
Hi All. We have a scenario, where the Application-Server (APP), Node-1 (CAS11), and Node-2 (CAS12) are hosted in DC1. Node-3 (CAS21) and Node-4 (CAS22) are in DC2. The intention is that we provide 4-way redundancy to APP, by specifying CAS11, CAS12, CAS21 and CAS22 as the addresses via Java-Cassa

Re: Some questions to adding a new datacenter into cassandra cluster.

2014-05-02 Thread Patricia Gorla
On Wed, Apr 30, 2014 at 10:21 AM, Arindam Barua wrote: > Since we don’t change the seeds configuration in the yaml files of DC1 and > DC2, how do DC1 and DC2 know the nodes in the DC3 if they reboot for some > reason later? Additional note: you want to have at least one seed node per availabili

RE: Some questions to adding a new datacenter into cassandra cluster.

2014-04-30 Thread Arindam Barua
Answers inline. From: Lu, Boying [mailto:boying...@emc.com] Sent: Wednesday, April 30, 2014 12:20 AM To: user@cassandra.apache.org Subject: Some questions to adding a new datacenter into cassandra cluster. Hi, All, I need to add a Cassandra (running on a three nodes) fresh installed in a

Some questions to adding a new datacenter into cassandra cluster.

2014-04-30 Thread Lu, Boying
Hi, All, I need to add a Cassandra (running on a three nodes) fresh installed in a datacenter say DC3 to existing Cassandra datacenters say DC1 and DC2. I read the document about it at http://www.datastax.com/documentation/cassandra/2.0/cassandra/operations/ops_add_dc_to_cluster_t.html But I h

Re: Some questions about the write operation and hinted handoff

2010-07-08 Thread Jonathan Ellis
On Thu, Jul 8, 2010 at 10:45 PM, ChingShen wrote: > Ok, If so, I suppose that A sends requests to B, C and D nodes(RF=3) at > CL.QUORUM, but D is down, then return success message to the client, and A > write a hint to E node? until D comes back up then E forwards the data to D? If it knows that

Re: Some questions about the write operation and hinted handoff

2010-07-08 Thread ChingShen
On Fri, Jul 9, 2010 at 4:32 AM, Jonathan Ellis wrote: > If the coordinator knows it can't achieve the requested CL it won't do > any writes, hinted or otherwise, and will immediately report > UnavailableException to the client. > To summarize: hinted writes are only generated when Cassandra (a) >

Re: Some questions about the write operation and hinted handoff

2010-07-08 Thread Jonathan Ellis
Right, if the nodes are marked up but do not confirm the writes, it will result in a TimedOutException. (It still won't generate hinted writes). To summarize: hinted writes are only generated when Cassandra (a) knows a target is down ahead of time and (b) still has enough UP targets to satisfy th

Re: Some questions about the write operation and hinted handoff

2010-07-08 Thread Benjamin Black
To clarify, this requires the coordinator know nodes are down. If the nodes are marked UP, but do not confirm the writes, this behavior does not seem possible. On Thu, Jul 8, 2010 at 11:31 AM, Jonathan Ellis wrote: > On Thu, Jul 8, 2010 at 1:19 PM, Benjamin Black wrote: >> On Thu, Jul 8, 2010 a

Re: Some questions about the write operation and hinted handoff

2010-07-08 Thread Benjamin Black
Important safety tip, I did not know that. On Thu, Jul 8, 2010 at 11:31 AM, Jonathan Ellis wrote: > On Thu, Jul 8, 2010 at 1:19 PM, Benjamin Black wrote: >> On Thu, Jul 8, 2010 at 9:02 AM, ChingShen wrote: >>> Hmm.. as you mentioned that it will write a hint and report success at >>> CL.ANY, do

Re: Some questions about the write operation and hinted handoff

2010-07-08 Thread Jonathan Ellis
On Thu, Jul 8, 2010 at 1:19 PM, Benjamin Black wrote: > On Thu, Jul 8, 2010 at 9:02 AM, ChingShen wrote: >> Hmm.. as you mentioned that it will write a hint and report success at >> CL.ANY, does the hinted handoff only work at CL.ANY? >> > > Still no.  Hints are written when nodes are down, regar

Re: Some questions about the write operation and hinted handoff

2010-07-08 Thread Benjamin Black
On Thu, Jul 8, 2010 at 9:02 AM, ChingShen wrote: > Hmm.. as you mentioned that it will write a hint and report success at > CL.ANY, does the hinted handoff only work at CL.ANY? > Still no. Hints are written when nodes are down, regardless of CL, unless HH is disabled. CL does not influence whet

Re: Some questions about the write operation and hinted handoff

2010-07-08 Thread ChingShen
Hmm.. as you mentioned that it will *write a hint *and report success at CL.ANY, does the hinted handoff only work at CL.ANY? Thanks. On Thu, Jul 8, 2010 at 11:29 PM, Jonathan Ellis wrote: > On Thu, Jul 8, 2010 at 10:23 AM, ChingShen > wrote: > > Thanks Jonathan Ellis, > > > > I want to make

Re: Some questions about the write operation and hinted handoff

2010-07-08 Thread Jonathan Ellis
On Thu, Jul 8, 2010 at 10:23 AM, ChingShen wrote: > Thanks Jonathan Ellis, > >   I want to make sure that after A return failure message to client at > CL.ONE, does A write a hint to C? No. -- Jonathan Ellis Project Chair, Apache Cassandra co-founder of Riptano, the source for professional Cass

Re: Some questions about the write operation and hinted handoff

2010-07-08 Thread ChingShen
Thanks Jonathan Ellis, I want to make sure that after A return failure message to client at CL.ONE, *does A write a hint to C?* If so, although the write operation is failed, but the data is still stored in C? if B comes back up, then C forwards to B? Shen On Thu, Jul 8, 2010 at 10:08 PM, Jona

Re: Some questions about the write operation and hinted handoff

2010-07-08 Thread Jonathan Ellis
On Thu, Jul 8, 2010 at 12:45 AM, ChingShen wrote: > hmm... I'm really confused. > The http://wiki.apache.org/cassandra/API document mentioned that if write > ConsistencyLevel=ANY that "Ensure the write has been written to at least 1 > node, including hinted recipients.", I couldn't imagine this ca

Re: Some questions about the write operation and hinted handoff

2010-07-07 Thread ChingShen
hmm... I'm really confused. The http://wiki.apache.org/cassandra/API document mentioned that if write ConsistencyLevel=ANY that "Ensure the write has been written to at least 1 node, including hinted recipients.", I couldn't imagine this case. :( If I have A,B,C and D nodes(RF=1), and write Consis

Re: Some questions about the write operation and hinted handoff

2010-07-07 Thread Jonathan Ellis
No, it means that HH writes don't count towards meeting the requested ConsistencyLevel. On Wed, Jul 7, 2010 at 9:36 PM, ChingShen wrote: > So, does it mean that only the CL=ZERO and CL=ANY support hinted handoff, > right? > > Thanks. > > Shen > > On Wed, Jul 7, 2010 at 11:28 PM, Jonathan Ellis w

Re: Some questions about the write operation and hinted handoff

2010-07-07 Thread ChingShen
So, does it mean that only the CL=ZERO and CL=ANY support hinted handoff, right? Thanks. Shen On Wed, Jul 7, 2010 at 11:28 PM, Jonathan Ellis wrote: > does http://wiki.apache.org/cassandra/HintedHandoff help? > > On Wed, Jul 7, 2010 at 10:16 AM, ChingShen > wrote: > > Thanks Jonathan Ellis, >

Re: Some questions about the write operation and hinted handoff

2010-07-07 Thread Jonathan Ellis
does http://wiki.apache.org/cassandra/HintedHandoff help? On Wed, Jul 7, 2010 at 10:16 AM, ChingShen wrote: > Thanks Jonathan Ellis, > >   If so, how does the hinted handoff work? I thought the coordinator node > will write the data to another node(e.g. G node), I'm confused. > > Shen > >> >> > S

Re: Some questions about the write operation and hinted handoff

2010-07-07 Thread ChingShen
Thanks Jonathan Ellis, If so, how does the hinted handoff work? I thought the coordinator node will write the data to another node(e.g. G node), I'm confused. Shen > > Second, if > > B node is down during the write operation, does it return failure(CL=ALL) > to > > user? > > yes > > -- > Jona

Re: Some questions about the write operation and hinted handoff

2010-07-07 Thread Jonathan Ellis
On Tue, Jul 6, 2010 at 10:05 PM, ChingShen wrote: > Hi all, > >   I have A, B, C, D, E, F and G nodes(RF=3), if I run a write > operation(CL=ALL) on "A" node(coordinator), and the key range between A and > B, therefore, the data will be stored on B, C and D nodes, right? depends on replication st

Some questions about the write operation and hinted handoff

2010-07-06 Thread ChingShen
Hi all, I have A, B, C, D, E, F and G nodes(RF=3), if I run a write operation(CL=ALL) on "A" node(coordinator), and the key range between A and B, therefore, the data will be stored on B, C and D nodes, right? Second, if B node is down during the write operation, does it return failure(CL=ALL) t

Re: Some questions about using Cassandra

2010-06-17 Thread Benjamin Black
Thursday, 17 June 2010 5:46 PM > To: user@cassandra.apache.org > Subject: Re: Some questions about using Cassandra > > On Thu, Jun 17, 2010 at 1:20 AM, Anthony Ikeda > wrote: >> Thanks Gary, I'm looking at that plug-in feature at the moment but there >> seem

RE: Some questions about using Cassandra

2010-06-17 Thread Anthony Ikeda
Thanks Sylvia, I would like to actually do that actually. Any idea how I can get started? -Original Message- From: Sylvain Lebresne [mailto:sylv...@yakaz.com] Sent: Thursday, 17 June 2010 5:46 PM To: user@cassandra.apache.org Subject: Re: Some questions about using Cassandra On Thu

Re: Some questions about using Cassandra

2010-06-17 Thread Sylvain Lebresne
distributed database it’s going to be used more for a > cache or our database. As I said this process depends on which sync protocol > we decide on (messaging, clustering, cloud, etc). > > > > Anthony > > > > > > From: Gary Dusbabek [mailto:gdusba...@gmail

RE: Some questions about using Cassandra

2010-06-16 Thread Anthony Ikeda
g, cloud, etc). Anthony From: Gary Dusbabek [mailto:gdusba...@gmail.com] Sent: Thursday, 17 June 2010 2:20 AM To: user@cassandra.apache.org Subject: Re: Some questions about using Cassandra On Tue, Jun 15, 2010 at 19:49, Anthony Ikeda wrote: Is there any concept of Listeners s

Re: Some questions about using Cassandra

2010-06-16 Thread Gary Dusbabek
On Tue, Jun 15, 2010 at 19:49, Anthony Ikeda wrote: > Is there any concept of Listeners such that when data is added to Cassandra > we can fire off another process to do something with that data? E.g. create > a copy in a secondary database for Business Intelligence reports? Send the > data to an

Re: Some questions about using Cassandra

2010-06-16 Thread Oleg Anastasjev
Anthony Ikeda cardlink.com.au> writes: > One factor I need to consider is our Business > Intelligence platform that will need to use the data stored for reporting > purposes. > >   > > We are looking at using Cassandra for our real-time layer for > Active-Active data centre use and perhaps have

RE: Some questions about using Cassandra

2010-06-15 Thread Anthony Ikeda
Thanks Benjamin. Looking at the 'plugins' now :) -Original Message- From: Benjamin Black [mailto:b...@b3k.us] Sent: Wednesday, 16 June 2010 11:35 AM To: user@cassandra.apache.org Subject: Re: Some questions about using Cassandra On Tue, Jun 15, 2010 at 6:07 PM, Anthony Ik

Re: Some questions about using Cassandra

2010-06-15 Thread Rob Coli
On 6/15/10 6:35 PM, Benjamin Black wrote: jmhodges contributed a patch (I remain incompetent at Jira searches) for 'coprocessors' to do what you want. That'd be where I'd start looking. https://issues.apache.org/jira/browse/CASSANDRA-1016 =Rob

Re: Some questions about using Cassandra

2010-06-15 Thread Benjamin Black
https://issues.apache.org/jira/browse/CASSANDRA-1016 'Plugins', excuse me. b

Re: Some questions about using Cassandra

2010-06-15 Thread Benjamin Black
On Tue, Jun 15, 2010 at 6:07 PM, Anthony Ikeda wrote: > > Thanks Jonathan, I was only asking about the event listeners because an > alternative we are considering is TIBCO Active Spaces which draws quite a lot > of parallels to Cassandra. > > Based on painful production experience, I would not

RE: Some questions about using Cassandra

2010-06-15 Thread Anthony Ikeda
have Oracle installed alongside for non-real-time use such that data is mediated to the Oracle database for other uses. Anthony From: Jonathan Shook [mailto:jsh...@gmail.com] Sent: Wednesday, 16 June 2010 10:58 AM To: user@cassandra.apache.org Subject: Re: Some questions about using

Re: Some questions about using Cassandra

2010-06-15 Thread Jonathan Shook
requirements go. > > > > On Tue, Jun 15, 2010 at 7:49 PM, Anthony Ikeda < > anthony.ik...@cardlink.com.au> wrote: > >> We are currently looking at a distributed database option and so far >> Cassandra ticks all the boxes. However, I still have some questions. >> >&

Re: Some questions about using Cassandra

2010-06-15 Thread Jonathan Shook
ra ticks all the boxes. However, I still have some questions. > > > > Is there any need for archiving of Cassandra and what backup options are > available? As it is a no-data-loss system I’m guessing archiving is not > exactly relevant. > > > > Is there any concept of

Some questions about using Cassandra

2010-06-15 Thread Anthony Ikeda
We are currently looking at a distributed database option and so far Cassandra ticks all the boxes. However, I still have some questions. Is there any need for archiving of Cassandra and what backup options are available? As it is a no-data-loss system I'm guessing archiving is not ex

Re: Some questions about using Binary Memtable to import data.

2010-05-20 Thread Jonathan Ellis
On Wed, May 19, 2010 at 1:37 AM, Peng Guo wrote: > Thanks for you information. > > I look at some source code of the implement. There still some question: > > 1 How did I know that the binary write message send to endpoint success? It doesn't. It's fire-and-forget. If you look at the example it

Re: Some questions about using Binary Memtable to import data.

2010-05-19 Thread Peng Guo
> But after I look at the wiki > > intro:http://wiki.apache.org/cassandra/BinaryMemtable > > > > I have some questions about using BinaryMemtable > > > > Will the data be replicated automatic? > > Can we modify the data that already exist in Cassandra? > > W

Re: Some questions about using Binary Memtable to import data.

2010-05-18 Thread Jonathan Ellis
ache.org/cassandra/BinaryMemtable > > I have some questions about using BinaryMemtable > > Will the data be replicated automatic? > Can we modify the data that already exist in Cassandra? > What will happen if we not turn off compaction? > What will happen if the data beyond the limite

Some questions about using Binary Memtable to import data.

2010-05-18 Thread Peng Guo
Hi All: I am trying to use Binary Memtable to import a large number of data. But after I look at the wiki intro: http://wiki.apache.org/cassandra/BinaryMemtable I have some questions about using BinaryMemtable 1. Will the data be replicated automatic? 2. Can we modify the data that