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

Promote the window table functions window attribute data type with precision 3

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.25.0
    • 1.26.0
    • core

    Description

      Now the window_start and window_end has a type of a Timestamp with default system precision. But, actually, many DB vendors has default precision as 6 (which is also defined in the SQL standard).

      We better promote the precision to 3 because:
      1. For windowing, time unit as millisecond is enough
      2. Make the precision deterministic instead of overriding by each engine's default one

      Attachments

        Issue Links

          Activity

            People

              danny0405 Danny Chen
              danny0405 Danny Chen
              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 - 20m
                  20m