[CALCITE-3252] Add CONVERT_TIMEZONE, TO_DATE, TO_TIMESTAMP functions to Redshift operator library

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.21.0
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: Lindsey Meyer
• Created: 14/Aug/19 18:16
• Updated: 10/Sep/19 21:36
• Resolved: 21/Aug/19 17:21

Description

Syntax error while parsing CONVERT_TIMEZONE, TO_DATE, TO_TIMESTAMP functions on Redshift. Example queries that error for these functions:

SELECT CONVERT_TIMEZONE('UTC', 'America/Los_Angeles', CAST('2019-01-01 01:00:00' AS TIMESTAMP) FROM mytable 

SELECT TO_DATE('2019-01-01', 'YYYY-MM-DD') FROM mytable 

SELECT TO_TIMESTAMP('2019-01-01 01:00:00', 'YYYY-MM-DD HH:MM:SS') FROM mytable 

With errors like:

No match found for function signature CONVERT_TIMEZONE(<CHARACTER>, <CHARACTER>, <TIMESTAMP>)

These are valid in Redshift and Postgres, except for CONVERT_TIMEZONE, which I believe is only valid on Redshift.

 

Issue Links

• links to: GitHub Pull Request #1380