4.insert.mql 2.1 KB

1234567891011121314151617181920212223242526
  1. insert into /test/bucketpromdb (id, prom) values (?, ?)
  2. /**
  3. params("bucketpromdb:wecise11",[{ "__name__":"key1", "__value__":2, "__timestamp__":"2024-08-27 11:24:17", "disk":"/opt/matrix", "CPU":"CPU1"}])
  4. **/
  5. ;
  6. insert into /test/bucketpromdb (id, prom) values ('bucketpromdb:wecise11',
  7. [{ '__name__':'key1', '__value__':2, '__timestamp__':'2024-07-27 11:24:17', 'disk':'/opt/matrix', 'CPU':'CPU1'},
  8. { '__name__':'key2', '__value__':8.81, '__timestamp__':'2024-07-27 11:25:18', 'disk':'/opt/matrix', 'CPU':'CPU2'},
  9. { '__name__':'key5', '__value__':2.9, '__timestamp__':'2024-07-27 11:25:19', 'disk':'/opt/matrix', 'CPU':'CPU5'},
  10. { '__name__':'key48', '__value__':2.9, '__timestamp__':'2024-07-27 11:26:19', 'disk':'/opt/matrix', 'CPU':'CPU48'},
  11. { '__name__':'key1', '__value__':2.7, '__timestamp__':'2024-07-28 11:24:17', 'disk':'/opt/matrix/test', 'CPU':'CPU1'},
  12. { '__name__':'key2', '__value__':8.82, '__timestamp__':'2024-07-28 11:25:18', 'disk':'/opt/matrix/test', 'CPU':'CPU2'},
  13. { '__name__':'key5', '__value__':2.9, '__timestamp__':'2024-07-28 11:25:19', 'disk':'/opt/matrix', 'CPU':'CPU5'},
  14. { '__name__':'key48', '__value__':2.9, '__timestamp__':'2024-07-28 11:26:19', 'disk':'/opt/matrix/test', 'CPU':'CPU48'},
  15. { '__name__':'key1', '__value__':2.7, '__timestamp__':'2024-07-29 11:24:17', 'disk':'/opt/matrix', 'CPU':'CPU1'},
  16. { '__name__':'key2', '__value__':8.83, '__timestamp__':'2024-07-29 11:25:18', 'disk':'/opt/matrix', 'CPU':'CPU2'},
  17. { '__name__':'key5', '__value__':2.9, '__timestamp__':'2024-07-29 11:25:19', 'disk':'/opt/matrix/test', 'CPU':'CPU5'},
  18. { '__name__':'key48', '__value__':2.9, '__timestamp__':'2024-07-29 11:26:19', 'disk':'/opt/matrix', 'CPU':'CPU48'},
  19. { '__name__':'key1', '__value__':2.7, '__timestamp__':'2024-07-30 11:24:17', 'disk':'/opt/matrix', 'CPU':'CPU1'},
  20. { '__name__':'key2', '__value__':8.84, '__timestamp__':'2024-07-30 11:25:18', 'disk':'/opt/matrix', 'CPU':'CPU2'},
  21. { '__name__':'key5', '__value__':2.9, '__timestamp__':'2024-07-30 11:25:19', 'disk':'/opt/matrix', 'CPU':'CPU5'},
  22. { '__name__':'key48', '__value__':2.9, '__timestamp__':'2024-07-30 11:26:19', 'disk':'/opt/matrix', 'CPU':'CPU48'}] )
  23. ;