[ https://issues.apache.org/jira/browse/HIVE-27484?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Work on HIVE-27484 started by okumin. ------------------------------------- > 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)