Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-5637

Date arith using literals SYSTEM ERROR: AssertionError: Internal error: Conversion to relational algebra failed to preserve datatypes

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 1.10.0
    • None
    • Server
    • None
    • Drill 1.10

    Description

      Use any file with one row in it.

      Submit the following statement to Drill which is performing interval arith on a date using literals.

      select DATE '2000-01-29' + INTERVAL -'1' YEAR from dfs.certp.TVERSION

      Error: SYSTEM ERROR: AssertionError: Internal error: Conversion to relational algebra failed to preserve datatypes:
      validated type:
      RecordType(TIMESTAMP(0) NOT NULL EXPR$0) NOT NULL
      converted type:
      RecordType(DATE NOT NULL EXPR$0) NOT NULL
      rel:
      LogicalProject(EXPR$0=[DATETIME_PLUS(2000-01-29, -12)])
      LogicalTableScan(table=[[dfs, certp, TVERSION]])

      Attachments

        Activity

          People

            Unassigned Unassigned
            the6campbells N Campbell
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: