1 Answer
- Newest
- Most votes
- Most comments
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
answered 2 years ago
Relevant content
- asked a year ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 3 months ago
- AWS OFFICIALUpdated 4 months ago
- AWS OFFICIALUpdated a year ago
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