insert into /test/bucketsplit (id, prom_split) values (?, ? )
/**
loop(1440)
set(ct,"2024-07-20 00:00:00")
beforerun(
    add(ct,60,second)
)
params("bucketsplit:wecise", [
			{"name": "key1", "value": 2, "timestamp": "{%t,ct}"},
			{"name": "key2", "value": 1.8, "timestamp": "{%t,ct}"},
			{"name": "key3", "value": 2.9, "timestamp": "{%t,ct}"},
			{"name": "key4", "value": 2, "timestamp": "{%t,ct}"},
			{"name": "key5", "value": 1.8, "timestamp": "{%t,ct}"},
			{"name": "key6", "value": 2.9, "timestamp": "{%t,ct}"},
			{"name": "key7", "value": 2, "timestamp": "{%t,ct}"},
			{"name": "key8", "value": 1.8, "timestamp": "{%t,ct}"},
			{"name": "key9", "value": 2.9, "timestamp": "{%t,ct}"},
			{"name": "key1", "disk": "/opt/matrix1", "CPU": "CPU1", "value": 2, "timestamp": "{%t,ct}"},
			{"name": "key2", "disk": "/opt/matrix1", "CPU": "CPU1", "value": 1.8, "timestamp": "{%t,ct}"},
			{"name": "key3", "disk": "/opt/matrix1", "CPU": "CPU2", "value": 2.9, "timestamp": "{%t,ct}"},
			{"name": "key4", "disk": "/opt/matrix1", "CPU": "CPU2", "value": 2, "timestamp": "{%t,ct}"},
			{"name": "key5", "disk": "/opt/matrix1", "CPU": "CPU3", "value": 1.8, "timestamp": "{%t,ct}"},
			{"name": "key6", "disk": "/opt/matrix1", "CPU": "CPU3", "value": 2.9, "timestamp": "{%t,ct}"},
			{"name": "key7", "disk": "/opt/matrix1", "CPU": "CPU4", "value": 2, "timestamp": "{%t,ct}"},
			{"name": "key8", "disk": "/opt/matrix1", "CPU": "CPU4", "value": 1.8, "timestamp": "{%t,ct}"},
			{"name": "key9", "disk": "/opt/matrix1", "CPU": "CPU4", "value": 2.9, "timestamp": "{%t,ct}"}])
**/;

