I created a reflection on a 1 million row fact table, and am getting an error querying it.
select * from fact1 limit 10
Failed to decode column metric9::double
When I delete the reflection, the query works fine (it’s getting passed to a Redshift data source). If I create the reflection again, same error (although the error is on a different column).
I have a few other tables that are dimension tables with only a hundred or a thousand rows, and querying against them works fine with reflections.
So I’m wondering if it’s the amount of data that’s causing problems.