[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.
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
Relevant questions
How to create Athena View using CDK
Accepted Answerasked 9 months agoAre redshift auto materialized views schema bound?
asked 2 months agoDoes SCT support converting Oracle View to Redshift View?
asked 4 months agoSetting up refresh schedules for Amazon Redshift materialized view
Accepted Answerasked 2 years agoHow can I drop a RedShift AutoMV?
Accepted Answerasked 2 months agoOracle materialized view replication to postgres using DMS CDC
asked 3 months agoCase sensitivity problem in view of JSON in a SUPER column
asked a year ago[bug report] Sagemaker data wrangler: An error occurred loading this view
asked 3 months ago[Bug] AVG() function does not work in Redshift materialized view
asked a month agoredshift does not create view with no schema binding with recursive cte inside
asked 8 months ago