influxdb实现tag,field数据迁移

前述

网上关于influxdb数据库中tag和field迁移的文章比较少，虽然有，但是大部分都是有问题的，比如下面两种方式

1、select tag1,tag2,field1,field2,field3 into target from origin
2、select * into target from origin

这两种sql并没有将tag和field 区分开，而是将tag作为filed导入进target表（measurement）中。

方案

根据官方文档显示：
Relocate data
Copy data to another database, retention policy, and measurement with the INTO clause:

SELECT <field_key> INTO <different_measurement> FROM
<current_measurement> [WHERE stuff] [GROUP BY stuff>]

文档地址
迁移SQL如下：

SELECT field1,field2,field3 INTO target FROM origin group by
tag1,tag2

如果两个database实例间实现迁移，写法如下：

SELECT field1,field2,field3 INTO db2…target FROM db1…origin group by
tag1,tag2