Query in RedShift using DBVisualizer fails in a particular instalation

Asked Feb 04 '20 at 14:20

Active Feb 04 '20 at 14:20

Viewed 164 times

I am running the following query in dBVisualizer

select top 100 * from analytical.dwh_sales where _material = '000032';

And is working propertly

But when the same query is executed in another computer (an export from my dBVisualizer installation to another machine) we are having the following error:

[Code: 500310, SQL State: 42703]  [Amazon](500310) Invalid operation: column "loc_XXX " does not exist in dwh_sales;

I dont if you can notice is adding a space to loc_XXX(space) . Not sure if is why is working in a computer and not in another.

asked Feb 04 '20 at 14:20

Jonathan Raul Tapia Lopez

1,383
9
25
31

First thing that comes in mind - different driver versions are used. Can you provide table DDL statement? – Edgars T. Feb 04 '20 at 14:37
I just modified the query to select top 100 * from analytical.dwh_sales where _material='000032'; (no spaces between =) and is working. Any idea why? – Jonathan Raul Tapia Lopez Feb 04 '20 at 15:06
It still might be driver issue, or maybe there wasn't spaces, but some different characters which were displayed as spaces. is column loc_XXX even existing in this table? – Edgars T. Feb 04 '20 at 15:30
Yes loc_XXX exists. I will check drivers – Jonathan Raul Tapia Lopez Feb 04 '20 at 16:34

Query in RedShift using DBVisualizer fails in a particular instalation

0 Answers0