1 個回答
- 最新
- 最多得票
- 最多評論
0
I had this when doing a SELECT * statement (therefore it includes the measure_value column), try limiting the sql columns with a:
SELECT <column1>, <column2>
etc.. (but not including the measure_value column)
Otherwise, if you've added the column measure_value yourself to the table, this should be renamed as its a reserved column name.. https://docs.aws.amazon.com/timestream/latest/developerguide/ts-limits.html#limits.system_identifier
已回答 2 年前
相關內容
- 已提問 1 年前
- AWS 官方已更新 7 個月前
- AWS 官方已更新 2 年前
- AWS 官方已更新 7 個月前
Thanks for that. I am really confused. On this page there is a query that uses "measurement_name" and a where filter: https://aws.amazon.com/blogs/database/effective-queries-for-common-query-patterns-in-amazon-timestream/
I have two different values in "measurement_name" - "V1" and "V2". How do I only get measurements for "V2"?
Unfortunately measure_name is a reserved column name (including any column names that start with measure_name)
So if you added data to the column measure_name you'll need to rename the column (awkwardly I think you'll need to delete the table entirely and repopulate a new table with the column called something different to do this)..
The same is true for the column measure_value