mirror of
https://github.com/GreptimeTeam/greptimedb.git
synced 2026-05-16 04:50:38 +00:00
b2074e3863
* chore: upgrade DataFusion family Signed-off-by: luofucong <luofc@foxmail.com> * chore: switch to released version of datafusion-pg-catalog --------- Signed-off-by: luofucong <luofc@foxmail.com> Co-authored-by: Ning Sun <sunning@greptime.com> Co-authored-by: Ning Sun <sunng@protonmail.com>
96 lines
2.7 KiB
Plaintext
96 lines
2.7 KiB
Plaintext
create table
|
|
skipping_table (
|
|
ts timestamp time index,
|
|
`id` string skipping index,
|
|
`name` string skipping index
|
|
with
|
|
(granularity = 8192),
|
|
);
|
|
|
|
Affected Rows: 0
|
|
|
|
INSERT INTO skipping_table VALUES (1664356800000, 'id1', 'name1');
|
|
|
|
Affected Rows: 1
|
|
|
|
ADMIN FLUSH_TABLE('skipping_table');
|
|
|
|
+-------------------------------------+
|
|
| ADMIN FLUSH_TABLE('skipping_table') |
|
|
+-------------------------------------+
|
|
| 0 |
|
|
+-------------------------------------+
|
|
|
|
INSERT INTO skipping_table VALUES (1664356801000, 'id2', 'name2');
|
|
|
|
Affected Rows: 1
|
|
|
|
ADMIN FLUSH_TABLE('skipping_table');
|
|
|
|
+-------------------------------------+
|
|
| ADMIN FLUSH_TABLE('skipping_table') |
|
|
+-------------------------------------+
|
|
| 0 |
|
|
+-------------------------------------+
|
|
|
|
INSERT INTO skipping_table VALUES (1664356802000, 'id3', 'name3');
|
|
|
|
Affected Rows: 1
|
|
|
|
ADMIN FLUSH_TABLE('skipping_table');
|
|
|
|
+-------------------------------------+
|
|
| ADMIN FLUSH_TABLE('skipping_table') |
|
|
+-------------------------------------+
|
|
| 0 |
|
|
+-------------------------------------+
|
|
|
|
-- SQLNESS REPLACE (metrics.*) REDACTED
|
|
-- SQLNESS REPLACE (RoundRobinBatch.*) REDACTED
|
|
-- SQLNESS REPLACE (-+) -
|
|
-- SQLNESS REPLACE (\s\s+) _
|
|
-- SQLNESS REPLACE (peers.*) REDACTED
|
|
-- SQLNESS REPLACE region=\d+\(\d+,\s+\d+\) region=REDACTED
|
|
EXPLAIN ANALYZE SELECT * FROM skipping_table WHERE id = 'id2' ORDER BY `name`;
|
|
|
|
+-+-+-+
|
|
| stage | node | plan_|
|
|
+-+-+-+
|
|
| 0_| 0_|_CooperativeExec REDACTED
|
|
|_|_|_MergeScanExec: REDACTED
|
|
|_|_|_|
|
|
| 1_| 0_|_SortPreservingMergeExec: [name@2 ASC NULLS LAST] REDACTED
|
|
|_|_|_SortExec: expr=[name@2 ASC NULLS LAST], preserve_partitioning=[true] REDACTED
|
|
|_|_|_FilterExec: id@1 = id2 REDACTED
|
|
|_|_|_SeqScan: region=REDACTED, "partition_count":{"count":3, "mem_ranges":0, "files":3, "file_ranges":3} REDACTED
|
|
|_|_|_|
|
|
|_|_| Total rows: 1_|
|
|
+-+-+-+
|
|
|
|
-- SQLNESS REPLACE (metrics.*) REDACTED
|
|
-- SQLNESS REPLACE (RoundRobinBatch.*) REDACTED
|
|
-- SQLNESS REPLACE (-+) -
|
|
-- SQLNESS REPLACE (\s\s+) _
|
|
-- SQLNESS REPLACE (peers.*) REDACTED
|
|
-- SQLNESS REPLACE region=\d+\(\d+,\s+\d+\) region=REDACTED
|
|
EXPLAIN ANALYZE SELECT * FROM skipping_table WHERE id = 'id5' ORDER BY `name`;
|
|
|
|
+-+-+-+
|
|
| stage | node | plan_|
|
|
+-+-+-+
|
|
| 0_| 0_|_CooperativeExec REDACTED
|
|
|_|_|_MergeScanExec: REDACTED
|
|
|_|_|_|
|
|
| 1_| 0_|_SortPreservingMergeExec: [name@2 ASC NULLS LAST] REDACTED
|
|
|_|_|_SortExec: expr=[name@2 ASC NULLS LAST], preserve_partitioning=[true] REDACTED
|
|
|_|_|_FilterExec: id@1 = id5 REDACTED
|
|
|_|_|_SeqScan: region=REDACTED, "partition_count":{"count":3, "mem_ranges":0, "files":3, "file_ranges":3} REDACTED
|
|
|_|_|_|
|
|
|_|_| Total rows: 0_|
|
|
+-+-+-+
|
|
|
|
DROP TABLE IF EXISTS skipping_table;
|
|
|
|
Affected Rows: 0
|
|
|