doupaimo8288
doupaimo8288
2016-08-09 11:55

使用相同的时间戳将不同的测量点写入InfluxDB

Is it possible to write more than one point with the same timestamp into one measurement using InfluxDB. Problem is that i am saving data from loggers that have one timestamp and a measurements from many inverters for that timestamp and of course the points are getting owerwritten. How can i fix the problem?

The data is like:

time: 2016-08-09 12:10:08 inverter: 1 ...other fields

time: 2016-08-09 12:10:08 inverter: 2 ...other fields

time: 2016-08-09 12:10:08 inverter: 3 ...other fields

etc...

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 复制链接分享
  • 邀请回答

1条回答

  • drhe80011 drhe80011 5年前

    No, you can't have two entries with the same timestamp for the same measurement.

    From the InfluxDB documentation:

    Conceptually you can think of a measurement as an SQL table, where the primary index is always time. tags and fields are effectively columns in the table. tags are indexed, and fields are not.

    You can however use Influx's high timestamp precision. Your datetime's precision seems to be only seconds. Influx's timestamps are distinguished by nanoseconds. So you might use information such as the inverter index and "encode" it into the nanoseconds. This way, no two entries will collide on the same timestamp.

    点赞 评论 复制链接分享