Cassandra: ORDER BY should do it in memory instead of trying to push down Cassandra in some cases

Create keyspace and tables cqlsh> CREATE KEYSPACE mykeyspace WITH REPLICATION = { 'class' : 'SimpleStrategy', 'replication_fact or' : 1} ; cqlsh> use mykeyspace; cqlsh:mykeyspace> CREATE TABLE users (user_id int PRIMARY KEY, fname text, lname text); cqlsh:mykeyspace> INSERT INTO users (user_id, fname, lname) VALUES (1745, 'john', 'smith'); cqlsh:mykeyspace> INSERT INTO users (user_id, fname, lname) VALUES (1744, 'john', 'doe'); cqlsh:mykeyspace> INSERT INTO users (user_id, fname, lname) VALUES (1746, 'john', 'smith'); cqlsh:mykeyspace> CREATE TABLE invoice (invoice_id int PRIMARY KEY, user_id int, sale double); cqlsh:mykeyspace> INSERT INTO invoice (invoice_id, user_id, sale) VALUES (1001, 1745, 10000); cqlsh:mykeyspace> INSERT INTO invoice (invoice_id, user_id, sale) VALUES (1002, 1745, 5000); cqlsh:mykeyspace> INSERT INTO invoice (invoice_id, user_id, sale) VALUES (1003, 1746, 20000); Build VDS for Cassandra mykeyspace Run the following SQL using teiid: select "cassandraDS_users"."user_id" as "cassandraDS_users_user_id", "cassandraDS_invoice"."sale" as "cassandraDS_invoice_sale" from "cassandraDS"."invoice" "cassandraDS_invoice" inner join "cassandraDS"."users" "cassandraDS_users" on ("cassandraDS_invoice"."user_id" = "cassandraDS_users"."user_id")