influxdb如何把point中的多个field一起查出来

influxdb遇到时间点存储不了

妙音 posted @ 2021年9月23日 14:33 in influxdb , 1690 阅读
 

 问题描述

 
    有一份mysql存储的历史数据，准备把它转为influxdb存储, 时间点用的是mysql表中记录的创建时间，创建时间是时许的。
 

环境描述

 
* influxdb: 2.0.8
 
* 开发语言: go
 
* influx客户端: influxdb-client-go 2.5.0
 
 

关键代码摘要

 
    使用如下代码, 创建point，发现存储不了。
 
point := influxdb2.NewPoint("table_name",
    map[string]string{
        ...
    },
    map[string]interface{}{
        ....
    },
    ts,     //对应mysql表中记录的创建时间
    )
 

解决过程

 
    开始以为数据是几年前的, 时间太长存储不了。 后来用time.Time().Add(-xxx), 把时间移到3年前， 结果能存储
 
 

解决办法

 
    原因是influx的精度是纳秒, 存入的时间精度是秒, 在Influx中无法存储
 
    解决办法是加1纳秒, ts.Add(time.Nanosecond*1)
 
Small_feed 评论 (31)
1
[回复]
Avatar_small
sophia 说:
2023年6月20日 15:23

I really loved reading your blog. It was very well authored and easy to undertand. Unlike additional blogs I have read which are really not tht good. I also found your posts very interesting. In fact after reading, I had to go show it to my friend and he ejoyed it as well! 천안출장마사지

2
[回复]
Avatar_small
sophia 说:
2023年8月20日 18:21

A very awesome blog post. We are really grateful for your blog post. You will find a lot of approaches after visiting your post. small pistol primers in stock now

3
[回复]
Avatar_small
sophia 说:
2023年8月27日 20:24

i read a lot of stuff and i found that the way of writing to clearifing that exactly want to say was very good so i am impressed and ilike to come again in future.. Mounjaro wholesale USA

4
[回复]
Avatar_small
sophia 说:
2023年8月29日 01:05

A very awesome blog post. We are really grateful for your blog post. You will find a lot of approaches after visiting your post. เว็บแทงบอลดีที่สุดUFABET

5
[回复]
Avatar_small
sophia 说:
2023年8月31日 17:28

I admire this article for the well-researched content and excellent wording. I got so involved in this material that I couldn’t stop reading. I am impressed with your work and skill. Thank you so much. livpure

6
[回复]
Avatar_small
Johny 说:
2023年9月01日 12:25

This is just the information I am finding everywhere. Thanks for your blog, I just subscribe your blog. This is a nice blog.. last minute naar guessing

7
[回复]
Avatar_small
sophia 说:
2023年9月02日 20:53

I admire this article for the well-researched content and excellent wording. I got so involved in this material that I couldn’t stop reading. I am impressed with your work and skill. Thank you so much. https://wm6969.com/

8
[回复]
Avatar_small
Dave 说:
2023年9月06日 17:41

I felt very happy while reading this site. This was really very informative site for me. I really liked it. This was really a cordial post. Thanks a lot!. bubble game

9
[回复]
Avatar_small
Dave 说:
2023年9月16日 18:14

Thank you for this fascinating post, I am happy I observed this website on Google. Not just content, in fact, the whole site is fantastic. shaggy rug

10
[回复]
Avatar_small
seo akc 说:
2023年10月07日 03:09

Within this webpage, you'll see the page, you need to understand this data. <a href="https://www.cbdflex.com/product/30ct-cbd-gummy-bears-300mg/">Buy CBD Gummy Bears</a>

11
[回复]
Avatar_small
Dave 说:
2023年10月07日 11:07

I am jovial you take pride in what you write. It makes you stand way out from many other writers that can not push high-quality content like you. ฝัน เห็น สามเณร

12
[回复]
Avatar_small
Dave 说:
2023年10月08日 13:34

Interesting post. I Have Been wondering about this issue, so thanks for posting. Pretty cool post.It 's really very nice and Useful post.Thanks Jogo do Tigre

13
[回复]
Avatar_small
Dave 说:
2023年10月09日 20:08

Wow, cool post. I'd like to write like this too - taking time and real hard work to make a great article... but I put things off too much and never seem to get started. Thanks though. KERASSENTIALS

