【详述】show create view default_catalog.dataplatform_caspian_xr0527.tongbu_view2;
±-------------±------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------±---------------------±---------------------+
| View | Create View | character_set_client | collation_connection |
±-------------±------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------±---------------------±---------------------+
| tongbu_view2 | CREATE VIEW tongbu_view2 (id, name) SECURITY NONE AS (SELECT default_catalog.dataplatform_caspian_xr0527.tongbu_table.id, default_catalog.dataplatform_caspian_xr0527.tongbu_table.name
FROM default_catalog.dataplatform_caspian_xr0527.tongbu_table); | utf8 | utf8_general_ci |
±-------------±------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------±---------------------±---------------------+
use iceberg.dataplatform_caspian_xr0527;
Database changed
mysql> SELECT * FROM default_catalog.dataplatform_caspian_xr0527.tongbu_view2;
ERROR 5502 (42602): Getting analyzing error. Detail message: View dataplatform_caspian_xr0527.tongbu_view2 references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them: Getting analyzing error. Detail message: Unknown table ‘dataplatform_caspian_xr0527.tongbu_table’…
【背景】做过哪些操作？
【业务影响】无法跨 catalog 访问 view
【是否存算分离】是
【StarRocks版本】例如：4.0.9
【集群规模】例如：3fe（1 follower+2observer）+40cn
【联系方式】xlrei@163.com