insert into /test/bucketsplit (id, prom_split) values ('bucketsplit:wecise', 
		[{ '__name__':'key1', '__value__':2, '__timestamp__':'2024-07-25 11:24:17', 'disk':'/opt/matrix1', 'CPU':'CPU1'},
		 { '__name__':'key2', '__value__':8.81, '__timestamp__':'2024-07-25 11:25:18', 'disk':'/opt/matrix2', 'CPU':'CPU2'},
		 { '__name__':'key5', '__value__':2.9, '__timestamp__':'2024-07-25 11:25:19', 'disk':'/opt/matrix3', 'CPU':'CPU5'},
		 { '__name__':'key48', '__value__':2.9, '__timestamp__':'2024-07-25 11:26:19', 'disk':'/opt/matrix4', 'CPU':'CPU48'},
		 
		 { '__name__':'key1', '__value__':200, '__timestamp__':'2024-07-25 11:34:17', 'disk':'/opt/matrix1', 'CPU':'CPU1'},
		 { '__name__':'key2', '__value__':80.81, '__timestamp__':'2024-07-25 11:35:18', 'disk':'/opt/matrix2', 'CPU':'CPU2'},
		 { '__name__':'key5', '__value__':20.9, '__timestamp__':'2024-07-25 11:35:19', 'disk':'/opt/matrix3', 'CPU':'CPU5'},
		 { '__name__':'key48', '__value__':20.9, '__timestamp__':'2024-07-25 11:36:19', 'disk':'/opt/matrix4', 'CPU':'CPU48'},
		 
		 
		 { '__name__':'key1', '__value__':20, '__timestamp__':'2024-07-26 11:24:17', 'disk':'/opt/matrix1', 'CPU':'CPU1'},
		 { '__name__':'key2', '__value__':800.81, '__timestamp__':'2024-07-26 11:25:18', 'disk':'/opt/matrix2', 'CPU':'CPU2'},
		 { '__name__':'key5', '__value__':20.9, '__timestamp__':'2024-07-26 11:25:19', 'disk':'/opt/matrix3', 'CPU':'CPU5'},
		 { '__name__':'key48', '__value__':200.9, '__timestamp__':'2024-07-26 11:26:19', 'disk':'/opt/matrix4', 'CPU':'CPU48'},
		 
		 { '__name__':'key1', '__value__':20, '__timestamp__':'2024-07-26 11:34:17', 'disk':'/opt/matrix1', 'CPU':'CPU1'},
		 { '__name__':'key2', '__value__':800.81, '__timestamp__':'2024-07-26 11:35:18', 'disk':'/opt/matrix2', 'CPU':'CPU2'},
		 { '__name__':'key5', '__value__':20.9, '__timestamp__':'2024-07-26 11:35:19', 'disk':'/opt/matrix3', 'CPU':'CPU5'},
		 { '__name__':'key48', '__value__':20.9, '__timestamp__':'2024-07-26 11:36:19', 'disk':'/opt/matrix4', 'CPU':'CPU48'},
		 
		 { '__name__':'key1', '__value__':20, '__timestamp__':'2024-07-27 11:24:17', 'disk':'/opt/matrix1', 'CPU':'CPU1'},
		 { '__name__':'key2', '__value__':800.81, '__timestamp__':'2024-07-27 11:25:18', 'disk':'/opt/matrix2', 'CPU':'CPU2'},
		 { '__name__':'key5', '__value__':20.9, '__timestamp__':'2024-07-27 11:25:19', 'disk':'/opt/matrix3', 'CPU':'CPU5'},
		 { '__name__':'key48', '__value__':200.9, '__timestamp__':'2024-07-27 11:26:19', 'disk':'/opt/matrix4', 'CPU':'CPU48'},
		 
		 { '__name__':'key1', '__value__':2, '__timestamp__':'2024-07-27 11:34:17', 'disk':'/opt/matrix1', 'CPU':'CPU1'},
		 { '__name__':'key2', '__value__':8.81, '__timestamp__':'2024-07-27 11:35:18', 'disk':'/opt/matrix2', 'CPU':'CPU2'},
		 { '__name__':'key5', '__value__':2.9, '__timestamp__':'2024-07-27 11:35:19', 'disk':'/opt/matrix3', 'CPU':'CPU5'},
		 { '__name__':'key48', '__value__':2.9, '__timestamp__':'2024-07-27 11:36:19', 'disk':'/opt/matrix4', 'CPU':'CPU48'},
		 
		 
		 { '__name__':'key1', '__value__':2.7, '__timestamp__':'2024-07-28 11:24:17', 'disk':'/opt/matrix5', 'CPU':'CPU1'},
		 { '__name__':'key2', '__value__':8.82, '__timestamp__':'2024-07-28 11:25:18', 'disk':'/opt/matrix6', 'CPU':'CPU2'},
		 { '__name__':'key5', '__value__':2.9, '__timestamp__':'2024-07-28 11:25:19', 'disk':'/opt/matrix7', 'CPU':'CPU5'},
		 { '__name__':'key48', '__value__':2.9, '__timestamp__':'2024-07-28 11:26:19', 'disk':'/opt/matrix8', 'CPU':'CPU48'},
		 { '__name__':'key1', '__value__':2.7, '__timestamp__':'2024-07-29 11:24:17', 'disk':'/opt/matrix9', 'CPU':'CPU1'},
		 { '__name__':'key2', '__value__':8.83, '__timestamp__':'2024-07-29 11:25:18', 'disk':'/opt/matrix10', 'CPU':'CPU2'},
		 { '__name__':'key5', '__value__':2.9, '__timestamp__':'2024-07-29 11:25:19', 'disk':'/opt/matrix11', 'CPU':'CPU5'},
		 { '__name__':'key48', '__value__':2.9, '__timestamp__':'2024-07-29 11:26:19', 'disk':'/opt/matrix12', 'CPU':'CPU48'},
		 { '__name__':'key1', '__value__':2.7, '__timestamp__':'2024-07-30 11:24:17', 'disk':'/opt/matrix12', 'CPU':'CPU1'},
		 { '__name__':'key2', '__value__':8.84, '__timestamp__':'2024-07-30 11:25:18', 'disk':'/opt/matrix13', 'CPU':'CPU2'},
		 { '__name__':'key5', '__value__':2.9, '__timestamp__':'2024-07-30 11:25:19', 'disk':'/opt/matrix13', 'CPU':'CPU5'},
		 { '__name__':'key48', '__value__':2.9, '__timestamp__':'2024-07-30 11:26:19', 'disk':'/opt/matrix13', 'CPU':'CPU48'},
		 { '__name__':'key1', '__value__':2, '__timestamp__':'2024-07-25 09:24:17', 'disk':'/opt/matrix1', 'CPU':'CPU1'},
		 { '__name__':'key2', '__value__':8.81, '__timestamp__':'2024-07-25 09:25:18', 'disk':'/opt/matrix2', 'CPU':'CPU2'},
		 { '__name__':'key5', '__value__':2.9, '__timestamp__':'2024-07-25 09:25:19', 'disk':'/opt/matrix3', 'CPU':'CPU5'},
		 { '__name__':'key48', '__value__':2.9, '__timestamp__':'2024-07-25 09:26:19', 'disk':'/opt/matrix4', 'CPU':'CPU48'},
		 { '__name__':'key1', '__value__':2, '__timestamp__':'2024-07-26 09:24:17', 'disk':'/opt/matrix1', 'CPU':'CPU1'},
		 { '__name__':'key2', '__value__':8.81, '__timestamp__':'2024-07-26 09:25:18', 'disk':'/opt/matrix2', 'CPU':'CPU2'},
		 { '__name__':'key5', '__value__':2.9, '__timestamp__':'2024-07-26 09:25:19', 'disk':'/opt/matrix3', 'CPU':'CPU5'},
		 { '__name__':'key48', '__value__':2.9, '__timestamp__':'2024-07-26 09:26:19', 'disk':'/opt/matrix4', 'CPU':'CPU48'},
		 { '__name__':'key1', '__value__':2, '__timestamp__':'2024-07-27 09:24:17', 'disk':'/opt/matrix1', 'CPU':'CPU1'},
		 { '__name__':'key2', '__value__':8.81, '__timestamp__':'2024-07-27 09:25:18', 'disk':'/opt/matrix2', 'CPU':'CPU2'},
		 { '__name__':'key5', '__value__':2.9, '__timestamp__':'2024-07-27 09:25:19', 'disk':'/opt/matrix3', 'CPU':'CPU5'},
		 { '__name__':'key48', '__value__':2.9, '__timestamp__':'2024-07-27 09:26:19', 'disk':'/opt/matrix4', 'CPU':'CPU48'},
		 { '__name__':'key1', '__value__':2.7, '__timestamp__':'2024-07-28 09:24:17', 'disk':'/opt/matrix5', 'CPU':'CPU1'},
		 { '__name__':'key2', '__value__':8.82, '__timestamp__':'2024-07-28 09:25:18', 'disk':'/opt/matrix6', 'CPU':'CPU2'},
		 { '__name__':'key5', '__value__':2.9, '__timestamp__':'2024-07-28 09:25:19', 'disk':'/opt/matrix7', 'CPU':'CPU5'},
		 { '__name__':'key48', '__value__':2.9, '__timestamp__':'2024-07-28 09:26:19', 'disk':'/opt/matrix8', 'CPU':'CPU48'},
		 { '__name__':'key1', '__value__':2.7, '__timestamp__':'2024-07-29 09:24:17', 'disk':'/opt/matrix9', 'CPU':'CPU1'},
		 { '__name__':'key2', '__value__':8.83, '__timestamp__':'2024-07-29 09:25:18', 'disk':'/opt/matrix10', 'CPU':'CPU2'},
		 { '__name__':'key5', '__value__':2.9, '__timestamp__':'2024-07-29 09:25:19', 'disk':'/opt/matrix11', 'CPU':'CPU5'},
		 { '__name__':'key48', '__value__':2.9, '__timestamp__':'2024-07-29 09:26:19', 'disk':'/opt/matrix12', 'CPU':'CPU48'},
		 { '__name__':'key1', '__value__':2.7, '__timestamp__':'2024-07-30 09:24:17', 'disk':'/opt/matrix12', 'CPU':'CPU1'},
		 { '__name__':'key2', '__value__':8.84, '__timestamp__':'2024-07-30 09:25:18', 'disk':'/opt/matrix13', 'CPU':'CPU2'},
		 { '__name__':'key5', '__value__':2.9, '__timestamp__':'2024-07-30 09:25:19', 'disk':'/opt/matrix13', 'CPU':'CPU5'},
		 { '__name__':'key48', '__value__':2.9, '__timestamp__':'2024-07-30 09:26:19', 'disk':'/opt/matrix13', 'CPU':'CPU48'}] )
