Re: Running select against cassandra

2020-02-06 Thread Erick Ramirez
> > Also is materialized view good for production? I agree with Sean's and Reid's sentiments about MVs. I still think of MVs as being experimental and not ready for primetime. I would wait for the improvements which may be coming in C* 4.0 but no promises there... yet. :) Cheers!

Re: Running select against cassandra

2020-02-06 Thread Abdul Patel
hursday, February 6, 2020 at 4:24 PM > *To: *"user@cassandra.apache.org" > *Subject: *RE: [EXTERNAL] Re: Running select against cassandra > > > > *Message from External Sender* > > Reid is right. You build the tables to easily answer the queries you want. > So, st

Re: [EXTERNAL] Re: Running select against cassandra

2020-02-06 Thread Reid Pinchback
? and minute = ? Sean Durity From: Reid Pinchback Sent: Thursday, February 6, 2020 4:10 PM To: user@cassandra.apache.org Subject: Re: [EXTERNAL] Re: Running select against cassandra Abdul, When in doubt, have a query model that immediately feeds you exactly what you are looking for. That’s kin

RE: [EXTERNAL] Re: Running select against cassandra

2020-02-06 Thread Durity, Sean R
:10 PM To: user@cassandra.apache.org Subject: Re: [EXTERNAL] Re: Running select against cassandra Abdul, When in doubt, have a query model that immediately feeds you exactly what you are looking for. That’s kind of the data model philosophy that you want to shoot for as much as feasible with C

RE: [EXTERNAL] Re: Running select against cassandra

2020-02-06 Thread Durity, Sean R
From reports on this mailing list, I do not allow materialized views. Sean Durity From: Reid Pinchback Sent: Thursday, February 6, 2020 4:10 PM To: user@cassandra.apache.org Subject: Re: [EXTERNAL] Re: Running select against cassandra Abdul, When in doubt, have a query model that immediately

Re: [EXTERNAL] Re: Running select against cassandra

2020-02-06 Thread Reid Pinchback
. You might want a composite partition key for having an efficient selection of narrow time ranges. From: Abdul Patel Reply-To: "user@cassandra.apache.org" Date: Thursday, February 6, 2020 at 2:42 PM To: "user@cassandra.apache.org" Subject: Re: [EXTERNAL] Re: Running sele

Re: [EXTERNAL] Re: Running select against cassandra

2020-02-06 Thread Abdul Patel
f your reporting requires > different granularities, you could consider a different time bucket for the > table (by hour, by week, etc.) > > > > > > Sean Durity – Staff Systems Engineer, Cassandra > > > > *From:* Abdul Patel > *Sent:* Thursday, February 6, 20

RE: [EXTERNAL] Re: Running select against cassandra

2020-02-06 Thread Durity, Sean R
bucket for the table (by hour, by week, etc.) Sean Durity – Staff Systems Engineer, Cassandra From: Abdul Patel Sent: Thursday, February 6, 2020 1:54 PM To: user@cassandra.apache.org Subject: [EXTERNAL] Re: Running select against cassandra Its sort of user connected, app team needa number of

Re: Running select against cassandra

2020-02-06 Thread Abdul Patel
Also is materialized view good for production? We are on 3.11.4 On Thursday, February 6, 2020, Abdul Patel wrote: > Its sort of user connected, app team needa number of active users > connected say every 1 to 5 mins. > The timeout at app end is 120ms. > > > > On Thursday, February 6, 2020, Mich

Re: Running select against cassandra

2020-02-06 Thread Abdul Patel
Its sort of user connected, app team needa number of active users connected say every 1 to 5 mins. The timeout at app end is 120ms. On Thursday, February 6, 2020, Michael Shuler wrote: > You'll have to be more specific. What is your table schema and what is the > SELECT query? What is the nor

Re: Running select against cassandra

2020-02-06 Thread Michael Shuler
You'll have to be more specific. What is your table schema and what is the SELECT query? What is the normal response time? As a basic guide for your general question, if the query is something sort of irrelevant that should be stored some other way, like a total row count, or most any SELECT t