[jira] [Updated] (HIVE-5686) partition column type validation doesn't quite work for dates
[ https://issues.apache.org/jira/browse/HIVE-5686?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan updated HIVE-5686: --- Resolution: Fixed Fix Version/s: 0.13.0 Status: Resolved (was: Patch Available) Committed to trunk. Thanks, Sergey! partition column type validation doesn't quite work for dates - Key: HIVE-5686 URL: https://issues.apache.org/jira/browse/HIVE-5686 Project: Hive Issue Type: Bug Reporter: Sergey Shelukhin Assignee: Sergey Shelukhin Fix For: 0.13.0 Attachments: HIVE-5686.01.patch, HIVE-5686.02.patch, HIVE-5686.03.patch, HIVE-5686.03.patch, HIVE-5686.03.patch, HIVE-5686.04.patch, HIVE-5686.patch Another interesting issue... {noformat} hive create table z(c string) partitioned by (i date,j date); OK Time taken: 0.099 seconds hive alter table z add partition (i='2012-01-01', j='foo'); FAILED: SemanticException [Error 10248]: Cannot add partition column j of type string as it cannot be converted to type date hive alter table z add partition (i='2012-01-01', j=date 'foo'); OK Time taken: 0.119 seconds {noformat} The fake date is caught in normal queries: {noformat} hive select * from z where j == date 'foo'; FAILED: SemanticException Unable to convert date literal string to date value. {noformat} -- This message was sent by Atlassian JIRA (v6.1#6144)
[jira] [Updated] (HIVE-5686) partition column type validation doesn't quite work for dates
[ https://issues.apache.org/jira/browse/HIVE-5686?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Shelukhin updated HIVE-5686: --- Attachment: HIVE-5686.04.patch partition column type validation doesn't quite work for dates - Key: HIVE-5686 URL: https://issues.apache.org/jira/browse/HIVE-5686 Project: Hive Issue Type: Bug Reporter: Sergey Shelukhin Assignee: Sergey Shelukhin Attachments: HIVE-5686.01.patch, HIVE-5686.02.patch, HIVE-5686.03.patch, HIVE-5686.03.patch, HIVE-5686.03.patch, HIVE-5686.04.patch, HIVE-5686.patch Another interesting issue... {noformat} hive create table z(c string) partitioned by (i date,j date); OK Time taken: 0.099 seconds hive alter table z add partition (i='2012-01-01', j='foo'); FAILED: SemanticException [Error 10248]: Cannot add partition column j of type string as it cannot be converted to type date hive alter table z add partition (i='2012-01-01', j=date 'foo'); OK Time taken: 0.119 seconds {noformat} The fake date is caught in normal queries: {noformat} hive select * from z where j == date 'foo'; FAILED: SemanticException Unable to convert date literal string to date value. {noformat} -- This message was sent by Atlassian JIRA (v6.1#6144)
[jira] [Updated] (HIVE-5686) partition column type validation doesn't quite work for dates
[ https://issues.apache.org/jira/browse/HIVE-5686?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Shelukhin updated HIVE-5686: --- Attachment: HIVE-5686.03.patch fix patch partition column type validation doesn't quite work for dates - Key: HIVE-5686 URL: https://issues.apache.org/jira/browse/HIVE-5686 Project: Hive Issue Type: Bug Reporter: Sergey Shelukhin Assignee: Sergey Shelukhin Attachments: HIVE-5686.01.patch, HIVE-5686.02.patch, HIVE-5686.03.patch, HIVE-5686.03.patch, HIVE-5686.patch Another interesting issue... {noformat} hive create table z(c string) partitioned by (i date,j date); OK Time taken: 0.099 seconds hive alter table z add partition (i='2012-01-01', j='foo'); FAILED: SemanticException [Error 10248]: Cannot add partition column j of type string as it cannot be converted to type date hive alter table z add partition (i='2012-01-01', j=date 'foo'); OK Time taken: 0.119 seconds {noformat} The fake date is caught in normal queries: {noformat} hive select * from z where j == date 'foo'; FAILED: SemanticException Unable to convert date literal string to date value. {noformat} -- This message was sent by Atlassian JIRA (v6.1#6144)
[jira] [Updated] (HIVE-5686) partition column type validation doesn't quite work for dates
[ https://issues.apache.org/jira/browse/HIVE-5686?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Shelukhin updated HIVE-5686: --- Status: Open (was: Patch Available) partition column type validation doesn't quite work for dates - Key: HIVE-5686 URL: https://issues.apache.org/jira/browse/HIVE-5686 Project: Hive Issue Type: Bug Reporter: Sergey Shelukhin Assignee: Sergey Shelukhin Attachments: HIVE-5686.01.patch, HIVE-5686.02.patch, HIVE-5686.03.patch, HIVE-5686.03.patch, HIVE-5686.patch Another interesting issue... {noformat} hive create table z(c string) partitioned by (i date,j date); OK Time taken: 0.099 seconds hive alter table z add partition (i='2012-01-01', j='foo'); FAILED: SemanticException [Error 10248]: Cannot add partition column j of type string as it cannot be converted to type date hive alter table z add partition (i='2012-01-01', j=date 'foo'); OK Time taken: 0.119 seconds {noformat} The fake date is caught in normal queries: {noformat} hive select * from z where j == date 'foo'; FAILED: SemanticException Unable to convert date literal string to date value. {noformat} -- This message was sent by Atlassian JIRA (v6.1#6144)
[jira] [Updated] (HIVE-5686) partition column type validation doesn't quite work for dates
[ https://issues.apache.org/jira/browse/HIVE-5686?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Shelukhin updated HIVE-5686: --- Status: Patch Available (was: Open) partition column type validation doesn't quite work for dates - Key: HIVE-5686 URL: https://issues.apache.org/jira/browse/HIVE-5686 Project: Hive Issue Type: Bug Reporter: Sergey Shelukhin Assignee: Sergey Shelukhin Attachments: HIVE-5686.01.patch, HIVE-5686.02.patch, HIVE-5686.03.patch, HIVE-5686.03.patch, HIVE-5686.03.patch, HIVE-5686.patch Another interesting issue... {noformat} hive create table z(c string) partitioned by (i date,j date); OK Time taken: 0.099 seconds hive alter table z add partition (i='2012-01-01', j='foo'); FAILED: SemanticException [Error 10248]: Cannot add partition column j of type string as it cannot be converted to type date hive alter table z add partition (i='2012-01-01', j=date 'foo'); OK Time taken: 0.119 seconds {noformat} The fake date is caught in normal queries: {noformat} hive select * from z where j == date 'foo'; FAILED: SemanticException Unable to convert date literal string to date value. {noformat} -- This message was sent by Atlassian JIRA (v6.1#6144)
[jira] [Updated] (HIVE-5686) partition column type validation doesn't quite work for dates
[ https://issues.apache.org/jira/browse/HIVE-5686?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Shelukhin updated HIVE-5686: --- Attachment: HIVE-5686.03.patch partition column type validation doesn't quite work for dates - Key: HIVE-5686 URL: https://issues.apache.org/jira/browse/HIVE-5686 Project: Hive Issue Type: Bug Reporter: Sergey Shelukhin Assignee: Sergey Shelukhin Attachments: HIVE-5686.01.patch, HIVE-5686.02.patch, HIVE-5686.03.patch, HIVE-5686.03.patch, HIVE-5686.03.patch, HIVE-5686.patch Another interesting issue... {noformat} hive create table z(c string) partitioned by (i date,j date); OK Time taken: 0.099 seconds hive alter table z add partition (i='2012-01-01', j='foo'); FAILED: SemanticException [Error 10248]: Cannot add partition column j of type string as it cannot be converted to type date hive alter table z add partition (i='2012-01-01', j=date 'foo'); OK Time taken: 0.119 seconds {noformat} The fake date is caught in normal queries: {noformat} hive select * from z where j == date 'foo'; FAILED: SemanticException Unable to convert date literal string to date value. {noformat} -- This message was sent by Atlassian JIRA (v6.1#6144)
[jira] [Updated] (HIVE-5686) partition column type validation doesn't quite work for dates
[ https://issues.apache.org/jira/browse/HIVE-5686?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Shelukhin updated HIVE-5686: --- Status: Open (was: Patch Available) partition column type validation doesn't quite work for dates - Key: HIVE-5686 URL: https://issues.apache.org/jira/browse/HIVE-5686 Project: Hive Issue Type: Bug Reporter: Sergey Shelukhin Assignee: Sergey Shelukhin Attachments: HIVE-5686.01.patch, HIVE-5686.02.patch, HIVE-5686.patch Another interesting issue... {noformat} hive create table z(c string) partitioned by (i date,j date); OK Time taken: 0.099 seconds hive alter table z add partition (i='2012-01-01', j='foo'); FAILED: SemanticException [Error 10248]: Cannot add partition column j of type string as it cannot be converted to type date hive alter table z add partition (i='2012-01-01', j=date 'foo'); OK Time taken: 0.119 seconds {noformat} The fake date is caught in normal queries: {noformat} hive select * from z where j == date 'foo'; FAILED: SemanticException Unable to convert date literal string to date value. {noformat} -- This message was sent by Atlassian JIRA (v6.1#6144)
[jira] [Updated] (HIVE-5686) partition column type validation doesn't quite work for dates
[ https://issues.apache.org/jira/browse/HIVE-5686?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Shelukhin updated HIVE-5686: --- Attachment: HIVE-5686.03.patch exact same patch again partition column type validation doesn't quite work for dates - Key: HIVE-5686 URL: https://issues.apache.org/jira/browse/HIVE-5686 Project: Hive Issue Type: Bug Reporter: Sergey Shelukhin Assignee: Sergey Shelukhin Attachments: HIVE-5686.01.patch, HIVE-5686.02.patch, HIVE-5686.03.patch, HIVE-5686.patch Another interesting issue... {noformat} hive create table z(c string) partitioned by (i date,j date); OK Time taken: 0.099 seconds hive alter table z add partition (i='2012-01-01', j='foo'); FAILED: SemanticException [Error 10248]: Cannot add partition column j of type string as it cannot be converted to type date hive alter table z add partition (i='2012-01-01', j=date 'foo'); OK Time taken: 0.119 seconds {noformat} The fake date is caught in normal queries: {noformat} hive select * from z where j == date 'foo'; FAILED: SemanticException Unable to convert date literal string to date value. {noformat} -- This message was sent by Atlassian JIRA (v6.1#6144)
[jira] [Updated] (HIVE-5686) partition column type validation doesn't quite work for dates
[ https://issues.apache.org/jira/browse/HIVE-5686?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Shelukhin updated HIVE-5686: --- Attachment: HIVE-5686.02.patch add support for dynamic partitioning with some static columns; remove the corresponding exception partition column type validation doesn't quite work for dates - Key: HIVE-5686 URL: https://issues.apache.org/jira/browse/HIVE-5686 Project: Hive Issue Type: Bug Reporter: Sergey Shelukhin Assignee: Sergey Shelukhin Attachments: HIVE-5686.01.patch, HIVE-5686.02.patch, HIVE-5686.patch Another interesting issue... {noformat} hive create table z(c string) partitioned by (i date,j date); OK Time taken: 0.099 seconds hive alter table z add partition (i='2012-01-01', j='foo'); FAILED: SemanticException [Error 10248]: Cannot add partition column j of type string as it cannot be converted to type date hive alter table z add partition (i='2012-01-01', j=date 'foo'); OK Time taken: 0.119 seconds {noformat} The fake date is caught in normal queries: {noformat} hive select * from z where j == date 'foo'; FAILED: SemanticException Unable to convert date literal string to date value. {noformat} -- This message was sent by Atlassian JIRA (v6.1#6144)
[jira] [Updated] (HIVE-5686) partition column type validation doesn't quite work for dates
[ https://issues.apache.org/jira/browse/HIVE-5686?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Shelukhin updated HIVE-5686: --- Status: Patch Available (was: Open) partition column type validation doesn't quite work for dates - Key: HIVE-5686 URL: https://issues.apache.org/jira/browse/HIVE-5686 Project: Hive Issue Type: Bug Reporter: Sergey Shelukhin Assignee: Sergey Shelukhin Attachments: HIVE-5686.01.patch, HIVE-5686.02.patch, HIVE-5686.patch Another interesting issue... {noformat} hive create table z(c string) partitioned by (i date,j date); OK Time taken: 0.099 seconds hive alter table z add partition (i='2012-01-01', j='foo'); FAILED: SemanticException [Error 10248]: Cannot add partition column j of type string as it cannot be converted to type date hive alter table z add partition (i='2012-01-01', j=date 'foo'); OK Time taken: 0.119 seconds {noformat} The fake date is caught in normal queries: {noformat} hive select * from z where j == date 'foo'; FAILED: SemanticException Unable to convert date literal string to date value. {noformat} -- This message was sent by Atlassian JIRA (v6.1#6144)
[jira] [Updated] (HIVE-5686) partition column type validation doesn't quite work for dates
[ https://issues.apache.org/jira/browse/HIVE-5686?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan updated HIVE-5686: --- Status: Open (was: Patch Available) partition column type validation doesn't quite work for dates - Key: HIVE-5686 URL: https://issues.apache.org/jira/browse/HIVE-5686 Project: Hive Issue Type: Bug Reporter: Sergey Shelukhin Assignee: Sergey Shelukhin Attachments: HIVE-5686.01.patch, HIVE-5686.patch Another interesting issue... {noformat} hive create table z(c string) partitioned by (i date,j date); OK Time taken: 0.099 seconds hive alter table z add partition (i='2012-01-01', j='foo'); FAILED: SemanticException [Error 10248]: Cannot add partition column j of type string as it cannot be converted to type date hive alter table z add partition (i='2012-01-01', j=date 'foo'); OK Time taken: 0.119 seconds {noformat} The fake date is caught in normal queries: {noformat} hive select * from z where j == date 'foo'; FAILED: SemanticException Unable to convert date literal string to date value. {noformat} -- This message was sent by Atlassian JIRA (v6.1#6144)
[jira] [Updated] (HIVE-5686) partition column type validation doesn't quite work for dates
[ https://issues.apache.org/jira/browse/HIVE-5686?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan updated HIVE-5686: --- Status: Open (was: Patch Available) You need to re-upload the patch for Hive QA to kick in. partition column type validation doesn't quite work for dates - Key: HIVE-5686 URL: https://issues.apache.org/jira/browse/HIVE-5686 Project: Hive Issue Type: Bug Reporter: Sergey Shelukhin Assignee: Sergey Shelukhin Attachments: HIVE-5686.patch Another interesting issue... {noformat} hive create table z(c string) partitioned by (i date,j date); OK Time taken: 0.099 seconds hive alter table z add partition (i='2012-01-01', j='foo'); FAILED: SemanticException [Error 10248]: Cannot add partition column j of type string as it cannot be converted to type date hive alter table z add partition (i='2012-01-01', j=date 'foo'); OK Time taken: 0.119 seconds {noformat} The fake date is caught in normal queries: {noformat} hive select * from z where j == date 'foo'; FAILED: SemanticException Unable to convert date literal string to date value. {noformat} -- This message was sent by Atlassian JIRA (v6.1#6144)
[jira] [Updated] (HIVE-5686) partition column type validation doesn't quite work for dates
[ https://issues.apache.org/jira/browse/HIVE-5686?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Shelukhin updated HIVE-5686: --- Status: Patch Available (was: Open) partition column type validation doesn't quite work for dates - Key: HIVE-5686 URL: https://issues.apache.org/jira/browse/HIVE-5686 Project: Hive Issue Type: Bug Reporter: Sergey Shelukhin Assignee: Sergey Shelukhin Attachments: HIVE-5686.01.patch, HIVE-5686.patch Another interesting issue... {noformat} hive create table z(c string) partitioned by (i date,j date); OK Time taken: 0.099 seconds hive alter table z add partition (i='2012-01-01', j='foo'); FAILED: SemanticException [Error 10248]: Cannot add partition column j of type string as it cannot be converted to type date hive alter table z add partition (i='2012-01-01', j=date 'foo'); OK Time taken: 0.119 seconds {noformat} The fake date is caught in normal queries: {noformat} hive select * from z where j == date 'foo'; FAILED: SemanticException Unable to convert date literal string to date value. {noformat} -- This message was sent by Atlassian JIRA (v6.1#6144)
[jira] [Updated] (HIVE-5686) partition column type validation doesn't quite work for dates
[ https://issues.apache.org/jira/browse/HIVE-5686?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Shelukhin updated HIVE-5686: --- Attachment: HIVE-5686.01.patch same patch partition column type validation doesn't quite work for dates - Key: HIVE-5686 URL: https://issues.apache.org/jira/browse/HIVE-5686 Project: Hive Issue Type: Bug Reporter: Sergey Shelukhin Assignee: Sergey Shelukhin Attachments: HIVE-5686.01.patch, HIVE-5686.patch Another interesting issue... {noformat} hive create table z(c string) partitioned by (i date,j date); OK Time taken: 0.099 seconds hive alter table z add partition (i='2012-01-01', j='foo'); FAILED: SemanticException [Error 10248]: Cannot add partition column j of type string as it cannot be converted to type date hive alter table z add partition (i='2012-01-01', j=date 'foo'); OK Time taken: 0.119 seconds {noformat} The fake date is caught in normal queries: {noformat} hive select * from z where j == date 'foo'; FAILED: SemanticException Unable to convert date literal string to date value. {noformat} -- This message was sent by Atlassian JIRA (v6.1#6144)
[jira] [Updated] (HIVE-5686) partition column type validation doesn't quite work for dates
[ https://issues.apache.org/jira/browse/HIVE-5686?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Shelukhin updated HIVE-5686: --- Attachment: HIVE-5686.patch partition column type validation doesn't quite work for dates - Key: HIVE-5686 URL: https://issues.apache.org/jira/browse/HIVE-5686 Project: Hive Issue Type: Bug Reporter: Sergey Shelukhin Assignee: Sergey Shelukhin Attachments: HIVE-5686.patch Another interesting issue... {noformat} hive create table z(c string) partitioned by (i date,j date); OK Time taken: 0.099 seconds hive alter table z add partition (i='2012-01-01', j='foo'); FAILED: SemanticException [Error 10248]: Cannot add partition column j of type string as it cannot be converted to type date hive alter table z add partition (i='2012-01-01', j=date 'foo'); OK Time taken: 0.119 seconds {noformat} The fake date is caught in normal queries: {noformat} hive select * from z where j == date 'foo'; FAILED: SemanticException Unable to convert date literal string to date value. {noformat} -- This message was sent by Atlassian JIRA (v6.1#6144)
[jira] [Updated] (HIVE-5686) partition column type validation doesn't quite work for dates
[ https://issues.apache.org/jira/browse/HIVE-5686?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Shelukhin updated HIVE-5686: --- Description: Another interesting issue... {noformat} hive create table z(c string) partitioned by (i date,j date); OK Time taken: 0.099 seconds hive alter table z add partition (i='2012-01-01', j='foo'); FAILED: SemanticException [Error 10248]: Cannot add partition column j of type string as it cannot be converted to type date hive alter table z add partition (i='2012-01-01', j=date 'foo'); OK Time taken: 0.119 seconds {noformat} The fake date is caught in normal queries: {noformat} hive select * from z where j == date 'foo'; FAILED: SemanticException Unable to convert date literal string to date value. {noformat} was: Another interesting issue... {noformat} hive create table z(c string) partitioned by (i date,j date); OK Time taken: 0.099 seconds hive alter table z add partition (i='2012-01-01', j='foo'); FAILED: SemanticException [Error 10248]: Cannot add partition column j of type string as it cannot be converted to type date hive alter table z add partition (i='2012-01-01', j=date 'foo'); OK Time taken: 0.119 seconds {noformat} partition column type validation doesn't quite work for dates - Key: HIVE-5686 URL: https://issues.apache.org/jira/browse/HIVE-5686 Project: Hive Issue Type: Bug Reporter: Sergey Shelukhin Assignee: Vikram Dixit K Another interesting issue... {noformat} hive create table z(c string) partitioned by (i date,j date); OK Time taken: 0.099 seconds hive alter table z add partition (i='2012-01-01', j='foo'); FAILED: SemanticException [Error 10248]: Cannot add partition column j of type string as it cannot be converted to type date hive alter table z add partition (i='2012-01-01', j=date 'foo'); OK Time taken: 0.119 seconds {noformat} The fake date is caught in normal queries: {noformat} hive select * from z where j == date 'foo'; FAILED: SemanticException Unable to convert date literal string to date value. {noformat} -- This message was sent by Atlassian JIRA (v6.1#6144)