kasakrisz commented on PR #5637:
URL: https://github.com/apache/hive/pull/5637#issuecomment-2996608233
@barking-code, @deniskuzZ
```
set hive.support.concurrency=true;
set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;
create table t1 (a bigint) stored as orc TBLPROPERTIES
('transactional'='true');
insert into t1 values
(1),
(1704034800001),
(1704034800001),
(1704034800001),
(1704034800001),
(1704034800001),
(1704034800001),
(1704034800001),
(1704034800001);
delete from t1 where a = 1; -- makes the column stats stale
set hive.fetch.task.conversion=none;
explain
select * from t1 where a >= 1704034800000;
explain
select * from t1 where a >= 10;
```
Partial plan of the first query:
```
select * from t1 where a >= 1704034800000
TableScan
alias: t1
filterExpr: (a >= 1704034800000L) (type: boolean)
Statistics: Num rows: 8 Data size: 64 Basic stats:
COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (a >= 1704034800000L) (type: boolean)
Statistics: Num rows: 1 Data size: 8 Basic stats:
COMPLETE Column stats: COMPLETE
```
Based on stats estimations the TS reads 8 rows and the filter forward only 1
row.
I run the query using both apache master and applying this patch but got the
same plan and row count estimates.
Partial plan of the second query:
```
select * from t1 where a >= 10
TableScan
alias: t1
filterExpr: (a >= 10L) (type: boolean)
Statistics: Num rows: 8 Data size: 64 Basic stats:
COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (a >= 10L) (type: boolean)
Statistics: Num rows: 8 Data size: 64 Basic stats:
COMPLETE Column stats: COMPLETE
```
This time the filter forward 8 rows bot on apache master and with this patch.
Please provide the repro steps to move this forward.
Thank you.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: gitbox-unsubscr...@hive.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: gitbox-unsubscr...@hive.apache.org
For additional commands, e-mail: gitbox-h...@hive.apache.org
