[jira] [Updated] (HIVE-22099) Several date related UDFs can't handle Julian dates properly since HIVE-20007
[ https://issues.apache.org/jira/browse/HIVE-22099?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Adam Szita updated HIVE-22099: -- Fix Version/s: 4.0.0 Resolution: Fixed Status: Resolved (was: Patch Available) > Several date related UDFs can't handle Julian dates properly since HIVE-20007 > - > > Key: HIVE-22099 > URL: https://issues.apache.org/jira/browse/HIVE-22099 > Project: Hive > Issue Type: Bug >Reporter: Adam Szita >Assignee: Adam Szita >Priority: Major > Fix For: 4.0.0 > > Attachments: HIVE-22099.0.patch, HIVE-22099.1.patch, > HIVE-22099.2.patch, HIVE-22099.3.patch, HIVE-22099.4.patch, > HIVE-22099.5.patch, HIVE-22099.6.patch, HIVE-22099.7.patch, > HIVE-22099.8.patch, HIVE-22099.9.patch > > > Currently dates that belong to Julian calendar (before Oct 15, 1582) are > handled improperly by date/timestamp UDFs. > E.g. DateFormat UDF: > Although the dates are in Julian calendar, the formatter insists to print > these according to Gregorian calendar causing multiple days of difference in > some cases: > > {code:java} > beeline> select date_format('1001-01-05','dd---MM--'); > ++ > | _c0 | > ++ > | 30---12--1000 | > ++{code} > I've observed similar problems in the following UDFs: > * add_months > * date_format > * day > * month > * months_between > * weekofyear > * year > -- This message was sent by Atlassian Jira (v8.3.2#803003)
[jira] [Updated] (HIVE-22099) Several date related UDFs can't handle Julian dates properly since HIVE-20007
[ https://issues.apache.org/jira/browse/HIVE-22099?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Adam Szita updated HIVE-22099: -- Attachment: HIVE-22099.9.patch > Several date related UDFs can't handle Julian dates properly since HIVE-20007 > - > > Key: HIVE-22099 > URL: https://issues.apache.org/jira/browse/HIVE-22099 > Project: Hive > Issue Type: Bug >Reporter: Adam Szita >Assignee: Adam Szita >Priority: Major > Attachments: HIVE-22099.0.patch, HIVE-22099.1.patch, > HIVE-22099.2.patch, HIVE-22099.3.patch, HIVE-22099.4.patch, > HIVE-22099.5.patch, HIVE-22099.6.patch, HIVE-22099.7.patch, > HIVE-22099.8.patch, HIVE-22099.9.patch > > > Currently dates that belong to Julian calendar (before Oct 15, 1582) are > handled improperly by date/timestamp UDFs. > E.g. DateFormat UDF: > Although the dates are in Julian calendar, the formatter insists to print > these according to Gregorian calendar causing multiple days of difference in > some cases: > > {code:java} > beeline> select date_format('1001-01-05','dd---MM--'); > ++ > | _c0 | > ++ > | 30---12--1000 | > ++{code} > I've observed similar problems in the following UDFs: > * add_months > * date_format > * day > * month > * months_between > * weekofyear > * year > -- This message was sent by Atlassian Jira (v8.3.2#803003)
[jira] [Updated] (HIVE-22099) Several date related UDFs can't handle Julian dates properly since HIVE-20007
[ https://issues.apache.org/jira/browse/HIVE-22099?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Adam Szita updated HIVE-22099: -- Status: Patch Available (was: In Progress) > Several date related UDFs can't handle Julian dates properly since HIVE-20007 > - > > Key: HIVE-22099 > URL: https://issues.apache.org/jira/browse/HIVE-22099 > Project: Hive > Issue Type: Bug >Reporter: Adam Szita >Assignee: Adam Szita >Priority: Major > Attachments: HIVE-22099.0.patch, HIVE-22099.1.patch, > HIVE-22099.2.patch, HIVE-22099.3.patch, HIVE-22099.4.patch, > HIVE-22099.5.patch, HIVE-22099.6.patch, HIVE-22099.7.patch, > HIVE-22099.8.patch, HIVE-22099.9.patch > > > Currently dates that belong to Julian calendar (before Oct 15, 1582) are > handled improperly by date/timestamp UDFs. > E.g. DateFormat UDF: > Although the dates are in Julian calendar, the formatter insists to print > these according to Gregorian calendar causing multiple days of difference in > some cases: > > {code:java} > beeline> select date_format('1001-01-05','dd---MM--'); > ++ > | _c0 | > ++ > | 30---12--1000 | > ++{code} > I've observed similar problems in the following UDFs: > * add_months > * date_format > * day > * month > * months_between > * weekofyear > * year > -- This message was sent by Atlassian Jira (v8.3.2#803003)
[jira] [Updated] (HIVE-22099) Several date related UDFs can't handle Julian dates properly since HIVE-20007
[ https://issues.apache.org/jira/browse/HIVE-22099?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Adam Szita updated HIVE-22099: -- Status: In Progress (was: Patch Available) > Several date related UDFs can't handle Julian dates properly since HIVE-20007 > - > > Key: HIVE-22099 > URL: https://issues.apache.org/jira/browse/HIVE-22099 > Project: Hive > Issue Type: Bug >Reporter: Adam Szita >Assignee: Adam Szita >Priority: Major > Attachments: HIVE-22099.0.patch, HIVE-22099.1.patch, > HIVE-22099.2.patch, HIVE-22099.3.patch, HIVE-22099.4.patch, > HIVE-22099.5.patch, HIVE-22099.6.patch, HIVE-22099.7.patch, > HIVE-22099.8.patch, HIVE-22099.9.patch > > > Currently dates that belong to Julian calendar (before Oct 15, 1582) are > handled improperly by date/timestamp UDFs. > E.g. DateFormat UDF: > Although the dates are in Julian calendar, the formatter insists to print > these according to Gregorian calendar causing multiple days of difference in > some cases: > > {code:java} > beeline> select date_format('1001-01-05','dd---MM--'); > ++ > | _c0 | > ++ > | 30---12--1000 | > ++{code} > I've observed similar problems in the following UDFs: > * add_months > * date_format > * day > * month > * months_between > * weekofyear > * year > -- This message was sent by Atlassian Jira (v8.3.2#803003)
[jira] [Updated] (HIVE-22099) Several date related UDFs can't handle Julian dates properly since HIVE-20007
[ https://issues.apache.org/jira/browse/HIVE-22099?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Adam Szita updated HIVE-22099: -- Attachment: HIVE-22099.8.patch > Several date related UDFs can't handle Julian dates properly since HIVE-20007 > - > > Key: HIVE-22099 > URL: https://issues.apache.org/jira/browse/HIVE-22099 > Project: Hive > Issue Type: Bug >Reporter: Adam Szita >Assignee: Adam Szita >Priority: Major > Attachments: HIVE-22099.0.patch, HIVE-22099.1.patch, > HIVE-22099.2.patch, HIVE-22099.3.patch, HIVE-22099.4.patch, > HIVE-22099.5.patch, HIVE-22099.6.patch, HIVE-22099.7.patch, HIVE-22099.8.patch > > > Currently dates that belong to Julian calendar (before Oct 15, 1582) are > handled improperly by date/timestamp UDFs. > E.g. DateFormat UDF: > Although the dates are in Julian calendar, the formatter insists to print > these according to Gregorian calendar causing multiple days of difference in > some cases: > > {code:java} > beeline> select date_format('1001-01-05','dd---MM--'); > ++ > | _c0 | > ++ > | 30---12--1000 | > ++{code} > I've observed similar problems in the following UDFs: > * add_months > * date_format > * day > * month > * months_between > * weekofyear > * year > -- This message was sent by Atlassian Jira (v8.3.2#803003)
[jira] [Updated] (HIVE-22099) Several date related UDFs can't handle Julian dates properly since HIVE-20007
[ https://issues.apache.org/jira/browse/HIVE-22099?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Adam Szita updated HIVE-22099: -- Status: Patch Available (was: In Progress) > Several date related UDFs can't handle Julian dates properly since HIVE-20007 > - > > Key: HIVE-22099 > URL: https://issues.apache.org/jira/browse/HIVE-22099 > Project: Hive > Issue Type: Bug >Reporter: Adam Szita >Assignee: Adam Szita >Priority: Major > Attachments: HIVE-22099.0.patch, HIVE-22099.1.patch, > HIVE-22099.2.patch, HIVE-22099.3.patch, HIVE-22099.4.patch, > HIVE-22099.5.patch, HIVE-22099.6.patch, HIVE-22099.7.patch, HIVE-22099.8.patch > > > Currently dates that belong to Julian calendar (before Oct 15, 1582) are > handled improperly by date/timestamp UDFs. > E.g. DateFormat UDF: > Although the dates are in Julian calendar, the formatter insists to print > these according to Gregorian calendar causing multiple days of difference in > some cases: > > {code:java} > beeline> select date_format('1001-01-05','dd---MM--'); > ++ > | _c0 | > ++ > | 30---12--1000 | > ++{code} > I've observed similar problems in the following UDFs: > * add_months > * date_format > * day > * month > * months_between > * weekofyear > * year > -- This message was sent by Atlassian Jira (v8.3.2#803003)
[jira] [Updated] (HIVE-22099) Several date related UDFs can't handle Julian dates properly since HIVE-20007
[ https://issues.apache.org/jira/browse/HIVE-22099?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Adam Szita updated HIVE-22099: -- Status: In Progress (was: Patch Available) > Several date related UDFs can't handle Julian dates properly since HIVE-20007 > - > > Key: HIVE-22099 > URL: https://issues.apache.org/jira/browse/HIVE-22099 > Project: Hive > Issue Type: Bug >Reporter: Adam Szita >Assignee: Adam Szita >Priority: Major > Attachments: HIVE-22099.0.patch, HIVE-22099.1.patch, > HIVE-22099.2.patch, HIVE-22099.3.patch, HIVE-22099.4.patch, > HIVE-22099.5.patch, HIVE-22099.6.patch, HIVE-22099.7.patch > > > Currently dates that belong to Julian calendar (before Oct 15, 1582) are > handled improperly by date/timestamp UDFs. > E.g. DateFormat UDF: > Although the dates are in Julian calendar, the formatter insists to print > these according to Gregorian calendar causing multiple days of difference in > some cases: > > {code:java} > beeline> select date_format('1001-01-05','dd---MM--'); > ++ > | _c0 | > ++ > | 30---12--1000 | > ++{code} > I've observed similar problems in the following UDFs: > * add_months > * date_format > * day > * month > * months_between > * weekofyear > * year > -- This message was sent by Atlassian Jira (v8.3.2#803003)
[jira] [Updated] (HIVE-22099) Several date related UDFs can't handle Julian dates properly since HIVE-20007
[ https://issues.apache.org/jira/browse/HIVE-22099?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Adam Szita updated HIVE-22099: -- Status: In Progress (was: Patch Available) > Several date related UDFs can't handle Julian dates properly since HIVE-20007 > - > > Key: HIVE-22099 > URL: https://issues.apache.org/jira/browse/HIVE-22099 > Project: Hive > Issue Type: Bug >Reporter: Adam Szita >Assignee: Adam Szita >Priority: Major > Attachments: HIVE-22099.0.patch, HIVE-22099.1.patch, > HIVE-22099.2.patch, HIVE-22099.3.patch, HIVE-22099.4.patch, > HIVE-22099.5.patch, HIVE-22099.6.patch, HIVE-22099.7.patch > > > Currently dates that belong to Julian calendar (before Oct 15, 1582) are > handled improperly by date/timestamp UDFs. > E.g. DateFormat UDF: > Although the dates are in Julian calendar, the formatter insists to print > these according to Gregorian calendar causing multiple days of difference in > some cases: > > {code:java} > beeline> select date_format('1001-01-05','dd---MM--'); > ++ > | _c0 | > ++ > | 30---12--1000 | > ++{code} > I've observed similar problems in the following UDFs: > * add_months > * date_format > * day > * month > * months_between > * weekofyear > * year > -- This message was sent by Atlassian Jira (v8.3.2#803003)
[jira] [Updated] (HIVE-22099) Several date related UDFs can't handle Julian dates properly since HIVE-20007
[ https://issues.apache.org/jira/browse/HIVE-22099?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Adam Szita updated HIVE-22099: -- Attachment: HIVE-22099.7.patch > Several date related UDFs can't handle Julian dates properly since HIVE-20007 > - > > Key: HIVE-22099 > URL: https://issues.apache.org/jira/browse/HIVE-22099 > Project: Hive > Issue Type: Bug >Reporter: Adam Szita >Assignee: Adam Szita >Priority: Major > Attachments: HIVE-22099.0.patch, HIVE-22099.1.patch, > HIVE-22099.2.patch, HIVE-22099.3.patch, HIVE-22099.4.patch, > HIVE-22099.5.patch, HIVE-22099.6.patch, HIVE-22099.7.patch > > > Currently dates that belong to Julian calendar (before Oct 15, 1582) are > handled improperly by date/timestamp UDFs. > E.g. DateFormat UDF: > Although the dates are in Julian calendar, the formatter insists to print > these according to Gregorian calendar causing multiple days of difference in > some cases: > > {code:java} > beeline> select date_format('1001-01-05','dd---MM--'); > ++ > | _c0 | > ++ > | 30---12--1000 | > ++{code} > I've observed similar problems in the following UDFs: > * add_months > * date_format > * day > * month > * months_between > * weekofyear > * year > -- This message was sent by Atlassian Jira (v8.3.2#803003)
[jira] [Updated] (HIVE-22099) Several date related UDFs can't handle Julian dates properly since HIVE-20007
[ https://issues.apache.org/jira/browse/HIVE-22099?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Adam Szita updated HIVE-22099: -- Status: Patch Available (was: In Progress) > Several date related UDFs can't handle Julian dates properly since HIVE-20007 > - > > Key: HIVE-22099 > URL: https://issues.apache.org/jira/browse/HIVE-22099 > Project: Hive > Issue Type: Bug >Reporter: Adam Szita >Assignee: Adam Szita >Priority: Major > Attachments: HIVE-22099.0.patch, HIVE-22099.1.patch, > HIVE-22099.2.patch, HIVE-22099.3.patch, HIVE-22099.4.patch, > HIVE-22099.5.patch, HIVE-22099.6.patch, HIVE-22099.7.patch > > > Currently dates that belong to Julian calendar (before Oct 15, 1582) are > handled improperly by date/timestamp UDFs. > E.g. DateFormat UDF: > Although the dates are in Julian calendar, the formatter insists to print > these according to Gregorian calendar causing multiple days of difference in > some cases: > > {code:java} > beeline> select date_format('1001-01-05','dd---MM--'); > ++ > | _c0 | > ++ > | 30---12--1000 | > ++{code} > I've observed similar problems in the following UDFs: > * add_months > * date_format > * day > * month > * months_between > * weekofyear > * year > -- This message was sent by Atlassian Jira (v8.3.2#803003)
[jira] [Updated] (HIVE-22099) Several date related UDFs can't handle Julian dates properly since HIVE-20007
[ https://issues.apache.org/jira/browse/HIVE-22099?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Adam Szita updated HIVE-22099: -- Attachment: HIVE-22099.6.patch > Several date related UDFs can't handle Julian dates properly since HIVE-20007 > - > > Key: HIVE-22099 > URL: https://issues.apache.org/jira/browse/HIVE-22099 > Project: Hive > Issue Type: Bug >Reporter: Adam Szita >Assignee: Adam Szita >Priority: Major > Attachments: HIVE-22099.0.patch, HIVE-22099.1.patch, > HIVE-22099.2.patch, HIVE-22099.3.patch, HIVE-22099.4.patch, > HIVE-22099.5.patch, HIVE-22099.6.patch > > > Currently dates that belong to Julian calendar (before Oct 15, 1582) are > handled improperly by date/timestamp UDFs. > E.g. DateFormat UDF: > Although the dates are in Julian calendar, the formatter insists to print > these according to Gregorian calendar causing multiple days of difference in > some cases: > > {code:java} > beeline> select date_format('1001-01-05','dd---MM--'); > ++ > | _c0 | > ++ > | 30---12--1000 | > ++{code} > I've observed similar problems in the following UDFs: > * add_months > * date_format > * day > * month > * months_between > * weekofyear > * year > -- This message was sent by Atlassian Jira (v8.3.2#803003)
[jira] [Updated] (HIVE-22099) Several date related UDFs can't handle Julian dates properly since HIVE-20007
[ https://issues.apache.org/jira/browse/HIVE-22099?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Adam Szita updated HIVE-22099: -- Status: Patch Available (was: In Progress) > Several date related UDFs can't handle Julian dates properly since HIVE-20007 > - > > Key: HIVE-22099 > URL: https://issues.apache.org/jira/browse/HIVE-22099 > Project: Hive > Issue Type: Bug >Reporter: Adam Szita >Assignee: Adam Szita >Priority: Major > Attachments: HIVE-22099.0.patch, HIVE-22099.1.patch, > HIVE-22099.2.patch, HIVE-22099.3.patch, HIVE-22099.4.patch, > HIVE-22099.5.patch, HIVE-22099.6.patch > > > Currently dates that belong to Julian calendar (before Oct 15, 1582) are > handled improperly by date/timestamp UDFs. > E.g. DateFormat UDF: > Although the dates are in Julian calendar, the formatter insists to print > these according to Gregorian calendar causing multiple days of difference in > some cases: > > {code:java} > beeline> select date_format('1001-01-05','dd---MM--'); > ++ > | _c0 | > ++ > | 30---12--1000 | > ++{code} > I've observed similar problems in the following UDFs: > * add_months > * date_format > * day > * month > * months_between > * weekofyear > * year > -- This message was sent by Atlassian Jira (v8.3.2#803003)
[jira] [Updated] (HIVE-22099) Several date related UDFs can't handle Julian dates properly since HIVE-20007
[ https://issues.apache.org/jira/browse/HIVE-22099?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Adam Szita updated HIVE-22099: -- Status: In Progress (was: Patch Available) > Several date related UDFs can't handle Julian dates properly since HIVE-20007 > - > > Key: HIVE-22099 > URL: https://issues.apache.org/jira/browse/HIVE-22099 > Project: Hive > Issue Type: Bug >Reporter: Adam Szita >Assignee: Adam Szita >Priority: Major > Attachments: HIVE-22099.0.patch, HIVE-22099.1.patch, > HIVE-22099.2.patch, HIVE-22099.3.patch, HIVE-22099.4.patch, HIVE-22099.5.patch > > > Currently dates that belong to Julian calendar (before Oct 15, 1582) are > handled improperly by date/timestamp UDFs. > E.g. DateFormat UDF: > Although the dates are in Julian calendar, the formatter insists to print > these according to Gregorian calendar causing multiple days of difference in > some cases: > > {code:java} > beeline> select date_format('1001-01-05','dd---MM--'); > ++ > | _c0 | > ++ > | 30---12--1000 | > ++{code} > I've observed similar problems in the following UDFs: > * add_months > * date_format > * day > * month > * months_between > * weekofyear > * year > -- This message was sent by Atlassian Jira (v8.3.2#803003)
[jira] [Updated] (HIVE-22099) Several date related UDFs can't handle Julian dates properly since HIVE-20007
[ https://issues.apache.org/jira/browse/HIVE-22099?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Adam Szita updated HIVE-22099: -- Attachment: HIVE-22099.5.patch > Several date related UDFs can't handle Julian dates properly since HIVE-20007 > - > > Key: HIVE-22099 > URL: https://issues.apache.org/jira/browse/HIVE-22099 > Project: Hive > Issue Type: Bug >Reporter: Adam Szita >Assignee: Adam Szita >Priority: Major > Attachments: HIVE-22099.0.patch, HIVE-22099.1.patch, > HIVE-22099.2.patch, HIVE-22099.3.patch, HIVE-22099.4.patch, HIVE-22099.5.patch > > > Currently dates that belong to Julian calendar (before Oct 15, 1582) are > handled improperly by date/timestamp UDFs. > E.g. DateFormat UDF: > Although the dates are in Julian calendar, the formatter insists to print > these according to Gregorian calendar causing multiple days of difference in > some cases: > > {code:java} > beeline> select date_format('1001-01-05','dd---MM--'); > ++ > | _c0 | > ++ > | 30---12--1000 | > ++{code} > I've observed similar problems in the following UDFs: > * add_months > * date_format > * day > * month > * months_between > * weekofyear > * year > -- This message was sent by Atlassian JIRA (v7.6.14#76016)
[jira] [Updated] (HIVE-22099) Several date related UDFs can't handle Julian dates properly since HIVE-20007
[ https://issues.apache.org/jira/browse/HIVE-22099?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Adam Szita updated HIVE-22099: -- Status: In Progress (was: Patch Available) > Several date related UDFs can't handle Julian dates properly since HIVE-20007 > - > > Key: HIVE-22099 > URL: https://issues.apache.org/jira/browse/HIVE-22099 > Project: Hive > Issue Type: Bug >Reporter: Adam Szita >Assignee: Adam Szita >Priority: Major > Attachments: HIVE-22099.0.patch, HIVE-22099.1.patch, > HIVE-22099.2.patch, HIVE-22099.3.patch, HIVE-22099.4.patch, HIVE-22099.5.patch > > > Currently dates that belong to Julian calendar (before Oct 15, 1582) are > handled improperly by date/timestamp UDFs. > E.g. DateFormat UDF: > Although the dates are in Julian calendar, the formatter insists to print > these according to Gregorian calendar causing multiple days of difference in > some cases: > > {code:java} > beeline> select date_format('1001-01-05','dd---MM--'); > ++ > | _c0 | > ++ > | 30---12--1000 | > ++{code} > I've observed similar problems in the following UDFs: > * add_months > * date_format > * day > * month > * months_between > * weekofyear > * year > -- This message was sent by Atlassian JIRA (v7.6.14#76016)
[jira] [Updated] (HIVE-22099) Several date related UDFs can't handle Julian dates properly since HIVE-20007
[ https://issues.apache.org/jira/browse/HIVE-22099?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Adam Szita updated HIVE-22099: -- Status: Patch Available (was: In Progress) > Several date related UDFs can't handle Julian dates properly since HIVE-20007 > - > > Key: HIVE-22099 > URL: https://issues.apache.org/jira/browse/HIVE-22099 > Project: Hive > Issue Type: Bug >Reporter: Adam Szita >Assignee: Adam Szita >Priority: Major > Attachments: HIVE-22099.0.patch, HIVE-22099.1.patch, > HIVE-22099.2.patch, HIVE-22099.3.patch, HIVE-22099.4.patch, HIVE-22099.5.patch > > > Currently dates that belong to Julian calendar (before Oct 15, 1582) are > handled improperly by date/timestamp UDFs. > E.g. DateFormat UDF: > Although the dates are in Julian calendar, the formatter insists to print > these according to Gregorian calendar causing multiple days of difference in > some cases: > > {code:java} > beeline> select date_format('1001-01-05','dd---MM--'); > ++ > | _c0 | > ++ > | 30---12--1000 | > ++{code} > I've observed similar problems in the following UDFs: > * add_months > * date_format > * day > * month > * months_between > * weekofyear > * year > -- This message was sent by Atlassian JIRA (v7.6.14#76016)
[jira] [Updated] (HIVE-22099) Several date related UDFs can't handle Julian dates properly since HIVE-20007
[ https://issues.apache.org/jira/browse/HIVE-22099?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Adam Szita updated HIVE-22099: -- Attachment: HIVE-22099.4.patch > Several date related UDFs can't handle Julian dates properly since HIVE-20007 > - > > Key: HIVE-22099 > URL: https://issues.apache.org/jira/browse/HIVE-22099 > Project: Hive > Issue Type: Bug >Reporter: Adam Szita >Assignee: Adam Szita >Priority: Major > Attachments: HIVE-22099.0.patch, HIVE-22099.1.patch, > HIVE-22099.2.patch, HIVE-22099.3.patch, HIVE-22099.4.patch > > > Currently dates that belong to Julian calendar (before Oct 15, 1582) are > handled improperly by date/timestamp UDFs. > E.g. DateFormat UDF: > Although the dates are in Julian calendar, the formatter insists to print > these according to Gregorian calendar causing multiple days of difference in > some cases: > > {code:java} > beeline> select date_format('1001-01-05','dd---MM--'); > ++ > | _c0 | > ++ > | 30---12--1000 | > ++{code} > I've observed similar problems in the following UDFs: > * add_months > * date_format > * day > * month > * months_between > * weekofyear > * year > -- This message was sent by Atlassian JIRA (v7.6.14#76016)
[jira] [Updated] (HIVE-22099) Several date related UDFs can't handle Julian dates properly since HIVE-20007
[ https://issues.apache.org/jira/browse/HIVE-22099?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Adam Szita updated HIVE-22099: -- Status: Patch Available (was: In Progress) > Several date related UDFs can't handle Julian dates properly since HIVE-20007 > - > > Key: HIVE-22099 > URL: https://issues.apache.org/jira/browse/HIVE-22099 > Project: Hive > Issue Type: Bug >Reporter: Adam Szita >Assignee: Adam Szita >Priority: Major > Attachments: HIVE-22099.0.patch, HIVE-22099.1.patch, > HIVE-22099.2.patch, HIVE-22099.3.patch, HIVE-22099.4.patch > > > Currently dates that belong to Julian calendar (before Oct 15, 1582) are > handled improperly by date/timestamp UDFs. > E.g. DateFormat UDF: > Although the dates are in Julian calendar, the formatter insists to print > these according to Gregorian calendar causing multiple days of difference in > some cases: > > {code:java} > beeline> select date_format('1001-01-05','dd---MM--'); > ++ > | _c0 | > ++ > | 30---12--1000 | > ++{code} > I've observed similar problems in the following UDFs: > * add_months > * date_format > * day > * month > * months_between > * weekofyear > * year > -- This message was sent by Atlassian JIRA (v7.6.14#76016)
[jira] [Updated] (HIVE-22099) Several date related UDFs can't handle Julian dates properly since HIVE-20007
[ https://issues.apache.org/jira/browse/HIVE-22099?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Adam Szita updated HIVE-22099: -- Status: In Progress (was: Patch Available) > Several date related UDFs can't handle Julian dates properly since HIVE-20007 > - > > Key: HIVE-22099 > URL: https://issues.apache.org/jira/browse/HIVE-22099 > Project: Hive > Issue Type: Bug >Reporter: Adam Szita >Assignee: Adam Szita >Priority: Major > Attachments: HIVE-22099.0.patch, HIVE-22099.1.patch, > HIVE-22099.2.patch, HIVE-22099.3.patch > > > Currently dates that belong to Julian calendar (before Oct 15, 1582) are > handled improperly by date/timestamp UDFs. > E.g. DateFormat UDF: > Although the dates are in Julian calendar, the formatter insists to print > these according to Gregorian calendar causing multiple days of difference in > some cases: > > {code:java} > beeline> select date_format('1001-01-05','dd---MM--'); > ++ > | _c0 | > ++ > | 30---12--1000 | > ++{code} > I've observed similar problems in the following UDFs: > * add_months > * date_format > * day > * month > * months_between > * weekofyear > * year > -- This message was sent by Atlassian JIRA (v7.6.14#76016)
[jira] [Updated] (HIVE-22099) Several date related UDFs can't handle Julian dates properly since HIVE-20007
[ https://issues.apache.org/jira/browse/HIVE-22099?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Adam Szita updated HIVE-22099: -- Status: In Progress (was: Patch Available) > Several date related UDFs can't handle Julian dates properly since HIVE-20007 > - > > Key: HIVE-22099 > URL: https://issues.apache.org/jira/browse/HIVE-22099 > Project: Hive > Issue Type: Bug >Reporter: Adam Szita >Assignee: Adam Szita >Priority: Major > Attachments: HIVE-22099.0.patch, HIVE-22099.1.patch, > HIVE-22099.2.patch, HIVE-22099.3.patch > > > Currently dates that belong to Julian calendar (before Oct 15, 1582) are > handled improperly by date/timestamp UDFs. > E.g. DateFormat UDF: > Although the dates are in Julian calendar, the formatter insists to print > these according to Gregorian calendar causing multiple days of difference in > some cases: > > {code:java} > beeline> select date_format('1001-01-05','dd---MM--'); > ++ > | _c0 | > ++ > | 30---12--1000 | > ++{code} > I've observed similar problems in the following UDFs: > * add_months > * date_format > * day > * month > * months_between > * weekofyear > * year > -- This message was sent by Atlassian JIRA (v7.6.14#76016)
[jira] [Updated] (HIVE-22099) Several date related UDFs can't handle Julian dates properly since HIVE-20007
[ https://issues.apache.org/jira/browse/HIVE-22099?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Adam Szita updated HIVE-22099: -- Status: Patch Available (was: In Progress) > Several date related UDFs can't handle Julian dates properly since HIVE-20007 > - > > Key: HIVE-22099 > URL: https://issues.apache.org/jira/browse/HIVE-22099 > Project: Hive > Issue Type: Bug >Reporter: Adam Szita >Assignee: Adam Szita >Priority: Major > Attachments: HIVE-22099.0.patch, HIVE-22099.1.patch, > HIVE-22099.2.patch, HIVE-22099.3.patch > > > Currently dates that belong to Julian calendar (before Oct 15, 1582) are > handled improperly by date/timestamp UDFs. > E.g. DateFormat UDF: > Although the dates are in Julian calendar, the formatter insists to print > these according to Gregorian calendar causing multiple days of difference in > some cases: > > {code:java} > beeline> select date_format('1001-01-05','dd---MM--'); > ++ > | _c0 | > ++ > | 30---12--1000 | > ++{code} > I've observed similar problems in the following UDFs: > * add_months > * date_format > * day > * month > * months_between > * weekofyear > * year > -- This message was sent by Atlassian JIRA (v7.6.14#76016)
[jira] [Updated] (HIVE-22099) Several date related UDFs can't handle Julian dates properly since HIVE-20007
[ https://issues.apache.org/jira/browse/HIVE-22099?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Adam Szita updated HIVE-22099: -- Attachment: HIVE-22099.3.patch > Several date related UDFs can't handle Julian dates properly since HIVE-20007 > - > > Key: HIVE-22099 > URL: https://issues.apache.org/jira/browse/HIVE-22099 > Project: Hive > Issue Type: Bug >Reporter: Adam Szita >Assignee: Adam Szita >Priority: Major > Attachments: HIVE-22099.0.patch, HIVE-22099.1.patch, > HIVE-22099.2.patch, HIVE-22099.3.patch > > > Currently dates that belong to Julian calendar (before Oct 15, 1582) are > handled improperly by date/timestamp UDFs. > E.g. DateFormat UDF: > Although the dates are in Julian calendar, the formatter insists to print > these according to Gregorian calendar causing multiple days of difference in > some cases: > > {code:java} > beeline> select date_format('1001-01-05','dd---MM--'); > ++ > | _c0 | > ++ > | 30---12--1000 | > ++{code} > I've observed similar problems in the following UDFs: > * add_months > * date_format > * day > * month > * months_between > * weekofyear > * year > -- This message was sent by Atlassian JIRA (v7.6.14#76016)
[jira] [Updated] (HIVE-22099) Several date related UDFs can't handle Julian dates properly since HIVE-20007
[ https://issues.apache.org/jira/browse/HIVE-22099?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Adam Szita updated HIVE-22099: -- Status: Patch Available (was: In Progress) > Several date related UDFs can't handle Julian dates properly since HIVE-20007 > - > > Key: HIVE-22099 > URL: https://issues.apache.org/jira/browse/HIVE-22099 > Project: Hive > Issue Type: Bug >Reporter: Adam Szita >Assignee: Adam Szita >Priority: Major > Attachments: HIVE-22099.0.patch, HIVE-22099.1.patch, > HIVE-22099.2.patch > > > Currently dates that belong to Julian calendar (before Oct 15, 1582) are > handled improperly by date/timestamp UDFs. > E.g. DateFormat UDF: > Although the dates are in Julian calendar, the formatter insists to print > these according to Gregorian calendar causing multiple days of difference in > some cases: > > {code:java} > beeline> select date_format('1001-01-05','dd---MM--'); > ++ > | _c0 | > ++ > | 30---12--1000 | > ++{code} > I've observed similar problems in the following UDFs: > * add_months > * date_format > * day > * month > * months_between > * weekofyear > * year > -- This message was sent by Atlassian JIRA (v7.6.14#76016)
[jira] [Updated] (HIVE-22099) Several date related UDFs can't handle Julian dates properly since HIVE-20007
[ https://issues.apache.org/jira/browse/HIVE-22099?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Adam Szita updated HIVE-22099: -- Attachment: HIVE-22099.2.patch > Several date related UDFs can't handle Julian dates properly since HIVE-20007 > - > > Key: HIVE-22099 > URL: https://issues.apache.org/jira/browse/HIVE-22099 > Project: Hive > Issue Type: Bug >Reporter: Adam Szita >Assignee: Adam Szita >Priority: Major > Attachments: HIVE-22099.0.patch, HIVE-22099.1.patch, > HIVE-22099.2.patch > > > Currently dates that belong to Julian calendar (before Oct 15, 1582) are > handled improperly by date/timestamp UDFs. > E.g. DateFormat UDF: > Although the dates are in Julian calendar, the formatter insists to print > these according to Gregorian calendar causing multiple days of difference in > some cases: > > {code:java} > beeline> select date_format('1001-01-05','dd---MM--'); > ++ > | _c0 | > ++ > | 30---12--1000 | > ++{code} > I've observed similar problems in the following UDFs: > * add_months > * date_format > * day > * month > * months_between > * weekofyear > * year > -- This message was sent by Atlassian JIRA (v7.6.14#76016)
[jira] [Updated] (HIVE-22099) Several date related UDFs can't handle Julian dates properly since HIVE-20007
[ https://issues.apache.org/jira/browse/HIVE-22099?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Adam Szita updated HIVE-22099: -- Status: In Progress (was: Patch Available) > Several date related UDFs can't handle Julian dates properly since HIVE-20007 > - > > Key: HIVE-22099 > URL: https://issues.apache.org/jira/browse/HIVE-22099 > Project: Hive > Issue Type: Bug >Reporter: Adam Szita >Assignee: Adam Szita >Priority: Major > Attachments: HIVE-22099.0.patch, HIVE-22099.1.patch, > HIVE-22099.2.patch > > > Currently dates that belong to Julian calendar (before Oct 15, 1582) are > handled improperly by date/timestamp UDFs. > E.g. DateFormat UDF: > Although the dates are in Julian calendar, the formatter insists to print > these according to Gregorian calendar causing multiple days of difference in > some cases: > > {code:java} > beeline> select date_format('1001-01-05','dd---MM--'); > ++ > | _c0 | > ++ > | 30---12--1000 | > ++{code} > I've observed similar problems in the following UDFs: > * add_months > * date_format > * day > * month > * months_between > * weekofyear > * year > -- This message was sent by Atlassian JIRA (v7.6.14#76016)
[jira] [Updated] (HIVE-22099) Several date related UDFs can't handle Julian dates properly since HIVE-20007
[ https://issues.apache.org/jira/browse/HIVE-22099?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Adam Szita updated HIVE-22099: -- Status: Patch Available (was: In Progress) > Several date related UDFs can't handle Julian dates properly since HIVE-20007 > - > > Key: HIVE-22099 > URL: https://issues.apache.org/jira/browse/HIVE-22099 > Project: Hive > Issue Type: Bug >Reporter: Adam Szita >Assignee: Adam Szita >Priority: Major > Attachments: HIVE-22099.0.patch, HIVE-22099.1.patch > > > Currently dates that belong to Julian calendar (before Oct 15, 1582) are > handled improperly by date/timestamp UDFs. > E.g. DateFormat UDF: > Although the dates are in Julian calendar, the formatter insists to print > these according to Gregorian calendar causing multiple days of difference in > some cases: > > {code:java} > beeline> select date_format('1001-01-05','dd---MM--'); > ++ > | _c0 | > ++ > | 30---12--1000 | > ++{code} > I've observed similar problems in the following UDFs: > * add_months > * date_format > * day > * month > * months_between > * weekofyear > * year > -- This message was sent by Atlassian JIRA (v7.6.14#76016)
[jira] [Updated] (HIVE-22099) Several date related UDFs can't handle Julian dates properly since HIVE-20007
[ https://issues.apache.org/jira/browse/HIVE-22099?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Adam Szita updated HIVE-22099: -- Labels: (was: backward-incompatible) > Several date related UDFs can't handle Julian dates properly since HIVE-20007 > - > > Key: HIVE-22099 > URL: https://issues.apache.org/jira/browse/HIVE-22099 > Project: Hive > Issue Type: Bug >Reporter: Adam Szita >Assignee: Adam Szita >Priority: Major > Attachments: HIVE-22099.0.patch, HIVE-22099.1.patch > > > Currently dates that belong to Julian calendar (before Oct 15, 1582) are > handled improperly by date/timestamp UDFs. > E.g. DateFormat UDF: > Although the dates are in Julian calendar, the formatter insists to print > these according to Gregorian calendar causing multiple days of difference in > some cases: > > {code:java} > beeline> select date_format('1001-01-05','dd---MM--'); > ++ > | _c0 | > ++ > | 30---12--1000 | > ++{code} > I've observed similar problems in the following UDFs: > * add_months > * date_format > * day > * month > * months_between > * weekofyear > * year > -- This message was sent by Atlassian JIRA (v7.6.14#76016)
[jira] [Updated] (HIVE-22099) Several date related UDFs can't handle Julian dates properly since HIVE-20007
[ https://issues.apache.org/jira/browse/HIVE-22099?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Adam Szita updated HIVE-22099: -- Description: Currently dates that belong to Julian calendar (before Oct 15, 1582) are handled improperly by date/timestamp UDFs. E.g. DateFormat UDF: Although the dates are in Julian calendar, the formatter insists to print these according to Gregorian calendar causing multiple days of difference in some cases: {code:java} beeline> select date_format('1001-01-05','dd---MM--'); ++ | _c0 | ++ | 30---12--1000 | ++{code} I've observed similar problems in the following UDFs: * add_months * date_format * day * month * months_between * weekofyear * year was: Currently dates that belong to Julian calendar (before Oct 15, 1582) are handled improperly by DateFormat UDF: Although the dates are in Julian calendar, the formatter insists to print these according to Gregorian calendar causing multiple days of difference in some cases: {code:java} beeline> select date_format('1001-01-05','dd---MM--'); ++ | _c0 | ++ | 30---12--1000 | ++{code} > Several date related UDFs can't handle Julian dates properly since HIVE-20007 > - > > Key: HIVE-22099 > URL: https://issues.apache.org/jira/browse/HIVE-22099 > Project: Hive > Issue Type: Bug >Reporter: Adam Szita >Assignee: Adam Szita >Priority: Major > Labels: backward-incompatible > Attachments: HIVE-22099.0.patch, HIVE-22099.1.patch > > > Currently dates that belong to Julian calendar (before Oct 15, 1582) are > handled improperly by date/timestamp UDFs. > E.g. DateFormat UDF: > Although the dates are in Julian calendar, the formatter insists to print > these according to Gregorian calendar causing multiple days of difference in > some cases: > > {code:java} > beeline> select date_format('1001-01-05','dd---MM--'); > ++ > | _c0 | > ++ > | 30---12--1000 | > ++{code} > I've observed similar problems in the following UDFs: > * add_months > * date_format > * day > * month > * months_between > * weekofyear > * year > -- This message was sent by Atlassian JIRA (v7.6.14#76016)
[jira] [Updated] (HIVE-22099) Several date related UDFs can't handle Julian dates properly since HIVE-20007
[ https://issues.apache.org/jira/browse/HIVE-22099?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Adam Szita updated HIVE-22099: -- Summary: Several date related UDFs can't handle Julian dates properly since HIVE-20007 (was: GenericUDFDateFormat can't handle Julian dates properly) > Several date related UDFs can't handle Julian dates properly since HIVE-20007 > - > > Key: HIVE-22099 > URL: https://issues.apache.org/jira/browse/HIVE-22099 > Project: Hive > Issue Type: Bug >Reporter: Adam Szita >Assignee: Adam Szita >Priority: Major > Labels: backward-incompatible > Attachments: HIVE-22099.0.patch, HIVE-22099.1.patch > > > Currently dates that belong to Julian calendar (before Oct 15, 1582) are > handled improperly by DateFormat UDF: > Although the dates are in Julian calendar, the formatter insists to print > these according to Gregorian calendar causing multiple days of difference in > some cases: > > {code:java} > beeline> select date_format('1001-01-05','dd---MM--'); > ++ > | _c0 | > ++ > | 30---12--1000 | > ++{code} > > -- This message was sent by Atlassian JIRA (v7.6.14#76016)