Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-5217

Implement unparseSqlIntervalLiteral in the Firebolt dialect

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.31.0
    • 1.33.0
    • None

    Description

      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:

      <date_column> + INTERVAL '1' DAY 

       

      Format supported by Firebolt

      <date_column> + INTERVAL '1 DAY'  

      Attachments

        Activity

          People

            Aymeric-Dispa Aymeric Dispa
            Aymeric-Dispa Aymeric Dispa
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 40m
                40m