- 최신
- 최다 투표
- 가장 많은 댓글
As it turns out, it's a bit more complicated than that. I contact AWS Support, and after a few exchanges, they confirmed there is a problem with IoT Core converting doubles, but the work around is to set the database query to use the cast operator with the 2015-10-08
SQL version. The newer version does not correctly support the cast, and will not work.
So, the Rule ended up being:
SELECT cast(temperature as double) as temperature, cast(humidity as double) as humidity, cast(rain as double) as rain, cast(groundtemperature as double) as groundtemperature, groundmoisture FROM 'tms/weather/#'
Using SQL version 2015-10-08
Once I did that, data was received and injected to Timestream correctly.
Mark
Similar topic - https://forums.aws.amazon.com/thread.jspa?messageID=965764버
Try casting the values to double in the IoT rule.
Edited by: rschultz on Mar 2, 2021 7:40 AM
관련 콘텐츠
- AWS 공식업데이트됨 일 년 전
- AWS 공식업데이트됨 2년 전
- AWS 공식업데이트됨 일 년 전
- AWS 공식업데이트됨 3년 전