Uploaded image for project: 'Spark'
  1. Spark
  2. SPARK-27790 Support ANSI SQL INTERVAL types
  3. SPARK-35704

Support fields by the day-time interval type

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 3.2.0
    • 3.2.0
    • SQL
    • None

    Description

      Extend the DayTimeIntervalType class and add two parameters that should specify the start and end fields in the type. This will allow to support of the following sub-types:

      1. INTERVAL DAY
      2. INTERVAL DAY TO HOUR
      3. INTERVAL DAY TO MINUTE
      4. INTERVAL HOUR
      5. INTERVAL HOUR TO MINUTE
      6. INTERVAL HOUR TO SECOND
      7. INTERVAL MINUTE
      8. INTERVAL MINUTE TO SECOND
      9. INTERVAL SECOND
         

      Attachments

        Issue Links

          blocks

          Sub-task - The sub-task of the issue SPARK-35726 Truncate java.time.Duration by fields of day-time interval type

          • Major - Major loss of function.
          • Resolved

          Sub-task - The sub-task of the issue SPARK-35727 Return INTERVAL DAY from dates subtraction

          • Major - Major loss of function.
          • Resolved

          Sub-task - The sub-task of the issue SPARK-35728 Check multiply/divide of day-time intervals of any fields by numeric

          • Major - Major loss of function.
          • Resolved

          Sub-task - The sub-task of the issue SPARK-35729 Check all day-time interval types in aggregate expressions

          • Major - Major loss of function.
          • Resolved

          Sub-task - The sub-task of the issue SPARK-35730 Check all day-time interval types in UDF

          • Major - Major loss of function.
          • Resolved

          Sub-task - The sub-task of the issue SPARK-35731 Check all day-time interval types in arrow

          • Major - Major loss of function.
          • Resolved

          Sub-task - The sub-task of the issue SPARK-35732 Parse DayTimeIntervalType from JSON

          • Major - Major loss of function.
          • Resolved

          Sub-task - The sub-task of the issue SPARK-35733 Check all day-time interval types in HiveInspectors tests

          • Major - Major loss of function.
          • Resolved

          Sub-task - The sub-task of the issue SPARK-35734 Format day-time intervals using type fields

          • Major - Major loss of function.
          • Resolved

          Sub-task - The sub-task of the issue SPARK-35735 Take into account day-time interval fields in cast

          • Major - Major loss of function.
          • Resolved

          Sub-task - The sub-task of the issue SPARK-35736 Parse any day-time interval types in SQL

          • Major - Major loss of function.
          • Resolved

          Sub-task - The sub-task of the issue SPARK-35737 Parse day-time interval literals to tightest types

          • Major - Major loss of function.
          • Resolved

          Sub-task - The sub-task of the issue SPARK-35768 Take into account year-month interval fields in cast

          • Major - Major loss of function.
          • Resolved

          Sub-task - The sub-task of the issue SPARK-35769 Truncate java.time.Period by fields of year-month interval type

          • Major - Major loss of function.
          • Resolved

          Sub-task - The sub-task of the issue SPARK-35770 Parse YearMonthIntervalType from JSON

          • Major - Major loss of function.
          • Resolved

          Sub-task - The sub-task of the issue SPARK-35771 Format year-month intervals using type fields

          • Major - Major loss of function.
          • Resolved

          Sub-task - The sub-task of the issue SPARK-35772 Check all year-month interval types in HiveInspectors tests

          • Major - Major loss of function.
          • Resolved

          Sub-task - The sub-task of the issue SPARK-35773 Parse year-month interval literals to tightest types

          • Major - Major loss of function.
          • Resolved

          Sub-task - The sub-task of the issue SPARK-35774 Parse any year-month interval types in SQL

          • Major - Major loss of function.
          • Resolved

          Sub-task - The sub-task of the issue SPARK-35775 Check all year-month interval types in aggregate expressions

          • Major - Major loss of function.
          • Resolved

          Sub-task - The sub-task of the issue SPARK-35776 Check all year-month interval types in arrow

          • Major - Major loss of function.
          • Resolved

          Sub-task - The sub-task of the issue SPARK-35777 Check all year-month interval types in UDF

          • Major - Major loss of function.
          • Resolved

          Sub-task - The sub-task of the issue SPARK-35778 Check multiply/divide of year-month intervals of any fields by numeric

          • Major - Major loss of function.
          • Resolved
          is a clone of

          Sub-task - The sub-task of the issue SPARK-35680 Support fields by year-month interval type

          • Major - Major loss of function.
          • Resolved
          links to

          Pull request #32849 [Github] Pull Request #32849 (MaxGekk)

          Activity

            People

              maxgekk Max Gekk
              maxgekk Max Gekk
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: