mirror of
https://github.com/GreptimeTeam/greptimedb.git
synced 2026-01-13 00:32:56 +00:00
8de11a0e34
* perf: set simple filter on primary key columns to exact filter Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * add sqlness test Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * fix typo Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * fix sqlness Signed-off-by: Ruihang Xia <waynestxia@gmail.com> --------- Signed-off-by: Ruihang Xia <waynestxia@gmail.com>
31 lines
987 B
SQL
31 lines
987 B
SQL
create table demo(ts timestamp time index, `value` double, host string,idc string, collector string, primary key(host, idc, collector));
|
|
|
|
insert into demo values(1,2,'test1', 'idc1', 'disk') ,(2,3,'test2', 'idc1', 'disk'), (3,4,'test3', 'idc2','memory');
|
|
|
|
select * from demo where host='test1';
|
|
|
|
select * from demo where host='test2';
|
|
|
|
select * from demo where host='test3';
|
|
|
|
select * from demo where host='test2' and idc='idc1';
|
|
|
|
select * from demo where host='test2' and idc='idc1' and collector='disk';
|
|
|
|
select * from demo where host='test2' and idc='idc2';
|
|
|
|
select * from demo where host='test3' and idc>'idc1';
|
|
|
|
select * from demo where idc='idc1' order by ts;
|
|
|
|
select * from demo where collector='disk' order by ts;
|
|
|
|
-- SQLNESS REPLACE (-+) -
|
|
-- SQLNESS REPLACE (\s\s+) _
|
|
-- SQLNESS REPLACE (peers.*) REDACTED
|
|
-- SQLNESS REPLACE (metrics.*) REDACTED
|
|
-- SQLNESS REPLACE region=\d+\(\d+,\s+\d+\) region=REDACTED
|
|
explain analyze select * from demo where idc='idc1';
|
|
|
|
drop table demo;
|