Questions tagged with Amazon Timestream
Content language: English
Select up to 5 tags to filter
Sort by most recent
Browse through the questions and answers listed below or filter and sort to narrow down your results.
I am recieving the following error when trying to test a lambda function to write to timestream:
```
RejectedRecords: An error occurred (RejectedRecordsException) when calling the WriteRecords...
1
answers
0
votes
2010
views
asked 2 years agolg...
I have a number of devices that are pushing their measured values to AWS TS only when the values has changed. When I pull a graph of my devices history, I want to see all the values up until NOW......
Accepted AnswerAmazon Timestream
2
answers
0
votes
267
views
asked 2 years agolg...
I have IoT things sending timestamps in GMT to a TimeStream table. This means that the data is corrected to GMT no matter where the data was collected. Are there time zone shift functions that I am...
1
answers
0
votes
1270
views
asked 2 years agolg...
I have generated a timestream database and table, but am struggling to write data to the table.
The data comes from an mqtt topic, and can be seen in the cloudwatch log, so I know my select statement...
1
answers
0
votes
942
views
asked 2 years agolg...
I have a Timestream table used for testing in a development environment. The table is set to 1 hour memory store retention-- the minimum-- and 30 days of magnetic store retention. I also have magnetic...
2
answers
0
votes
1074
views
asked 2 years agolg...
Hi aws re:Post!
I used the AWS Timestream Web App Query Editor while developing my CDK IaC to test certain queries - specifically, I run the following and receive 1000 rows in response:
```
SELECT...
1
answers
0
votes
439
views
asked 2 years agolg...
I am looking for an option to have aggregation over timeseries to be performed only for weekdays, like Monday, Tuesday and etc. I tried DAYNAME function but it doesn't seem to exist. Is there an...
Accepted AnswerAmazon Timestream
1
answers
0
votes
288
views
asked 2 years agolg...
I have a cron job that exports a list of number of messages per user frequencies such as:
* 10 * 1
* 5 * 2
* 8 * 3
(Which means: 8 users have posted 3 messages)
I'd like to have a histogram chart...
0
answers
0
votes
74
views
asked 2 years agolg...
Is there a way to convert Interval type to total seconds, minutes, etc? I would like to be able to ouput the difference in seconds between two Timestamps
For instance (note I am just denoting the...
2
answers
0
votes
1828
views
asked 2 years agolg...
I have an AWS TimeStream table defined as follows:
* user_id (varchar)
* measure_name (varchar)
* time (timestamp)
* measure_value::boolean (boolean)
(`measure_name` being an event name)
When I...
0
answers
0
votes
86
views
asked 2 years agolg...
Query to get everything since midnight of most recent Sunday or everything after midnight todaylg...
Using Timestream with Grafana. I want a graph to display the count of records a machine has cycled (one record per cycle) on a daily basis. Displaying this data in last 24 hours is confusing because...
1
answers
0
votes
937
views
asked 2 years agolg...
Hello, I wrote a python code that pushes cryptocurrency prices into AWS TimeStream. It was working fine until 20 seconds later where i am getting an error:
'dimension name and value exceeds the...
0
answers
0
votes
133
views
asked 2 years agolg...