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

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

Re: Counters 2.1 Accuracy

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. 2015-06

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

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 : > Hi, I'm trying to use bounded query and I get weird err

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

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 : > Sorry, misprint > //composeQuery() => INSERT INTO packets (id, fingerprint, mark) VALUES > (?, ?, ?); > PreparedStatement preparedStatement = session.prepare(co

Re: 10000+ CF support from Cassandra

any ideas or advises? On Mon, Jun 22, 2015 at 10:55 AM, Arun Chaitanya 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 > > Modifications to def

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

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 On 23 June 2015 at 20:23, Alex Popescu wrote: > > On Tue, Jun 23, 2015 at 12:13 PM, Marcos Ortiz wrote: > >>

Re: 10000+ CF support from Cassandra

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 clea

InvalidQueryException: Invalid amount of bind variables

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

Re: InvalidQueryException: Invalid amount of bind variables

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

Re: 10000+ CF support from Cassandra

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 c

Adding Nodes With Inconsistent Data

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 o

Re: 10000+ CF support from Cassandra

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 sc

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

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 On 23 June 2015 at 20:23, Alex Popescu

Re: Adding Nodes With Inconsistent Data

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 data

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

https://labs.spotify.com/2015/06/23/user-database-switch/ On Wed, Jun 24, 2015 at 5:57 PM, Marcos Ortiz 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 case) to Ca

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

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 : > 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 > (Po

Re: Adding Nodes With Inconsistent Data

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 wrote: > It looks to me that can indeed happen theoretically (I m

Read is slower in 2.1.6 than 2.0.14?

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 capac

Range not found after nodetool decommission

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: Read is slower in 2.1.6 than 2.0.14?

I am amazed to see that you don't have OOM with this setup... 1 - for performances and given Cassandra replication properties an I/O usage you might want to try with a Raid0. But I imagine this is tradeoff. 2 - A billion is quite a few and any of your nodes takes the full load. You might want to