Using ODBC connection to Redshift I set up with AWS drivers. I can preview some queries without a problem. I can also fetch results from all queries I've tried. However, when I try to preview one table in particular I get the error:
"Error Previewing SQL:
missing value where TRUE/FALSE needed"
The query I'm using is simply:
-- !preview conn=con
SELECT * FROM table_name LIMIT 100
The exact same format is working for the other tables.
I can run the exact same query with DBI::dbSendQuery and fetch the result without getting any error. Could it be a problem with column formats?