Exporting selected CQL data to SQL
Use export options to select columns for export and limit the page size of the export. You can conditionally filter the data to select for export.
In DataStax Enterprise 4.5.2, you can use new export options to select certain columns for export and limit the page size of the export. You can also conditionally filter the data you select for export using the --cassandra-where-clause option <clause>. You enclose the CQL WHERE clause in double quotation marks.
This example creates a CQL table of columns of different data types, inserts values into the table, and exports the data to SQL.