Re: timeuuid and cql3 query

2013-06-19 Thread Davide Anastasia
Hi Tyler, I am interested in this scenario as well: could you please elaborate further your answer? Thanks a lot, Davide On 19 Jun 2013 16:01, "Tyler Hobbs" wrote: > > On Wed, Jun 19, 2013 at 8:08 AM, Ryan, Brent wrote: > >> >> CREATE TABLE count3 ( >> counter text, >> ts timeuuid, >> ke

Re: Bulk loader with Cassandra 1.2.5

2013-06-08 Thread Davide Anastasia
; password varchar, > age int, > email varchar) > WITH COMPACT STORAGE > and compaction = {'class' : 'LeveledCompactionStrategy' } > > From: Davide Anastasia > Reply-To: "user@cassandra.apache.org" > Date: Friday, June 7, 2013 2:1

Data model for financial time series

2013-06-07 Thread Davide Anastasia
Hi, I am trying to build the storage of stock prices in Cassandra. My queries are ideally of three types: - give me everything between time A and time B; - give me everything about symbol X; - give me everything of type Y; ...or an intersection of the three. Something I will be happy doing is: - g

Re: Bulk loader with Cassandra 1.2.5

2013-06-07 Thread Davide Anastasia
varchar, > age int, > email varchar) > > WITH COMPACT STORAGE > > and compaction = {'class' : 'LeveledCompactionStrategy' } > > > From: Davide Anastasia > Reply-To: "user@cassandra.apache.org" > Date: Frida

Re: Bulk loader with Cassandra 1.2.5

2013-06-06 Thread Davide Anastasia
Hi, I've just tried to change it to integer and I get exactly the same error. Thanks, Davide On 6 June 2013 23:53, Keith Wright wrote: > Could it be because you are writing age as a long but have it defined as an > integer in the table definition? > > Davide Anastasia wrot

Bulk loader with Cassandra 1.2.5

2013-06-06 Thread Davide Anastasia
Hi, I am currently using Cassandra 1.2.5 on RHEL6 with Oracle JVM. I want to try to build a bulk loader for stock prices that I have available in CSV format. However, I have started exploring Cassandra from something easier, focussing on the example available in the manual. I cannot manage to have