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年前
関連するコンテンツ
- AWS公式更新しました 2年前
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