create table demo(ts timestamp time index, `value` double, host string,idc string, collector string, primary key(host, idc, collector));

Affected Rows: 0

insert into demo values(1,2,'test1', 'idc1', 'disk') ,(2,3,'test2', 'idc1', 'disk'), (3,4,'test3', 'idc2','memory');

Affected Rows: 3

select * from demo where host='test1';

+-------------------------+-------+-------+------+-----------+
| ts                      | value | host  | idc  | collector |
+-------------------------+-------+-------+------+-----------+
| 1970-01-01T00:00:00.001 | 2.0   | test1 | idc1 | disk      |
+-------------------------+-------+-------+------+-----------+

select * from demo where host='test2';

+-------------------------+-------+-------+------+-----------+
| ts                      | value | host  | idc  | collector |
+-------------------------+-------+-------+------+-----------+
| 1970-01-01T00:00:00.002 | 3.0   | test2 | idc1 | disk      |
+-------------------------+-------+-------+------+-----------+

select * from demo where host='test3';

+-------------------------+-------+-------+------+-----------+
| ts                      | value | host  | idc  | collector |
+-------------------------+-------+-------+------+-----------+
| 1970-01-01T00:00:00.003 | 4.0   | test3 | idc2 | memory    |
+-------------------------+-------+-------+------+-----------+

select * from demo where host='test2' and idc='idc1';

+-------------------------+-------+-------+------+-----------+
| ts                      | value | host  | idc  | collector |
+-------------------------+-------+-------+------+-----------+
| 1970-01-01T00:00:00.002 | 3.0   | test2 | idc1 | disk      |
+-------------------------+-------+-------+------+-----------+

select * from demo where host='test2' and idc='idc1' and collector='disk';

+-------------------------+-------+-------+------+-----------+
| ts                      | value | host  | idc  | collector |
+-------------------------+-------+-------+------+-----------+
| 1970-01-01T00:00:00.002 | 3.0   | test2 | idc1 | disk      |
+-------------------------+-------+-------+------+-----------+

select * from demo where host='test2' and idc='idc2';

++
++

select * from demo where host='test3' and idc>'idc1';

+-------------------------+-------+-------+------+-----------+
| ts                      | value | host  | idc  | collector |
+-------------------------+-------+-------+------+-----------+
| 1970-01-01T00:00:00.003 | 4.0   | test3 | idc2 | memory    |
+-------------------------+-------+-------+------+-----------+

select * from demo where idc='idc1' order by ts;

+-------------------------+-------+-------+------+-----------+
| ts                      | value | host  | idc  | collector |
+-------------------------+-------+-------+------+-----------+
| 1970-01-01T00:00:00.001 | 2.0   | test1 | idc1 | disk      |
| 1970-01-01T00:00:00.002 | 3.0   | test2 | idc1 | disk      |
+-------------------------+-------+-------+------+-----------+

select * from demo where collector='disk' order by ts;

+-------------------------+-------+-------+------+-----------+
| ts                      | value | host  | idc  | collector |
+-------------------------+-------+-------+------+-----------+
| 1970-01-01T00:00:00.001 | 2.0   | test1 | idc1 | disk      |
| 1970-01-01T00:00:00.002 | 3.0   | test2 | idc1 | disk      |
+-------------------------+-------+-------+------+-----------+

drop table demo;

Affected Rows: 0