Write Data

Insert data

Of course, you can insert data by sql API too:

python

  1. from greptime import query
  2. @copr(returns=["affected_rows"])
  3. def insert() -> vector[i32]:
  4. return query().sql("insert into monitor(host, ts, cpu, memory) values('localhost',1667446807000, 15.3, 66.6)")

json

  1. {
  2. "code": 0,
  3. "output": [
  4. {
  5. "records": {
  6. "schema": {
  7. "column_schemas": [
  8. {
  9. "name": "rows",
  10. "data_type": "Int32"
  11. }
  12. ]
  13. },
  14. "rows": [
  15. [
  16. 1
  17. ]
  18. ]
  19. }
  20. }
  21. ],
  22. "execution_time_ms": 4
  23. }