Re: Accessing dynamic columns via cqlsh

2015-10-15 Thread Onur Yalazı
to accomplish all the same business functionality using CQL, but you might not be able to create a CQL schema that maps exactly to the data at rest for your historic schema. On Thu, Oct 15, 2015 at 8:54 AM Onur Yalazı <mailto:onur.yal...@8digits.com>> wrote: Hello, I have

Accessing dynamic columns via cqlsh

2015-10-15 Thread Onur Yalazı
Hello, I have a cassandra cluster from pre-cql era and I am having problems accessing data via cqlsh. As you can see below, I can not reach dynamic columns via cqlsh but they are accessible via cassandra-cli. How can I make the data shown on cqlsh? cqlsh:automation> select * from "EventKeys

Re: Consistency Issues

2015-10-01 Thread Onur Yalazı
Thank you Jake. The issue is I do not have missing CF's and upgrading beyond 2.1.3 is not a possibility because of the deprecation of cql dialects. Our application is using Hector and migrating to cql3 is a huge refactoring. On 01/10/15 15:48, Jake Luciani wrote: Couple things to try. 1. n

cqlsh strange inconsistency

2015-10-01 Thread Onur Yalazı
Hello, I have a table with a status field and a secondary index on that table. Every row has 1 or -1 status values. I have these queries run from cqlsh with the results: consistency all; select count(*) from table; /** 1901 Select count(*) from table where status=1; /** 27 select count(*) fro