使用 DDL/DML 将数据导入流入数据库并设置保留策略

Question

我在一个文本文件中有数据，如下所示。。。

DML
CONTEXT-DATABASE: import
CONTEXT-RETENTION-POLICY: oneyear
FO,type=FreshOrders avg_FreshOrders=1479.0840707964599,p95_FreshOrders=2589,FreshOrders=226 1593648000000
FO,type=FreshOrders avg_FreshOrders=2242.86170212766,p95_FreshOrders=5622,FreshOrders=188 1593475200000
FO,type=FreshOrders avg_FreshOrders=1682.3375,p95_FreshOrders=2738,FreshOrders=160 1593734400000

我把这个文本文件放在influxDB中一个名为data的文件夹中。我的要求是将最后3行数据导入到流入数据库中。我正在导航到influxDB文件夹C:UsersAdministratorDownloadsinfluxdb-1.8.0_windows_amd64influxdb-1.8.0-1，并在命令提示符下运行以下命令导入

influx -import -path=C:UsersAdministratorDownloadsinfluxdb-1.8.0_windows_amd64influxdb-1.8.0-1dataimport.txt -precision=ns

但数据没有被导入，并且低于错误。有人能帮我解决这个问题吗？

C:UsersAdministratorDownloadsinfluxdb-1.8.0_windows_amd64influxdb-1.8.0-1>influx -import -path=C:UsersAdministratorDownloadsinfluxdb-1.8.0_windows_amd64influxdb-1.8.0-1dataimport.txt -precision=s
2020/07/13 16:34:25 error: error parsing query: found DML, expected SELECT, DELETE, SHOW, CREATE, DROP, EXPLAIN, GRANT, REVOKE, ALTER, SET, KILL at line 1, char 1
2020/07/13 16:34:25 error: error parsing query: found CONTEXT, expected SELECT, DELETE, SHOW, CREATE, DROP, EXPLAIN, GRANT, REVOKE, ALTER, SET, KILL at line 1, char 1
2020/07/13 16:34:25 error: error parsing query: found CONTEXT, expected SELECT, DELETE, SHOW, CREATE, DROP, EXPLAIN, GRANT, REVOKE, ALTER, SET, KILL at line 1, char 1
2020/07/13 16:34:25 error: error parsing query: found FO, expected SELECT, DELETE, SHOW, CREATE, DROP, EXPLAIN, GRANT, REVOKE, ALTER, SET, KILL at line 1, char 1
2020/07/13 16:34:25 error: error parsing query: found FO, expected SELECT, DELETE, SHOW, CREATE, DROP, EXPLAIN, GRANT, REVOKE, ALTER, SET, KILL at line 1, char 1
2020/07/13 16:34:25 error: error parsing query: found FO, expected SELECT, DELETE, SHOW, CREATE, DROP, EXPLAIN, GRANT, REVOKE, ALTER, SET, KILL at line 1, char 1 

Answer 1

更改文件内容如下：

# DML
# CONTEXT-DATABASE: import
# CONTEXT-RETENTION-POLICY: oneyear
FO,type=FreshOrders avg_FreshOrders=1479.0840707964599,p95_FreshOrders=2589,FreshOrders=226 1593648000000
FO,type=FreshOrders avg_FreshOrders=2242.86170212766,p95_FreshOrders=5622,FreshOrders=188 1593475200000
FO,type=FreshOrders avg_FreshOrders=1682.3375,p95_FreshOrders=2738,FreshOrders=160 1593734400000