Re: ODBC driver for C* 2.0.xx

2015-01-16 Thread Jens-U. Mozdzen
Hi Minh, Zitat von Ngoc Minh VO : Hello, We are trying to connect some BI tools (eg. Tableau) to our NoSQL database running C* v2.0.6. It seems that the latest Datastax's ODBC driver is not compatible with Cassandra v2.xx (but only with v1.xx, i.e. prior CQL3 era): http://www.datastax.co

Re: C* throws OOM error despite use of automatic paging

2015-01-09 Thread Jens-U. Mozdzen
Hi Mohammed, Zitat von Mohammed Guller : Hi - We have an ETL application that reads all rows from Cassandra (2.1.2), filters them and stores a small subset in an RDBMS. Our application is using Datastax's Java driver (2.1.4) to fetch data from the C* nodes. Since the Java driver supports

Re: ttl in collections

2015-01-06 Thread Jens-U. Mozdzen
Hi Eduardo, Zitat von Eduardo Cusa : [...] I have to worry about the tombstones generated? Considering that I will have many daily set updates that depends on your definition of "many"... we've run into a situation where we wanted to age out old data using TTL... unfortunately, we ran in

table scan speeds

2015-01-04 Thread Jens-U. Mozdzen
Hi *, we're experimenting with a 4-node Cassandra setup, aggregating input streams and persisting time-bucket based aggregation results. One test was to create "full dumps" of a table with around 32 million existing entries. The keyspace was created with a replication factor of 2 and the

Re: Column family ID mismatch-Error on concurrent schema modifications

2014-11-30 Thread Jens-U. Mozdzen
Hi Eric, Zitat von Eric Stevens : @Jens, will "inactive" CFs be released from C*'s memory after i.e. a few days or when under resource pressure? No, certain memory structures are allocated and will remain resident on each node for as long as the table exists. That's good to know, while not

Re: Column family ID mismatch-Error on concurrent schema modifications

2014-11-27 Thread Jens-U. Mozdzen
Hi DuyHai, Zitat von DuyHai Doan : Hello Peter I'm working with Peter and am the one initiating the table creation in my code. For safe concurrent table creation, use CREATE TABLE xxx IF NOT EXISTS. It unfortunately, my code already has the "IF NOT EXISTS" clause in the create stateme