Re: Adding New Nodes/Data Center to an existing Cluster.

Neha/Sebastian, Sorry for the typo. We use DSE 4.7 which ships with Cassandra 2.1 Regards Sachin On Tue, Sep 1, 2015 at 10:04 PM, Neha Trivedi wrote: > Sachin, > Hope you are not using Cassandra 2.2 in production? > regards > Neha > > On Tue, Sep 1, 2015 at 11:20 PM, Sebastian Estevez < > sebast

SELECT DISTINCT and rows with only static columns

I have a columnfamily with static columns and non-static columns. When I have a row with values only in the static columns, select distinct will return that row, whereas select will not. For example: cqlsh> select distinct id from members where id = 'zyto-8c0db'; plan_id zyto-8c0d

Re: Order By limitation or bug?

This query would be reasonable to support, so I've opened https://issues.apache.org/jira/browse/CASSANDRA-10271 to fix that. On Thu, Sep 3, 2015 at 7:48 PM, Alec Collier wrote: > You should be able to execute the following > > > > SELECT data FROM import_file WHERE roll = 1 AND type = 'foo' ORDE

Convert joins in RDBMS to Cassandra

1. Hi All, 1. I am trying to model RDBMS joins into cassandra. As I am new to cassandra, I need your help/suggestion on this. Below is the information regarding the query: 2. 3. I have a query in RDBMS as follows: 4. 5. select t3.name from Table1 t1, Table2 t2, Table3

Re: who does generate timestamp during the write?

Timestamps can come from three different places, in order of precedence from highest to lowest: * The CQL query itself through the "USING TIMESTAMP" clause * The driver (or maybe application) at the protocol level when using the v3 native protocol or higher (which is available in Cassandra 2.1+).

Old SSTables lying around

Hey, We're running a Cassandra 2.2.0 cluster with 8 nodes. We are doing frequent updates to our data and we have very few reads, and we are using Leveled Compaction with a sstable_size_in_mb of 160MB. We don't have that much data currently since we're just testing the cluster. We are seeing the SS

Re: Why I can not do a "count(*) ... allow filtering " without facing operation timeout?

I hope this is not a production query... All the best, [image: datastax_logo.png] Sebastián Estévez Solutions Architect | 954 905 8615 | sebastian.este...@datastax.com [image: linkedin.png] [image: facebook.png]

tablesnap / tableslurp usage pointers?

Hi, I'm trying to use tablesnap [1] for disaster recovery backups, and while my uploads seem to be working fine, I can't figure out how to run the associated tableslurp tool for restores. If I pass the full S3 path to the individual table to tableslurp, it will restore that table, but if I try to

Re: who does generate timestamp during the write?

I meant thrift based api. If we are talking about CQL then timestamps are generated by node you are connected to. This is a "client". On Fri, Sep 4, 2015 at 10:49 AM, ibrahim El-sanosi wrote: > Hi Andrey, > > I just came across this articale " > > "Each cell in a CQL table has a corresponding ti

Re: who does generate timestamp during the write?

Hi Andrey, I just came across this articale " "Each cell in a CQL table has a corresponding timestamp which is taken from the clock on *the Cassandra node* *that orchestrates the write.* When you are reading from a Cassandra cluster the node that coordinates the read will compare the timestamps o

Re: who does generate timestamp during the write?

Coordinator doesn't generate timestamp, it is generated by client. On Fri, Sep 4, 2015 at 10:37 AM, ibrahim El-sanosi wrote: > Ok, why coordinator does generate timesamp, as the write is a part of > Cassandra process after client submit the request to Cassandra? > > On Fri, Sep 4, 2015 at 6:29 P

Re: who does generate timestamp during the write?

Ok, why coordinator does generate timesamp, as the write is a part of Cassandra process after client submit the request to Cassandra? On Fri, Sep 4, 2015 at 6:29 PM, Andrey Ilinykh wrote: > Your application. > > On Fri, Sep 4, 2015 at 10:26 AM, ibrahim El-sanosi < > ibrahimsaba...@gmail.com> wro

Re: who does generate timestamp during the write?

Your application. On Fri, Sep 4, 2015 at 10:26 AM, ibrahim El-sanosi wrote: > Dear folks, > > When we hear about the notion of Last-Write-Wins in Cassandra according to > timestamp, *who does generate this timestamp during the write, > coordinator or each individual replica in which the write is

who does generate timestamp during the write?

Dear folks, When we hear about the notion of Last-Write-Wins in Cassandra according to timestamp, *who does generate this timestamp during the write, coordinator or each individual replica in which the write is going to be stored?* *Regards,* *Ibrahim*

Re: Repair documentation

It was a typo in the first test, it should be /repair -h 127.0.0.1 -p 7100 repair -pr -hosts 127.0.0.2 127.0.0.3 /and not /repair -h 127.0.0.1 -p 7100 repair -pr 127.0.0.2 127.0.0.3/ / /BR Marcus Olsson On 09/04/2015 02:50 PM, Marcus Olsson wrote: Hi, While checking the repair documentation

Repair documentation

Hi, While checking the repair documentation at http://docs.datastax.com/en/cassandra/2.1/cassandra/tools/toolsRepair.html I noticed the line***Use the **-hosts**option to list the good nodes to use for repairing the bad nodes. Use **-h**to name the bad nodes.* and below there was an example:

Re: Incremental repair from the get go

Starting up fresh it is totally OK to just start using incremental repairs On Thu, Sep 3, 2015 at 10:25 PM, Jean-Francois Gosselin < jfgosse...@gmail.com> wrote: > > On fresh install of Cassandra what's the best approach to start using > incremental repair from the get go (I'm using LCS) ? > > Ru

Re: Data Size on each node

Hi, I agree with Alain, we have the same kind of problem here (4 DCs, ~1TB / node) and we are replacing our big servers full of spinning drives with a bigger number of smaller servers with SSDs (microservers are quite efficient in terms of rack space and cost). Kévin On Tue, Sep 1, 2015 at 1:11

Re: Why I can not do a "count(*) ... allow filtering " without facing operation timeout?

Hi, Checkout CASSANDRA-8899, my guess is that you have to increase the timeout in cqlsh. /Tommy On 2015-09-04 10:31, shahab wrote: Hi, This is probably a silly problem , but it is really serious for me. I have a cluster of 3 nodes, with replication factor 2. But still I can not do a simpl

Why I can not do a "count(*) ... allow filtering " without facing operation timeout?

Hi, This is probably a silly problem , but it is really serious for me. I have a cluster of 3 nodes, with replication factor 2. But still I can not do a simple "select count(*) from ..." neither using DevCenter nor "cqlsh" . Any idea how this can be done? best, /Shahab

Re: Cassandra 2.2 for time series

This solution is very "sql-like", meaning that you query what you want when you need it. Unfortunately this will probably not scale as your data grows, you might want to consider de-normalizing your data. You could maintain a min/max average in the application that inserts the data, or have a batch