Amazon Redshift 將不再支援從修補程式 198 開始建立新的 Python UDFs。現有 Python UDF 將繼續正常運作至 2026 年 6 月 30 日。如需詳細資訊，請參閱[部落格文章](https://aws.amazon.com/blogs/big-data/amazon-redshift-python-user-defined-functions-will-reach-end-of-support-after-june-30-2026/)。 本文為英文版的機器翻譯版本，如內容有任何歧義或不一致之處，概以英文版為準。 # SYS\_MV\_STATE 結果包括所有具體化視觀表狀態的相關資訊。它包括基底資料表資訊、結構描述屬性，以及有關最近事件的資訊，例如卸除欄。 所有使用者都可看見 SYS\_MV\_STATE。超級使用者可以看見所有資料列；一般使用者只能看見自己的資料。如需詳細資訊，請參閱[系統資料表和檢視中資料的可見性](cm_chap_system-tables.md#c_visibility-of-data)。 ## 資料表欄 | 欄名稱 | 資料類型 | 說明 | | --- | --- | --- | | user\_id | bigint | 建立事件的使用者 ID。 | | transaction\_id | bigint | 事件的交易 ID。 | | database\_name | char(128) | 包含具體化視觀表的資料庫。 | | event\_desc | char(500) | 提示狀態變更的事件。範例值包括下列各項：[See the AWS documentation website for more details](http://docs.aws.amazon.com/zh_tw/redshift/latest/dg/SYS_MV_STATE.html)請注意，此欄還有其他可能的值。 | | start\_time | timestamp | 事件的開始時間。 | | base\_table\_database\_name | char(128) | 基底資料表的資料庫名稱。 | | base\_table\_schema | char(128) | 基底資料表的結構描述。 | | base\_table\_name | char(128) | 基底資料表的名稱。 | | mv\_schema | char(128) | 具體化視觀表的結構描述。 | | mv\_name | char(128) | 具體化視觀表的名稱。 | | state | character(32) | 具體化視觀表的變更後狀態如下：[See the AWS documentation website for more details](http://docs.aws.amazon.com/zh_tw/redshift/latest/dg/SYS_MV_STATE.html) | ## 範例查詢 下列查詢顯示具體化視觀表的狀態。 ``` select * from sys_mv_state; ``` 此查詢會傳回下列範例輸出： ``` user_id | transaction_id | database_name | event_desc | start_time | base_table_database_name | base_table_schema | base_table_name | mv_schema | mv_name | state ---------+----------------+---------------+-----------------------------+----------------------------+--------------------------+-------------------+---------------------+-------------+----------------------------+-------------- 106 | 12720 | tickit_db | TRUNCATE | 2023-07-26 14:59:12.788268 | tickit_db | mv_schema | test_table_95d6d861 | mv_schema | materialized_view_a1f3f862 | Recompute 106 | 12724 | tickit_db | ALTER TABLE ALTER DISTSTYLE | 2023-07-26 14:59:51.409014 | tickit_db | mv_schema | test_table_58102435 | mv_schema | materialized_view_ca746631 | Recompute 106 | 12720 | tickit_db | Column was renamed | 2023-07-26 14:59:12.822928 | tickit_db | mv_schema | test_table_95d6d861 | mv_schema | materialized_view_5750a8d4 | Unrefreshable 106 | 12727 | tickit_db | Table was renamed | 2023-07-26 15:00:08.051244 | tickit_db | mv_schema | test_table_95d6d861 | mv_schema | materialized_view_5750a8d4 | Unrefreshable 106 | 12720 | tickit_db | Column was renamed | 2023-07-26 14:59:12.857755 | tickit_db | mv_schema | test_table_95d6d861 | mv_schema | materialized_view_5750a8d4 | Unrefreshable 106 | 12727 | tickit_db | Table was renamed | 2023-07-26 15:00:08.051358 | tickit_db | mv_schema | test_table_95d6d861 | mv_schema | materialized_view_5ef0d754 | Unrefreshable 106 | 12720 | tickit_db | TRUNCATE | 2023-07-26 14:59:12.788159 | tickit_db | mv_schema | test_table_95d6d861 | mv_schema | materialized_view_5750a8d4 | Recompute 106 | 12720 | tickit_db | Column was renamed | 2023-07-26 14:59:12.857799 | tickit_db | mv_schema | test_table_95d6d861 | mv_schema | materialized_view_a1f3f862 | Unrefreshable 106 | 12720 | tickit_db | TRUNCATE | 2023-07-26 14:59:12.788327 | tickit_db | mv_schema | test_table_95d6d861 | mv_schema | materialized_view_5ef0d754 | Recompute 106 | 12727 | tickit_db | ALTER TABLE ALTER SORTKEY | 2023-07-26 15:00:08.006235 | tickit_db | mv_schema | test_table_58102435 | mv_schema | materialized_view_ca746631 | Recompute 106 | 12720 | tickit_db | Column was renamed | 2023-07-26 14:59:12.82297 | tickit_db | mv_schema | test_table_95d6d861 | mv_schema | materialized_view_a1f3f862 | Unrefreshable 106 | 12727 | tickit_db | Table was renamed | 2023-07-26 15:00:08.051321 | tickit_db | mv_schema | test_table_95d6d861 | mv_schema | materialized_view_a1f3f862 | Unrefreshable ```