Re: Scala driver

Hello, I'm also using the Java driver. Its evolving the fastest and is simple to use Thanks Jabbar Azam On 2 Sep 2014 06:15, "Gary Zhao" wrote: > Thanks Jan. I decided to use Java driver directly. It's not hard to use. > > > On Sun, Aug 31, 2014 at 1:08 AM, Jan Algermissen < > jan.algermis...@n

Re: EC2 - Performace Question

Count(*) queries are very inefficient - you'll want to take Michael's advice and use counter tables On Mon, Sep 1, 2014 at 9:26 PM, Johnny Miller wrote: > Try turning on query tracing to see what's taking lots of time. > > On 1 Sep 2014, at 23:54, "Laing, Michael" > wrote: > > Is there a reaso

Re: Java sample code for non-blocking async query

This is what I used in scala - you'll need the 'toFuture' implicit to do executeAsync asynchronously https://github.com/eigengo/activator-akka-cassandra/blob/master/src/main/scala/core/cassandra.scala On Mon, Sep 1, 2014 at 10:14 PM, Gary Zhao wrote: > Hello > > I'm looking for non-blocking as

Re: Scala driver

Thanks Jan. I decided to use Java driver directly. It's not hard to use. On Sun, Aug 31, 2014 at 1:08 AM, Jan Algermissen wrote: > Hi Gary, > > On 31 Aug 2014, at 07:19, Gary Zhao wrote: > > Hi > > Could you recommend a Scala driver and share your experiences of using it. > Im thinking if i us

Java sample code for non-blocking async query

Hello I'm looking for non-blocking async query sample code. The one I found in the following link is async query but blocking. Could anyone share such code? http://www.datastax.com/documentation/developer/java-driver/1.0/java-driver/asynchronous_t.html Thanks Gary

Re: OpsCenter_rollups*

@Rob - You can have OpsCenter not write to the cluster it's monitoring: http://www.datastax.com/dev/blog/storing-opscenter-data-in-a-separate-cluster. OpsCenter has supported this for sometime. On 26 Aug 2014, at 12:07, Mark Reddy wrote: >> Why is there so much OpsCenter work happening? > > O

Re: EC2 - Performace Question

Try turning on query tracing to see what's taking lots of time. > On 1 Sep 2014, at 23:54, "Laing, Michael" wrote: > > Is there a reason why updating a counter for this information will not work > for you? > >> On Monday, September 1, 2014, eduardo.cusa >> wrote: >> yes, is the same table, m

Re: EC2 - Performace Question

Is there a reason why updating a counter for this information will not work for you? On Monday, September 1, 2014, eduardo.cusa < eduardo.c...@usmediaconsulting.com> wrote: > yes, is the same table, my mistake. > > > On Mon, Sep 1, 2014 at 6:35 PM, Laing, Michael [via [hidden email] >

Re: EC2 - Performace Question

yes, is the same table, my mistake. On Mon, Sep 1, 2014 at 6:35 PM, Laing, Michael [via cassandra-u...@incubator.apache.org] < ml-node+s3065146n7596569...@n2.nabble.com> wrote: > Is table track_user equivalent to table userpixel? > > On Monday, September 1, 2014, Eduardo Cusa <[hidden email] > <

Re: EC2 - Performace Question

Is table track_user equivalent to table userpixel? On Monday, September 1, 2014, Eduardo Cusa < eduardo.c...@usmediaconsulting.com> wrote: > Hi All. I Have a Cluster in Amazon with the following settings: > > * 2 Nodes M3.Large > * Cassandra 2.0.7 > * Default instaltion on ubuntu > > And I have o

EC2 - Performace Question

Hi All. I Have a Cluster in Amazon with the following settings: * 2 Nodes M3.Large * Cassandra 2.0.7 * Default instaltion on ubuntu And I have one table with 5.000.000 rows: CREATE TABLE track_user ( userid text, trackid text,date text ,advid text, country text, region text,

Re: Help with select IN query in cassandra

Thanks Michael I will certainly go with this approach for now. -Subodh On Mon, Sep 1, 2014 at 6:33 AM, Laing, Michael wrote: > This should work for your query requirements - 2 tables w same info because > disk is cheap and writes are fast so optimize for reads: > > CREATE TABLE sensor_asset ( >

Re: Help with select IN query in cassandra

I am guessing OP => Original Poster. I had not asked about deletion, but Jack thanks for your suggestion for overall handling of deletion. For the type of sensor data I am collecting we really don't want to delete the data as we want to figure out data trend over real long term ( 1, 2 years). BTW

Re: Help with select IN query in cassandra

I did see a reference to deletions: “overall approaches considering volumes, deletion, compaction etc.” Did I merely misunderstand the reference? That’s all I was responding to... sorry if my misunderstanding added any confusion! -- Jack Krupansky From: Laing, Michael Sent: Monday, September 1

Re: Help with select IN query in cassandra

Did the OP propose that? On Mon, Sep 1, 2014 at 10:53 AM, Jack Krupansky wrote: > One comment on deletions – aren’t deletions kind of an anti-pattern for > modern data processing, such as sensor data, time series data, and social > media? I mean, isn’t it usually better to return a full histo

Re: Help with select IN query in cassandra

One comment on deletions – aren’t deletions kind of an anti-pattern for modern data processing, such as sensor data, time series data, and social media? I mean, isn’t it usually better to return a full history of the data, with some aging scheme, and manage the tracking of which values are “curr

Re: Help with select IN query in cassandra

This should work for your query requirements - 2 tables w same info because disk is cheap and writes are fast so optimize for reads: CREATE TABLE sensor_asset ( asset_id text, event_time timestamp, tuuid timeuuid, sensor_reading map, sensor_serial_number text, sensor_type int, PRIMAR

Re: Help with migration from Thrift to CQL3 on Cassandra 2.0.10

On Sun, Aug 31, 2014 at 2:59 AM, Todd Nine wrote: > Hi all, > I'm working on transferring our thrift DAOs over to CQL. It's going > well, except for 2 cases that both use multi get. The use case is very > simple. It is a narrow row, by design, with only a few columns. When I > perform a mul