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

Increase the precision of INTERVAL types to be larger than 2

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 1.10.0
    • None
    • SQL Parser
    • None
    • Drill 1.10

    Description

      You cannot express an interval literal (DAY, HOUR, MINUTE, SECOND, ...) with a precision greater than 2.

      select INTERVAL '100' DAY from dfs.certp.TVERSION
      Error: VALIDATION ERROR: From line 1, column 8 to line 1, column 25: Interval field value 100 exceeds precision of DAY(2) field

      select INTERVAL '160' HOUR from dfs.certp.TVERSION
      Error: VALIDATION ERROR: From line 1, column 8 to line 1, column 26: Interval field value 160 exceeds precision of HOUR(2) field

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated: