Open lgbo-ustc opened 3 days ago
Run Gluten Clickhouse CI on x86
Run Gluten Clickhouse CI on x86
Run Gluten Clickhouse CI on x86
Run Gluten Clickhouse CI on x86
A benchmark on following queries
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)
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, l_orderkey order by l_partkey) as r from tpch_pq.lineitem) where r = 1;
+---------+
| Result |
+---------+
+---------+
No rows selected (41.441 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, l_orderkey order by l_partkey) as r from tpch_pq.lineitem) where r = 1;
+---------+
| Result |
+---------+
+---------+
No rows selected (50.714 seconds)
Run Gluten Clickhouse CI on x86
Run Gluten Clickhouse CI on x86
What changes were proposed in this pull request?
(Please fill in changes proposed in this fix)
Fixes: #7905
How was this patch tested?
(Please explain how this patch was tested. E.g. unit tests, integration tests, manual tests)
unit tests
(If this patch involves UI changes, please attach a screenshot; otherwise, remove this)