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:41, Modha, Digant <digant.mo...@tdsecurities.com<mailto:digant.mo...@tdsecurities.com>> wrote: It was local quorum. There’s no difference with CONSISTENCY ALL. Consistency level set to LOCAL_QUORUM. cassandra@cqlsh> select * from wp.position where account_id = 'user_1'; account_id | security_id | counter | avg_exec_price | pending_quantity | quantity | transaction_id | update_time ------------+-------------+---------+----------------+------------------+----------+----------------+--------------------------------- user_1 | AMZN | 2 | 1239.2 | 0 | 1011 | null | 2018-01-25 17:18:07.158000+0000 user_1 | AMZN | 1 | 1239.2 | 0 | 1010 | null | 2018-01-25 17:18:07.158000+0000 (2 rows) cassandra@cqlsh> select * from wp.position where account_id = 'user_1' group by security_id; account_id | security_id | counter | avg_exec_price | pending_quantity | quantity | transaction_id | update_time ------------+-------------+---------+----------------+------------------+----------+----------------+--------------------------------- user_1 | AMZN | 1 | 1239.2 | 0 | 1010 | null | 2018-01-25 17:18:07.158000+0000 (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 | counter | avg_exec_price | quantity | update_time ------------+-------------+---------+----------------+----------+--------------------------------- user_1 | AMZN | 2 | 1239.2 | 1011 | 2018-01-25 17:18:07.158000+0000 (1 rows) cassandra@cqlsh> consistency all; Consistency level set to ALL. cassandra@cqlsh> select * from wp.position where account_id = 'user_1' group by security_id; account_id | security_id | counter | avg_exec_price | pending_quantity | quantity | transaction_id | update_time ------------+-------------+---------+----------------+------------------+----------+----------------+--------------------------------- user_1 | AMZN | 1 | 1239.2 | 0 | 1010 | null | 2018-01-25 17:18:07.158000+0000 (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 | counter | avg_exec_price | quantity | update_time ------------+-------------+---------+----------------+----------+--------------------------------- user_1 | AMZN | 2 | 1239.2 | 1011 | 2018-01-25 17:18:07.158000+0000 From: kurt greaves [mailto:k...@instaclustr.com<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 direct or consequential caused by the use of this information. This communication is for informational purposes only and is not intended as an offer or solicitation for the purchase or sale of any financial instrument or as an official confirmation of any transaction. TD Securities is neither making any investment recommendation nor providing any professional or advisory services relating to the activities described herein. All market prices, data and other information are not warranted as to completeness or accuracy and are subject to change without notice Any products described herein are (i) not insured by the FDIC, (ii) not a deposit or other obligation of, or guaranteed by, an insured depository institution and (iii) subject to investment risks, including possible loss of the principal amount invested. The information shall not be further distributed or duplicated in whole or in part by any means without the prior written consent of TD Securities. TD Securities is a trademark of The Toronto-Dominion Bank and represents TD Securities (USA) LLC and certain investment banking activities of The Toronto-Dominion Bank and its subsidiaries. TD Securities disclaims any liability or losses either direct or consequential caused by the use of this information. This communication is for informational purposes only and is not intended as an offer or solicitation for the purchase or sale of any financial instrument or as an official confirmation of any transaction. TD Securities is neither making any investment recommendation nor providing any professional or advisory services relating to the activities described herein. All market prices, data and other information are not warranted as to completeness or accuracy and are subject to change without notice Any products described herein are (i) not insured by the FDIC, (ii) not a deposit or other obligation of, or guaranteed by, an insured depository institution and (iii) subject to investment risks, including possible loss of the principal amount invested. The information shall not be further distributed or duplicated in whole or in part by any means without the prior written consent of TD Securities. TD Securities is a trademark of The Toronto-Dominion Bank and represents TD Securities (USA) LLC and certain investment banking activities of The Toronto-Dominion Bank and its subsidiaries.
