Influxdb select into tag 13 and I have some dummy values in my test db where id is a tag and value is a field: > SELECT * FROM dummy name: dummy ----- time id value 1468276508161069051 1234 12345 1468276539152853428 613 352 1468276543470535110 613 4899 1468276553853436191 1234 12 May 12, 2017 · I have already used select … into, but the field that I need to convert to tag is still a field. Apr 27, 2020 · 前述 网上关于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表 Dec 4, 2021 · select * into testtable2 from testtable1. By the way: the CLI is opened with /usr/bin/influx -unsafeSsl -ssl -database telegraf (if your database is named telegraf) In my case (zigbee / mqtt / telegraf) the layout of mqtt_consumer measurement was like this: > show tag keys from mqtt_consumer name: mqtt_consumer tagKey-----host topic In the InfluxDB API, specify the database in place of using the db query string parameter if desired. A query requires at least one field key in the SELECT clause to return data. Selecting tag keys in the SELECT statement. Is there another select-into query syntax that supports the tag value transform operation? This application is generally asynchronous, so even if the metadata rename feature existed, we would probably faced with the need to select-into from the original series to the new series after the rename until the rename propagated to all sources. This measurement has many points inside. Example. Basically, I have a measurement with this fields: SALA: tag sector: field … and I need that the field “sector” convert to tag for use it as a filter in templating. If the SELECT clause only includes a single tag key or several tag keys, the query returns an empty response. Common issues with the SELECT statement Selecting tag keys in the SELECT clause. --. The following query returns no data because it specifies a single tag key (location) in the SELECT clause: Jul 13, 2016 · I have started playing around with Influxdb v0. gwb vxif ouroi pam kqukqs cxinb jgqtydyn exxuxu hda pnwcotj