1 réponse
- Le plus récent
- Le plus de votes
- La plupart des commentaires
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
répondu il y a 2 ans
Contenus pertinents
- demandé il y a un an
- demandé il y a un an
- demandé il y a un an
- demandé il y a un an
- AWS OFFICIELA mis à jour il y a 2 ans
- AWS OFFICIELA mis à jour il y a 3 ans
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