TDengine直方图的sql
select HISTOGRAM(fieldName, 'linear_bin', '{"start": 100.000000, "width": 100.000000, "count": 10, "infinity": true}', 0) countStr FROM tableName
infinity true ,false 代码是否含首尾
返回数据格式为:
{"lower_bin":-inf, "upper_bin":100, "count":70070}
从数据库取出doble类型的数据,发现丢失精度可以用cast转为字符串
SELECT ts , cast(field1 as NCHAR(100)) as field1 FROM tableName WHERE