Re: com.datastax.driver.core.exceptions.SyntaxError: line 1:37 no viable alternative at character

2015-06-24 Thread Serega Sheypak
Sorry, misprint //composeQuery() = INSERT INTO packets (id, fingerprint, mark) VALUES (?, ?, ?); PreparedStatement preparedStatement = session.prepare(composeQuery()); //exception happens here! 2015-06-24 11:20 GMT+02:00 Serega Sheypak serega.shey...@gmail.com: Hi, I'm trying to use bounded

Re: After Restart Nodes had lost data

2015-06-24 Thread Jean Tremblay
No, I did not. On 24 Jun 2015, at 06:05, Jason Wee peich...@gmail.commailto:peich...@gmail.com wrote: on the node 192.168.2.100, did you run repair after its status is UN? On Wed, Jun 24, 2015 at 2:46 AM, Jean Tremblay

Re: Counters 2.1 Accuracy

2015-06-24 Thread Phil Yang
IMO, the main concern of C*'s counter is, it is not idempotent. For example, if you add a counter and get a timeout error, you can not know whether it is successful. For non-counter writes, they are idempotent so you can just retry, but if you retry in counter, there may be a double write.

DTCS - nodetool repair - TTL

2015-06-24 Thread Anishek Agarwal
Hello all, We are running c* version 2.0.15. We have 5 nodes with RF=3. We are using DTCS and on all inserts we have a TTL of 30 days. We have no deletes.We just have one CF. When i run nodetool repair on a node i notice a lot of extra sst tables created, this I think is due to the fact that its

com.datastax.driver.core.exceptions.SyntaxError: line 1:37 no viable alternative at character

2015-06-24 Thread Serega Sheypak
Hi, I'm trying to use bounded query and I get weird error: Here is a query: Bounded query: INSERT INTO packets (id, fingerprint, mark) VALUES (?, ?, ?); Here is a code: PreparedStatement preparedStatement = session.prepare(composeQuery()); //composeQuery returns INSERT INTO packets (id,

Re: 10000+ CF support from Cassandra

2015-06-24 Thread Arun Chaitanya
any ideas or advises? On Mon, Jun 22, 2015 at 10:55 AM, Arun Chaitanya chaitan64a...@gmail.com wrote: Hello All, Now we settled on the following approach. I want to know if there are any problems that you foresee in the production environment. Our Approach: Use Off Heap Memory

Re: com.datastax.driver.core.exceptions.SyntaxError: line 1:37 no viable alternative at character

2015-06-24 Thread Serega Sheypak
omg!!! It was some weird unprinted character. That is why C* driver failed to parse it 2015-06-24 11:35 GMT+02:00 Serega Sheypak serega.shey...@gmail.com: Sorry, misprint //composeQuery() = INSERT INTO packets (id, fingerprint, mark) VALUES (?, ?, ?); PreparedStatement preparedStatement

Re: Any use-case about a migration from SQL Server to Cassandra?

2015-06-24 Thread Carlos Alonso
This article from Spotify Labs is a really nice write up of migrating SQL (Postgres in this case) to Cassandra Carlos Alonso | Software Engineer | @calonso https://twitter.com/calonso On 23 June 2015 at 20:23, Alex Popescu al...@datastax.com wrote: On Tue, Jun 23, 2015 at 12:13 PM, Marcos

Re: Adding Nodes With Inconsistent Data

2015-06-24 Thread Jake Luciani
This is no longer an issue in 2.1. https://issues.apache.org/jira/browse/CASSANDRA-2434 We now make sure the replica we bootstrap from is the one that will no longer own that range On Wed, Jun 24, 2015 at 4:58 PM, Alain RODRIGUEZ arodr...@gmail.com wrote: It looks to me that can indeed happen

Re: Adding Nodes With Inconsistent Data

2015-06-24 Thread Alain RODRIGUEZ
It looks to me that can indeed happen theoretically (I might be wrong). However, - Hinted Handoff tends to remove this issue, if this is big worry, you might want to make sure HH are enabled and well tuned - Read Repairs (synchronous or not) might have mitigate things also, if you read fresh

Re: [MASSMAIL]Re: Any use-case about a migration from SQL Server to Cassandra?

