[jira] [Updated] (HIVE-11573) PointLookupOptimizer can be pessimistic at a low nDV
[ https://issues.apache.org/jira/browse/HIVE-11573?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lefty Leverenz updated HIVE-11573: -- Labels: (was: TODOC2.0) > PointLookupOptimizer can be pessimistic at a low nDV > > > Key: HIVE-11573 > URL: https://issues.apache.org/jira/browse/HIVE-11573 > Project: Hive > Issue Type: Bug >Affects Versions: 2.0.0 >Reporter: Gopal V >Assignee: Gopal V > Fix For: 2.0.0 > > Attachments: HIVE-11573.1.patch, HIVE-11573.2.patch, > HIVE-11573.3.patch, HIVE-11573.4.patch, HIVE-11573.5.patch, HIVE-11573.6.patch > > > The PointLookupOptimizer can turn off some of the optimizations due to its > use of tuple IN() clauses. > Limit the application of the optimizer for very low nDV cases and extract the > sub-clause as a pre-condition during runtime, to trigger the simple column > predicate index lookups. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-11573) PointLookupOptimizer can be pessimistic at a low nDV
[ https://issues.apache.org/jira/browse/HIVE-11573?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jesus Camacho Rodriguez updated HIVE-11573: --- Fix Version/s: (was: 1.3.0) PointLookupOptimizer can be pessimistic at a low nDV Key: HIVE-11573 URL: https://issues.apache.org/jira/browse/HIVE-11573 Project: Hive Issue Type: Bug Affects Versions: 2.0.0 Reporter: Gopal V Assignee: Gopal V Labels: TODOC2.0 Fix For: 2.0.0 Attachments: HIVE-11573.1.patch, HIVE-11573.2.patch, HIVE-11573.3.patch, HIVE-11573.4.patch, HIVE-11573.5.patch, HIVE-11573.6.patch The PointLookupOptimizer can turn off some of the optimizations due to its use of tuple IN() clauses. Limit the application of the optimizer for very low nDV cases and extract the sub-clause as a pre-condition during runtime, to trigger the simple column predicate index lookups. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-11573) PointLookupOptimizer can be pessimistic at a low nDV
[ https://issues.apache.org/jira/browse/HIVE-11573?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jesus Camacho Rodriguez updated HIVE-11573: --- Attachment: HIVE-11573.5.patch PointLookupOptimizer can be pessimistic at a low nDV Key: HIVE-11573 URL: https://issues.apache.org/jira/browse/HIVE-11573 Project: Hive Issue Type: Bug Affects Versions: 1.3.0, 2.0.0 Reporter: Gopal V Assignee: Gopal V Labels: TODOC2.0 Fix For: 1.3.0, 2.0.0 Attachments: HIVE-11573.1.patch, HIVE-11573.2.patch, HIVE-11573.3.patch, HIVE-11573.4.patch, HIVE-11573.5.patch The PointLookupOptimizer can turn off some of the optimizations due to its use of tuple IN() clauses. Limit the application of the optimizer for very low nDV cases and extract the sub-clause as a pre-condition during runtime, to trigger the simple column predicate index lookups. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-11573) PointLookupOptimizer can be pessimistic at a low nDV
[ https://issues.apache.org/jira/browse/HIVE-11573?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gopal V updated HIVE-11573: --- Attachment: HIVE-11573.4.patch Fix the hashset traversal order and update qfiles. PointLookupOptimizer can be pessimistic at a low nDV Key: HIVE-11573 URL: https://issues.apache.org/jira/browse/HIVE-11573 Project: Hive Issue Type: Bug Affects Versions: 1.3.0, 2.0.0 Reporter: Gopal V Assignee: Gopal V Labels: TODOC2.0 Fix For: 1.3.0, 2.0.0 Attachments: HIVE-11573.1.patch, HIVE-11573.2.patch, HIVE-11573.3.patch, HIVE-11573.4.patch The PointLookupOptimizer can turn off some of the optimizations due to its use of tuple IN() clauses. Limit the application of the optimizer for very low nDV cases and extract the sub-clause as a pre-condition during runtime, to trigger the simple column predicate index lookups. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-11573) PointLookupOptimizer can be pessimistic at a low nDV
[ https://issues.apache.org/jira/browse/HIVE-11573?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gopal V updated HIVE-11573: --- Labels: TODOC2.0 (was: ) PointLookupOptimizer can be pessimistic at a low nDV Key: HIVE-11573 URL: https://issues.apache.org/jira/browse/HIVE-11573 Project: Hive Issue Type: Bug Affects Versions: 1.3.0, 2.0.0 Reporter: Gopal V Assignee: Gopal V Labels: TODOC2.0 Fix For: 1.3.0, 2.0.0 Attachments: HIVE-11573.1.patch, HIVE-11573.2.patch, HIVE-11573.3.patch The PointLookupOptimizer can turn off some of the optimizations due to its use of tuple IN() clauses. Limit the application of the optimizer for very low nDV cases and extract the sub-clause as a pre-condition during runtime, to trigger the simple column predicate index lookups. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-11573) PointLookupOptimizer can be pessimistic at a low nDV
[ https://issues.apache.org/jira/browse/HIVE-11573?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gopal V updated HIVE-11573: --- Attachment: HIVE-11573.3.patch Add test case testing the sub-expr extract min restriction. Fixed golden files. PointLookupOptimizer can be pessimistic at a low nDV Key: HIVE-11573 URL: https://issues.apache.org/jira/browse/HIVE-11573 Project: Hive Issue Type: Bug Affects Versions: 1.3.0, 2.0.0 Reporter: Gopal V Assignee: Gopal V Fix For: 1.3.0, 2.0.0 Attachments: HIVE-11573.1.patch, HIVE-11573.2.patch, HIVE-11573.3.patch The PointLookupOptimizer can turn off some of the optimizations due to its use of tuple IN() clauses. Limit the application of the optimizer for very low nDV cases and extract the sub-clause as a pre-condition during runtime, to trigger the simple column predicate index lookups. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-11573) PointLookupOptimizer can be pessimistic at a low nDV
[ https://issues.apache.org/jira/browse/HIVE-11573?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gopal V updated HIVE-11573: --- Attachment: HIVE-11573.1.patch PointLookupOptimizer can be pessimistic at a low nDV Key: HIVE-11573 URL: https://issues.apache.org/jira/browse/HIVE-11573 Project: Hive Issue Type: Bug Affects Versions: 1.3.0, 2.0.0 Reporter: Gopal V Assignee: Gopal V Fix For: 1.3.0, 2.0.0 Attachments: HIVE-11573.1.patch The PointLookupOptimizer can turn off some of the optimizations due to its use of tuple IN() clauses. Limit the application of the optimizer for very low nDV cases and extract the sub-clause as a pre-condition during runtime, to trigger the simple column predicate index lookups. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-11573) PointLookupOptimizer can be pessimistic at a low nDV
[ https://issues.apache.org/jira/browse/HIVE-11573?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gopal V updated HIVE-11573: --- Attachment: HIVE-11573.2.patch PointLookupOptimizer can be pessimistic at a low nDV Key: HIVE-11573 URL: https://issues.apache.org/jira/browse/HIVE-11573 Project: Hive Issue Type: Bug Affects Versions: 1.3.0, 2.0.0 Reporter: Gopal V Assignee: Gopal V Fix For: 1.3.0, 2.0.0 Attachments: HIVE-11573.1.patch, HIVE-11573.2.patch The PointLookupOptimizer can turn off some of the optimizations due to its use of tuple IN() clauses. Limit the application of the optimizer for very low nDV cases and extract the sub-clause as a pre-condition during runtime, to trigger the simple column predicate index lookups. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-11573) PointLookupOptimizer can be pessimistic at a low nDV
[ https://issues.apache.org/jira/browse/HIVE-11573?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gopal V updated HIVE-11573: --- Attachment: HIVE-11594.2.patch PointLookupOptimizer can be pessimistic at a low nDV Key: HIVE-11573 URL: https://issues.apache.org/jira/browse/HIVE-11573 Project: Hive Issue Type: Bug Affects Versions: 1.3.0, 2.0.0 Reporter: Gopal V Assignee: Gopal V Fix For: 1.3.0, 2.0.0 Attachments: HIVE-11573.1.patch The PointLookupOptimizer can turn off some of the optimizations due to its use of tuple IN() clauses. Limit the application of the optimizer for very low nDV cases and extract the sub-clause as a pre-condition during runtime, to trigger the simple column predicate index lookups. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-11573) PointLookupOptimizer can be pessimistic at a low nDV
[ https://issues.apache.org/jira/browse/HIVE-11573?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gopal V updated HIVE-11573: --- Attachment: (was: HIVE-11594.2.patch) PointLookupOptimizer can be pessimistic at a low nDV Key: HIVE-11573 URL: https://issues.apache.org/jira/browse/HIVE-11573 Project: Hive Issue Type: Bug Affects Versions: 1.3.0, 2.0.0 Reporter: Gopal V Assignee: Gopal V Fix For: 1.3.0, 2.0.0 Attachments: HIVE-11573.1.patch The PointLookupOptimizer can turn off some of the optimizations due to its use of tuple IN() clauses. Limit the application of the optimizer for very low nDV cases and extract the sub-clause as a pre-condition during runtime, to trigger the simple column predicate index lookups. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
