[
https://issues.apache.org/jira/browse/HIVE-21576?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Karen Coppage updated HIVE-21576:
---------------------------------
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/|https://docs.google.com/document/d/1V7k6-lrPGW7_uhqM-FhKl3QsxwCRy69v2KIxPsGjc1k/edit]
was:
Introduce FORMAT clause to CAST statements as well as the below limited list of
SQL:2016 datetime formats to Hive in general. These can be used if a
session-level feature flag is turned on.
* 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/|https://docs.google.com/document/d/1V7k6-lrPGW7_uhqM-FhKl3QsxwCRy69v2KIxPsGjc1k/edit]
> Introduce CAST...FORMAT and limited list of SQL:2016 datetime formats
> ---------------------------------------------------------------------
>
> Key: HIVE-21576
> URL: https://issues.apache.org/jira/browse/HIVE-21576
> Project: Hive
> Issue Type: Improvement
> Reporter: Karen Coppage
> Assignee: Karen Coppage
> Priority: Major
> Attachments: HIVE-21576.01.patch, HIVE-21576.03.patch,
> HIVE-21576.04.patch, HIVE-21576.2.patch
>
>
> 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/|https://docs.google.com/document/d/1V7k6-lrPGW7_uhqM-FhKl3QsxwCRy69v2KIxPsGjc1k/edit]
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
