[jira] [Updated] (HIVE-6934) PartitionPruner doesn't handle top level constant expression correctly
[ https://issues.apache.org/jira/browse/HIVE-6934?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan updated HIVE-6934: --- Component/s: Query Processor Logical Optimizer > PartitionPruner doesn't handle top level constant expression correctly > -- > > Key: HIVE-6934 > URL: https://issues.apache.org/jira/browse/HIVE-6934 > Project: Hive > Issue Type: Bug > Components: Logical Optimizer, Query Processor >Reporter: Harish Butani >Assignee: Hari Sankar Sivarama Subramaniyan >Priority: Critical > Fix For: 0.14.0 > > Attachments: HIVE-6934.4.patch, HIVE-6934.5.patch, HIVE-6934.6.patch, > HIVE-6934.7.patch, HIVE-6934.8.patch, HIVE-6934.9.patch, HIVE-6934.91.patch, > HIVE-6934.92.patch > > > You hit this error indirectly, because how we handle invalid constant > comparisons. Consider: > {code} > create table x(key int, value string) partitioned by (dt int, ts string); > -- both these queries hit this issue > select * from x where key = 'abc'; > select * from x where dt = 'abc'; > -- the issue is the comparison get converted to the constant false > -- and the PartitionPruner doesn't handle top level constant exprs corrcetly > {code} > Thanks to [~hsubramaniyan] for uncovering this as part of adding tests for > HIVE-5376 -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-6934) PartitionPruner doesn't handle top level constant expression correctly
[ https://issues.apache.org/jira/browse/HIVE-6934?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan updated HIVE-6934: --- Fix Version/s: (was: 0.15.0) 0.14.0 > PartitionPruner doesn't handle top level constant expression correctly > -- > > Key: HIVE-6934 > URL: https://issues.apache.org/jira/browse/HIVE-6934 > Project: Hive > Issue Type: Bug > Components: Logical Optimizer, Query Processor >Reporter: Harish Butani >Assignee: Hari Sankar Sivarama Subramaniyan >Priority: Critical > Fix For: 0.14.0 > > Attachments: HIVE-6934.4.patch, HIVE-6934.5.patch, HIVE-6934.6.patch, > HIVE-6934.7.patch, HIVE-6934.8.patch, HIVE-6934.9.patch, HIVE-6934.91.patch, > HIVE-6934.92.patch > > > You hit this error indirectly, because how we handle invalid constant > comparisons. Consider: > {code} > create table x(key int, value string) partitioned by (dt int, ts string); > -- both these queries hit this issue > select * from x where key = 'abc'; > select * from x where dt = 'abc'; > -- the issue is the comparison get converted to the constant false > -- and the PartitionPruner doesn't handle top level constant exprs corrcetly > {code} > Thanks to [~hsubramaniyan] for uncovering this as part of adding tests for > HIVE-5376 -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-6934) PartitionPruner doesn't handle top level constant expression correctly
[ https://issues.apache.org/jira/browse/HIVE-6934?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan updated HIVE-6934: --- Resolution: Fixed Fix Version/s: (was: 0.14.0) 0.15.0 Status: Resolved (was: Patch Available) Committed to trunk. > PartitionPruner doesn't handle top level constant expression correctly > -- > > Key: HIVE-6934 > URL: https://issues.apache.org/jira/browse/HIVE-6934 > Project: Hive > Issue Type: Bug >Reporter: Harish Butani >Assignee: Hari Sankar Sivarama Subramaniyan >Priority: Critical > Fix For: 0.15.0 > > Attachments: HIVE-6934.4.patch, HIVE-6934.5.patch, HIVE-6934.6.patch, > HIVE-6934.7.patch, HIVE-6934.8.patch, HIVE-6934.9.patch, HIVE-6934.91.patch, > HIVE-6934.92.patch > > > You hit this error indirectly, because how we handle invalid constant > comparisons. Consider: > {code} > create table x(key int, value string) partitioned by (dt int, ts string); > -- both these queries hit this issue > select * from x where key = 'abc'; > select * from x where dt = 'abc'; > -- the issue is the comparison get converted to the constant false > -- and the PartitionPruner doesn't handle top level constant exprs corrcetly > {code} > Thanks to [~hsubramaniyan] for uncovering this as part of adding tests for > HIVE-5376 -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-6934) PartitionPruner doesn't handle top level constant expression correctly
[ https://issues.apache.org/jira/browse/HIVE-6934?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hari Sankar Sivarama Subramaniyan updated HIVE-6934: Status: Patch Available (was: In Progress) > PartitionPruner doesn't handle top level constant expression correctly > -- > > Key: HIVE-6934 > URL: https://issues.apache.org/jira/browse/HIVE-6934 > Project: Hive > Issue Type: Bug >Reporter: Harish Butani >Assignee: Hari Sankar Sivarama Subramaniyan >Priority: Critical > Fix For: 0.14.0 > > Attachments: HIVE-6934.4.patch, HIVE-6934.5.patch, HIVE-6934.6.patch, > HIVE-6934.7.patch, HIVE-6934.8.patch, HIVE-6934.9.patch, HIVE-6934.91.patch, > HIVE-6934.92.patch > > > You hit this error indirectly, because how we handle invalid constant > comparisons. Consider: > {code} > create table x(key int, value string) partitioned by (dt int, ts string); > -- both these queries hit this issue > select * from x where key = 'abc'; > select * from x where dt = 'abc'; > -- the issue is the comparison get converted to the constant false > -- and the PartitionPruner doesn't handle top level constant exprs corrcetly > {code} > Thanks to [~hsubramaniyan] for uncovering this as part of adding tests for > HIVE-5376 -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-6934) PartitionPruner doesn't handle top level constant expression correctly
[ https://issues.apache.org/jira/browse/HIVE-6934?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hari Sankar Sivarama Subramaniyan updated HIVE-6934: Attachment: HIVE-6934.92.patch > PartitionPruner doesn't handle top level constant expression correctly > -- > > Key: HIVE-6934 > URL: https://issues.apache.org/jira/browse/HIVE-6934 > Project: Hive > Issue Type: Bug >Reporter: Harish Butani >Assignee: Hari Sankar Sivarama Subramaniyan >Priority: Critical > Fix For: 0.14.0 > > Attachments: HIVE-6934.4.patch, HIVE-6934.5.patch, HIVE-6934.6.patch, > HIVE-6934.7.patch, HIVE-6934.8.patch, HIVE-6934.9.patch, HIVE-6934.91.patch, > HIVE-6934.92.patch > > > You hit this error indirectly, because how we handle invalid constant > comparisons. Consider: > {code} > create table x(key int, value string) partitioned by (dt int, ts string); > -- both these queries hit this issue > select * from x where key = 'abc'; > select * from x where dt = 'abc'; > -- the issue is the comparison get converted to the constant false > -- and the PartitionPruner doesn't handle top level constant exprs corrcetly > {code} > Thanks to [~hsubramaniyan] for uncovering this as part of adding tests for > HIVE-5376 -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-6934) PartitionPruner doesn't handle top level constant expression correctly
[ https://issues.apache.org/jira/browse/HIVE-6934?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hari Sankar Sivarama Subramaniyan updated HIVE-6934: Status: In Progress (was: Patch Available) > PartitionPruner doesn't handle top level constant expression correctly > -- > > Key: HIVE-6934 > URL: https://issues.apache.org/jira/browse/HIVE-6934 > Project: Hive > Issue Type: Bug >Reporter: Harish Butani >Assignee: Hari Sankar Sivarama Subramaniyan >Priority: Critical > Fix For: 0.14.0 > > Attachments: HIVE-6934.4.patch, HIVE-6934.5.patch, HIVE-6934.6.patch, > HIVE-6934.7.patch, HIVE-6934.8.patch, HIVE-6934.9.patch, HIVE-6934.91.patch > > > You hit this error indirectly, because how we handle invalid constant > comparisons. Consider: > {code} > create table x(key int, value string) partitioned by (dt int, ts string); > -- both these queries hit this issue > select * from x where key = 'abc'; > select * from x where dt = 'abc'; > -- the issue is the comparison get converted to the constant false > -- and the PartitionPruner doesn't handle top level constant exprs corrcetly > {code} > Thanks to [~hsubramaniyan] for uncovering this as part of adding tests for > HIVE-5376 -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-6934) PartitionPruner doesn't handle top level constant expression correctly
[ https://issues.apache.org/jira/browse/HIVE-6934?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hari Sankar Sivarama Subramaniyan updated HIVE-6934: Status: Patch Available (was: Open) > PartitionPruner doesn't handle top level constant expression correctly > -- > > Key: HIVE-6934 > URL: https://issues.apache.org/jira/browse/HIVE-6934 > Project: Hive > Issue Type: Bug >Reporter: Harish Butani >Assignee: Hari Sankar Sivarama Subramaniyan >Priority: Critical > Fix For: 0.14.0 > > Attachments: HIVE-6934.4.patch, HIVE-6934.5.patch, HIVE-6934.6.patch, > HIVE-6934.7.patch, HIVE-6934.8.patch, HIVE-6934.9.patch, HIVE-6934.91.patch > > > You hit this error indirectly, because how we handle invalid constant > comparisons. Consider: > {code} > create table x(key int, value string) partitioned by (dt int, ts string); > -- both these queries hit this issue > select * from x where key = 'abc'; > select * from x where dt = 'abc'; > -- the issue is the comparison get converted to the constant false > -- and the PartitionPruner doesn't handle top level constant exprs corrcetly > {code} > Thanks to [~hsubramaniyan] for uncovering this as part of adding tests for > HIVE-5376 -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-6934) PartitionPruner doesn't handle top level constant expression correctly
[ https://issues.apache.org/jira/browse/HIVE-6934?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hari Sankar Sivarama Subramaniyan updated HIVE-6934: Attachment: HIVE-6934.91.patch > PartitionPruner doesn't handle top level constant expression correctly > -- > > Key: HIVE-6934 > URL: https://issues.apache.org/jira/browse/HIVE-6934 > Project: Hive > Issue Type: Bug >Reporter: Harish Butani >Assignee: Hari Sankar Sivarama Subramaniyan >Priority: Critical > Fix For: 0.14.0 > > Attachments: HIVE-6934.4.patch, HIVE-6934.5.patch, HIVE-6934.6.patch, > HIVE-6934.7.patch, HIVE-6934.8.patch, HIVE-6934.9.patch, HIVE-6934.91.patch > > > You hit this error indirectly, because how we handle invalid constant > comparisons. Consider: > {code} > create table x(key int, value string) partitioned by (dt int, ts string); > -- both these queries hit this issue > select * from x where key = 'abc'; > select * from x where dt = 'abc'; > -- the issue is the comparison get converted to the constant false > -- and the PartitionPruner doesn't handle top level constant exprs corrcetly > {code} > Thanks to [~hsubramaniyan] for uncovering this as part of adding tests for > HIVE-5376 -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-6934) PartitionPruner doesn't handle top level constant expression correctly
[ https://issues.apache.org/jira/browse/HIVE-6934?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan updated HIVE-6934: --- Status: Open (was: Patch Available) Test failures need to be looked at. > PartitionPruner doesn't handle top level constant expression correctly > -- > > Key: HIVE-6934 > URL: https://issues.apache.org/jira/browse/HIVE-6934 > Project: Hive > Issue Type: Bug >Reporter: Harish Butani >Assignee: Hari Sankar Sivarama Subramaniyan >Priority: Critical > Fix For: 0.14.0 > > Attachments: HIVE-6934.4.patch, HIVE-6934.5.patch, HIVE-6934.6.patch, > HIVE-6934.7.patch, HIVE-6934.8.patch, HIVE-6934.9.patch > > > You hit this error indirectly, because how we handle invalid constant > comparisons. Consider: > {code} > create table x(key int, value string) partitioned by (dt int, ts string); > -- both these queries hit this issue > select * from x where key = 'abc'; > select * from x where dt = 'abc'; > -- the issue is the comparison get converted to the constant false > -- and the PartitionPruner doesn't handle top level constant exprs corrcetly > {code} > Thanks to [~hsubramaniyan] for uncovering this as part of adding tests for > HIVE-5376 -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-6934) PartitionPruner doesn't handle top level constant expression correctly
[ https://issues.apache.org/jira/browse/HIVE-6934?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hari Sankar Sivarama Subramaniyan updated HIVE-6934: Attachment: HIVE-6934.9.patch > PartitionPruner doesn't handle top level constant expression correctly > -- > > Key: HIVE-6934 > URL: https://issues.apache.org/jira/browse/HIVE-6934 > Project: Hive > Issue Type: Bug >Reporter: Harish Butani >Assignee: Hari Sankar Sivarama Subramaniyan >Priority: Critical > Fix For: 0.14.0 > > Attachments: HIVE-6934.4.patch, HIVE-6934.5.patch, HIVE-6934.6.patch, > HIVE-6934.7.patch, HIVE-6934.8.patch, HIVE-6934.9.patch > > > You hit this error indirectly, because how we handle invalid constant > comparisons. Consider: > {code} > create table x(key int, value string) partitioned by (dt int, ts string); > -- both these queries hit this issue > select * from x where key = 'abc'; > select * from x where dt = 'abc'; > -- the issue is the comparison get converted to the constant false > -- and the PartitionPruner doesn't handle top level constant exprs corrcetly > {code} > Thanks to [~hsubramaniyan] for uncovering this as part of adding tests for > HIVE-5376 -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-6934) PartitionPruner doesn't handle top level constant expression correctly
[ https://issues.apache.org/jira/browse/HIVE-6934?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hari Sankar Sivarama Subramaniyan updated HIVE-6934: Status: Patch Available (was: Open) > PartitionPruner doesn't handle top level constant expression correctly > -- > > Key: HIVE-6934 > URL: https://issues.apache.org/jira/browse/HIVE-6934 > Project: Hive > Issue Type: Bug >Reporter: Harish Butani >Assignee: Hari Sankar Sivarama Subramaniyan >Priority: Critical > Fix For: 0.14.0 > > Attachments: HIVE-6934.4.patch, HIVE-6934.5.patch, HIVE-6934.6.patch, > HIVE-6934.7.patch, HIVE-6934.8.patch, HIVE-6934.9.patch > > > You hit this error indirectly, because how we handle invalid constant > comparisons. Consider: > {code} > create table x(key int, value string) partitioned by (dt int, ts string); > -- both these queries hit this issue > select * from x where key = 'abc'; > select * from x where dt = 'abc'; > -- the issue is the comparison get converted to the constant false > -- and the PartitionPruner doesn't handle top level constant exprs corrcetly > {code} > Thanks to [~hsubramaniyan] for uncovering this as part of adding tests for > HIVE-5376 -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-6934) PartitionPruner doesn't handle top level constant expression correctly
[ https://issues.apache.org/jira/browse/HIVE-6934?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan updated HIVE-6934: --- Status: Open (was: Patch Available) Canceling patch, as it needs more work. > PartitionPruner doesn't handle top level constant expression correctly > -- > > Key: HIVE-6934 > URL: https://issues.apache.org/jira/browse/HIVE-6934 > Project: Hive > Issue Type: Bug >Reporter: Harish Butani >Assignee: Hari Sankar Sivarama Subramaniyan >Priority: Critical > Fix For: 0.14.0 > > Attachments: HIVE-6934.4.patch, HIVE-6934.5.patch, HIVE-6934.6.patch, > HIVE-6934.7.patch, HIVE-6934.8.patch > > > You hit this error indirectly, because how we handle invalid constant > comparisons. Consider: > {code} > create table x(key int, value string) partitioned by (dt int, ts string); > -- both these queries hit this issue > select * from x where key = 'abc'; > select * from x where dt = 'abc'; > -- the issue is the comparison get converted to the constant false > -- and the PartitionPruner doesn't handle top level constant exprs corrcetly > {code} > Thanks to [~hsubramaniyan] for uncovering this as part of adding tests for > HIVE-5376 -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-6934) PartitionPruner doesn't handle top level constant expression correctly
[ https://issues.apache.org/jira/browse/HIVE-6934?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hari Sankar Sivarama Subramaniyan updated HIVE-6934: Status: Patch Available (was: Open) > PartitionPruner doesn't handle top level constant expression correctly > -- > > Key: HIVE-6934 > URL: https://issues.apache.org/jira/browse/HIVE-6934 > Project: Hive > Issue Type: Bug >Reporter: Harish Butani >Assignee: Hari Sankar Sivarama Subramaniyan >Priority: Critical > Fix For: 0.14.0 > > Attachments: HIVE-6934.4.patch, HIVE-6934.5.patch, HIVE-6934.6.patch, > HIVE-6934.7.patch, HIVE-6934.8.patch > > > You hit this error indirectly, because how we handle invalid constant > comparisons. Consider: > {code} > create table x(key int, value string) partitioned by (dt int, ts string); > -- both these queries hit this issue > select * from x where key = 'abc'; > select * from x where dt = 'abc'; > -- the issue is the comparison get converted to the constant false > -- and the PartitionPruner doesn't handle top level constant exprs corrcetly > {code} > Thanks to [~hsubramaniyan] for uncovering this as part of adding tests for > HIVE-5376 -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-6934) PartitionPruner doesn't handle top level constant expression correctly
[ https://issues.apache.org/jira/browse/HIVE-6934?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hari Sankar Sivarama Subramaniyan updated HIVE-6934: Attachment: HIVE-6934.8.patch added additional tests as per [~ashutoshc]'s comment > PartitionPruner doesn't handle top level constant expression correctly > -- > > Key: HIVE-6934 > URL: https://issues.apache.org/jira/browse/HIVE-6934 > Project: Hive > Issue Type: Bug >Reporter: Harish Butani >Assignee: Hari Sankar Sivarama Subramaniyan >Priority: Critical > Fix For: 0.14.0 > > Attachments: HIVE-6934.4.patch, HIVE-6934.5.patch, HIVE-6934.6.patch, > HIVE-6934.7.patch, HIVE-6934.8.patch > > > You hit this error indirectly, because how we handle invalid constant > comparisons. Consider: > {code} > create table x(key int, value string) partitioned by (dt int, ts string); > -- both these queries hit this issue > select * from x where key = 'abc'; > select * from x where dt = 'abc'; > -- the issue is the comparison get converted to the constant false > -- and the PartitionPruner doesn't handle top level constant exprs corrcetly > {code} > Thanks to [~hsubramaniyan] for uncovering this as part of adding tests for > HIVE-5376 -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-6934) PartitionPruner doesn't handle top level constant expression correctly
[ https://issues.apache.org/jira/browse/HIVE-6934?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hari Sankar Sivarama Subramaniyan updated HIVE-6934: Status: Open (was: Patch Available) > PartitionPruner doesn't handle top level constant expression correctly > -- > > Key: HIVE-6934 > URL: https://issues.apache.org/jira/browse/HIVE-6934 > Project: Hive > Issue Type: Bug >Reporter: Harish Butani >Assignee: Hari Sankar Sivarama Subramaniyan >Priority: Critical > Fix For: 0.14.0 > > Attachments: HIVE-6934.4.patch, HIVE-6934.5.patch, HIVE-6934.6.patch, > HIVE-6934.7.patch > > > You hit this error indirectly, because how we handle invalid constant > comparisons. Consider: > {code} > create table x(key int, value string) partitioned by (dt int, ts string); > -- both these queries hit this issue > select * from x where key = 'abc'; > select * from x where dt = 'abc'; > -- the issue is the comparison get converted to the constant false > -- and the PartitionPruner doesn't handle top level constant exprs corrcetly > {code} > Thanks to [~hsubramaniyan] for uncovering this as part of adding tests for > HIVE-5376 -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-6934) PartitionPruner doesn't handle top level constant expression correctly
[ https://issues.apache.org/jira/browse/HIVE-6934?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hari Sankar Sivarama Subramaniyan updated HIVE-6934: Attachment: HIVE-6934.7.patch Rebasing the patch. ccing [~ashutoshc] for reviewing the change. > PartitionPruner doesn't handle top level constant expression correctly > -- > > Key: HIVE-6934 > URL: https://issues.apache.org/jira/browse/HIVE-6934 > Project: Hive > Issue Type: Bug >Reporter: Harish Butani >Assignee: Hari Sankar Sivarama Subramaniyan >Priority: Critical > Fix For: 0.14.0 > > Attachments: HIVE-6934.4.patch, HIVE-6934.5.patch, HIVE-6934.6.patch, > HIVE-6934.7.patch > > > You hit this error indirectly, because how we handle invalid constant > comparisons. Consider: > {code} > create table x(key int, value string) partitioned by (dt int, ts string); > -- both these queries hit this issue > select * from x where key = 'abc'; > select * from x where dt = 'abc'; > -- the issue is the comparison get converted to the constant false > -- and the PartitionPruner doesn't handle top level constant exprs corrcetly > {code} > Thanks to [~hsubramaniyan] for uncovering this as part of adding tests for > HIVE-5376 -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-6934) PartitionPruner doesn't handle top level constant expression correctly
[ https://issues.apache.org/jira/browse/HIVE-6934?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hari Sankar Sivarama Subramaniyan updated HIVE-6934: Status: Patch Available (was: Open) > PartitionPruner doesn't handle top level constant expression correctly > -- > > Key: HIVE-6934 > URL: https://issues.apache.org/jira/browse/HIVE-6934 > Project: Hive > Issue Type: Bug >Reporter: Harish Butani >Assignee: Hari Sankar Sivarama Subramaniyan >Priority: Critical > Fix For: 0.14.0 > > Attachments: HIVE-6934.4.patch, HIVE-6934.5.patch, HIVE-6934.6.patch, > HIVE-6934.7.patch > > > You hit this error indirectly, because how we handle invalid constant > comparisons. Consider: > {code} > create table x(key int, value string) partitioned by (dt int, ts string); > -- both these queries hit this issue > select * from x where key = 'abc'; > select * from x where dt = 'abc'; > -- the issue is the comparison get converted to the constant false > -- and the PartitionPruner doesn't handle top level constant exprs corrcetly > {code} > Thanks to [~hsubramaniyan] for uncovering this as part of adding tests for > HIVE-5376 -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-6934) PartitionPruner doesn't handle top level constant expression correctly
[ https://issues.apache.org/jira/browse/HIVE-6934?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vikram Dixit K updated HIVE-6934: - Fix Version/s: 0.14.0 > PartitionPruner doesn't handle top level constant expression correctly > -- > > Key: HIVE-6934 > URL: https://issues.apache.org/jira/browse/HIVE-6934 > Project: Hive > Issue Type: Bug >Reporter: Harish Butani >Assignee: Hari Sankar Sivarama Subramaniyan >Priority: Critical > Fix For: 0.14.0 > > Attachments: HIVE-6934.4.patch, HIVE-6934.5.patch, HIVE-6934.6.patch > > > You hit this error indirectly, because how we handle invalid constant > comparisons. Consider: > {code} > create table x(key int, value string) partitioned by (dt int, ts string); > -- both these queries hit this issue > select * from x where key = 'abc'; > select * from x where dt = 'abc'; > -- the issue is the comparison get converted to the constant false > -- and the PartitionPruner doesn't handle top level constant exprs corrcetly > {code} > Thanks to [~hsubramaniyan] for uncovering this as part of adding tests for > HIVE-5376 -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-6934) PartitionPruner doesn't handle top level constant expression correctly
[ https://issues.apache.org/jira/browse/HIVE-6934?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vikram Dixit K updated HIVE-6934: - Priority: Critical (was: Major) > PartitionPruner doesn't handle top level constant expression correctly > -- > > Key: HIVE-6934 > URL: https://issues.apache.org/jira/browse/HIVE-6934 > Project: Hive > Issue Type: Bug >Reporter: Harish Butani >Assignee: Hari Sankar Sivarama Subramaniyan >Priority: Critical > Fix For: 0.14.0 > > Attachments: HIVE-6934.4.patch, HIVE-6934.5.patch, HIVE-6934.6.patch > > > You hit this error indirectly, because how we handle invalid constant > comparisons. Consider: > {code} > create table x(key int, value string) partitioned by (dt int, ts string); > -- both these queries hit this issue > select * from x where key = 'abc'; > select * from x where dt = 'abc'; > -- the issue is the comparison get converted to the constant false > -- and the PartitionPruner doesn't handle top level constant exprs corrcetly > {code} > Thanks to [~hsubramaniyan] for uncovering this as part of adding tests for > HIVE-5376 -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-6934) PartitionPruner doesn't handle top level constant expression correctly
[ https://issues.apache.org/jira/browse/HIVE-6934?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hari Sankar Sivarama Subramaniyan updated HIVE-6934: Attachment: (was: HIVE-6934.3.patch) > PartitionPruner doesn't handle top level constant expression correctly > -- > > Key: HIVE-6934 > URL: https://issues.apache.org/jira/browse/HIVE-6934 > Project: Hive > Issue Type: Bug >Reporter: Harish Butani >Assignee: Hari Sankar Sivarama Subramaniyan > Attachments: HIVE-6934.4.patch, HIVE-6934.5.patch, HIVE-6934.6.patch > > > You hit this error indirectly, because how we handle invalid constant > comparisons. Consider: > {code} > create table x(key int, value string) partitioned by (dt int, ts string); > -- both these queries hit this issue > select * from x where key = 'abc'; > select * from x where dt = 'abc'; > -- the issue is the comparison get converted to the constant false > -- and the PartitionPruner doesn't handle top level constant exprs corrcetly > {code} > Thanks to [~hsubramaniyan] for uncovering this as part of adding tests for > HIVE-5376 -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Updated] (HIVE-6934) PartitionPruner doesn't handle top level constant expression correctly
[ https://issues.apache.org/jira/browse/HIVE-6934?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hari Sankar Sivarama Subramaniyan updated HIVE-6934: Attachment: (was: HIVE-6934.1.patch) > PartitionPruner doesn't handle top level constant expression correctly > -- > > Key: HIVE-6934 > URL: https://issues.apache.org/jira/browse/HIVE-6934 > Project: Hive > Issue Type: Bug >Reporter: Harish Butani >Assignee: Hari Sankar Sivarama Subramaniyan > Attachments: HIVE-6934.2.patch, HIVE-6934.3.patch, HIVE-6934.4.patch, > HIVE-6934.5.patch, HIVE-6934.6.patch > > > You hit this error indirectly, because how we handle invalid constant > comparisons. Consider: > {code} > create table x(key int, value string) partitioned by (dt int, ts string); > -- both these queries hit this issue > select * from x where key = 'abc'; > select * from x where dt = 'abc'; > -- the issue is the comparison get converted to the constant false > -- and the PartitionPruner doesn't handle top level constant exprs corrcetly > {code} > Thanks to [~hsubramaniyan] for uncovering this as part of adding tests for > HIVE-5376 -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Updated] (HIVE-6934) PartitionPruner doesn't handle top level constant expression correctly
[ https://issues.apache.org/jira/browse/HIVE-6934?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hari Sankar Sivarama Subramaniyan updated HIVE-6934: Status: Open (was: Patch Available) > PartitionPruner doesn't handle top level constant expression correctly > -- > > Key: HIVE-6934 > URL: https://issues.apache.org/jira/browse/HIVE-6934 > Project: Hive > Issue Type: Bug >Reporter: Harish Butani >Assignee: Hari Sankar Sivarama Subramaniyan > Attachments: HIVE-6934.2.patch, HIVE-6934.3.patch, HIVE-6934.4.patch, > HIVE-6934.5.patch, HIVE-6934.6.patch > > > You hit this error indirectly, because how we handle invalid constant > comparisons. Consider: > {code} > create table x(key int, value string) partitioned by (dt int, ts string); > -- both these queries hit this issue > select * from x where key = 'abc'; > select * from x where dt = 'abc'; > -- the issue is the comparison get converted to the constant false > -- and the PartitionPruner doesn't handle top level constant exprs corrcetly > {code} > Thanks to [~hsubramaniyan] for uncovering this as part of adding tests for > HIVE-5376 -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Updated] (HIVE-6934) PartitionPruner doesn't handle top level constant expression correctly
[ https://issues.apache.org/jira/browse/HIVE-6934?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hari Sankar Sivarama Subramaniyan updated HIVE-6934: Attachment: (was: HIVE-6934.2.patch) > PartitionPruner doesn't handle top level constant expression correctly > -- > > Key: HIVE-6934 > URL: https://issues.apache.org/jira/browse/HIVE-6934 > Project: Hive > Issue Type: Bug >Reporter: Harish Butani >Assignee: Hari Sankar Sivarama Subramaniyan > Attachments: HIVE-6934.3.patch, HIVE-6934.4.patch, HIVE-6934.5.patch, > HIVE-6934.6.patch > > > You hit this error indirectly, because how we handle invalid constant > comparisons. Consider: > {code} > create table x(key int, value string) partitioned by (dt int, ts string); > -- both these queries hit this issue > select * from x where key = 'abc'; > select * from x where dt = 'abc'; > -- the issue is the comparison get converted to the constant false > -- and the PartitionPruner doesn't handle top level constant exprs corrcetly > {code} > Thanks to [~hsubramaniyan] for uncovering this as part of adding tests for > HIVE-5376 -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Updated] (HIVE-6934) PartitionPruner doesn't handle top level constant expression correctly
[ https://issues.apache.org/jira/browse/HIVE-6934?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hari Sankar Sivarama Subramaniyan updated HIVE-6934: Status: Open (was: Patch Available) > PartitionPruner doesn't handle top level constant expression correctly > -- > > Key: HIVE-6934 > URL: https://issues.apache.org/jira/browse/HIVE-6934 > Project: Hive > Issue Type: Bug >Reporter: Harish Butani >Assignee: Hari Sankar Sivarama Subramaniyan > Attachments: HIVE-6934.1.patch, HIVE-6934.2.patch, HIVE-6934.3.patch, > HIVE-6934.4.patch, HIVE-6934.5.patch, HIVE-6934.6.patch > > > You hit this error indirectly, because how we handle invalid constant > comparisons. Consider: > {code} > create table x(key int, value string) partitioned by (dt int, ts string); > -- both these queries hit this issue > select * from x where key = 'abc'; > select * from x where dt = 'abc'; > -- the issue is the comparison get converted to the constant false > -- and the PartitionPruner doesn't handle top level constant exprs corrcetly > {code} > Thanks to [~hsubramaniyan] for uncovering this as part of adding tests for > HIVE-5376 -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Updated] (HIVE-6934) PartitionPruner doesn't handle top level constant expression correctly
[ https://issues.apache.org/jira/browse/HIVE-6934?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hari Sankar Sivarama Subramaniyan updated HIVE-6934: Attachment: HIVE-6934.6.patch > PartitionPruner doesn't handle top level constant expression correctly > -- > > Key: HIVE-6934 > URL: https://issues.apache.org/jira/browse/HIVE-6934 > Project: Hive > Issue Type: Bug >Reporter: Harish Butani >Assignee: Hari Sankar Sivarama Subramaniyan > Attachments: HIVE-6934.1.patch, HIVE-6934.2.patch, HIVE-6934.3.patch, > HIVE-6934.4.patch, HIVE-6934.5.patch, HIVE-6934.6.patch > > > You hit this error indirectly, because how we handle invalid constant > comparisons. Consider: > {code} > create table x(key int, value string) partitioned by (dt int, ts string); > -- both these queries hit this issue > select * from x where key = 'abc'; > select * from x where dt = 'abc'; > -- the issue is the comparison get converted to the constant false > -- and the PartitionPruner doesn't handle top level constant exprs corrcetly > {code} > Thanks to [~hsubramaniyan] for uncovering this as part of adding tests for > HIVE-5376 -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Updated] (HIVE-6934) PartitionPruner doesn't handle top level constant expression correctly
[ https://issues.apache.org/jira/browse/HIVE-6934?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hari Sankar Sivarama Subramaniyan updated HIVE-6934: Status: Patch Available (was: Open) > PartitionPruner doesn't handle top level constant expression correctly > -- > > Key: HIVE-6934 > URL: https://issues.apache.org/jira/browse/HIVE-6934 > Project: Hive > Issue Type: Bug >Reporter: Harish Butani >Assignee: Hari Sankar Sivarama Subramaniyan > Attachments: HIVE-6934.1.patch, HIVE-6934.2.patch, HIVE-6934.3.patch, > HIVE-6934.4.patch, HIVE-6934.5.patch, HIVE-6934.6.patch > > > You hit this error indirectly, because how we handle invalid constant > comparisons. Consider: > {code} > create table x(key int, value string) partitioned by (dt int, ts string); > -- both these queries hit this issue > select * from x where key = 'abc'; > select * from x where dt = 'abc'; > -- the issue is the comparison get converted to the constant false > -- and the PartitionPruner doesn't handle top level constant exprs corrcetly > {code} > Thanks to [~hsubramaniyan] for uncovering this as part of adding tests for > HIVE-5376 -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Updated] (HIVE-6934) PartitionPruner doesn't handle top level constant expression correctly
[ https://issues.apache.org/jira/browse/HIVE-6934?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hari Sankar Sivarama Subramaniyan updated HIVE-6934: Attachment: HIVE-6934.5.patch > PartitionPruner doesn't handle top level constant expression correctly > -- > > Key: HIVE-6934 > URL: https://issues.apache.org/jira/browse/HIVE-6934 > Project: Hive > Issue Type: Bug >Reporter: Harish Butani >Assignee: Hari Sankar Sivarama Subramaniyan > Attachments: HIVE-6934.1.patch, HIVE-6934.2.patch, HIVE-6934.3.patch, > HIVE-6934.4.patch, HIVE-6934.5.patch > > > You hit this error indirectly, because how we handle invalid constant > comparisons. Consider: > {code} > create table x(key int, value string) partitioned by (dt int, ts string); > -- both these queries hit this issue > select * from x where key = 'abc'; > select * from x where dt = 'abc'; > -- the issue is the comparison get converted to the constant false > -- and the PartitionPruner doesn't handle top level constant exprs corrcetly > {code} > Thanks to [~hsubramaniyan] for uncovering this as part of adding tests for > HIVE-5376 -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Updated] (HIVE-6934) PartitionPruner doesn't handle top level constant expression correctly
[ https://issues.apache.org/jira/browse/HIVE-6934?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hari Sankar Sivarama Subramaniyan updated HIVE-6934: Status: Patch Available (was: Open) > PartitionPruner doesn't handle top level constant expression correctly > -- > > Key: HIVE-6934 > URL: https://issues.apache.org/jira/browse/HIVE-6934 > Project: Hive > Issue Type: Bug >Reporter: Harish Butani >Assignee: Hari Sankar Sivarama Subramaniyan > Attachments: HIVE-6934.1.patch, HIVE-6934.2.patch, HIVE-6934.3.patch, > HIVE-6934.4.patch, HIVE-6934.5.patch > > > You hit this error indirectly, because how we handle invalid constant > comparisons. Consider: > {code} > create table x(key int, value string) partitioned by (dt int, ts string); > -- both these queries hit this issue > select * from x where key = 'abc'; > select * from x where dt = 'abc'; > -- the issue is the comparison get converted to the constant false > -- and the PartitionPruner doesn't handle top level constant exprs corrcetly > {code} > Thanks to [~hsubramaniyan] for uncovering this as part of adding tests for > HIVE-5376 -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Updated] (HIVE-6934) PartitionPruner doesn't handle top level constant expression correctly
[ https://issues.apache.org/jira/browse/HIVE-6934?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hari Sankar Sivarama Subramaniyan updated HIVE-6934: Status: Open (was: Patch Available) > PartitionPruner doesn't handle top level constant expression correctly > -- > > Key: HIVE-6934 > URL: https://issues.apache.org/jira/browse/HIVE-6934 > Project: Hive > Issue Type: Bug >Reporter: Harish Butani >Assignee: Hari Sankar Sivarama Subramaniyan > Attachments: HIVE-6934.1.patch, HIVE-6934.2.patch, HIVE-6934.3.patch, > HIVE-6934.4.patch > > > You hit this error indirectly, because how we handle invalid constant > comparisons. Consider: > {code} > create table x(key int, value string) partitioned by (dt int, ts string); > -- both these queries hit this issue > select * from x where key = 'abc'; > select * from x where dt = 'abc'; > -- the issue is the comparison get converted to the constant false > -- and the PartitionPruner doesn't handle top level constant exprs corrcetly > {code} > Thanks to [~hsubramaniyan] for uncovering this as part of adding tests for > HIVE-5376 -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Updated] (HIVE-6934) PartitionPruner doesn't handle top level constant expression correctly
[ https://issues.apache.org/jira/browse/HIVE-6934?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hari Sankar Sivarama Subramaniyan updated HIVE-6934: Status: Patch Available (was: Open) > PartitionPruner doesn't handle top level constant expression correctly > -- > > Key: HIVE-6934 > URL: https://issues.apache.org/jira/browse/HIVE-6934 > Project: Hive > Issue Type: Bug >Reporter: Harish Butani >Assignee: Hari Sankar Sivarama Subramaniyan > Attachments: HIVE-6934.1.patch, HIVE-6934.2.patch, HIVE-6934.3.patch, > HIVE-6934.4.patch > > > You hit this error indirectly, because how we handle invalid constant > comparisons. Consider: > {code} > create table x(key int, value string) partitioned by (dt int, ts string); > -- both these queries hit this issue > select * from x where key = 'abc'; > select * from x where dt = 'abc'; > -- the issue is the comparison get converted to the constant false > -- and the PartitionPruner doesn't handle top level constant exprs corrcetly > {code} > Thanks to [~hsubramaniyan] for uncovering this as part of adding tests for > HIVE-5376 -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Updated] (HIVE-6934) PartitionPruner doesn't handle top level constant expression correctly
[ https://issues.apache.org/jira/browse/HIVE-6934?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hari Sankar Sivarama Subramaniyan updated HIVE-6934: Attachment: HIVE-6934.4.patch > PartitionPruner doesn't handle top level constant expression correctly > -- > > Key: HIVE-6934 > URL: https://issues.apache.org/jira/browse/HIVE-6934 > Project: Hive > Issue Type: Bug >Reporter: Harish Butani >Assignee: Hari Sankar Sivarama Subramaniyan > Attachments: HIVE-6934.1.patch, HIVE-6934.2.patch, HIVE-6934.3.patch, > HIVE-6934.4.patch > > > You hit this error indirectly, because how we handle invalid constant > comparisons. Consider: > {code} > create table x(key int, value string) partitioned by (dt int, ts string); > -- both these queries hit this issue > select * from x where key = 'abc'; > select * from x where dt = 'abc'; > -- the issue is the comparison get converted to the constant false > -- and the PartitionPruner doesn't handle top level constant exprs corrcetly > {code} > Thanks to [~hsubramaniyan] for uncovering this as part of adding tests for > HIVE-5376 -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Updated] (HIVE-6934) PartitionPruner doesn't handle top level constant expression correctly
[ https://issues.apache.org/jira/browse/HIVE-6934?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hari Sankar Sivarama Subramaniyan updated HIVE-6934: Attachment: (was: HIVE-6934.4.patch) > PartitionPruner doesn't handle top level constant expression correctly > -- > > Key: HIVE-6934 > URL: https://issues.apache.org/jira/browse/HIVE-6934 > Project: Hive > Issue Type: Bug >Reporter: Harish Butani >Assignee: Hari Sankar Sivarama Subramaniyan > Attachments: HIVE-6934.1.patch, HIVE-6934.2.patch, HIVE-6934.3.patch > > > You hit this error indirectly, because how we handle invalid constant > comparisons. Consider: > {code} > create table x(key int, value string) partitioned by (dt int, ts string); > -- both these queries hit this issue > select * from x where key = 'abc'; > select * from x where dt = 'abc'; > -- the issue is the comparison get converted to the constant false > -- and the PartitionPruner doesn't handle top level constant exprs corrcetly > {code} > Thanks to [~hsubramaniyan] for uncovering this as part of adding tests for > HIVE-5376 -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Updated] (HIVE-6934) PartitionPruner doesn't handle top level constant expression correctly
[ https://issues.apache.org/jira/browse/HIVE-6934?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hari Sankar Sivarama Subramaniyan updated HIVE-6934: Status: Open (was: Patch Available) > PartitionPruner doesn't handle top level constant expression correctly > -- > > Key: HIVE-6934 > URL: https://issues.apache.org/jira/browse/HIVE-6934 > Project: Hive > Issue Type: Bug >Reporter: Harish Butani >Assignee: Hari Sankar Sivarama Subramaniyan > Attachments: HIVE-6934.1.patch, HIVE-6934.2.patch, HIVE-6934.3.patch > > > You hit this error indirectly, because how we handle invalid constant > comparisons. Consider: > {code} > create table x(key int, value string) partitioned by (dt int, ts string); > -- both these queries hit this issue > select * from x where key = 'abc'; > select * from x where dt = 'abc'; > -- the issue is the comparison get converted to the constant false > -- and the PartitionPruner doesn't handle top level constant exprs corrcetly > {code} > Thanks to [~hsubramaniyan] for uncovering this as part of adding tests for > HIVE-5376 -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Updated] (HIVE-6934) PartitionPruner doesn't handle top level constant expression correctly
[ https://issues.apache.org/jira/browse/HIVE-6934?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hari Sankar Sivarama Subramaniyan updated HIVE-6934: Attachment: HIVE-6934.4.patch [~ashutoshc] HIVE-6934.4.patch should solve all the related issues. > PartitionPruner doesn't handle top level constant expression correctly > -- > > Key: HIVE-6934 > URL: https://issues.apache.org/jira/browse/HIVE-6934 > Project: Hive > Issue Type: Bug >Reporter: Harish Butani >Assignee: Hari Sankar Sivarama Subramaniyan > Attachments: HIVE-6934.1.patch, HIVE-6934.2.patch, HIVE-6934.3.patch > > > You hit this error indirectly, because how we handle invalid constant > comparisons. Consider: > {code} > create table x(key int, value string) partitioned by (dt int, ts string); > -- both these queries hit this issue > select * from x where key = 'abc'; > select * from x where dt = 'abc'; > -- the issue is the comparison get converted to the constant false > -- and the PartitionPruner doesn't handle top level constant exprs corrcetly > {code} > Thanks to [~hsubramaniyan] for uncovering this as part of adding tests for > HIVE-5376 -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Updated] (HIVE-6934) PartitionPruner doesn't handle top level constant expression correctly
[ https://issues.apache.org/jira/browse/HIVE-6934?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hari Sankar Sivarama Subramaniyan updated HIVE-6934: Status: Patch Available (was: Open) > PartitionPruner doesn't handle top level constant expression correctly > -- > > Key: HIVE-6934 > URL: https://issues.apache.org/jira/browse/HIVE-6934 > Project: Hive > Issue Type: Bug >Reporter: Harish Butani >Assignee: Hari Sankar Sivarama Subramaniyan > Attachments: HIVE-6934.1.patch, HIVE-6934.2.patch, HIVE-6934.3.patch > > > You hit this error indirectly, because how we handle invalid constant > comparisons. Consider: > {code} > create table x(key int, value string) partitioned by (dt int, ts string); > -- both these queries hit this issue > select * from x where key = 'abc'; > select * from x where dt = 'abc'; > -- the issue is the comparison get converted to the constant false > -- and the PartitionPruner doesn't handle top level constant exprs corrcetly > {code} > Thanks to [~hsubramaniyan] for uncovering this as part of adding tests for > HIVE-5376 -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Updated] (HIVE-6934) PartitionPruner doesn't handle top level constant expression correctly
[ https://issues.apache.org/jira/browse/HIVE-6934?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan updated HIVE-6934: --- Status: Open (was: Patch Available) [~hsubramaniyan] Are you still working on this? This looks useful to fix this. I believe as a side effect of this HIVE-7417 may also get fixed. > PartitionPruner doesn't handle top level constant expression correctly > -- > > Key: HIVE-6934 > URL: https://issues.apache.org/jira/browse/HIVE-6934 > Project: Hive > Issue Type: Bug >Reporter: Harish Butani >Assignee: Hari Sankar Sivarama Subramaniyan > Attachments: HIVE-6934.1.patch, HIVE-6934.2.patch, HIVE-6934.3.patch > > > You hit this error indirectly, because how we handle invalid constant > comparisons. Consider: > {code} > create table x(key int, value string) partitioned by (dt int, ts string); > -- both these queries hit this issue > select * from x where key = 'abc'; > select * from x where dt = 'abc'; > -- the issue is the comparison get converted to the constant false > -- and the PartitionPruner doesn't handle top level constant exprs corrcetly > {code} > Thanks to [~hsubramaniyan] for uncovering this as part of adding tests for > HIVE-5376 -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Updated] (HIVE-6934) PartitionPruner doesn't handle top level constant expression correctly
[ https://issues.apache.org/jira/browse/HIVE-6934?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hari Sankar Sivarama Subramaniyan updated HIVE-6934: Attachment: HIVE-6934.3.patch Attaching the fix after rebasing with the latest trunk. > PartitionPruner doesn't handle top level constant expression correctly > -- > > Key: HIVE-6934 > URL: https://issues.apache.org/jira/browse/HIVE-6934 > Project: Hive > Issue Type: Bug >Reporter: Harish Butani >Assignee: Hari Sankar Sivarama Subramaniyan > Attachments: HIVE-6934.1.patch, HIVE-6934.2.patch, HIVE-6934.3.patch > > > You hit this error indirectly, because how we handle invalid constant > comparisons. Consider: > {code} > create table x(key int, value string) partitioned by (dt int, ts string); > -- both these queries hit this issue > select * from x where key = 'abc'; > select * from x where dt = 'abc'; > -- the issue is the comparison get converted to the constant false > -- and the PartitionPruner doesn't handle top level constant exprs corrcetly > {code} > Thanks to [~hsubramaniyan] for uncovering this as part of adding tests for > HIVE-5376 -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Updated] (HIVE-6934) PartitionPruner doesn't handle top level constant expression correctly
[ https://issues.apache.org/jira/browse/HIVE-6934?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hari Sankar Sivarama Subramaniyan updated HIVE-6934: Status: Patch Available (was: Open) > PartitionPruner doesn't handle top level constant expression correctly > -- > > Key: HIVE-6934 > URL: https://issues.apache.org/jira/browse/HIVE-6934 > Project: Hive > Issue Type: Bug >Reporter: Harish Butani >Assignee: Hari Sankar Sivarama Subramaniyan > Attachments: HIVE-6934.1.patch, HIVE-6934.2.patch, HIVE-6934.3.patch > > > You hit this error indirectly, because how we handle invalid constant > comparisons. Consider: > {code} > create table x(key int, value string) partitioned by (dt int, ts string); > -- both these queries hit this issue > select * from x where key = 'abc'; > select * from x where dt = 'abc'; > -- the issue is the comparison get converted to the constant false > -- and the PartitionPruner doesn't handle top level constant exprs corrcetly > {code} > Thanks to [~hsubramaniyan] for uncovering this as part of adding tests for > HIVE-5376 -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Updated] (HIVE-6934) PartitionPruner doesn't handle top level constant expression correctly
[ https://issues.apache.org/jira/browse/HIVE-6934?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan updated HIVE-6934: --- Status: Open (was: Patch Available) Failed tests need to be looked at > PartitionPruner doesn't handle top level constant expression correctly > -- > > Key: HIVE-6934 > URL: https://issues.apache.org/jira/browse/HIVE-6934 > Project: Hive > Issue Type: Bug >Reporter: Harish Butani >Assignee: Hari Sankar Sivarama Subramaniyan > Attachments: HIVE-6934.1.patch, HIVE-6934.2.patch > > > You hit this error indirectly, because how we handle invalid constant > comparisons. Consider: > {code} > create table x(key int, value string) partitioned by (dt int, ts string); > -- both these queries hit this issue > select * from x where key = 'abc'; > select * from x where dt = 'abc'; > -- the issue is the comparison get converted to the constant false > -- and the PartitionPruner doesn't handle top level constant exprs corrcetly > {code} > Thanks to [~hsubramaniyan] for uncovering this as part of adding tests for > HIVE-5376 -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Updated] (HIVE-6934) PartitionPruner doesn't handle top level constant expression correctly
[ https://issues.apache.org/jira/browse/HIVE-6934?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hari Sankar Sivarama Subramaniyan updated HIVE-6934: Status: Patch Available (was: Open) > PartitionPruner doesn't handle top level constant expression correctly > -- > > Key: HIVE-6934 > URL: https://issues.apache.org/jira/browse/HIVE-6934 > Project: Hive > Issue Type: Bug >Reporter: Harish Butani >Assignee: Hari Sankar Sivarama Subramaniyan > Attachments: HIVE-6934.1.patch, HIVE-6934.2.patch > > > You hit this error indirectly, because how we handle invalid constant > comparisons. Consider: > {code} > create table x(key int, value string) partitioned by (dt int, ts string); > -- both these queries hit this issue > select * from x where key = 'abc'; > select * from x where dt = 'abc'; > -- the issue is the comparison get converted to the constant false > -- and the PartitionPruner doesn't handle top level constant exprs corrcetly > {code} > Thanks to [~hsubramaniyan] for uncovering this as part of adding tests for > HIVE-5376 -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Updated] (HIVE-6934) PartitionPruner doesn't handle top level constant expression correctly
[ https://issues.apache.org/jira/browse/HIVE-6934?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hari Sankar Sivarama Subramaniyan updated HIVE-6934: Status: Open (was: Patch Available) > PartitionPruner doesn't handle top level constant expression correctly > -- > > Key: HIVE-6934 > URL: https://issues.apache.org/jira/browse/HIVE-6934 > Project: Hive > Issue Type: Bug >Reporter: Harish Butani >Assignee: Hari Sankar Sivarama Subramaniyan > Attachments: HIVE-6934.1.patch, HIVE-6934.2.patch > > > You hit this error indirectly, because how we handle invalid constant > comparisons. Consider: > {code} > create table x(key int, value string) partitioned by (dt int, ts string); > -- both these queries hit this issue > select * from x where key = 'abc'; > select * from x where dt = 'abc'; > -- the issue is the comparison get converted to the constant false > -- and the PartitionPruner doesn't handle top level constant exprs corrcetly > {code} > Thanks to [~hsubramaniyan] for uncovering this as part of adding tests for > HIVE-5376 -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Updated] (HIVE-6934) PartitionPruner doesn't handle top level constant expression correctly
[ https://issues.apache.org/jira/browse/HIVE-6934?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hari Sankar Sivarama Subramaniyan updated HIVE-6934: Attachment: HIVE-6934.2.patch > PartitionPruner doesn't handle top level constant expression correctly > -- > > Key: HIVE-6934 > URL: https://issues.apache.org/jira/browse/HIVE-6934 > Project: Hive > Issue Type: Bug >Reporter: Harish Butani >Assignee: Hari Sankar Sivarama Subramaniyan > Attachments: HIVE-6934.1.patch, HIVE-6934.2.patch > > > You hit this error indirectly, because how we handle invalid constant > comparisons. Consider: > {code} > create table x(key int, value string) partitioned by (dt int, ts string); > -- both these queries hit this issue > select * from x where key = 'abc'; > select * from x where dt = 'abc'; > -- the issue is the comparison get converted to the constant false > -- and the PartitionPruner doesn't handle top level constant exprs corrcetly > {code} > Thanks to [~hsubramaniyan] for uncovering this as part of adding tests for > HIVE-5376 -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Updated] (HIVE-6934) PartitionPruner doesn't handle top level constant expression correctly
[ https://issues.apache.org/jira/browse/HIVE-6934?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hari Sankar Sivarama Subramaniyan updated HIVE-6934: Attachment: HIVE-6934.1.patch > PartitionPruner doesn't handle top level constant expression correctly > -- > > Key: HIVE-6934 > URL: https://issues.apache.org/jira/browse/HIVE-6934 > Project: Hive > Issue Type: Bug >Reporter: Harish Butani >Assignee: Hari Sankar Sivarama Subramaniyan > Attachments: HIVE-6934.1.patch > > > You hit this error indirectly, because how we handle invalid constant > comparisons. Consider: > {code} > create table x(key int, value string) partitioned by (dt int, ts string); > -- both these queries hit this issue > select * from x where key = 'abc'; > select * from x where dt = 'abc'; > -- the issue is the comparison get converted to the constant false > -- and the PartitionPruner doesn't handle top level constant exprs corrcetly > {code} > Thanks to [~hsubramaniyan] for uncovering this as part of adding tests for > HIVE-5376 -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Updated] (HIVE-6934) PartitionPruner doesn't handle top level constant expression correctly
[ https://issues.apache.org/jira/browse/HIVE-6934?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hari Sankar Sivarama Subramaniyan updated HIVE-6934: Status: Patch Available (was: Open) > PartitionPruner doesn't handle top level constant expression correctly > -- > > Key: HIVE-6934 > URL: https://issues.apache.org/jira/browse/HIVE-6934 > Project: Hive > Issue Type: Bug >Reporter: Harish Butani >Assignee: Hari Sankar Sivarama Subramaniyan > Attachments: HIVE-6934.1.patch > > > You hit this error indirectly, because how we handle invalid constant > comparisons. Consider: > {code} > create table x(key int, value string) partitioned by (dt int, ts string); > -- both these queries hit this issue > select * from x where key = 'abc'; > select * from x where dt = 'abc'; > -- the issue is the comparison get converted to the constant false > -- and the PartitionPruner doesn't handle top level constant exprs corrcetly > {code} > Thanks to [~hsubramaniyan] for uncovering this as part of adding tests for > HIVE-5376 -- This message was sent by Atlassian JIRA (v6.2#6252)