2015-06-24 Thread Alain RODRIGUEZ
I guess it is this one, enjoy it: https://labs.spotify.com/2015/06/23/user-database-switch/ :-) 2015-06-24 22:57 GMT+02:00 Marcos Ortiz mlor...@uci.cu: Where is the link, Carlos? On 24/06/15 07:18, Carlos Alonso wrote: This article from Spotify Labs is a really nice write up of migrating

Re: [MASSMAIL]Re: Any use-case about a migration from SQL Server to Cassandra?

2015-06-24 Thread Paulo Ricardo Motta Gomes
https://labs.spotify.com/2015/06/23/user-database-switch/ On Wed, Jun 24, 2015 at 5:57 PM, Marcos Ortiz mlor...@uci.cu wrote: Where is the link, Carlos? On 24/06/15 07:18, Carlos Alonso wrote: This article from Spotify Labs is a really nice write up of migrating SQL (Postgres in this

Re: [MASSMAIL]Re: Any use-case about a migration from SQL Server to Cassandra?

2015-06-24 Thread Marcos Ortiz
Where is the link, Carlos? On 24/06/15 07:18, Carlos Alonso wrote: This article from Spotify Labs is a really nice write up of migrating SQL (Postgres in this case) to Cassandra Carlos Alonso | Software Engineer | @calonso https://twitter.com/calonso On 23 June 2015 at 20:23, Alex Popescu

Re: 10000+ CF support from Cassandra

2015-06-24 Thread Jack Krupansky
By entries, do you mean rows or columns? Please clarify how many columns each of your tables has, and how many rows you are populating for each table. In case I didn't make it clear earlier, limit yourself to low hundreds (like 250) of tables and you should be fine. Thousands of tables is a clear

InvalidQueryException: Invalid amount of bind variables

2015-06-24 Thread Eax Melanhovich
Hello. I'm having some problems with Cassandra driver for Java. Here is a simple Scala project: https://github.com/afiskon/scala-cassandra-example When I run it I get following output: http://paste.ubuntu.com/11767987/ As I understand this piece of code: ``` private val id = id private val

Read is slower in 2.1.6 than 2.0.14?

2015-06-24 Thread Zhiyan Shao
Hi, we recently experimented read performance on both versions and found read is slower in 2.1.6. Here is our setup: 1. Machines: 3 physical hosts. Each node has 24 cores CPU, 256G memory and 8x600GB SAS disks with raid 1. 2. Replica is 3 and a billion rows of data is inserted. 3. Key cache

Re: InvalidQueryException: Invalid amount of bind variables

2015-06-24 Thread Eax Melanhovich
Ok, I discovered that passing Statement instead of string to executeAsync method solves a problem: https://github.com/afiskon/scala-cassandra-example/commit/4f3f30597a4df340f739e4ec53ec9ee3d87da495 Still, according to documentation for getQueryString method described problem should be considered

Range not found after nodetool decommission

2015-06-24 Thread 曹志富
ERROR [OptionalTasks:1] 2015-06-25 08:56:19,156 CassandraDaemon.java:223 - Exception in thread Thread[OptionalTasks:1,5,main] java.lang.AssertionError: -110036444293069784 not found in -- Ranger Tsao

Re: 10000+ CF support from Cassandra

2015-06-24 Thread Arun Chaitanya
Hi Jack, When I mean entries, I meant rows. Each column family has about 200 columns. Disabling of slab allocation is an expert-only feature - its use is generally an anti-pattern, not recommended. I understand this and have seen this recommendation at several places. I want to understand the

Re: 10000+ CF support from Cassandra

2015-06-24 Thread Jack Krupansky
I would say that it's mostly a performance issue, tied to memory management, but the main problem is that a large number of tables invites a whole host of clluster management difficulties that require... expert attention, which then means you need an expert to maintain and enhance it. Cassandra

Adding Nodes With Inconsistent Data

2015-06-24 Thread Anuj Wadehra
Hi, We faced a scenario where we lost little data after adding 2 nodes in the cluster. There were intermittent dropped mutations in the cluster. Need to verify my understanding how this may have happened to do Root Cause Analysis: Scenario: 3 nodes, RF=3, Read / Write CL= Quorum 1. Due to