lgbo-ustc commented on PR #7976:
URL:
https://github.com/apache/incubator-gluten/pull/7976#issuecomment-2487979082
A benchmark on following query
```sql
insert overwrite table dump_line
select l_orderkey, l_partkey, l_suppkey, l_linenumber from (
select l_orderkey, l_partkey, l_suppkey, l_linenumber, row_number() over
(partition by l_suppkey order by l_orderkey, l_partkey) as r from
tpch_pq.lineitem
) where r = 1;
```
- before
```
0: jdbc:hive2://localhost:10000> insert overwrite table dump_line select
l_orderkey, l_partkey, l_suppkey, l_linenumber from (select l_orderkey,
l_partkey, l_suppkey, l_linenumber, row_number() over (partition by l_suppkey
order by l_orderkey, l_partkey) as r from tpch_pq.lineitem) where r = 1;
+---------+
| Result |
+---------+
+---------+
No rows selected (28.467 seconds)
```
-after
```
0: jdbc:hive2://localhost:10000> insert overwrite table dump_line select
l_orderkey, l_partkey, l_suppkey, l_linenumber from (select l_orderkey,
l_partkey, l_suppkey, l_linenumber, row_number() over (partition by l_suppkey
order by l_orderkey, l_partkey) as r from tpch_pq.lineitem) where r = 1;
+---------+
| Result |
+---------+
+---------+
No rows selected (14.3 seconds)
```
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
