Stack Overflow
Stack Overflow

Questions tagged [griddb]

GridDB is 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

265 questions
1
vote
0 answers

How can do cluster synchronization in distributed environment?

i am trying to sync data from griddb database in different environments but nodes are not communicating i check network connection between the nodes that is ok but still not getting results.
Muaaz Hasni
  • 51
  • 3
1
vote
0 answers

Can we partition a table based on a timestamp column in GridDB?

In MySQL, it is possible to partition a table based on a timestamp column using the PARTITION BY RANGE clause in the CREATE TABLE statement. Can a similar approach be used in GridDB to partition a table based on a timestamp column? If so, how can…
Ammar Ubaid
  • 31
  • 2
1
vote
0 answers

How can indexing improve query performance and when should i use composite index in GridDB?

I have a large sales transaction data and I want to create a table to store this data in GridDB and be able to quickly query it based on several criteria, including date, store location, product category, and payment method. Here's a CREATE TABLE…
Ammar Ubaid
  • 31
  • 2
1
vote
0 answers

Sampling Constraint Violation in GridDB

So I have created a container, conInfo in GridDB comprising of used car sales where the schema of the container looks as follows: const conInfo = new griddb.ContainerInfo({ 'name': "usedcaranalysis", 'columnInfoList': [ ["name",…
Ismail Vohra
  • 79
  • 7
1
vote
0 answers

Optimal memory+cache settings for faster SQL processing in GridDB

I am using GridDB as my in-memory database, and I intend to run heavy SQL queries on it. The underlying data has many columns/properties, distributed in many tables. Think of it as a large number of CSVs, with each CSV having 20 or more columns. My…
Pratik Dwivedi
  • 53
  • 5
1
vote
0 answers

What is the syntax for griddb to create analytics query like

I have created database on griddb containerize, in which departments and salaries are stored. I want to implement one case to categorize salaries like low/high. In SQL it is easy to implement but how the syntax looks like in gridbdb? select…
Junaid umer
  • 67
  • 4
1
vote
0 answers

Error on regression test using "make check" on postgresql 11.0 in GridDB (FDW)

It cannot complete regression test using make check command. The issue occurs below: SELECT * FROM department d, employee e WHERE d.department_id = e.emp_dept_id LIMIT 10; …
Salman Khwaja
  • 117
  • 4
1
vote
0 answers

Error when creating foreign table in GridDB (FDW)

I’m getting issue when creating the foreign table. I think griddb_fdw can not link table "T 1" to foreign table "ft1". CREATE FOREIGN TABLE ft1 ( c0 int, "C 1" int NOT NULL, c2 int NOT NULL, c3 text, c4 timestamptz, c5…
Salman Khwaja
  • 117
  • 4
1
vote
0 answers

Error when using sub-query with multi instances of tabl in GridDB

I have a scenario as below: -- In GridDB set_tableInfo(store, "INT8_TBL", &INT8_TBL, 3, "id", GS_TYPE_INTEGER, GS_TYPE_OPTION_NOT_NULL, "q1", GS_TYPE_LONG, GS_TYPE_OPTION_NULLABLE, …
Salman Khwaja
  • 117
  • 4
1
vote
0 answers

Error when setting text column to null value in GridDB (FDW)

The server is terminated connection because of setting null value to text column. -- join with nullable side with some columns with null values UPDATE ft5 SET c3 = null where c1 % 9 = 0; server closed the connection unexpectedly This probably…
Nooruddin Lakhani
  • 7,507
  • 2
  • 19
  • 39
1
vote
1 answer

How can I use GridDB with Apache Spark?

I have a large amount of data stored in GridDB and want to process it using Apache Spark. However, I'm unsure how to connect GridDB to Spark or use GridDB as a data source. Here's what I have so far: val spark =…
SimoIT
  • 79
  • 4
1
vote
0 answers

Inconsistent behavior of SELECT target and WHERE condition on system columns in GridDB (FDW)

I tried to SELECT some systems columns, tableoid and ctid. The behavior is inconsistent. I can achieve the result from SELECT command: SELECT tableoid::regclass, * FROM ft1 t1 LIMIT 1; tableoid | c1 | c2 | c3 | c4 | …
Nooruddin Lakhani
  • 7,507
  • 2
  • 19
  • 39
1
vote
0 answers

Partitioning feature causes the crash error in GridDB (FDW)

Regarding to the table partitioning feature, It causes the crash error by the following scenario: create table itrtest (a int, b text) partition by list (a); create foreign table remp1 (a int, b text) server griddb_svr options (table_name…
Nooruddin Lakhani
  • 7,507
  • 2
  • 19
  • 39
1
vote
0 answers

How can I query time-series data in GridDB using SQL?

I have a lot of time-series data stored in a GridDB database, and I want to query it using SQL. However, I don't know the syntax for selecting data based on a time range. Here's what I have so far: SELECT * FROM my_container WHERE timestamp >=…
SimoIT
  • 79
  • 4
1
vote
0 answers

Unable to do data backup in GridDB

So I have been working with GridDB and using it for multiple projects. But recently, I received an error while backing up my data. I follow the commands mentioned below to usually fully backup my data and check its status: $ gs_backup -u admin/admin…
Emad Bin Abid
  • 61
  • 5
1 2 3
…
17 18