mirror of
https://github.com/GreptimeTeam/greptimedb.git
synced 2026-01-07 22:02:56 +00:00
c471007edd
* refactor: refactor copy from executor * feat: support to copy from CSV and JSON format files * feat: support to copy table to the CSV and JSON format file * test: add tests copy from/to * chore: apply suggestions from CR
32 lines
1001 B
SQL
32 lines
1001 B
SQL
CREATE TABLE demo(host string, cpu double, memory double, ts TIMESTAMP time index);
|
|
|
|
insert into demo(host, cpu, memory, ts) values ('host1', 66.6, 1024, 1655276557000), ('host2', 88.8, 333.3, 1655276558000);
|
|
|
|
Copy demo TO '/tmp/demo/export/csv/demo.csv' with (format='csv');
|
|
|
|
CREATE TABLE with_filename(host string, cpu double, memory double, ts timestamp time index);
|
|
|
|
Copy with_filename FROM '/tmp/demo/export/csv/demo.csv' with (format='csv');
|
|
|
|
select * from with_filename order by ts;
|
|
|
|
CREATE TABLE with_path(host string, cpu double, memory double, ts timestamp time index);
|
|
|
|
Copy with_path FROM '/tmp/demo/export/csv/' with (format='csv');
|
|
|
|
select * from with_path order by ts;
|
|
|
|
CREATE TABLE with_pattern(host string, cpu double, memory double, ts timestamp time index);
|
|
|
|
Copy with_pattern FROM '/tmp/demo/export/csv/' WITH (pattern = 'demo.*',format='csv');
|
|
|
|
select * from with_pattern order by ts;
|
|
|
|
drop table demo;
|
|
|
|
drop table with_filename;
|
|
|
|
drop table with_path;
|
|
|
|
drop table with_pattern;
|