Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [griddb]

For questions about GridDB, an open source time series database optimized for IoT and Big Data.

GridDB is a highly scalable time series database best suited for Big Data and IoT. It is designed to handle time-sensitive IoT data across numerous sensors while maintaining consistency and durability.

GridDB Community Edition database server and client libraries are open-sourced under the AGPL v3.0 and Apache license respectively.

Useful Links

26 questions
2
votes
0 answers

How Can I Optimize Partitioning and Replication Settings in GridDB for High-Volume Time-Series IoT Workloads?

I am designing an IoT application that ingests high volumes of time-series data in real time. I am evaluating GridDB as the backend due to its in-memory capabilities, hybrid storage model, and ACID compliance for container-level transactions. In…
Farwa Waheed
  • 21
  • 2
2
votes
3 answers

When I combine the NOT and BETWEEN operators, the query unexpectedly retrieves additional null values

Query 1 and Query 2 share the same semantics, both involving the combination of the NOT and BETWEEN operators, with the evaluation of the BETWEEN expression being FALSE in both cases. However, Query 1 unexpectedly retrieves more null values than…
Alice
  • 163
  • 2
2
votes
0 answers

EXPLAIN SQL does not use the index in GridDB

I have created an index, but explain sql does not use the index. I have ensured that GridDB has up-to-date statistics by running the available commands and index on (DeviceId, Property) is in the correct order. griddb 5.1.0 gs[public]> explain…
Arqish Mithani
  • 49
  • 3
2
votes
1 answer

Potential issue with aggregation result (std deviation and variance)

I am running a query against the following dataset: https://www.kaggle.com/datasets/census/population-time-series-data. Here is the code: year_in_mili = 31536000000 ts = store.get_container("population") query = ts.query("select * from population…
Nooruddin Lakhani
  • 149
  • 5
2
votes
0 answers

Error: Library not loaded "/lib/libgridstore.0.dylib" in GridDB

I’m getting import error cannot load library /usr/local/lib/libgridstore.0.dylib Environment: macOS Big Sur v11.6.5 python version: 3.10.0b4 Steps to produce the issue: #Created virtual env via pyenv pyenv virtualenv 3.10.0b4 onDemand #Could not…
Arqish Mithani
  • 49
  • 3
1
vote
0 answers

GridDB How to properly delete a database with containers?

I'm working with GridDB CE in a Java application and trying to programmatically delete a database. However, I'm encountering that error. 145045 JC_DATABASE_NOT_EMPTY ERROR Checking of client request failed. Number of DB containers may not be zero.…
omar esawy
  • 11
  • 1
1
vote
0 answers

Fail to be Cross Compiled in GridDB

I am trying to cross-compile GridDB. The configuration command I used is: ./configure --target=arm-buildroot-linux-gnueabihf --host=arm-buildroot-linux-gnueabihf --build=x86_64-pc-linux-gnu --prefix=/usr --exec-prefix=/usr --sysconfdir=/etc…
Shams
  • 111
  • 2
1
vote
0 answers

Unable to query after a successful connection for a period of time in GridDB

I’m experiencing an issue with GridDB where the program becomes blocked during a query and logs a Sending heartbeat It seems that the issue is related to the connection management or the GridDB cluster's responsiveness Following are the logs select…
Alice
  • 163
  • 2
1
vote
1 answer

GridDB v5.6 Compression Type (ZSTD). Querying much faster?

GridDB 5.6 has a new compression method that I wanted to test. I made a simple test where I ingested X amount of rows and tested the compression method against the old compression available prior to 5.6 (ZLIB) and against no compression. The results…
L. Connell
  • 69
  • 6
1
vote
1 answer

Database memory limit

I want to create a test lab used by developers, one of the VMs will be running griddb as a database. I want to restrict the database engine memory usage by running "gs_paramconf -u admin/ --set storeMemoryLimit 4096MB" as described here…
Jacob_P
  • 29
  • 1
1
vote
1 answer

GridDB via Kubernetes

I want to deploy application using Kubernetes, one of the used components will be a GridDb database, I used the following article to deploy it - https://griddb.net/en/blog/creating-a-kubernetes-application-using-griddb-and-go/, the deployment…
Jacob_P
  • 29
  • 1
1
vote
1 answer

Being hit with memory limit restrictions in GridDB despite increasing the SQL and general storeMemoryLimit

I have a table with ~1 million rows that is being attempted to be read by a java program via the TQL interface (ie. just using the normal Java API, no SQL). But when I try to read the container, I'm met with a memory error: Exception in thread…
L. Connell
  • 69
  • 6
1
vote
1 answer

Data seemingly not being saved into GridDB partitioned table (No Errors being thrown?)

I have a java program which writes rows into my GridDB table via the NoSQL API. I am properly catching errors and I see in the logs that the data is being stored into my container via multiput, but when I go into the CLI to view the contents of the…
L. Connell
  • 69
  • 6
1
vote
0 answers

GridDB error cannot build on ubuntu 22.04

I'm getting the following error 3rd_party/MessagePack/Makefile.am:8: warning: source file '$(srcdir)/src/unpack.c' is in a subdirectory, 3rd_party/MessagePack/Makefile.am:8: but option 'subdir-objects' is disabled AM_INIT_AUTOMAKE add…
Nooruddin Lakhani
  • 149
  • 5
1
vote
0 answers

How do I force drop expiry-release partitioned tables in GridDB?

I have a container I made as seen here: Database : public Name : RAWLOG_agent_tests Type : COLLECTION Partition ID: 78 DataAffinity: - Partitioned : true Partition Type : INTERVAL Partition Column : ts Partition…
L. Connell
  • 69
  • 6
1
2