Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-21576

Introduce CAST...FORMAT and limited list of SQL:2016 datetime formats

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 4.0.0-alpha-1
    • None
    • None

    Description

      Introduce FORMAT clause to CAST statements as well as the below limited list of SQL:2016 datetime formats to Hive in general.

      • YYYY
      • MM
      • DD
      • HH
      • MI
      • SS
      • YYY
      • YY
      • Y
      • RRRR
      • RR
      • DDD
      • HH12
      • HH24
      • SSSSS
      • FF[1..9]
      • AM/A.M.
      • PM/P.M.
      • TZH
      • TZM

      Definitions of these formats here: https://docs.google.com/document/d/1V7k6-lrPGW7_uhqM-FhKl3QsxwCRy69v2KIxPsGjc1k/

      Attachments

        1. HIVE-21576.01.patch
          59 kB
          Karen Coppage
        2. HIVE-21576.03.patch
          171 kB
          Karen Coppage
        3. HIVE-21576.04.patch
          188 kB
          Karen Coppage
        4. HIVE-21576.05.patch
          208 kB
          Karen Coppage
        5. HIVE-21576.06.patch
          207 kB
          Karen Coppage
        6. HIVE-21576.07.patch
          207 kB
          Karen Coppage
        7. HIVE-21576.08.patch
          181 kB
          Karen Coppage
        8. HIVE-21576.09.patch
          188 kB
          Karen Coppage
        9. HIVE-21576.10.patch
          188 kB
          Karen Coppage
        10. HIVE-21576.11.patch
          189 kB
          Karen Coppage
        11. HIVE-21576.12.patch
          104 kB
          Karen Coppage
        12. HIVE-21576.13.patch
          104 kB
          Karen Coppage
        13. HIVE-21576.14.patch
          104 kB
          Karen Coppage
        14. HIVE-21576.15.patch
          104 kB
          Karen Coppage
        15. HIVE-21576.16.patch
          104 kB
          Karen Coppage
        16. HIVE-21576.16.patch
          104 kB
          Karen Coppage
        17. HIVE-21576.17.patch
          91 kB
          Karen Coppage
        18. HIVE-21576.18.patch
          91 kB
          Karen Coppage
        19. HIVE-21576.2.patch
          167 kB
          Karen Coppage

        Issue Links

          is a child of

          Improvement - An improvement or enhancement to an existing feature or task. HIVE-21575 Add support for SQL:2016 datetime templates/patterns/masks and CAST(... AS ... FORMAT <pattern>)

          • Major - Major loss of function.
          • Resolved
          is related to

          New Feature - A new feature of the product, which has yet to be developed. IMPALA-4018 Add support for SQL:2016 datetime templates/patterns/masks to CAST(... AS ... FORMAT <template>)

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          links to

          Web Link review board

          Activity

            People

              klcopp Karen Coppage
              klcopp Karen Coppage
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: