CODEWITHSUNDEEP
cassandracqlcassandra-3.0
user306080
user306080

Reputation: 1519

SELECT clause in Cassandra CQL

I need to run the following query (SQL syntax)

select AGGREGATE_NAME AS NAME, KEYSPACE_NAME from SYSTEM_SCHEMA.AGGREGATES
UNION ALL
select TRIGGER_NAME AS NAME, KEYSPACE_NAME from SYSTEM_SCHEMA.TRIGGERS

But, of course, Cassandra does not support UNION ALL. How to write this in one query like this in Cassandra CQL?

Upvotes: 1

Views: 260

Answers (1)

Jim Wartnick
Jim Wartnick

Reputation: 2196

As you're doing a UNION ALL (all rows), simply write it as two separate queries and concatenate your results. Easiest answer I can think of.

-Jim

Upvotes: 3

Related Questions