Seonggon Namgung created HIVE-28281:
---------------------------------------
Summary: Hive produces incorrect result when a vertex contains
multiple LimitOperator
Key: HIVE-28281
URL: https://issues.apache.org/jira/browse/HIVE-28281
Project: Hive
Issue Type: Bug
Reporter: Seonggon Namgung
I observed that running the following query with TestMiniLlapLocalCliDriver
produces wrong result. I expected 3 rows for table401_3, but got only a single
row.
{code:java}
--! qt:dataset:src
set mapred.min.split.size=10;
set mapred.max.split.size=10;
set tez.grouping.min-size=10;
set tez.grouping.max-size=10;
set tez.grouping.split-waves=10;
create table table230_1 (key string, value string);
create table table401_3 (key string, value string);
from (select * from src) a
insert overwrite table table230_1 select key, value where key = 230 limit 1
insert overwrite table table401_3 select key, value where key = 401 limit 3;
select * from table230_1;
select * from table401_3;{code}
It seems that current LimitReached optimization does not work well when a
vertex contains multiple LimitOperators.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
