Alter materialized view in BigQuery results in "Unexpected statement"
Thomas Ruble
I am getting an error "Unexpected statement type ALTER_MATERIALIZED_VIEW" when following this guide here. How do I alter a materialized view using the DDL?
DavicC
The Unexpected statement type ALTER_MATERIALIZED_VIEW is actually a warning message, not an error. This is the current message prompt but, it has been brought up to Google Cloud for a fix since the message should not be a warning message but a confirmation message.
Executing the command:
ALTER MATERIALIZED VIEW project-id.my_dataset.my_mv_table
SET OPTIONS (enable_refresh=true)
This currently shows the warning message Unexpected statement type ALTER_MATERIALIZED_VIEW. I simulated this in my project and see how it goes.
With my replication, I was to update a materialized view using the same command you found in this article. I used the parameters enable_refresh=false, description="Refresh update to FALSE" for testing purposes. See initial details of the materialized view below.
After executing the command, here's what showed as the prompt.
While the warning message prompt showed, the details I updated in the materialized view were correct. Here is a screenshot of the details of the materialized view after the update.
Thus, you are following the correct article in updating your materialized view.
この記事はインターネットから収集されたものであり、転載の際にはソースを示してください。
侵害の場合は、連絡してください[email protected]
編集
関連記事
Related 関連記事
- 1
Materialized view not updating
- 2
Passing FTS to a materialized view
- 3
difference between view and indexed view or materialized view
- 4
Change column type in a materialized view
- 5
PostgreSQL ALTER VIEW AS
- 6
List grants and privileges for a materialized view in PostgreSQL
- 7
Create primary key on materialized view in Postgres
- 8
Create primary key on materialized view in Postgres
- 9
How to convert to Materialized view query with bind variables
- 10
Navigation View seems to alter color of background
- 11
JMeter View Results in table
- 12
Alter background color of NavBar inserted in App.vue from within sibling router-view component
- 13
BigQuery - Create view with Partition but base table doesn't have
- 14
ClickHouse TTL on materialized column
- 15
View last results on Stack Overflow (Or other website) after reload page
- 16
Popping View Controller Results in Odd navigationItem / backBarButtonItem Title Swap
- 17
ListFragment with a custom view hierarchy results with zero width / height children in onViewCreated
- 18
How to render JSON results nicely into asp.net mvc view
- 19
paginator->links() results in Method Illuminate\View\View::__toString() must not throw an exception
- 20
SQL Oracle 12c で ALTER VIEW を使用してビューに列を追加する方法
- 21
BigQuery | Python | BigQueryテーブルからデータをエクスポートするVIEW
- 22
alter an existing map in hive
- 23
SQL Alter Table WITH Value
- 24
Alter Stata graphing scheme
- 25
MySQL Alter Table
- 26
Plotting a datetime dataframe results in error view limit minimum -36495.50013946759 is less than 1
- 27
BindingSource.count is 1 in .NET4 when data source results view is empty
- 28
How do you default the Windows 10 Explorer view to `Details` when looking at search results?
- 29
Bigquery：ジョブは完了しましたが、job.query_results（）。total_bytes_processedはNoneを返します
コメントを追加