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

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

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 4.0.0
    • Component/s: None
    • Labels:
      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

            Activity

              People

              • Assignee:
                klcopp Karen Coppage
                Reporter:
                klcopp Karen Coppage
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: