mirror of
https://github.com/GreptimeTeam/greptimedb.git
synced 2026-01-05 12:52:57 +00:00
314f2704d4
* chore: update datafusion * update sqlness case of time.sql Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * fix: adjust range query partition * fix: hisogram incorrect result Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * fix: ignore filter pushdown temporarily Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * fix: update limit sqlness result Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * fix: histogram with wrong distribution Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * fix: update negative ordinal sqlness case Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * feat: bump df to cd7a00b Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * resolve conflicts * ignore test_range_filter Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * fix promql exec panic * fix "select count(*)" exec error * re-enable the "test_range_filter" test since the filter push down seems not necessary to be removed * fix: range query schema error * update sqlness results Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * resolve conflicts * update datafusion, again * fix pyo3 compile error, and update some sqlness results * update decimal sqlness cases Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * fix: promql literal * fix udaf tests * fix filter pushdown sqlness tests * fix?: test_cast * fix: rspy test fail due to datafusion `sin` signature change * rebase main to see if there are any failed tests * debug ci * debug ci * debug ci * enforce input partition Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * debug ci * fix ci * fix ci * debug ci * debug ci * debug ci * fix sqlness * feat: do not return error while creating a filter * chore: remove array from error * chore: replace todo with unimplemented * Update src/flow/clippy.toml Co-authored-by: Yingwen <realevenyag@gmail.com> --------- Signed-off-by: Ruihang Xia <waynestxia@gmail.com> Co-authored-by: Ruihang Xia <waynestxia@gmail.com> Co-authored-by: WUJingdi <taylor-lagrange@qq.com> Co-authored-by: discord9 <discord9@163.com> Co-authored-by: evenyag <realevenyag@gmail.com> Co-authored-by: tison <wander4096@gmail.com>
208 lines
5.8 KiB
Plaintext
208 lines
5.8 KiB
Plaintext
create table t_1 (ts timestamp time index, vin string, val int);
|
|
|
|
Affected Rows: 0
|
|
|
|
create table t_2 (ts timestamp time index, vin string, val int);
|
|
|
|
Affected Rows: 0
|
|
|
|
create table t_3 (ts timestamp time index, vin string, val int);
|
|
|
|
Affected Rows: 0
|
|
|
|
create table t_4 (ts timestamp time index, vin string, val int);
|
|
|
|
Affected Rows: 0
|
|
|
|
create table t_5 (ts timestamp time index, vin string, val int);
|
|
|
|
Affected Rows: 0
|
|
|
|
create table t_6 (ts timestamp time index, vin string, val int);
|
|
|
|
Affected Rows: 0
|
|
|
|
create table t_7 (ts timestamp time index, vin string, val int);
|
|
|
|
Affected Rows: 0
|
|
|
|
create table t_8 (ts timestamp time index, vin string, val int);
|
|
|
|
Affected Rows: 0
|
|
|
|
create table t_9 (ts timestamp time index, vin string, val int);
|
|
|
|
Affected Rows: 0
|
|
|
|
create table t_10 (ts timestamp time index, vin string, val int);
|
|
|
|
Affected Rows: 0
|
|
|
|
-- SQLNESS REPLACE (-+) -
|
|
-- SQLNESS REPLACE (\s\s+) _
|
|
-- SQLNESS REPLACE (RoundRobinBatch.*) REDACTED
|
|
-- SQLNESS REPLACE (Hash.*) REDACTED
|
|
-- SQLNESS REPLACE (peers.*) REDACTED
|
|
explain
|
|
select *
|
|
from
|
|
t_1
|
|
INNER JOIN t_2 ON t_2.ts = t_1.ts
|
|
AND t_2.vin = t_1.vin
|
|
INNER JOIN t_3 ON t_3.ts = t_2.ts
|
|
AND t_3.vin = t_2.vin
|
|
INNER JOIN t_4 ON t_4.ts = t_3.ts
|
|
AND t_4.vin = t_3.vin
|
|
INNER JOIN t_5 ON t_5.ts = t_4.ts
|
|
AND t_5.vin = t_4.vin
|
|
INNER JOIN t_6 ON t_6.ts = t_5.ts
|
|
AND t_6.vin = t_5.vin
|
|
INNER JOIN t_7 ON t_7.ts = t_6.ts
|
|
AND t_7.vin = t_6.vin
|
|
INNER JOIN t_8 ON t_8.ts = t_7.ts
|
|
AND t_8.vin = t_7.vin
|
|
INNER JOIN t_9 ON t_9.ts = t_8.ts
|
|
AND t_9.vin = t_8.vin
|
|
INNER JOIN t_10 ON t_10.ts = t_9.ts
|
|
AND t_10.vin = t_9.vin
|
|
where
|
|
t_1.vin is not null
|
|
order by t_1.ts desc
|
|
limit 1;
|
|
|
|
+-+-+
|
|
| plan_type_| plan_|
|
|
+-+-+
|
|
| logical_plan_| Limit: skip=0, fetch=1_|
|
|
|_|_Sort: t_1.ts DESC NULLS FIRST, fetch=1_|
|
|
|_|_Projection: t_1.ts, t_1.vin, t_1.val, t_2.ts, t_2.vin, t_2.val, t_3.ts, t_3.vin, t_3.val, t_4.ts, t_4.vin, t_4.val, t_5.ts, t_5.vin, t_5.val, t_6.ts, t_6.vin, t_6.val, t_7.ts, t_7.vin, t_7.val, t_8.ts, t_8.vin, t_8.val, t_9.ts, t_9.vin, t_9.val, t_10.ts, t_10.vin, t_10.val |
|
|
|_|_Inner Join: t_9.ts = t_10.ts, t_9.vin = t_10.vin_|
|
|
|_|_Inner Join: t_8.ts = t_9.ts, t_8.vin = t_9.vin_|
|
|
|_|_Inner Join: t_7.ts = t_8.ts, t_7.vin = t_8.vin_|
|
|
|_|_Inner Join: t_6.ts = t_7.ts, t_6.vin = t_7.vin_|
|
|
|_|_Inner Join: t_5.ts = t_6.ts, t_5.vin = t_6.vin_|
|
|
|_|_Inner Join: t_4.ts = t_5.ts, t_4.vin = t_5.vin_|
|
|
|_|_Inner Join: t_3.ts = t_4.ts, t_3.vin = t_4.vin_|
|
|
|_|_Inner Join: t_2.ts = t_3.ts, t_2.vin = t_3.vin_|
|
|
|_|_Inner Join: t_1.ts = t_2.ts, t_1.vin = t_2.vin_|
|
|
|_|_Filter: t_1.vin IS NOT NULL_|
|
|
|_|_MergeScan [is_placeholder=false]_|
|
|
|_|_Filter: t_2.vin IS NOT NULL_|
|
|
|_|_MergeScan [is_placeholder=false]_|
|
|
|_|_MergeScan [is_placeholder=false]_|
|
|
|_|_MergeScan [is_placeholder=false]_|
|
|
|_|_MergeScan [is_placeholder=false]_|
|
|
|_|_MergeScan [is_placeholder=false]_|
|
|
|_|_MergeScan [is_placeholder=false]_|
|
|
|_|_MergeScan [is_placeholder=false]_|
|
|
|_|_MergeScan [is_placeholder=false]_|
|
|
|_|_MergeScan [is_placeholder=false]_|
|
|
| physical_plan | GlobalLimitExec: skip=0, fetch=1_|
|
|
|_|_SortPreservingMergeExec: [ts@0 DESC], fetch=1_|
|
|
|_|_SortExec: TopK(fetch=1), expr=[ts@0 DESC]_|
|
|
|_|_CoalesceBatchesExec: target_batch_size=8192_|
|
|
|_|_REDACTED
|
|
|_|_CoalesceBatchesExec: target_batch_size=8192_|
|
|
|_|_REDACTED
|
|
|_|_CoalesceBatchesExec: target_batch_size=8192_|
|
|
|_|_REDACTED
|
|
|_|_CoalesceBatchesExec: target_batch_size=8192_|
|
|
|_|_REDACTED
|
|
|_|_CoalesceBatchesExec: target_batch_size=8192_|
|
|
|_|_REDACTED
|
|
|_|_CoalesceBatchesExec: target_batch_size=8192_|
|
|
|_|_REDACTED
|
|
|_|_CoalesceBatchesExec: target_batch_size=8192_|
|
|
|_|_REDACTED
|
|
|_|_CoalesceBatchesExec: target_batch_size=8192_|
|
|
|_|_REDACTED
|
|
|_|_CoalesceBatchesExec: target_batch_size=8192_|
|
|
|_|_REDACTED
|
|
|_|_CoalesceBatchesExec: target_batch_size=8192_|
|
|
|_|_RepartitionExec: partitioning=REDACTED
|
|
|_|_CoalesceBatchesExec: target_batch_size=8192_|
|
|
|_|_FilterExec: vin@1 IS NOT NULL_|
|
|
|_|_RepartitionExec: partitioning=REDACTED
|
|
|_|_MergeScanExec: REDACTED
|
|
|_|_CoalesceBatchesExec: target_batch_size=8192_|
|
|
|_|_RepartitionExec: partitioning=REDACTED
|
|
|_|_CoalesceBatchesExec: target_batch_size=8192_|
|
|
|_|_FilterExec: vin@1 IS NOT NULL_|
|
|
|_|_RepartitionExec: partitioning=REDACTED
|
|
|_|_MergeScanExec: REDACTED
|
|
|_|_CoalesceBatchesExec: target_batch_size=8192_|
|
|
|_|_RepartitionExec: partitioning=REDACTED
|
|
|_|_RepartitionExec: partitioning=REDACTED
|
|
|_|_MergeScanExec: REDACTED
|
|
|_|_CoalesceBatchesExec: target_batch_size=8192_|
|
|
|_|_RepartitionExec: partitioning=REDACTED
|
|
|_|_RepartitionExec: partitioning=REDACTED
|
|
|_|_MergeScanExec: REDACTED
|
|
|_|_CoalesceBatchesExec: target_batch_size=8192_|
|
|
|_|_RepartitionExec: partitioning=REDACTED
|
|
|_|_RepartitionExec: partitioning=REDACTED
|
|
|_|_MergeScanExec: REDACTED
|
|
|_|_CoalesceBatchesExec: target_batch_size=8192_|
|
|
|_|_RepartitionExec: partitioning=REDACTED
|
|
|_|_RepartitionExec: partitioning=REDACTED
|
|
|_|_MergeScanExec: REDACTED
|
|
|_|_CoalesceBatchesExec: target_batch_size=8192_|
|
|
|_|_RepartitionExec: partitioning=REDACTED
|
|
|_|_RepartitionExec: partitioning=REDACTED
|
|
|_|_MergeScanExec: REDACTED
|
|
|_|_CoalesceBatchesExec: target_batch_size=8192_|
|
|
|_|_RepartitionExec: partitioning=REDACTED
|
|
|_|_RepartitionExec: partitioning=REDACTED
|
|
|_|_MergeScanExec: REDACTED
|
|
|_|_CoalesceBatchesExec: target_batch_size=8192_|
|
|
|_|_RepartitionExec: partitioning=REDACTED
|
|
|_|_RepartitionExec: partitioning=REDACTED
|
|
|_|_MergeScanExec: REDACTED
|
|
|_|_CoalesceBatchesExec: target_batch_size=8192_|
|
|
|_|_RepartitionExec: partitioning=REDACTED
|
|
|_|_RepartitionExec: partitioning=REDACTED
|
|
|_|_MergeScanExec: REDACTED
|
|
|_|_|
|
|
+-+-+
|
|
|
|
drop table t_1;
|
|
|
|
Affected Rows: 0
|
|
|
|
drop table t_2;
|
|
|
|
Affected Rows: 0
|
|
|
|
drop table t_3;
|
|
|
|
Affected Rows: 0
|
|
|
|
drop table t_4;
|
|
|
|
Affected Rows: 0
|
|
|
|
drop table t_5;
|
|
|
|
Affected Rows: 0
|
|
|
|
drop table t_6;
|
|
|
|
Affected Rows: 0
|
|
|
|
drop table t_7;
|
|
|
|
Affected Rows: 0
|
|
|
|
drop table t_8;
|
|
|
|
Affected Rows: 0
|
|
|
|
drop table t_9;
|
|
|
|
Affected Rows: 0
|
|
|
|
drop table t_10;
|
|
|
|
Affected Rows: 0
|
|
|