Bringing together the Apache Cassandra experts from the community and DataStax.

Want to learn? Have a question? Want to share your expertise? You are in the right place!

Not sure where to begin? Getting Started

 

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 characters needed characters left characters exceeded

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 characters needed characters left characters exceeded

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

Done

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

0 Likes 0 ·