Jira created: CASSANDRA-14209.
From: kurt greaves [mailto:k...@instaclustr.com]
Sent: Thursday, February 01, 2018 12:38 AM
To: User
Subject: Re: group by select queries
Seems problematic. Would you be able to create a JIRA ticket with the above
information/examples?
On 30 January 2018 at 22
gt;>
>> (1 rows)
>>
>> cassandra@cqlsh> select account_id,security_id, counter,
>> avg_exec_price,quantity, update_time from wp.position where account_id =
>> 'user_1' group by security_id ;
>>
>>
>>
>> account_id | security_id |
by security_id ;
>
>
>
> account_id | security_id | counter | avg_exec_price | quantity |
> update_time
>
> ----+-+-++--
> +-
>
> user_1 |AMZN | 2 | 1239.2 |
:18:07.158000+
From: kurt greaves [mailto:k...@instaclustr.com]
Sent: Monday, January 29, 2018 11:03 PM
To: User
Subject: Re: group by select queries
What consistency were you querying at? Can you retry with CONSISTENCY ALL?
TD Securities disclaims any liability or losses either
What consistency were you querying at? Can you retry with CONSISTENCY ALL?
HI,
I get two different out with these 2 queries. The only difference between the
2 queries is that one does 'select *' and other does 'select specific fields'
without any aggregate functions. Does group by pick any record? It seems to
pick either the first or the last record. I expected th