By using AWS re:Post, you agree to the Terms of Use

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

0

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 a month ago44 views
1 Answer
0

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

answered a month 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