When Starrocks is used in shared-data mode, are materialized views created on s3 or in local storage? If on S3, Is there anything that would lock data to specific nodes (e.g. colocation), or is data just loaded and cached on whatever nodes are free?
on remote storage, local storage is just for cache and yes, they are. partition and bucketing model still applies in shared data, however not as strict as the shared nothing mode in some cases.