575 questions
Score of 2
1 answer
93 views
Troubleshooting TQL Query Performance on Large Time-Series Containers
I'm hitting a bit of a wall with TQL (GridDB's query language) performance on my GridDB Cloud instance. I've got a TimeSeries container that's grown quite large (about 500 million rows of sensor data),...
- reputation score 21
Score of 1
0 answers
100 views
Optimizing batch data ingestion for high-throughput IoT in GridDB Cloud (Python/Java Native Client)
I'm wrestling with a pretty common IoT problem here, but specifically with GridDB Cloud. I've got a ton of time-series sensor data coming in – we're talking thousands of data points per second – and I ...
- reputation score 1
Score of 1
1 answer
125 views
Return the next OFF event after each ON event
I'm querying motion sensor data stored in GridDB. Each row represents a sensor state change.
Sample data:
dt
message
2021-06-30 10:00:00
ON
2021-06-30 10:00:13
OFF
2021-06-30 10:04:57
ON
2021-06-30 10:...
- reputation score 19
Score of 0
0 answers
91 views
TIME_AVG() aggregation throws TQL_UNSUPPORTED_AGGREGATION when executed on a COLLECTION container
I am trying to calculate a time-weighted average using the TIME_AVG() aggregation function in GridDB with the Python client. However, the query consistently fails with a TQL_UNSUPPORTED_AGGREGATION ...
- reputation score 6887
Score of 2
0 answers
72 views
Does GridStoreFactory.getGridStore() internally reuse connections when identical connection properties are supplied?
I'm developing a Java application that interacts with GridDB and I'm trying to better understand how the Java client manages connections.
In several places in the application, I obtain a GridStore ...
- reputation score 124
Advice
0
votes
1
replies
74
views
Is retrieving the row before calling put() the only way to update a single field in GridDB?
I'm using the GridDB Java API and have a collection where each row contains several fields. In some cases, I only need to update a single field.
Right now I'm doing this:
Device device = container.get(...
- reputation score 31
Advice
1
vote
2
replies
74
views
Is it necessary to close Query or RowSet objects in the GridDB Java API?
I'm using the GridDB Java client to execute queries like this:
Query<RowSet<Row>> query =
container.query("SELECT * FROM sensor_data");
RowSet<Row> rs = query.fetch();
...
- reputation score 31
Score of 1
0 answers
47 views
Can a RowKeyPredicate instance be safely reused across multiple GridDB Python queries?
I'm trying to reduce object creation in a high-throughput Python application by reusing a single RowKeyPredicate.
The application repeatedly performs range lookups.
predicate = griddb.RowKeyPredicate(...
- reputation score 335
Score of 1
0 answers
59 views
Why does container.put() overwrite concurrent updates to different columns in GridDB Cloud Python client?
I'm testing concurrent updates from two independent Python services.
Both services retrieve exactly the same row.
row = container.get(42)
The row initially contains
{
"id":42,
"...
- reputation score 124
Score of 3
0 answers
66 views
Composite index appears unused when executing TQL queries through the GridDB Python client
I have a Collection container containing approximately 8 million rows.
Each row contains: deviceId, timestamp, temperature, status.
To speed up time-range queries for a specific device I created a ...
- reputation score 335
Advice
0
votes
0
replies
80
views
What is the correct way to update an existing record in a GridDB Collection container?
I have a Collection container in GridDB that stores employee information.
Example:
empId Name Department
101 Alice HR
102 Bob Sales
Suppose I want to update employee 102's ...
- reputation score 1
Advice
0
votes
2
replies
89
views
Does GridDB load the entire result set into memory when query.fetch() is called?
I'm working with GridDB Community Edition and Java 17. One of my containers contains approximately 200,000 rows.
Query<RowSet<Row>> query =
container.query("SELECT * FROM ...
- reputation score 31
Advice
0
votes
1
replies
51
views
GridDB Java client throws GSException after long idle period
I'm using a single GridStore instance that is created during application startup.
GridStore store = GridStoreFactory.getInstance().getGridStore(props);
After the application remains idle for about 30–...
- reputation score 31
Score of 3
1 answer
87 views
Why does a predicate containing NULL-valued columns return different results than equivalent client-side filtering?
I'm using GridDB Cloud with the Python client (griddb_python) and found what appears to be a discrepancy between server-side filtering performed by TQL and equivalent filtering performed in Python ...
- reputation score 335
Score of 4
0 answers
71 views
Why does GridDB Python client return different Python types for the same column when using get() and query().fetch()?
I'm using GridDB Cloud with the Python client (griddb_python) and noticed that the same row appears to be deserialized differently depending on whether it is retrieved using container.get() or through ...
- reputation score 335
