[jira] [Updated] (HIVE-27484) Limit pushdown with offset generate wrong results
[ https://issues.apache.org/jira/browse/HIVE-27484?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krisztian Kasa updated HIVE-27484: -- Resolution: Fixed Status: Resolved (was: Patch Available) Merged to master. Thanks [~okumin] for the patch and [~aturoczy] for review. > Limit pushdown with offset generate wrong results > - > > Key: HIVE-27484 > URL: https://issues.apache.org/jira/browse/HIVE-27484 > Project: Hive > Issue Type: Bug > Components: CBO >Affects Versions: 4.0.0-alpha-2 >Reporter: okumin >Assignee: okumin >Priority: Major > Labels: pull-request-available > > With `hive.optimize.limittranspose` in CBO, Hive can generate incorrect > results. > For example, I'd say this case should generate 1 row. > https://github.com/apache/hive/blob/rel/release-4.0.0-alpha-2/ql/src/test/results/clientpositive/llap/limit_join_transpose.q.out#L1328-L1341 -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Updated] (HIVE-27484) Limit pushdown with offset generate wrong results
[ https://issues.apache.org/jira/browse/HIVE-27484?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] okumin updated HIVE-27484: -- Status: Patch Available (was: In Progress) > Limit pushdown with offset generate wrong results > - > > Key: HIVE-27484 > URL: https://issues.apache.org/jira/browse/HIVE-27484 > Project: Hive > Issue Type: Bug > Components: CBO >Affects Versions: 4.0.0-alpha-2 >Reporter: okumin >Assignee: okumin >Priority: Major > Labels: pull-request-available > > With `hive.optimize.limittranspose` in CBO, Hive can generate incorrect > results. > For example, I'd say this case should generate 1 row. > https://github.com/apache/hive/blob/rel/release-4.0.0-alpha-2/ql/src/test/results/clientpositive/llap/limit_join_transpose.q.out#L1328-L1341 -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Updated] (HIVE-27484) Limit pushdown with offset generate wrong results
[ https://issues.apache.org/jira/browse/HIVE-27484?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated HIVE-27484: -- Labels: pull-request-available (was: ) > Limit pushdown with offset generate wrong results > - > > Key: HIVE-27484 > URL: https://issues.apache.org/jira/browse/HIVE-27484 > Project: Hive > Issue Type: Bug > Components: CBO >Affects Versions: 4.0.0-alpha-2 >Reporter: okumin >Assignee: okumin >Priority: Major > Labels: pull-request-available > > With `hive.optimize.limittranspose` in CBO, Hive can generate incorrect > results. > For example, I'd say this case should generate 1 row. > https://github.com/apache/hive/blob/rel/release-4.0.0-alpha-2/ql/src/test/results/clientpositive/llap/limit_join_transpose.q.out#L1328-L1341 -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Updated] (HIVE-27484) Limit pushdown with offset generate wrong results
[ https://issues.apache.org/jira/browse/HIVE-27484?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] okumin updated HIVE-27484: -- Description: With `hive.optimize.limittranspose` in CBO, Hive can generate incorrect results. For example, I'd say this case should generate 1 row. https://github.com/apache/hive/blob/rel/release-4.0.0-alpha-2/ql/src/test/results/clientpositive/llap/limit_join_transpose.q.out#L1328-L1341 was: With `hive.optimize.limittranspose`, Hive can generate incorrect results. For example, I'd say this case should generate 1 row. https://github.com/apache/hive/blob/rel/release-4.0.0-alpha-2/ql/src/test/results/clientpositive/llap/limit_join_transpose.q.out#L1328-L1341 > Limit pushdown with offset generate wrong results > - > > Key: HIVE-27484 > URL: https://issues.apache.org/jira/browse/HIVE-27484 > Project: Hive > Issue Type: Bug > Components: CBO >Affects Versions: 4.0.0-alpha-2 >Reporter: okumin >Assignee: okumin >Priority: Major > > With `hive.optimize.limittranspose` in CBO, Hive can generate incorrect > results. > For example, I'd say this case should generate 1 row. > https://github.com/apache/hive/blob/rel/release-4.0.0-alpha-2/ql/src/test/results/clientpositive/llap/limit_join_transpose.q.out#L1328-L1341 -- This message was sent by Atlassian Jira (v8.20.10#820010)
