Browse through the questions and answers listed below or filter and sort to narrow down your results.
Timestream DAYNAME alternative to limit aggregation to weekdays
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 alternative to that function or any other way to achieve what I am after?
Would be also interesting to find out how to get aggregation limited from 06:00 to 16:00 every day for example, but this might be a separate question.
Accepted AnswerAmazon Timestream
1
answers
0
votes
2
views
asked 18 days ago
What happens when you give TimeStream a timestamp in the future?
I am testing some calculations in DraftSight that come from TimeStream. I an using an IOT thing to send a timestamp to AWS, a rule to insert the packet into TimeStream. When I send a timestamp in the past it seems to show up in TimeStream. When I send a timestamp from in the future it seems to not show up. I am not sure though if it is latency or if timestream is rejecting the entry because the timestamp is in the future.
Does TimeStream reject timestamps from the future?
Accepted AnswerAmazon Timestream
1
answers
0
votes
12
views
asked 2 months ago
1
answers
0
votes
11
views
asked 2 months ago
Adding columns to Timestream table in the AWS web query editor
First...is it possible?
I am trying to add a column to a table called "MedFlaminator". I just created the table and it has the default layout. Two columns exist:
> measure_name varchar MEASURE_NAME
> time timestamp TIMESTAMP
My query looks like this:
> alter table MedFlaminator
add column feedback_score int
I have tried all kinds of combinations of this query. I am getting the following error:
> 10:58:16 AM Failed The query syntax is invalid at line 1:1
alter table MedFlaminator add column feedback_score int
What is wrong here?
Accepted AnswerAmazon Timestream
1
answers
0
votes
12
views
asked 2 months ago
Formatting time as a unix timestamp
We are able to enter records into tables using any time unit. But when querying the table, I can only seem to be able to return it as what I can assume is the ISO format. IE: 2021-03-18 04:00:00.055000000
Is there any way to get a query result with a unix like timestamp instead?
Accepted AnswerAmazon Timestream
2
answers
0
votes
8
views
asked a year ago
Unable to use ANY(), ALL(), SOME()
Has anyone seen an error like:
Problems with function : ANY. Either the function does not exist, or there is a problem with a dependent function
SELECT * FROM "mytable"."temperature" WHERE device_name <> ANY('Foo', 'Bar')
Edited by: dwery on Nov 22, 2020 9:50 AM
Accepted AnswerAmazon Timestream
2
answers
0
votes
1
views
asked a year ago
Timestream In-Memory Storage
Hello,
We are planning to integrate our IoT data in lambda and then insert it into the timestream. But the problem is that Timestream has an in-memory database option and we are just afraid of it that what if something goes down, like a maintenance shutdown. Will we lose our data? or does AWS make multiple copies of the data stored in memory or something like that?
Accepted AnswerAmazon Timestream
1
answers
0
votes
6
views
asked 2 years ago