14
[回复]
Avatar_small
Dave 说:
2023年10月11日 20:19

Interesting post. I Have Been wondering about this issue, so thanks for posting. Pretty cool post.It 's really very nice and Useful post.Thanks CORTEXI

15
[回复]
Avatar_small
Dave 说:
2023年10月25日 18:28

Thank you very much for this great post. bitcoin recovery tool

16
[回复]
Avatar_small
wallpaper singapore 说:
2023年11月02日 01:41

Positive site, where did u come up with the information on this posting?I have read a few of the articles on your website now, and I really like your style. Thanks a million and please keep up the effective work. Sajta de Pollo

17
[回复]
Avatar_small
wallpaper singapore 说:
2023年11月03日 13:43

Pretty nice post. I just stumbled upon your weblog and wanted to say that I have really enjoyed browsing your blog posts. After all I’ll be subscribing to your feed and I hope you write again soon! wallpaper singapore

18
[回复]
Avatar_small
Dav 说:
2023年11月05日 20:37

Nice post! This is a very nice blog that I will definitively come back to more times this year! Thanks for informative post. wallpaper singapore

19
[回复]
Avatar_small
Dave 说:
2023年11月13日 18:21

The pencils are stars, and the packaging is the red carpet – glamorous! pencil packing job

20
[回复]
Avatar_small
rtpligaciputra.live 说:
2023年11月14日 02:05

RTP Ligaciputra brings an exciting blend of entertainment and gaming, creating a thrilling online experience. With its high RTP (Return to Player) rates, it adds an extra level of excitement to the gaming world. Ready to embark on an adventure where fun meets favorable odds!

21
[回复]
Avatar_small
Dave 说:
2023年11月16日 17:38

I admire this article for the well-researched content and excellent wording. I got so involved in this material that I couldn’t stop reading. I am impressed with your work and skill. Thank you so much. kuliah online kelas karyawan murah

22
[回复]
Avatar_small
Dave 说:
2023年11月16日 19:14

I admire this article for the well-researched content and excellent wording. I got so involved in this material that I couldn’t stop reading. I am impressed with your work and skill. Thank you so much. temazepam te koop

23
[回复]
Avatar_small
Dave 说:
2023年11月25日 13:47

Positive site, where did u come up with the information on this posting?I have read a few of the articles on your website now, and I really like your style. Thanks a million and please keep up the effective work. 3m film brisbane

24
[回复]
Avatar_small
Dave 说:
2023年12月22日 13:43

I have read all the comments and suggestions posted by the visitors for this article are very fine,We will wait for your next article so only.Thanks! roket288

25
[回复]
Avatar_small
jack 说:
2023年12月23日 03:33

It's superior, however , check out material at the street address. <a href="https://calculator-converter.com/inches-to-microns.htm">inches to microns</a>

26
[回复]
Avatar_small
Dave 说:
2023年12月24日 01:14

Excellent article. Very interesting to read. I really love to read such a nice article. Thanks! keep rocking. fake id kopen

27
[回复]
Avatar_small
jack 说:
2023年12月25日 03:48

I can recommend primarily decent and even responsible tips, as a result view it: <a href="https://metric-calculator.com/convert-tbsp-to-g-sugar.htm">tbsp to g sugar</a>

28
[回复]
Avatar_small
Dave 说:
2024年1月07日 01:18

I wanted to thank you for this great read!! I definitely enjoying every little bit of it I have you bookmarked to check out new stuff you post. köpa hasch online

29
[回复]
Avatar_small
Dave 说:
2024年1月21日 00:17

I visit your blog regularly and recommend it to all of those who wanted to enhance their knowledge with ease. The style of writing is excellent and also the content is top-notch. Thanks for that shrewdness you provide the readers! buy automatic instagram likes

30
[回复]
Avatar_small
Dave 说:
2024年2月09日 01:30

I wanted to thank you for this great read!! I definitely enjoying every little bit of it I have you bookmarked to check out new stuff you post. köpa hasch online

31
[回复]
Avatar_small
tech 说:
2024年11月01日 23:54

Your blog has truly captured my interest. I can see why, as you've done an excellent job of making it engaging. Your efforts are truly commendable. who can come to india visa policy


登录 *


loading captcha image...
(输入验证码)
or Ctrl+Enter