question

Hariharan avatar image
Hariharan asked Erick Ramirez answered

How can I create a table with both clustering order and NodeSync enabled?

How can I create a table having both Clustering order by and nodesync enabled ?

Since nodesync can be enabled on per table basis, how can I achieve both in create table statement ?

dsecql
10 |1000

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

1 Answer

Erick Ramirez avatar image
Erick Ramirez answered

Here's the CQL command for it:

CREATE TABLE ... (
  ...
) WITH CLUSTERING ORDER BY (somecolumn DESC)
  ...
  AND nodesync = {'enabled': 'true', 'incremental': 'true'};

For more info, see the CQL CREATE TABLE command. Cheers!

Share
10 |1000

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.