Uploaded image for project: 'Cost Management'
  1. Cost Management
  2. COST-732

Ensure consistent Presto SQL date filtering

XMLWordPrintable

    • Icon: Story Story
    • Resolution: Done
    • Icon: Normal Normal
    • 2021Q3
    • None
    • None

      Description

      We need a guarantee that we will not filter data on a date using a timestamp with a time component that is non-zero.


      Backend Requirements

      • Add a hard failure to our Presto SQL processing code if we pass an arg to SQL that is a timestamp (we should only pass in date objects to avoid cleaving data from a day)
      • Convert Presto SQL code to use timestamp comparisons where the underlying data type is a timestamp, making sure that the arg passed in has only a data component

      Additional Information and Assumptions

      • Anything else here

      Acceptance Criteria

      • See backend requirements

              aberglun@redhat.com Andrew Berglund (Inactive)
              aberglun@redhat.com Andrew Berglund (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: