Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-4223

Hana translator: incorrect pushdown of QUARTER function

    Details

      Description

      Teiid's QUARTER function returns integer.
      SAP HANA's QUARTER function returns string in form:

      2000-Q1
      

      So the function either shouldn't be pushed down, or it has to be pushed down together with some substring method wrapping it:

      SUBSTR_REGEXPR('[[:digit:]]{4}\-Q([[:digit:]]{1})' IN quarter(datevalue) GROUP 1)
      

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                shawkins Steven Hawkins
                Reporter:
                jstastny Jan Stastny
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: