Digant Modha created CASSANDRA-14209: ----------------------------------------
Summary: group by select queries query results differ when using select * vs select fields Key: CASSANDRA-14209 URL: https://issues.apache.org/jira/browse/CASSANDRA-14209 Project: Cassandra Issue Type: Bug Reporter: Digant Modha Attachments: Re group by select queries.txt {{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.}} {{I am using Apache Cassandra 3.10.}} {{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)}} {{Table Description:}} {{CREATE TABLE wp.position (}} {{ account_id text,}} {{ security_id text,}} {{ counter bigint,}} {{ avg_exec_price double,}} {{ pending_quantity double,}} {{ quantity double,}} {{ transaction_id uuid,}} {{ update_time timestamp,}} {{ PRIMARY KEY (account_id, security_id, counter)}} {{) WITH CLUSTERING ORDER BY (security_id ASC, counter DESC)}}{{ }} -- This message was sent by Atlassian JIRA (v7.6.3#76005) --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org For additional commands, e-mail: commits-h...@cassandra.apache.org