[jira] [Updated] (HIVE-9396) date_add()/date_sub() should allow tinyint/smallint/bigint arguments in addition to int
[
https://issues.apache.org/jira/browse/HIVE-9396?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jason Dere updated HIVE-9396:
-
Resolution: Fixed
Status: Resolved (was: Patch Available)
I've committed this to trunk, thanks for doing this [~spena].
date_add()/date_sub() should allow tinyint/smallint/bigint arguments in
addition to int
---
Key: HIVE-9396
URL: https://issues.apache.org/jira/browse/HIVE-9396
Project: Hive
Issue Type: Bug
Components: UDF
Reporter: Jason Dere
Assignee: Sergio Peña
Attachments: HIVE-9396.3.patch, HIVE-9396.4.patch
{noformat}
hive select c1, date_add('1985-01-01', c1) from short1;
FAILED: SemanticException [Error 10014]: Line 1:11 Wrong arguments 'c1':
DATE_ADD() only takes INT types as second argument, got SHORT
{noformat}
We should allow date_add()/date_sub() to take any integral type for the 2nd
argument, rather than just int.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Updated] (HIVE-9396) date_add()/date_sub() should allow tinyint/smallint/bigint arguments in addition to int
[
https://issues.apache.org/jira/browse/HIVE-9396?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Lefty Leverenz updated HIVE-9396:
-
Fix Version/s: 0.15.0
date_add()/date_sub() should allow tinyint/smallint/bigint arguments in
addition to int
---
Key: HIVE-9396
URL: https://issues.apache.org/jira/browse/HIVE-9396
Project: Hive
Issue Type: Bug
Components: UDF
Reporter: Jason Dere
Assignee: Sergio Peña
Fix For: 0.15.0
Attachments: HIVE-9396.3.patch, HIVE-9396.4.patch
{noformat}
hive select c1, date_add('1985-01-01', c1) from short1;
FAILED: SemanticException [Error 10014]: Line 1:11 Wrong arguments 'c1':
DATE_ADD() only takes INT types as second argument, got SHORT
{noformat}
We should allow date_add()/date_sub() to take any integral type for the 2nd
argument, rather than just int.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Updated] (HIVE-9396) date_add()/date_sub() should allow tinyint/smallint/bigint arguments in addition to int
[
https://issues.apache.org/jira/browse/HIVE-9396?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Lefty Leverenz updated HIVE-9396:
-
Labels: TODOC15 (was: )
date_add()/date_sub() should allow tinyint/smallint/bigint arguments in
addition to int
---
Key: HIVE-9396
URL: https://issues.apache.org/jira/browse/HIVE-9396
Project: Hive
Issue Type: Bug
Components: UDF
Reporter: Jason Dere
Assignee: Sergio Peña
Labels: TODOC15
Fix For: 0.15.0
Attachments: HIVE-9396.3.patch, HIVE-9396.4.patch
{noformat}
hive select c1, date_add('1985-01-01', c1) from short1;
FAILED: SemanticException [Error 10014]: Line 1:11 Wrong arguments 'c1':
DATE_ADD() only takes INT types as second argument, got SHORT
{noformat}
We should allow date_add()/date_sub() to take any integral type for the 2nd
argument, rather than just int.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Updated] (HIVE-9396) date_add()/date_sub() should allow tinyint/smallint/bigint arguments in addition to int
[
https://issues.apache.org/jira/browse/HIVE-9396?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sergio Peña updated HIVE-9396:
--
Status: Patch Available (was: Open)
date_add()/date_sub() should allow tinyint/smallint/bigint arguments in
addition to int
---
Key: HIVE-9396
URL: https://issues.apache.org/jira/browse/HIVE-9396
Project: Hive
Issue Type: Bug
Components: UDF
Reporter: Jason Dere
Assignee: Sergio Peña
Attachments: HIVE-9396.3.patch
{noformat}
hive select c1, date_add('1985-01-01', c1) from short1;
FAILED: SemanticException [Error 10014]: Line 1:11 Wrong arguments 'c1':
DATE_ADD() only takes INT types as second argument, got SHORT
{noformat}
We should allow date_add()/date_sub() to take any integral type for the 2nd
argument, rather than just int.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Updated] (HIVE-9396) date_add()/date_sub() should allow tinyint/smallint/bigint arguments in addition to int
[
https://issues.apache.org/jira/browse/HIVE-9396?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sergio Peña updated HIVE-9396:
--
Attachment: (was: HIVE-9396.2.patch)
date_add()/date_sub() should allow tinyint/smallint/bigint arguments in
addition to int
---
Key: HIVE-9396
URL: https://issues.apache.org/jira/browse/HIVE-9396
Project: Hive
Issue Type: Bug
Components: UDF
Reporter: Jason Dere
Assignee: Sergio Peña
Attachments: HIVE-9396.3.patch
{noformat}
hive select c1, date_add('1985-01-01', c1) from short1;
FAILED: SemanticException [Error 10014]: Line 1:11 Wrong arguments 'c1':
DATE_ADD() only takes INT types as second argument, got SHORT
{noformat}
We should allow date_add()/date_sub() to take any integral type for the 2nd
argument, rather than just int.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Updated] (HIVE-9396) date_add()/date_sub() should allow tinyint/smallint/bigint arguments in addition to int
[
https://issues.apache.org/jira/browse/HIVE-9396?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sergio Peña updated HIVE-9396:
--
Status: Open (was: Patch Available)
date_add()/date_sub() should allow tinyint/smallint/bigint arguments in
addition to int
---
Key: HIVE-9396
URL: https://issues.apache.org/jira/browse/HIVE-9396
Project: Hive
Issue Type: Bug
Components: UDF
Reporter: Jason Dere
Assignee: Sergio Peña
Attachments: HIVE-9396.3.patch
{noformat}
hive select c1, date_add('1985-01-01', c1) from short1;
FAILED: SemanticException [Error 10014]: Line 1:11 Wrong arguments 'c1':
DATE_ADD() only takes INT types as second argument, got SHORT
{noformat}
We should allow date_add()/date_sub() to take any integral type for the 2nd
argument, rather than just int.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Updated] (HIVE-9396) date_add()/date_sub() should allow tinyint/smallint/bigint arguments in addition to int
[
https://issues.apache.org/jira/browse/HIVE-9396?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sergio Peña updated HIVE-9396:
--
Attachment: HIVE-9396.4.patch
Attaching new patch with tests updated so that in can apply patch on trunk
date_add()/date_sub() should allow tinyint/smallint/bigint arguments in
addition to int
---
Key: HIVE-9396
URL: https://issues.apache.org/jira/browse/HIVE-9396
Project: Hive
Issue Type: Bug
Components: UDF
Reporter: Jason Dere
Assignee: Sergio Peña
Attachments: HIVE-9396.3.patch, HIVE-9396.4.patch
{noformat}
hive select c1, date_add('1985-01-01', c1) from short1;
FAILED: SemanticException [Error 10014]: Line 1:11 Wrong arguments 'c1':
DATE_ADD() only takes INT types as second argument, got SHORT
{noformat}
We should allow date_add()/date_sub() to take any integral type for the 2nd
argument, rather than just int.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Updated] (HIVE-9396) date_add()/date_sub() should allow tinyint/smallint/bigint arguments in addition to int
[
https://issues.apache.org/jira/browse/HIVE-9396?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sergio Peña updated HIVE-9396:
--
Status: Patch Available (was: Open)
date_add()/date_sub() should allow tinyint/smallint/bigint arguments in
addition to int
---
Key: HIVE-9396
URL: https://issues.apache.org/jira/browse/HIVE-9396
Project: Hive
Issue Type: Bug
Components: UDF
Reporter: Jason Dere
Assignee: Sergio Peña
Attachments: HIVE-9396.3.patch, HIVE-9396.4.patch
{noformat}
hive select c1, date_add('1985-01-01', c1) from short1;
FAILED: SemanticException [Error 10014]: Line 1:11 Wrong arguments 'c1':
DATE_ADD() only takes INT types as second argument, got SHORT
{noformat}
We should allow date_add()/date_sub() to take any integral type for the 2nd
argument, rather than just int.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Updated] (HIVE-9396) date_add()/date_sub() should allow tinyint/smallint/bigint arguments in addition to int
[
https://issues.apache.org/jira/browse/HIVE-9396?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sergio Peña updated HIVE-9396:
--
Attachment: HIVE-9396.3.patch
date_add()/date_sub() should allow tinyint/smallint/bigint arguments in
addition to int
---
Key: HIVE-9396
URL: https://issues.apache.org/jira/browse/HIVE-9396
Project: Hive
Issue Type: Bug
Components: UDF
Reporter: Jason Dere
Assignee: Sergio Peña
Attachments: HIVE-9396.3.patch
{noformat}
hive select c1, date_add('1985-01-01', c1) from short1;
FAILED: SemanticException [Error 10014]: Line 1:11 Wrong arguments 'c1':
DATE_ADD() only takes INT types as second argument, got SHORT
{noformat}
We should allow date_add()/date_sub() to take any integral type for the 2nd
argument, rather than just int.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Updated] (HIVE-9396) date_add()/date_sub() should allow tinyint/smallint/bigint arguments in addition to int
[
https://issues.apache.org/jira/browse/HIVE-9396?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sergio Peña updated HIVE-9396:
--
Status: Open (was: Patch Available)
Canceling patch to rename attachment, and run patch again.
date_add()/date_sub() should allow tinyint/smallint/bigint arguments in
addition to int
---
Key: HIVE-9396
URL: https://issues.apache.org/jira/browse/HIVE-9396
Project: Hive
Issue Type: Bug
Components: UDF
Reporter: Jason Dere
Assignee: Sergio Peña
Attachments: HIVE-9396.3.patch
{noformat}
hive select c1, date_add('1985-01-01', c1) from short1;
FAILED: SemanticException [Error 10014]: Line 1:11 Wrong arguments 'c1':
DATE_ADD() only takes INT types as second argument, got SHORT
{noformat}
We should allow date_add()/date_sub() to take any integral type for the 2nd
argument, rather than just int.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Updated] (HIVE-9396) date_add()/date_sub() should allow tinyint/smallint/bigint arguments in addition to int
[
https://issues.apache.org/jira/browse/HIVE-9396?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jason Dere updated HIVE-9396:
-
Status: Patch Available (was: Open)
date_add()/date_sub() should allow tinyint/smallint/bigint arguments in
addition to int
---
Key: HIVE-9396
URL: https://issues.apache.org/jira/browse/HIVE-9396
Project: Hive
Issue Type: Bug
Components: UDF
Reporter: Jason Dere
Assignee: Sergio Peña
Attachments: HIVE-9396.2.patch
{noformat}
hive select c1, date_add('1985-01-01', c1) from short1;
FAILED: SemanticException [Error 10014]: Line 1:11 Wrong arguments 'c1':
DATE_ADD() only takes INT types as second argument, got SHORT
{noformat}
We should allow date_add()/date_sub() to take any integral type for the 2nd
argument, rather than just int.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Updated] (HIVE-9396) date_add()/date_sub() should allow tinyint/smallint/bigint arguments in addition to int
[
https://issues.apache.org/jira/browse/HIVE-9396?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jason Dere updated HIVE-9396:
-
Status: Open (was: Patch Available)
date_add()/date_sub() should allow tinyint/smallint/bigint arguments in
addition to int
---
Key: HIVE-9396
URL: https://issues.apache.org/jira/browse/HIVE-9396
Project: Hive
Issue Type: Bug
Components: UDF
Reporter: Jason Dere
Assignee: Sergio Peña
Attachments: HIVE-9396.2.patch
{noformat}
hive select c1, date_add('1985-01-01', c1) from short1;
FAILED: SemanticException [Error 10014]: Line 1:11 Wrong arguments 'c1':
DATE_ADD() only takes INT types as second argument, got SHORT
{noformat}
We should allow date_add()/date_sub() to take any integral type for the 2nd
argument, rather than just int.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Updated] (HIVE-9396) date_add()/date_sub() should allow tinyint/smallint/bigint arguments in addition to int
[
https://issues.apache.org/jira/browse/HIVE-9396?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sergio Peña updated HIVE-9396:
--
Attachment: HIVE-9396.1.patch
date_add()/date_sub() should allow tinyint/smallint/bigint arguments in
addition to int
---
Key: HIVE-9396
URL: https://issues.apache.org/jira/browse/HIVE-9396
Project: Hive
Issue Type: Bug
Components: UDF
Reporter: Jason Dere
Assignee: Sergio Peña
Attachments: HIVE-9396.1.patch
{noformat}
hive select c1, date_add('1985-01-01', c1) from short1;
FAILED: SemanticException [Error 10014]: Line 1:11 Wrong arguments 'c1':
DATE_ADD() only takes INT types as second argument, got SHORT
{noformat}
We should allow date_add()/date_sub() to take any integral type for the 2nd
argument, rather than just int.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Updated] (HIVE-9396) date_add()/date_sub() should allow tinyint/smallint/bigint arguments in addition to int
[
https://issues.apache.org/jira/browse/HIVE-9396?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sergio Peña updated HIVE-9396:
--
Status: Patch Available (was: Open)
Here's the patch that supports tinyint/smallint/int/bigint.
Bigint is supported only if the value is = to Integer.MAX_VALUE because the
Calendar.add() method accepts only integer values.
date_add()/date_sub() should allow tinyint/smallint/bigint arguments in
addition to int
---
Key: HIVE-9396
URL: https://issues.apache.org/jira/browse/HIVE-9396
Project: Hive
Issue Type: Bug
Components: UDF
Reporter: Jason Dere
Assignee: Sergio Peña
Attachments: HIVE-9396.1.patch
{noformat}
hive select c1, date_add('1985-01-01', c1) from short1;
FAILED: SemanticException [Error 10014]: Line 1:11 Wrong arguments 'c1':
DATE_ADD() only takes INT types as second argument, got SHORT
{noformat}
We should allow date_add()/date_sub() to take any integral type for the 2nd
argument, rather than just int.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Updated] (HIVE-9396) date_add()/date_sub() should allow tinyint/smallint/bigint arguments in addition to int
[
https://issues.apache.org/jira/browse/HIVE-9396?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sergio Peña updated HIVE-9396:
--
Status: Open (was: Patch Available)
date_add()/date_sub() should allow tinyint/smallint/bigint arguments in
addition to int
---
Key: HIVE-9396
URL: https://issues.apache.org/jira/browse/HIVE-9396
Project: Hive
Issue Type: Bug
Components: UDF
Reporter: Jason Dere
Assignee: Sergio Peña
{noformat}
hive select c1, date_add('1985-01-01', c1) from short1;
FAILED: SemanticException [Error 10014]: Line 1:11 Wrong arguments 'c1':
DATE_ADD() only takes INT types as second argument, got SHORT
{noformat}
We should allow date_add()/date_sub() to take any integral type for the 2nd
argument, rather than just int.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Updated] (HIVE-9396) date_add()/date_sub() should allow tinyint/smallint/bigint arguments in addition to int
[
https://issues.apache.org/jira/browse/HIVE-9396?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sergio Peña updated HIVE-9396:
--
Attachment: (was: HIVE-9396.1.patch)
date_add()/date_sub() should allow tinyint/smallint/bigint arguments in
addition to int
---
Key: HIVE-9396
URL: https://issues.apache.org/jira/browse/HIVE-9396
Project: Hive
Issue Type: Bug
Components: UDF
Reporter: Jason Dere
Assignee: Sergio Peña
{noformat}
hive select c1, date_add('1985-01-01', c1) from short1;
FAILED: SemanticException [Error 10014]: Line 1:11 Wrong arguments 'c1':
DATE_ADD() only takes INT types as second argument, got SHORT
{noformat}
We should allow date_add()/date_sub() to take any integral type for the 2nd
argument, rather than just int.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Updated] (HIVE-9396) date_add()/date_sub() should allow tinyint/smallint/bigint arguments in addition to int
[
https://issues.apache.org/jira/browse/HIVE-9396?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sergio Peña updated HIVE-9396:
--
Attachment: (was: HIVE-9396.1.patch)
date_add()/date_sub() should allow tinyint/smallint/bigint arguments in
addition to int
---
Key: HIVE-9396
URL: https://issues.apache.org/jira/browse/HIVE-9396
Project: Hive
Issue Type: Bug
Components: UDF
Reporter: Jason Dere
Assignee: Sergio Peña
{noformat}
hive select c1, date_add('1985-01-01', c1) from short1;
FAILED: SemanticException [Error 10014]: Line 1:11 Wrong arguments 'c1':
DATE_ADD() only takes INT types as second argument, got SHORT
{noformat}
We should allow date_add()/date_sub() to take any integral type for the 2nd
argument, rather than just int.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Updated] (HIVE-9396) date_add()/date_sub() should allow tinyint/smallint/bigint arguments in addition to int
[
https://issues.apache.org/jira/browse/HIVE-9396?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sergio Peña updated HIVE-9396:
--
Attachment: HIVE-9396.1.patch
date_add()/date_sub() should allow tinyint/smallint/bigint arguments in
addition to int
---
Key: HIVE-9396
URL: https://issues.apache.org/jira/browse/HIVE-9396
Project: Hive
Issue Type: Bug
Components: UDF
Reporter: Jason Dere
Assignee: Sergio Peña
{noformat}
hive select c1, date_add('1985-01-01', c1) from short1;
FAILED: SemanticException [Error 10014]: Line 1:11 Wrong arguments 'c1':
DATE_ADD() only takes INT types as second argument, got SHORT
{noformat}
We should allow date_add()/date_sub() to take any integral type for the 2nd
argument, rather than just int.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Updated] (HIVE-9396) date_add()/date_sub() should allow tinyint/smallint/bigint arguments in addition to int
[
https://issues.apache.org/jira/browse/HIVE-9396?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sergio Peña updated HIVE-9396:
--
Attachment: HIVE-9396.2.patch
date_add()/date_sub() should allow tinyint/smallint/bigint arguments in
addition to int
---
Key: HIVE-9396
URL: https://issues.apache.org/jira/browse/HIVE-9396
Project: Hive
Issue Type: Bug
Components: UDF
Reporter: Jason Dere
Assignee: Sergio Peña
Attachments: HIVE-9396.2.patch
{noformat}
hive select c1, date_add('1985-01-01', c1) from short1;
FAILED: SemanticException [Error 10014]: Line 1:11 Wrong arguments 'c1':
DATE_ADD() only takes INT types as second argument, got SHORT
{noformat}
We should allow date_add()/date_sub() to take any integral type for the 2nd
argument, rather than just int.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Updated] (HIVE-9396) date_add()/date_sub() should allow tinyint/smallint/bigint arguments in addition to int
[
https://issues.apache.org/jira/browse/HIVE-9396?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sergio Peña updated HIVE-9396:
--
Status: Patch Available (was: Open)
Here's the patch without support for BITINT data types. TINYINT/SMALLINT/INT
are still supported.
date_add()/date_sub() should allow tinyint/smallint/bigint arguments in
addition to int
---
Key: HIVE-9396
URL: https://issues.apache.org/jira/browse/HIVE-9396
Project: Hive
Issue Type: Bug
Components: UDF
Reporter: Jason Dere
Assignee: Sergio Peña
Attachments: HIVE-9396.2.patch
{noformat}
hive select c1, date_add('1985-01-01', c1) from short1;
FAILED: SemanticException [Error 10014]: Line 1:11 Wrong arguments 'c1':
DATE_ADD() only takes INT types as second argument, got SHORT
{noformat}
We should allow date_add()/date_sub() to take any integral type for the 2nd
argument, rather than just int.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
