Re: Group By Does Not Follow Clustering Order

2019-03-25 Thread Joseph Wonesh
ce_id). > > > > > > *From:* Kenneth Brotman [mailto:kenbrot...@yahoo.com.INVALID] > *Sent:* Thursday, February 21, 2019 3:38 PM > *To:* user@cassandra.apache.org > *Subject:* RE: Group By Does Not Follow Clustering Order > > > > Joseph, > > > > In this

RE: Group By Does Not Follow Clustering Order

2019-02-21 Thread Kenneth Brotman
primary key should have a compound partition key of (project_id, policy_id, device_id). From: Kenneth Brotman [mailto:kenbrot...@yahoo.com.INVALID] Sent: Thursday, February 21, 2019 3:38 PM To: user@cassandra.apache.org Subject: RE: Group By Does Not Follow Clustering Order Joseph

RE: Group By Does Not Follow Clustering Order

2019-02-21 Thread Kenneth Brotman
re already doing “policy_id=7331 and device_id=’1234567890’” and returning one (limit 1)? Kenneth Brotman From: Joseph Wonesh [mailto:joseph.won...@sticknfind.com] Sent: Thursday, February 21, 2019 10:39 AM To: user@cassandra.apache.org Subject: Re: Group By Does Not Follow Clustering Order

Re: Group By Does Not Follow Clustering Order

2019-02-21 Thread Joseph Wonesh
Hi all, I am bumping this email hoping that it can reach a larger audience. Thanks, Joseph On Tue, Feb 12, 2019 at 11:45 AM Joseph Wonesh wrote: > Hello, > > I have a materialized view defined by the following: > > CREATE MATERIALIZED VIEW m_ps_project_policy_device0 AS >SELECT policy_