559 questions
0
votes
0
answers
37
views
NOT BETWEEN Returns Unexpected Rows Including NULL Values
I'm seeing unexpected behavior when using NOT BETWEEN in a GridDB SQL query. Two logically equivalent filters produce different results, specifically regarding rows where the column value is NULL.
...
- 6,841
1
vote
1
answer
29
views
TimeSeries rejects high-precision TIMESTAMP as primary key
I'm trying to create a TimeSeries container in GridDB with microsecond precision for my timestamp column, but I'm getting schema validation errors.
Problem
When I define a TIMESTAMP with fractional ...
- 362
1
vote
0
answers
49
views
Why are rows returned as stale when fetching TimeSeries data with multiple sequential queries on the same RowSet?
I’m using GridDB Cloud with the Python client (griddb_python) and found a reproducible issue where executing multiple sequential queries on a TimeSeries container causes the second query to return ...
- 66
0
votes
0
answers
108
views
GridDB SQL error while using GROUP BY RANGE
I am getting error using GROUP BY RANGE in GridDB sql. I am referring to the example mention in the doc https://griddb.org/docs-en/manuals/GridDB_SQL_Reference.html#group-by-range
name: trend_data1
ts
...
- 73
1
vote
0
answers
27
views
TimeSeries aggregation query returns wrong result when executed inside explicit transaction?
I’m using GridDB Cloud with the Python client (griddb_python) and have found an issue where executing a TimeSeries aggregation query inside an explicit transaction gives inconsistent or incorrect ...
- 57
2
votes
1
answer
84
views
GridDB Cloud Python client: How to handle connection timeout and auto-reconnect?
I’m using GridDB Cloud with the official Python client to insert real-time IoT data into a time-series container.
The script runs continuously, but after a few hours I get a connection timeout and ...
- 67
2
votes
1
answer
117
views
How to improve query performance on large time-series container in GridDB Cloud?
I’m using GridDB Cloud (Free Tier) with Python to store time-series IoT data.
My container currently has around 10 million rows, and it continues to grow daily.
Schema:
device_id STRING,
created_at ...
- 67
0
votes
0
answers
39
views
GSException when inserting rows into a TimeSeries container
I'm using GridDB and trying to insert data into a TimeSeries container. This throws a GSException when I try to put the row. Why does this exception occur, and what is the correct way to insert rows ...
- 6,841
1
vote
0
answers
123
views
How do I disable autocommit and make a batch of put operations atomic?
I’m using GridDB Cloud (Free) with the Python client, and I need to write a batch of rows to a TimeSeries container atomically (all-or-nothing). I'm having trouble figuring out how to turn autocommit ...
- 907
0
votes
0
answers
20
views
WebAPI Returns "Container not existed" Error for Partitioned Containers Despite Container Existence
The GridDB WebAPI fails to interact with partitioned containers, returning a "Container not existed" error even though the container exists and is accessible via gs_sh.
Environment:
OS: ...
- 6,841
0
votes
0
answers
33
views
Are multi-put/batched put() operations atomic across replicas, or can partial replication occur per partition?
I run a 3-node GridDB cluster (replication factor = 2). I insert time-series rows from multiple threads using the Python client, using a TIMESTAMP column as the row-key (client generates timestamps). ...
0
votes
0
answers
28
views
Latest Row ≤ a target timestamp per deviceid (single statement) [duplicate]
I’m on GridDB Cloud (Free). For a TimeSeries container I need, for a given :target_ts, the latest row at or before that timestamp per deviceid in one SQL statement.
Schema & Seed Data:
CREATE ...
- 907
0
votes
1
answer
77
views
Get hierarchical structure from a single table
Expected result is somewhat hierarchical structure from a single table in griddb cloud as shown in below table, where every row contains hourly data in a way that there is only one device entry per ...
- 94
4
votes
0
answers
116
views
Unable to connect to GridDB Cloud using Python requests (Web API)
I’m trying to connect to GridDB Cloud from Python using the Web API to create a container (table), insert a row, and query it. However every request returns a 403 Forbidden error.
In my Python script ...
- 7
0
votes
0
answers
72
views
Composite key (ts, deviceid) with timeseries container
I’m on GridDB Cloud (Free). For a TimeSeries container, I want each device to have at most one row per timestamp, i.e., enforce uniqueness on (ts, deviceid).
Schema:
CREATE TABLE TSDB (
ts TIMESTAMP ...
- 907
0
votes
2
answers
92
views
Correct syntax for selecting data between NOW() and the previous hour
Considering that GridDB does not provide an INTERVAL keyword and will result in a syntax error, what is the correct syntax for selecting data between NOW() and the previous hour in GridDB/GridDB Cloud?...
- 94
1
vote
0
answers
168
views
Get hourly timestamped data using a string identifier
In the scenario where sensor data is attached to a specific string identifier in GridDb/GridDb Cloud, the SQL query should return hourly sensor data only matching with a certain combination of letters....
- 94
3
votes
0
answers
77
views
GridDB Cloud client failing with "Failed to import 'org.apache'" using JPype
I’m working on a demo project to simulate an IoT device using Python and GridDB.
I’m trying to connect to GridDB Cloud from a Windows environment.
I keep running into the following error:
Failed to ...
- 7
1
vote
1
answer
87
views
How to use FIXED_LIST instead of MULTICAST in griddb using jdbc driver
The GridDB server has been configured to use FIXED_LIST instead of MULTICAST and is functioning correctly. While the c_client and Java samples within GridDB operate as intended, the samples for JDBC ...
- 94
1
vote
1
answer
103
views
Efficiently query the latest row per device in a time-series container
I’m working with GridDB Cloud (Free Tier) using the Python client (latest version on Ubuntu 22.04).
I have a container called sensor_data with this schema:
device_id STRING,
created_at TIMESTAMP,
...
- 67
2
votes
1
answer
89
views
Create a composite row key in GridDB using NewSQL
How to create a composite row key in GridDB using NewSQL?
I am creating a collection container for storing thermostat data for multiple devices. I want to have the composite key on device_id and ...
- 73
0
votes
1
answer
46
views
GridDB Python client inserting datetime object into TIMESTAMP column
I’m using GridDB Cloud (Free Tier) with the official Python client (latest pip release) on Ubuntu 22.04.
My container schema looks like this:
device_id STRING,
created_at TIMESTAMP,
temperature DOUBLE
...
- 67
4
votes
1
answer
153
views
"Top-1 Per Group”: Get the latest row per deviceid in a time range
I'm using GridDB TimeSeries and need, for a given time range, the latest row per deviceid (i.e., top-1 by timestamp within each device), returned in one query.
Expected output (example for two devices ...
- 907
3
votes
0
answers
92
views
Time-Series Pagination: LIMIT/OFFSET vs keyset (seek by last timestamp) to avoid duplicates/skips while new rows arrive?
I’m paging through a large time range in a GridDB TimeSeries container and need a pattern that won’t duplicate or skip rows if new data arrives while I’m paging.
Schema (TimeSeries):
ts (TIMESTAMP, ...
- 907
4
votes
0
answers
138
views
Hourly true average between timestamps [closed]
I’m storing IoT readings in a GridDB container and need one row per hour with the true average of the points that actually fall inside each hour (not interpolated values):
ts_bucket ...
- 907
0
votes
0
answers
40
views
Time-series container shows unexpected “Row key conflict” during parallel batch inserts with TTL enabled
I’m testing high-throughput ingestion of smart-grid power-meter readings into a GridDB time-series container with a TTL (time-to-live) setting.
Multiple workers insert rows for the same meter in near-...
3
votes
1
answer
99
views
How to group by day in GridDB Cloud without manually concatenating year, month, and day?
Table schema:
CREATE TABLE WeatherReadings
(
ts TIMESTAMP,
temp DOUBLE
);
Sample data:
INSERT INTO WeatherReadings (ts, temp)
VALUES
(TIMESTAMP('2025-08-22T01:05:00Z'), 20.5),
(TIMESTAMP('...
- 33
1
vote
0
answers
55
views
How to efficiently query nested JSON fields in GridDB using TQL?
I’m experimenting with GridDB CE for a project where sensor data is stored as JSON objects inside a BLOB column. For example, I have a container defined as:
ContainerInfo containerInfo = new ...
2
votes
0
answers
126
views
Why do I get NULL values when fetching rows?
I’m testing GridDB Cloud with the C client. I insert a couple of rows into a container, but when I query them back, the row values sometimes come out as NULL (empty), even though I just inserted data.
...
- 21
1
vote
1
answer
142
views
Pattern matching in GridDB using NewSQL
I am looking for pattern matching in GridDB using NewSQL to return values true when matched and false when not matched.
The string can start with
91 followed 33 followed by 8 digit number followed by ...
- 73
1
vote
0
answers
37
views
GridDB Custom Partitioning in Node.js
Can I Define a Custom Partition Key for GridDB Containers Using Node.js?
I want to distribute data across GridDB nodes based on a custom column (e.g., region_id) instead of relying on automatic ...
0
votes
0
answers
67
views
Getting "Container not found" error when trying to modify GridDB container column definitions at runtime
I need to add columns to an existing GridDB container in my Python application, but getting a "Container not found" error when trying to modify the ColumnInfo after container creation.
...
-2
votes
1
answer
66
views
Window function issue when more than one window function consecutively used in query [closed]
I created a collection named ‘orders’ with the below DDL using NewSQL Interface:
CREATE TABLE orders
(
orderId STRING PRIMARY KEY,
customerId STRING,
orderDate TIMESTAMP,
totalAmount ...
- 73
0
votes
0
answers
31
views
How to programmatically handle container partition redistribution in GridDB cluster after node failure?
Question
GridDB Container Partition Recovery After Node Failure
I'm working with a 3-node GridDB cluster and need to implement automatic recovery logic when one node fails. My application creates ...
2
votes
2
answers
138
views
How to perform hourly aggregation in time-series table?
I am using GridDB Cloud for time-series analysis and need to calculate hourly average temperature readings from a table containing sensor data. I want to group my readings into 1-hour intervals and ...
3
votes
2
answers
112
views
How to cast a timestamp to date in format YYYY-MM-DD in griddb
I created a collection container name ‘orders’ with the below DDL using NewSQL Interface:
CREATE TABLE orders
(
orderId STRING PRIMARY KEY,
customerId STRING,
orderDate TIMESTAMP,
...
- 73
0
votes
1
answer
70
views
Issue with lower SQL function in GridDB
I'm using the SQL statement below to convert the first character of a string column stored in a GridDB collection container to lowercase. I'm using the lower function. However, when the first letter ...
- 101
1
vote
1
answer
99
views
How to query a JSON column by a nested key?
I’m using GridDB 5.3 with the Java client to store IoT sensor readings.
Each reading is stored in a collection, and one of the columns contains a JSON payload as a string.
Here’s a minimal Java ...
0
votes
1
answer
52
views
Check referential integrity between two GridDB containers
I have two GridDB Cloud containers participating in a one-to-many relationship. The tables layout is shown below:
Table Customer (collection container)
Name
Type
Nullity
Key
Customer_ID
INTEGER
NOT ...
- 101
2
votes
1
answer
47
views
How to automically update a specific column in a TimeSeries container row without overwriting other fields?
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&...
- 66
2
votes
0
answers
27
views
How to perform time-bounded range queries on a TimeSeries container?
I'm using GridDB CE v5.0 and the Python client (griddb_python) to store sensor data in a TimeSeries container with this schema:
[
('timestamp', griddb.Type.TIMESTAMP),
('temperature', griddb....
- 66
1
vote
0
answers
32
views
How to implement efficient secondary index filtering on non-key columns in TimeSeries containers?
I'm using GridDB CE v5.0 with the Java client for a time-series IoT data application. Each TimeSeries container logs data like this:
class Telemetry {
Timestamp timestamp;
String deviceId;
...
- 57
2
votes
1
answer
50
views
How to perform time-windowed aggregation on multi-device sensor data in a single TimeSeries container?
I’m using GridDB CE 5.0 with the Java client to store high-frequency time-series data from multiple IoT devices. All sensor readings are stored in a single TimeSeries container, with each row ...
- 57
2
votes
1
answer
63
views
Installing Griddb python client strange error
I'm trying to install the Griddb python client. I cloned the github repo: https://github.com/griddb/python_client.git, and installed maven dependencies successfully with mvn install.
Then when I went ...
- 23
0
votes
0
answers
41
views
How to fix the GridDB WebAPI: Error inserting rows “Mapping JSON data error at field 'rows' “?
I am developing a smart energy monitoring application using node.js and gridDB Cloud WebAPI.I am trying to insert data into container called energy_data,but I consistently receive the following error:
...
0
votes
0
answers
41
views
How can I fix a 403 Forbidden(Microsoft-Azure-Application-Gateway) error when using Python to migrate Chado database into GridDB Cloud via REST API?
I am building a Python application to migrate data from Chado PostgresSQL database into GridDB Cloud,using GridDB's REST API(WebAPI).When i run my application ,the API responds with 403 Forbidden ...
0
votes
0
answers
38
views
Handling deeply nested JSON structures and queries
I am using GridDB Community Edition (v5.x) with the RESTful Web API. My data comes as complex JSON documents with multiple levels of nesting (objects within objects, arrays of objects, etc.). For ...
0
votes
0
answers
22
views
How to Resolve EE_STACK_MEMORY_LIMIT_EXCEEDED Error in GridDB When Processing Service Events?
I am working with GridDB and encountering the following error when processing service events:
EE_STACK_MEMORY_LIMIT_EXCEEDED: Processing of service event failed. Memory may have exceeded the limit ...
0
votes
0
answers
29
views
JDBC_UNSUPPORTED_PARAMETER_VALUE Error with Custom Object in Parameterized Query
I am working on a Java application using GridDB's Java API (version 5.6.0) and encountered a JDBC_UNSUPPORTED_PARAMETER_VALUE error with the message: "Checking of client request failed. Operation ...
1
vote
0
answers
34
views
How to fix GridDB WebAPI SQL endpoint error "Cannot deserialize instance of java.util.ArrayList out of START_OBJECT token" for SELECT COUNT(*) query?
I am developing a Node.js/Express.js application using GridDB Cloud’s WebAPI v2.When i run SELECT queries,the API reponds with a deserialization error instead of returning the single count value and ...