question

aaaseva avatar image
aaaseva asked Erick Ramirez edited

Why is the materialised view limit per table set to 0 on my Astra DB?

Datastax Astra Database

Cannot create materialized view on a table.

Database UUID

70f5e36a-a942-42b5-9fdb-ff403d8fa17f/database/d8df253d-e6b7-4393-bea8-ffe580004f51
https://astra.datastax.com/org/70f5e36a-a942-42b5-9fdb-ff403d8fa17f/database/d8df253d-e6b7-4393-bea8-ffe580004f51

Error message:

cqlsh:ks_flights_v2> CREATE MATERIALIZED VIEW IF NOT EXISTS delays AS     SELECT DayOfWeek, Origin, UniqueCarrier, FlightNum, DepDelay     FROM flights     PRIMARY KEY (DayOfWeek, Origin, UniqueCarrier, DepDelay) ;
InvalidRequest: Error from server: code=2200 [Invalid query] message="Tables cannot have more than 0 materialized views, failed to create materialized view delays on table flights"

According to documentation, Astra supports up to two materialized views per table

astramaterialized views
10 |1000
Toggle Comment visibility. Current Visibility: Viewable by all users

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 Erick Ramirez edited

[EDITED] I just got reminded by the team that materialised views are currently not supported on Astra serverless DBs (any new DB created after March 4, 2021).

I don't have visibility of the Astra roadmap so I'm not able to say when MVs will be supported again.

I will update my post whenever I get more details. Cheers!

1 comment Share
10 |1000
Toggle Comment visibility. Current Visibility: Viewable by all users

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

aaaseva avatar image aaaseva commented ·

Done

70f5e36a-a942-42b5-9fdb-ff403d8fa17f/database/d8df253d-e6b7-4393-bea8-ffe580004f51

0 Likes 0 ·