How to automically update a specific column in a TimeSeries container row without overwriting other fields?

Question

I'm using GridDB CE v5.0 with the Python client (griddb_python) to manage time-series sensor data.

My container schema is:

[
    ("timestamp", griddb.Type.TIMESTAMP),
    ("device_id", griddb.Type.STRING),
    ("temperature", griddb.Type.FLOAT),
    ("voltage", griddb.Type.FLOAT),
    ("status", griddb.Type.BOOL)
]

I want to update only the status column for a particular timestamp (i.e., primary key), without modifying other columns.

Use Case:

In my application, a background process updates only the status field (e.g., alarm triggered or not) based on new logic. However, temperature and voltage fields are written by a different process and I want to avoid overwriting those inadvertently.

What I’ve tried:

row = container.get(row_key)  # row_key = timestamp
row[4] = True  # update status
container.put(row)  # overwrite full row

This works but:

It requires pulling the full row.
I'm concerned it may race with other writes.

Question

Is there a way in GridDB Python API to perform an in-place partial update (e.g., update status only) without re-sending the entire row? I don't want to send my entire row every time.

Kanza · Accepted Answer · 2025-07-17 12:50:19Z

-1

In GridDB, TimeSeries containers do not support updating individual columns directly. To update a specific field, you must read the entire row for the given timestamp, modify the desired column, and write the full row back using put(). Partial updates are not allowed. This ensures the entire row is replaced atomically. If needed, you can use a transaction to make the read-modify-write operation safe from concurrency issues.

answered Jul 17 at 12:50

Kanza

1

Sign up to request clarification or add additional context in comments.

1 Comment

Rohit Gupta Jul 17 at 13:43

Do you have a reference for this?

Collectives™ on Stack Overflow

How to automically update a specific column in a TimeSeries container row without overwriting other fields?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest