I'm using apache spark on top of cassandra for such cases
Sent using Zoho Mail
---- On Mon, 09 Apr 2018 18:00:33 +0430 DuyHai Doan
<doanduy...@gmail.com> wrote ----
No, sorting by column other than clustering column is not possible
On Mon, Apr 9, 2018 at 11:42 AM, Eunsu Kim <eunsu.bil...@gmail.com> wrote:
Hello, everyone.
I am using 3.11.0 and I have the following table.
CREATE TABLE summary_5m (
service_key text,
hash_key int,
instance_hash int,
collected_time timestamp,
count int,
PRIMARY KEY ((service_key), hash_key, instance_hash, collected_time)
)
And I can sum count grouping by primary key.
select service_key, hash_key, instance_hash, sum(count) as count_summ
from apm.ip_summary_5m
where service_key='ABCED'
group by service_key, hash_key, instance_hash;
But what I want is to get only the top 100 with a high value added.
Like following query is attached … (syntax error, of course)
order by count_sum limit 100;
Anybody have ever solved this problem?
Thank you in advance.
