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

108 questions
2
votes
2 answers

Ordering output by custom order with GridDB

I am trying to run a ORDER BY query but I want the output to be ordered according to a custom scheme. In SQL this is often done with a case system, but depending on the DB there are also other implementations. How would I achieve the sorting…
Frostbite
  • 119
  • 5
2
votes
1 answer

GridDB C client, Failed to run sample1.c

When I install c_client on Github after I follow guid on Github. Input the following command: $ cp client/c/sample/sample1.c . $ gcc -I./client/c/include -L./bin sample1.c -lgridstore $ export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:./bin After I run…
Tung Duong
  • 73
  • 5
1
vote
0 answers

Does GridDB Supports Procedural Sql (PL/SQL)?

According to GridDB documentation,it supports basic SQL operations such as DDL/DML queries. But there is no info about whether it supports advanced SQL functions or not. Any help in this regards will be highly appreciated.
Bishwajit
  • 11
  • 1
  • 4
1
vote
1 answer

Issues building GridDB CE v4.6 from Source

I am currently running GridDB 4.5.2 (from yum) on CentOS Linux release 7.9.2009 When attempting to build the new GridDB version from source, I get the following error: g++: internal compiler error: Killed (program cc1plus) Please submit a full bug…
Gopheritis
  • 60
  • 5
1
vote
0 answers

Unable to install GridDB on Fedora

I am trying to install GridDB on my Fedora 33. I am trying to install it using the guide mentioned https://docs.griddb.net/gettingstarted/using-source-code/ downloaded the latest version using $ git clone https://github.com/griddb/griddb.git but…
1
vote
1 answer

How to control the motor using the rotary encoder

I want to control the accuracy of the motor using a rotary encoder. For example, I want to move the motor to any side, for example, 70 degrees, and return to its original place using a rotary encoder. I wrote a code, but this code the motor does not…
chosen one
  • 11
  • 1
1
vote
0 answers

Cannot connect to a GridDB docker container with multicast network setting

I am trying to connect to the GridDB server via sql workbench/j by following this blog post. I setup the GridDB server on a CentOS Docker image, Mac Host and can successfully connect via the sqlwbconsole from within the container, but having problem…
Codelicious
  • 140
  • 9
1
vote
1 answer

The difference between griddb timeSeries container and collection container

"GridDB has two container types: Collections which can have any type of row key, and TimeSeries which always have a timestamp as the row key" Reference: https://griddb.net/en/blog/data-modeling-with-griddb/ rowKey for the collection container…
Tung Duong
  • 73
  • 5
1
vote
1 answer

The difference in runtime when using master node connection and multicast mode of GridDB

I am trying to measure GridDB performance using sample1.py with GridDB python client. When using multicast mode, it took 3.714s. I used this command: "time python sample/sample1.py 239.0.0.1 31999 griddb admin admin" I tried using the master node…
Tung Duong
  • 73
  • 5
1
vote
1 answer

In GridDB, can an index/rowkey/search be inverted?

Using GridDB, I sometimes need to read data starting with the first row, and sometimes starting with the last row. Currently I have two containers with the same data but inserted in the opposite order of each other. While functional, this does seem…
L. Connell
  • 37
  • 5
1
vote
1 answer

Rowkey for time-series container of GridDB based on gsCurrentTime()

I have input from a wide variety of sensors who each only ever produce one or two rows of input, so creating a new container per sensor makes little sense. The data comes in an order which should not be lost, as such I've considered enumerating…
Frostbite
  • 119
  • 5
1
vote
0 answers

Preserving historical data in a timeseries container with row expiration

I am using GridDB's timeseries row expiration to have old rows drop out of a dataset. But I want the dataset to include some yet older rows, with a special status as historical data which foregoes said expiration. To be more concrete, I have…
Frostbite
  • 119
  • 5
1
vote
1 answer

Usage of GridDB's set_auto_commit() function

At several points in the documentation of GridDB the auto-commit feature is disabled and instead there are manual commits. I did not manage to find any explanation for this behaviour. It seems that it needs to be disabled when deleting a row from a…
Frostbite
  • 119
  • 5
1
vote
1 answer

I get error when i try to install Griddb database

I'm trying to install Griddb on Centos 8 by running rpm file: sudo rpm -i griddb_nosql-4.3.0-1.linux.x86_64.rpm but i get this error: error: Failed dependencies: /usr/bin/python is needed by griddb_nosql-4.3.0-1.linux.x86_64 it seems like…
1
vote
0 answers

GridDB puts data have not success

When I puts data on GridDB_NoSQL sever : Data includes : 1000 row && 10000 column (String data 20 byte) I see notification: [ 0 ] 60015 [60015:DS_DS_SCHEMA_INVALID] Number of columns = 10000 is invalid (address=10.116.41.212:10001,…
Tung Duong
  • 73
  • 5
1
2 3 4 5 6 7 8