Error Previewing SQL

RStudio IDE
1

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?

2

Hi @davidpb90, if you are able to provide more information, I think it would be worth opening an Issue in the RStudio GitHub repo: https://github.com/rstudio/rstudio/issues

3

Thanks @edgararuiz, I will. What kind of information would be relevant: the drivers I'm using, R and Rstudio version, the code for the queries that are working,...?

4

Right, and as much information as you can share about the names and types of the columns in that table.

5

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.