Stack Overflow
Stack Overflow

Questions tagged [amazon-timestream]

Use this tag for questions about Amazon Timestream, a fully managed time series database service.

153 questions
3
votes
0 answers

Is there a way to get the record's version in Timestream?

In order to upsert records in timestream, the version number of the new record should be higher than that of the existing record. But I have not been able to find a way to get the existing record's version. Version is not returned in the AWS…
ninsonTan
  • 361
  • 1
  • 2
  • 17
2
votes
0 answers

AWS Timestream: Data lost when writing large amount of data to magnetic store

I was attempting to ingest around 100,000 records into a newly created Timestream table through Lambda function. All the records have the same timestamp and the timestamp is beyond the retention period of memory store so they were all written to…
Yuntian
  • 21
  • 1
2
votes
1 answer

How to optimize AWS Timestream database or query?

I created a sample AWS Timestream database with one table: Initially this had 400 sample rows, and the following query took ~0.3 seconds on average from the Timestream Console: SELECT make, COUNT(*) AS makeCount FROM …
Chad Johnson
  • 21,215
  • 34
  • 109
  • 207
2
votes
2 answers

Cannot write to AWS Timestream table and dealing with ActiveMagneticStorePartitions caused throttling

I was importing some old data to the Timestream table successfully for a while but then it started to give the error: Timestream error: com.amazonaws.services.timestreamwrite.model.ThrottlingException: Your magnetic store writes to Timestream are…
mico
  • 709
  • 5
  • 18
2
votes
0 answers

How to get a nested JSON object (array) in AWS IoT-Core and send it to AWS timestream as a string?

I have the following payload (JSON) in my MQTT broker AWS IoT-Core / Topic (+/+/myTopic): { "id":"sig3678", "r_timestmp":1659443813, "sku":61, "z_x_1":{ "a_b":[ 234, 245, ...], "c_d":[ 435, -45, ...] }, "z_x_2":{ "a_b":[…
IgorAlves
  • 5,086
  • 10
  • 52
  • 83
2
votes
1 answer

AWS timestream : Name already exists in dimension for the given multi measure name, or name exists in multi measures for the given dimension name

I am developing an IOT application that is writing to AWS Timestream quite frequently. It is trying to insert the records with different times but still, I am getting the same error. Each record row looks as follows record = { 'Dimensions':…
Haseeb Asif
  • 1,766
  • 2
  • 23
  • 41
2
votes
1 answer

Insert into AWS Timestream using API

I'm currently working on a project where I am required to write sensor data to AWS Timestream. I could use AWS IoT Core (MQTT) and inject that into Timestream, however, would prefer making a direct insert into Timestream. I also can't use the…
Eckaard
  • 53
  • 8
2
votes
0 answers

Query AWS Timestream with Spring Data JPA

I'm using Spring Boot as backend framework and I would like to store and query some time series data into the AWS Timestream DB service. I see that AWS suggests to use the AWS Java SDK, but is there a way to use Spring Data JPA, which I tipically…
gperego
  • 121
  • 4
2
votes
1 answer

Storing geospatial data in AWS TimeStream

I am trying to store GPS coordinates of devices for which I receive multiple updates every minute. I decided to use AWS TimeStream since all of the data that I am collecting are time series, but now when I am trying to query information that is in a…
TSpark
  • 189
  • 1
  • 14
2
votes
0 answers

Executing queries from Intellij Ultimate DB plugin to AWS Timestream service

I am trying to use Intellij Idea to query AWS timestream however I am having some problems with it. when I execute the query in AWS console it works just fine, executing the same query in Intellij Idea return an error: Error executing query with id…
Adelin
  • 18,144
  • 26
  • 115
  • 175
2
votes
1 answer

Writing data to timestreamDb from AWS Glue

I'm trying to use glue streaming and write data to AWS TimestreamDB but I'm having a hard time in configuring the JDBC connection. Steps I’m following are below and the documentation link:…
Suraj Haradagatti
  • 49
  • 4
2
votes
1 answer

How do I query the total time an IoT device is active?

I'm new to SQL and AWS Timestream and I want to write a query which will give me the total time that a device is active. I then want to translate that into energy usage based on the kWh rating of the device. The time intervals for data points are…
Duncan Drennan
  • 871
  • 2
  • 9
  • 21
2
votes
1 answer

AWS Timestream DB - storing null values - Python

Just wondering if anyone has worked out how to store null values in a timestream database: I have the following code: dimensions = [ {'Name': 'gatewayId', 'Value': gatewayId} …
dx4100
  • 21
  • 4
2
votes
1 answer

In AWS IoT Core rule action or AWS Timestream database table how can we specify/configure measures?

Following is the data in my message. { "time_epoch": 1604489437, "temperature": 100, "device_id": "TempSensor1" } I have an IoT core rule that takes this msg and has an action to send it to the Timestream db table. In the IoT core rule - I…
variable
  • 8,262
  • 9
  • 95
  • 215
2
votes
3 answers

TimeStream + Grafana: not recognizing series in data

Jumping on AWS Timestream, I've some trouble with the grafana integration: I've build a query that returns a count of events grouped by day and "thing" - and would like to show that in a graph. Doesn't even matter which one. In a table, the data is…
Blitz
  • 5,521
  • 3
  • 35
  • 53
1
2
3
…
10 11