You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@calcite.apache.org by "Aymeric Dispa (Jira)" <ji...@apache.org> on 2022/07/23 08:31:00 UTC

[jira] [Created] (CALCITE-5217) Implement unparseSqlIntervalLiteral in the Firebolt dialect

Aymeric Dispa created CALCITE-5217:
--------------------------------------

             Summary: Implement unparseSqlIntervalLiteral in the Firebolt dialect
                 Key: CALCITE-5217
                 URL: https://issues.apache.org/jira/browse/CALCITE-5217
             Project: Calcite
          Issue Type: Bug
            Reporter: Aymeric Dispa


The syntax used by Firebolt for the operator INTERVAL does not match with the query generated. To fix it, the method unparseSqlIntervalLiteral must be implemented in the dialect.

What we get with the current dialect:
{code:java}
<date_column> + INTERVAL '1' DAY {code}
 

Format supported by Firebolt
{code:java}
<date_column> + INTERVAL '1 DAY'  {code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)