The CREATE statement ‘CREATE TABLE open_executions’ from temporal/schema.cql at master · temporalio/temporal · GitHub runs into an error on Astra DB:
“error executing statement:Clustering key columns must exactly match columns in CLUSTERING ORDER BY directive”
Changing the ‘order by’ expression to (start_time DESC, run_id DESC) solves the issue but not sure if runtime behavior is affected?
Suggest to update the DDL to be compatible with current Astra DB version. Or is there another way to handle this?