在InfluxDB中将TAG转换为FIELD [英] Convert TAG to FIELD in InfluxDB

问题描述

是否可以将标签(字符串)转换为包含标签值转换版本的字段(如double)?像QL更新表达式一样?

解决方案

一个人可以使用influx_inspect export将数据库转储到 解决方案

One could use influx_inspect export to dump the database in the line protocol format. Then relevant columns could be grepped and modified with your favorite tool, like python or sed/bash. And the modified time series could be re-inserted directly into the database (one could use split -l 7000 to split field time series into chunks and the use curl -POST .../write?db=... --data-binary @chunk and iterate over those chunks expecting HTTP 204 for correctly inserted values).

这篇关于在InfluxDB中将TAG转换为FIELD的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！