{"record":{"id":"06a8287b11d5f1ec","repo":"risingwavelabs/risingwave","slug":"alter-view-set-streaming-enable-unaligned-join-is","errorCode":null,"errorMessage":"ALTER VIEW SET STREAMING_ENABLE_UNALIGNED_JOIN is not supported. Only supported for materialized views","messagePattern":"ALTER VIEW SET STREAMING_ENABLE_UNALIGNED_JOIN is not supported\\. Only supported for materialized views","errorType":"error_code","errorClass":null,"httpStatus":null,"severity":"error","filePath":"src/frontend/src/handler/mod.rs","lineNumber":1206,"sourceCode":"                        PbThrottleTarget::Mv,\n                        rate_limit_type_to_throttle_type(rate_limit.rate_limit_type),\n                        name,\n                        rate_limit.rate_limit,\n                    )\n                    .await\n                }\n                AlterViewOperation::SwapRenameView { target_view } => {\n                    alter_swap_rename::handle_swap_rename(\n                        handler_args,\n                        name,\n                        target_view,\n                        statement_type,\n                    )\n                    .await\n                }\n                AlterViewOperation::SetStreamingEnableUnalignedJoin { enable } => {\n                    if !materialized {\n                        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\");","sourceCodeStart":1188,"sourceCodeEnd":1224,"githubUrl":"https://github.com/risingwavelabs/risingwave/blob/6469eb736d691e8e9b8a419a57edd6429ca77417/src/frontend/src/handler/mod.rs#L1188-L1224","documentation":"In the ALTER VIEW handler, `ALTER VIEW ... SET STREAMING_ENABLE_UNALIGNED_JOIN` was executed against a view rather than a materialized view. The unaligned-join streaming option only applies to materialized views (which own stream fragments), so the statement is rejected.","triggerScenarios":"Running `ALTER VIEW <name> SET STREAMING_ENABLE_UNALIGNED_JOIN = true|false` where `<name>` is a regular VIEW (materialized = false).","commonSituations":"Confusing `ALTER VIEW` with `ALTER MATERIALIZED VIEW`; applying tuning knobs documented for MVs to plain views.","solutions":["Use `ALTER MATERIALIZED VIEW <name> SET STREAMING_ENABLE_UNALIGNED_JOIN = <bool>;`","Confirm the object is an MV with `SHOW MATERIALIZED VIEWS LIKE '<name>';`","Remove the setting if the target is a plain view — it has no streaming join"],"exampleFix":"// before\nALTER VIEW my_v SET STREAMING_ENABLE_UNALIGNED_JOIN = true;\n// after\nALTER MATERIALIZED VIEW my_mv SET STREAMING_ENABLE_UNALIGNED_JOIN = true;","handlingStrategy":"validation","validationCode":"SELECT name FROM rw_catalog.rw_mviews WHERE name = 'my_object';\n-- only proceed with ALTER ... SET STREAMING_ENABLE_UNALIGNED_JOIN if a row exists","typeGuard":null,"tryCatchPattern":null,"preventionTips":["Use ALTER MATERIALIZED VIEW for streaming settings","Confirm object type with catalog queries before ALTER","Keep plain views free of streaming tuning knobs"],"tags":["sql","alter","materialized-view"],"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"}