Redshift Error: 1 unrecognized node type: 407

Discussion of open issues, suggestions and bugs regarding database management and development tools for PostgreSQL
Post Reply
dburtsev
Posts: 11
Joined: Wed 18 Jan 2017 19:57

Redshift Error: 1 unrecognized node type: 407

Post by dburtsev » Thu 13 Feb 2020 14:37

This query works:
SELECT CONVERT_TIMEZONE('America/New_York', sae.event_time) AS local_time, sae.*
FROM stl_alert_event_log sae
WHERE
(sae.event_time > CONVERT_TIMEZONE('America/New_York', 'UTC', (SELECT DATEADD(hrs, 9, TRUNC(GETDATE()))))
AND sae.event_time < CONVERT_TIMEZONE('America/New_York', 'UTC', (DATEADD(hrs, 18, TRUNC(GETDATE())))))

This return an error:
SELECT CONVERT_TIMEZONE('America/New_York', sae.event_time) AS local_time, sae.*
FROM stl_alert_event_log sae
WHERE
(sae.event_time > CONVERT_TIMEZONE('America/New_York', 'UTC', (SELECT DATEADD(hrs, 9, TRUNC(GETDATE()))))
AND sae.event_time < CONVERT_TIMEZONE('America/New_York', 'UTC', (DATEADD(hrs, 18, TRUNC(GETDATE())))))
ORDER BY sae.event_time

alexa
Devart Team
Posts: 2856
Joined: Fri 24 Jun 2011 14:17

Re: Redshift Error: 1 unrecognized node type: 407

Post by alexa » Fri 14 Feb 2020 10:08

The error is returned by the Redshift server itself.

You could try performing this in some other tool to see if there is any difference.

dburtsev
Posts: 11
Joined: Wed 18 Jan 2017 19:57

Re: Redshift Error: 1 unrecognized node type: 407

Post by dburtsev » Fri 14 Feb 2020 15:21

Only your tool have this problem.
I tested it with:
Aginity Workbench for Redshift and HeidiSQL

You can test it with command line tool psql.exe:
C:\PostgreSQL\bin>set PGCLIENTENCODING=UTF8

C:\PostgreSQL\bin>set PGPASSWORD=xyz

C:\PostgreSQL\bin>psql.exe -f C:\\PostgreSQL\\bin\\query.sql "host=redmocs.xyz.us-east-1.redshift.amazonaws.com user=xyz dbname=xyz port=5439 "
local_time | user_name | query_text | event | solution | query_millisec
------------+-----------+------------+-------+----------+----------------
(0 rows)

alexa
Devart Team
Posts: 2856
Joined: Fri 24 Jun 2011 14:17

Re: Redshift Error: 1 unrecognized node type: 407

Post by alexa » Mon 17 Feb 2020 13:14

Thank you for bringing this to our attention.

We will investigate this issue and will answer you as soon as possible.

Post Reply