[Bug] AVG() function does not work in Redshift materialized view

If I create a materialized view using the AVG() function, it raises an error when I query data from that view. Meanwhile, the function works just fine on a normal view.

I'm attaching below the query to replicate this bug.

SQL query to replicate the bug

Topics: Analytics Database
Tags: Amazon Redshift Database
Language: English

EA-Notional-TS

asked 4 years ago518 views

1 Answer

Newest
Most votes
Most comments

Are these answers helpful? Upvote the correct answer to help the community benefit from your knowledge.

If you have a support ticket with AWS please post the ticket number here and we can review this in more details.

AWS-User-4882824

answered 4 years ago

Relevant content

How to List Views (CREATE VIEW) Without Materialized Views in Amazon Redshift?
dashline
asked 3 years ago
Possible bug with Materialized View refreshes in Redshift
nacho
asked 3 years ago
Redshift: cross-database queries are not working for materialized views.
Nazarii
asked 2 years ago
Query errors during refresh of Redshift Materialized Views
tjtoll
asked 3 years ago
How do I resolve the "Underlying table with oid of view does not exist" error that I receive when refreshing Redshift materialized views?
AWS OFFICIALUpdated 3 years ago
Why doesn’t my materialized view refresh for my Amazon Redshift cluster?
AWS OFFICIALUpdated a year ago
How do I resolve the "Log group does not exist" error for Lambda function logs in the CloudWatch console?
AWS OFFICIALUpdated 3 months ago
How do I create an AWS Lambda function that runs queries in Amazon Redshift?
AWS OFFICIALUpdated 4 months ago
Complex Materialized View creation using Redshift Nested Materialized Views
EXPERT
Samir Kakli
published 2 years ago
Understanding Auto Materialized Views with Amazon Redshift Zero ETL
EXPERT
AmritaAWS
published 8 months ago

[Bug] AVG() function does not work in Redshift materialized view

Add your answer

Relevant content