'BQ error [80324028] in querying Materialized View

We are getting following error when we are querying freshly created Materialized view. We could also see the Materialized View listed in INFORMATION_SCHEMA table. Have retried several times but getting same error.

An internal error
occurred and the request could not be completed. This is usually caused by a transient issue. Retrying the job with back-off as described in the
BigQuery SLA should solve the problem: https://cloud.google.com/bigquery/sla. If the error continues to occur please contact support at
https://cloud.google.com/support. Error: 80324028

We have retried querying the view multiple times but no luck. We have tried creating and querying with normal columns (without aggregation) also. Have tried creating a Standard View at the same time and was able to query it.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source