Timestream weird behavior with measure name

0

Hello: I'm having a weird behavior in Timestream where my data has a measure name "Latitude" which normally has decimal values like 121.451253 but it was stored as bigint truncating the decimal part. I also tried to send the measure as string in which case it was just ignored (not stored). I noticed that changing the name of the measure or just using lowercase like "latitude", everything is fine... Is there any issue using some specific words? I checked there is no reserved word with that name... Thanks

  • I also noticed that once it stores a measure with some specific type (String, BigInt, etc), it won't accept same measures in different types...Is this correct?

已提問 3 年前檢視次數 640 次
1 個回答
0

Hi, the Latitude is not a special keyword. So no issues using Latitude.

  • Measure names in Timestream are case sensitive. So Latitude and latitude will be two different measure names.
  • Timestream offers flexible and incremental schema definition. This means you do not need to define schema upfront while creating a table. However, we do assign the type to a particular column (Latitude in this case) first time system ingests a measure name. if you first ingested Latitude with Big Int, it is not possible to change it to double. The system will treat Latitude as BIG INT.
  • You can check the schema of your table (Types for each column in table) in the query editor mode of the console

Hope this helps.

AWS
已回答 3 年前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南