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. }