[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

asked 2 years ago304 views
1 Answer

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

answered 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions