Retrieval using the IN keyword
The IN keyword can define a set of clustering columns to fetch together, supporting a "multi-get" of CQL rows.
Similar to a SQL query, in CQL queries the IN
keyword can define a
set of clustering columns to fetch together, supporting a "multi-get" of CQL rows. A
single clustering column can be defined if all preceding columns are defined for
either equality or group inclusion. Alternatively, several clustering columns may be
defined to collect several rows, as long as all preceding columns are queried for
equality or group inclusion. The defined clustering columns can also be queried for
inequality.
Note that using both IN
and ORDER BY
will require
turning off paging with the PAGING OFF
command in cqlsh.