im getting error like "Tables cannot have more than 0 materialized views, failed to create materialized view"

Question

this is the command I used for creating a table in Cassandra.

create table materialed_main (car_make text,car_model text,id int,department text,frist text, last text,primary key(car_make,car_model,id));

and this is a materialized view for the above table.

create materialized view materialed_view as select * from materialed_main where first is not null and car_make is not null and car_model is not null and id is not null primary key(first,car_make,car_model, id);

but I'm not sure why I'm getting this error

Error from server: code=2200 [Invalid query] message="Tables cannot have more than 0 materialized views, failed to create materialized view materialed_view on table materialed_main"

Answer 1

From documentation:

Note: Materialized views are not available on Astra serverless databases. For more, see Astra database limits

That second page says:

Secondary indexes and materialized views are not available for serverless databases. Our team is working to offer materialized views for serverless databases soon

Answer 2

Use CUSTOM INDEX instead of MATERIALIZED VIEW. Storage-Attached Indexing (SAI)