mirror of
https://github.com/GreptimeTeam/greptimedb.git
synced 2026-05-18 22:10:42 +00:00
25 lines
497 B
Plaintext
25 lines
497 B
Plaintext
CREATE TABLE demo(host string, cpu double, memory double, ts TIMESTAMP time index);
|
|
|
|
Affected Rows: 0
|
|
|
|
insert into demo(host, cpu, memory, ts) values ('host1', 66.6, 1024, 1655276557000), ('host2', 88.8, 333.3, 1655276558000);
|
|
|
|
Affected Rows: 2
|
|
|
|
Copy demo TO '/tmp/export/demo.parquet';
|
|
|
|
Affected Rows: 2
|
|
|
|
Copy demo TO '/tmp/export/demo.csv' with (format='csv');
|
|
|
|
Affected Rows: 2
|
|
|
|
Copy demo TO '/tmp/export/demo.json' with (format='json');
|
|
|
|
Affected Rows: 2
|
|
|
|
drop table demo;
|
|
|
|
Affected Rows: 0
|
|
|