;

insert into /test/bucketsplit (id, prom_split) values ('bucketsplit:wecise', 
		[{ '__name__':'key1', '__value__':2, '__timestamp__':1627702037000.12345, 'disk':'/opt/matrix1', 'CPU':'CPU1'},
		 { '__name__':'key2', '__value__':8.81, '__timestamp__':1627702098000.23333, 'disk':'/opt/matrix2', 'CPU':'CPU2'},
		 { '__name__':'key5', '__value__':2.9, '__timestamp__':1627702099000.23456, 'disk':'/opt/matrix3', 'CPU':'CPU5'},
		 { '__name__':'key48', '__value__':2.9, '__timestamp__':1627702159000.75678, 'disk':'/opt/matrix4', 'CPU':'CPU48'},
		 { '__name__':'key1', '__value__':2, '__timestamp__':1627701977000.34567, 'disk':'/opt/matrix1', 'CPU':'CPU1'},
		 { '__name__':'key2', '__value__':8.81, '__timestamp__':1627702038000.6789, 'disk':'/opt/matrix2', 'CPU':'CPU2'},
		 { '__name__':'key5', '__value__':2.9, '__timestamp__':1627702039000.21345, 'disk':'/opt/matrix3', 'CPU':'CPU5'},
		 { '__name__':'key48', '__value__':2.9, '__timestamp__':1627702099000.34567, 'disk':'/opt/matrix4', 'CPU':'CPU48'},
		 { '__name__':'key1', '__value__':2, '__timestamp__':1627701917000.34556, 'disk':'/opt/matrix1', 'CPU':'CPU1'},
		 { '__name__':'key2', '__value__':8.81, '__timestamp__':1627701978000.234, 'disk':'/opt/matrix2', 'CPU':'CPU2'},
		 { '__name__':'key5', '__value__':2.9, '__timestamp__':1627701979000.234, 'disk':'/opt/matrix3', 'CPU':'CPU5'},
		 { '__name__':'key48', '__value__':2.9, '__timestamp__':1627702039000.1, 'disk':'/opt/matrix4', 'CPU':'CPU48'},
		 { '__name__':'key1', '__value__':20, '__timestamp__':1627701857000.23423, 'disk':'/opt/matrix1', 'CPU':'CPU1'},
		 { '__name__':'key2', '__value__':88.1, '__timestamp__':1627701918000.78, 'disk':'/opt/matrix2', 'CPU':'CPU2'},
		 { '__name__':'key5', '__value__':29, '__timestamp__':1627701919000.63, 'disk':'/opt/matrix3', 'CPU':'CPU5'},
		 { '__name__':'key48', '__value__':29, '__timestamp__':1627701979000.123, 'disk':'/opt/matrix4', 'CPU':'CPU48'}	] )
;

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