Uploaded image for project: 'Spark'
  1. Spark
  2. SPARK-27764 Feature Parity between PostgreSQL and Spark
  3. SPARK-27578

Support INTERVAL ... HOUR TO SECOND syntax

    XMLWordPrintableJSON

Details

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

    Description

      Currently, SparkSQL can support interval format like this. 

       

      select interval '5 23:59:59.155' day to second.

       

      Can SparkSQL support grammar like below, as Presto/Teradata can support it well now.

      select interval '23:59:59.155' hour to second

       

       

      Attachments

        Issue Links

          relates to

          Sub-task - The sub-task of the issue SPARK-28107 Interval type conversion syntax support

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

          Web Link GitHub Pull Request #24472

          Activity

            People

              lipzhu Zhu, Lipeng
              lipzhu Zhu, Lipeng
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: