{"record":{"id":"917c4dfeb298aa91","repo":"risingwavelabs/risingwave","slug":"set-config-is-only-supported-for-materialized-view","errorCode":null,"errorMessage":"SET CONFIG is only supported for materialized views","messagePattern":"SET CONFIG is only supported for materialized views","errorType":"error_code","errorClass":null,"httpStatus":null,"severity":"error","filePath":"src/frontend/src/handler/mod.rs","lineNumber":1224,"sourceCode":"                        bail!(\n                            \"ALTER VIEW SET STREAMING_ENABLE_UNALIGNED_JOIN is not supported. Only supported for materialized views\"\n                        );\n                    }\n                    alter_streaming_enable_unaligned_join::handle_alter_streaming_enable_unaligned_join(handler_args, name, enable).await\n                }\n                AlterViewOperation::AsQuery { query } => {\n                    if !materialized {\n                        bail_not_implemented!(\"ALTER VIEW AS QUERY\");\n                    }\n                    // `ALTER MATERIALIZED VIEW AS QUERY` is only available in development build now.\n                    if !cfg!(debug_assertions) {\n                        bail_not_implemented!(\"ALTER MATERIALIZED VIEW AS QUERY\");\n                    }\n                    alter_mv::handle_alter_mv(handler_args, name, query).await\n                }\n                AlterViewOperation::SetConfig { entries } => {\n                    if !materialized {\n                        bail!(\"SET CONFIG is only supported for materialized views\");\n                    }\n                    alter_streaming_config::handle_alter_streaming_set_config(\n                        handler_args,\n                        name,\n                        entries,\n                        statement_type,\n                    )\n                    .await\n                }\n                AlterViewOperation::ResetConfig { keys } => {\n                    if !materialized {\n                        bail!(\"RESET CONFIG is only supported for materialized views\");\n                    }\n                    alter_streaming_config::handle_alter_streaming_reset_config(\n                        handler_args,\n                        name,\n                        keys,\n                        statement_type,","sourceCodeStart":1206,"sourceCodeEnd":1242,"githubUrl":"https://github.com/risingwavelabs/risingwave/blob/6469eb736d691e8e9b8a419a57edd6429ca77417/src/frontend/src/handler/mod.rs#L1206-L1242","documentation":"`ALTER ... SET CONFIG` adjusts streaming configuration of a streaming job, which only materialized views have. When the altered object is a plain view (not materialized), the handler rejects the operation.","triggerScenarios":"Running `ALTER VIEW <name> SET CONFIG (<key> = <value>)` where `<name>` is a regular VIEW created via `CREATE VIEW`.","commonSituations":"Mixing up `ALTER VIEW` and `ALTER MATERIALIZED VIEW` syntax; copy-pasting tuning commands between views and MVs.","solutions":["Use `ALTER MATERIALIZED VIEW <name> SET CONFIG (...);` instead","Confirm the object is an MV via `SHOW MATERIALIZED VIEWS LIKE '<name>';`","For plain views, change the underlying query definition with `ALTER VIEW <name> AS <query>` instead"],"exampleFix":"// before\nALTER VIEW my_v SET CONFIG (streaming_use_fetch_operator = true);\n// after\nALTER MATERIALIZED VIEW my_mv SET CONFIG (streaming_use_fetch_operator = true);","handlingStrategy":"validation","validationCode":"SELECT name FROM rw_catalog.rw_mviews WHERE name = 'my_object';\n-- only proceed with ALTER ... SET CONFIG if a row exists","typeGuard":null,"tryCatchPattern":null,"preventionTips":["Use ALTER MATERIALIZED VIEW ... SET CONFIG for streaming config changes","Confirm object type with SHOW MATERIALIZED VIEWS before ALTER","For plain views use ALTER VIEW ... AS <query> instead"],"tags":["sql","alter","config"],"backgroundTag":"operation-not-supported","analyzedSha":"6469eb736d691e8e9b8a419a57edd6429ca77417","analyzedAt":"2026-09-11T21:06:21.487Z","contentChangedAt":"2026-09-11T21:06:21.487Z","schemaVersion":2},"datasetVersion":"2026-09-23T08:17:48.524Z"}