Skip to content

查询返回结果中小数点后面的值被自动截取了 #3630

Closed

Description

@juice411

如图:
cfa3c8ac224601cded0592a4d2f20bc
last 查询结果为:2805.56055
select 查询结果为:2805.56
后面的数字被截取了

Activity

  1. HTHou commented on Jul 27, 2021

    @HTHou
    Contributor

    show timeseries看看序列的详细信息?

  2. juice411 commented on Jul 27, 2021

    @juice411
    Author
  3. juice411 commented on Jul 27, 2021

    @juice411
    Author

    image

  4. HTHou commented on Jul 27, 2021

    @HTHou
    Contributor

    这是因为使用了 RLE编码方式对于浮点数是有损编码导致的,如果需要保证精度,对于浮点数可以使用 gorilla 编码。

  5. juice411 commented on Jul 27, 2021

    @juice411
    Author

    如何对线上系统做修改?修改完后影响已归档数据吗

  6. qiaojialin commented on Jul 27, 2021

    @qiaojialin
    Member

    改 iotdb-engine.properties 里的这个参数:
    float_precision=6
    反注释重启生效。不影响已归档数据,只影响新写的数据。

  7. juice411 commented on Jul 27, 2021

    @juice411
    Author

    这个方案可以,多谢!

  8. locked and limited conversation to collaborators on Aug 24, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions