Visibility CQL DDL runs into error on Astra DB

Community Support
1

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?

2

We don’t have Astra-specific schema on OSS yet.

I believe you are correct and that for astra temporal/schema.cql at master · temporalio/temporal · GitHub
needs to be updated. Double checking with server team and will get back to you.