odbtools/odbctest/mql/basic/24bucket_promdb/1230data2.mql

insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', 
		[{ '__name__':'key1', '__value__':2, '__timestamp__':'2024-07-27 11:24:17', 'disk':'/opt/matrix', 'CPU':'CPU1'},
		 { '__name__':'key2', '__value__':18.8, '__timestamp__':'2024-07-27 11:25:18', 'disk':'/opt/matrix', 'CPU':'CPU2'},
		 { '__name__':'key5', '__value__':2.9, '__timestamp__':'2024-07-27 11:25:19', 'disk':'/opt/matrix/test', 'CPU':'CPU5'},
		 { '__name__':'key48', '__value__':2.9, '__timestamp__':'2024-07-27 11:26:19', 'disk':'/opt/matrix', 'CPU':'CPU48'},
		 { '__name__':'key1', '__value__':12.7, '__timestamp__':'2024-07-28 11:24:17', 'disk':'/opt/matrix', 'CPU':'CPU1'},
		 { '__name__':'key2', '__value__':18.8, '__timestamp__':'2024-07-28 11:25:18', 'disk':'/opt/matrix', 'CPU':'CPU2'},
		 { '__name__':'key5', '__value__':12.9, '__timestamp__':'2024-07-28 11:25:19', 'disk':'/opt/matrix', 'CPU':'CPU5'},
		 { '__name__':'key48', '__value__':12.9, '__timestamp__':'2024-07-28 11:26:19', 'disk':'/opt/matrix', 'CPU':'CPU48'},
		 { '__name__':'key1', '__value__':2.7, '__timestamp__':'2024-07-29 11:24:17', 'disk':'/opt/matrix/test', 'CPU':'CPU1'},
		 { '__name__':'key2', '__value__':8.86, '__timestamp__':'2024-07-29 11:25:18', 'disk':'/opt/matrix', 'CPU':'CPU2'},
		 { '__name__':'key5', '__value__':2.9, '__timestamp__':'2024-07-29 11:25:19', 'disk':'/opt/matrix', 'CPU':'CPU5'},
		 { '__name__':'key48', '__value__':2.9, '__timestamp__':'2024-07-29 11:26:19', 'disk':'/opt/matrix', 'CPU':'CPU48'},
		 { '__name__':'key1', '__value__':22.7, '__timestamp__':'2024-07-30 11:24:17', 'disk':'/opt/matrix/test', 'CPU':'CPU1'},
		 { '__name__':'key2', '__value__':28.8, '__timestamp__':'2024-07-30 11:25:18', 'disk':'/opt/matrix', 'CPU':'CPU2'},
		 { '__name__':'key5', '__value__':22.9, '__timestamp__':'2024-07-30 11:25:19', 'disk':'/opt/matrix/test', 'CPU':'CPU5'},
		 { '__name__':'key48', '__value__':22.9, '__timestamp__':'2024-07-30 11:26:19', 'disk':'/opt/matrix', 'CPU':'CPU48'}] )
;

insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key3', '__value__':2, '__timestamp__':'2024-11-28 11:24:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:24:00.000';
insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.8, '__timestamp__':'2024-11-28 11:25:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:25:00.001';
insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.8, '__timestamp__':'2024-11-28 11:26:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:26:00.002';
insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key3', '__value__':null, '__timestamp__':'2024-11-28 11:27:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2024-11-28 11:27:00.003';
insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.6, '__timestamp__':'2024-11-28 11:28:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:28:00.004';
insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2024-11-28 11:29:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:29:00.005';
insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.6, '__timestamp__':'2024-11-28 11:30:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:30:00.006';
insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2024-11-28 11:31:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2024-11-28 11:31:00.007';
insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.6, '__timestamp__':'2024-11-28 11:32:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:32:00.008';

insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2024-11-28 11:24:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:24:00.009';
insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.6, '__timestamp__':'2024-11-28 11:25:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:25:00.010';
insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key4', '__value__':null, '__timestamp__':'2024-11-28 11:26:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2024-11-28 11:26:00.011';
insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key4', '__value__':3.7, '__timestamp__':'2024-11-28 11:27:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:27:00.012';
insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2024-11-28 11:28:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:28:00.013';
insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key4', '__value__':3.7, '__timestamp__':'2024-11-28 11:29:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:29:00.014';
insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2024-11-28 11:30:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:30:00.015';
insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key4', '__value__':4.7, '__timestamp__':'2024-11-28 11:31:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:31:00.016';
insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2024-11-28 11:32:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:32:00.017';

insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key3', '__value__':2, '__timestamp__':'2024-12-28 11:24:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] );
insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.8, '__timestamp__':'2024-12-28 11:25:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) ;
insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.8, '__timestamp__':'2024-12-28 11:26:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) ;
insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key3', '__value__':null, '__timestamp__':'2024-12-28 11:27:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) ;
insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.6, '__timestamp__':'2024-12-28 11:28:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) ;
insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2024-12-28 11:29:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) ;
insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.6, '__timestamp__':'2024-12-28 11:30:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) ;
insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2024-12-28 11:31:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) ;
insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.6, '__timestamp__':'2024-12-28 11:32:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) ;

insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2024-12-28 11:24:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) ;
insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.6, '__timestamp__':'2024-12-28 11:25:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) ;
insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key4', '__value__':null, '__timestamp__':'2024-12-28 11:26:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) ;
insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key4', '__value__':3.7, '__timestamp__':'2024-12-28 11:27:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) ;
insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2024-12-28 11:28:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) ;
insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key4', '__value__':3.7, '__timestamp__':'2024-12-28 11:29:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) ;
insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2024-12-28 11:30:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) ;
insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key4', '__value__':4.7, '__timestamp__':'2024-12-28 11:31:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) ;
insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2024-12-28 11:32:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) ;

insert into /test/bucketpromdb2 (id, prom2) values (?, ? )
/**
params("bucketpromdb2:wecise", [
		{"name": "key1", "value": 2, "timestamp": "2024-07-28 11:24:17"},
		{"name": "key2", "value": 1.8, "timestamp": "2024-07-28 11:25:18"},
		{"name": "key3", "value": 2.9, "timestamp": "2024-07-28 11:25:19"}])
**/
;

insert into /test/bucketpromdb2 (id, prom2) values (?, ? )
/**
params("bucketpromdb2:wecise", [
		{"name": "key1", "value": 2, "timestamp": "2024-07-28 12:24:17"},
		{"name": "key2", "value": 1.9, "timestamp": "2024-07-28 12:25:18"},
		{"name": "key3", "value": 3.9, "timestamp": "2024-07-28 12:25:19"},
		{"name": "key48", "value": 3.9, "timestamp": "2024-07-28 12:25:19"}])
**/
;

insert into /test/bucketpromdb2 (id, prom2) values (?, ? )
/**
params("bucketpromdb2:wecise", [
		{"name": "key1", "value": 2, "timestamp": "2024-07-29 11:24:17", "disk": "/opt/matrix", "CPU": "CPU1"},
		{"name": "key2", "value": 2.8, "timestamp": "2024-07-29 11:25:18", "disk": "/opt/matrix/test", "CPU": "CPU2"},
		{"name": "key3", "value": 2.9, "timestamp": "2024-07-29 11:25:19", "disk": "/opt/matrix", "CPU": "CPU3"},
		{"name": "key48", "value": 2.9, "timestamp": "2024-07-29 11:25:19", "disk": "/opt/matrix", "CPU": "CPU48"}])
**/
;

insert into /test/bucketpromdb2 (id, prom2) values (?, ? )
/**
params("bucketpromdb2:wecise", [
		{"__name__": "key1", "__value__": 5.2, "__timestamp__": "2024-07-30 11:24:17", "disk": "/opt/matrix", "CPU": "CPU1"},
		{"__name__": "key2", "__value__": 4, "__timestamp__": "2024-07-30 11:25:18", "disk": "/opt/matrix/test", "CPU": "CPU2"},
		{"__name__": "key3", "__value__": 2.9, "__timestamp__": "2024-07-30 11:25:19", "disk": "/opt/matrix", "CPU": "CPU3"},
		{"__name__": "key48", "__value__": 2.9, "__timestamp__": "2024-07-30 11:25:19", "disk": "/opt/matrix", "CPU": "CPU48"}])
**/
;

insert into /test/bucketpromdb2 (id, prom2) values (?, ? ) at ?
/**
params("bucketpromdb2:wecise", [
		{"__name__": "key1", "__value__": 6.0, "__timestamp__": "2024-07-31 11:24:17", "disk": "/opt/matrix", "CPU": "CPU1"},
		{"__name__": "key2", "__value__": 3.8, "__timestamp__": "2024-07-31 11:25:18", "disk": "/opt/matrix/test", "CPU": "CPU2"},
		{"__name__": "key3", "__value__": 5, "__timestamp__": "2024-07-31 11:25:19", "disk": "/opt/matrix", "CPU": "CPU3"},
		{"__name__": "key48", "__value__": 2.9, "__timestamp__": "2024-07-31 11:25:19", "disk": "/opt/matrix", "CPU": "CPU48"}],
        "2024-07-31 11:24:17")
**/
;

/**
sleep(1s)
**/
;