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
3
votes
2 answers

To find Lowest Experience of any Employee by writing a query in GRID DB

I am working on a EmployeeDetails table. I have 4 columns in that table(Empid,Empname, DateOfJoining, Salary). I want to write a query to fetch the Empid,Empname and salary of the employee who is having Lowest Experience. Can someone please…
Harshal
  • 31
  • 1
2
votes
0 answers

Unable to connect with GRIDDB using SQL workbench

I need to connect to a GRIDDB instance running on a CentOS 7 machine by using SQL workbench from my Windows 10 machine. I have setup the GRIDDB environment on CentOS 7 VM on Hyper-V. I am successful in taking a putty session of my VM, and can also…
Syed Mudassir Ali
  • 41
  • 2
2
votes
1 answer

Failure to Use a Stored Procedure in GridDB

Since I have previously worked with relational databases, using stored procedures is a common practice, but for quite a long time, I have shifted to using GridDB, a NoSQL database. The problem that I recently faced was the use of a stored procedure…
Ismail Vohra
  • 79
  • 7
2
votes
0 answers

How can I calculate the average value of a data field in specified intervals using GridDB

I want to get the average value of the specified data field values in each interval, for example, the sum of data fields in each hour in a 24 hour day. I tried the following methods to get the data, but they failed to meet my needs. How do I get the…
Nooruddin Lakhani
  • 7,507
  • 2
  • 19
  • 39
2
votes
0 answers

Class "StoreFactory" not found

I'm trying to run the sample1.php class available at php client github repo that is a simple GridDB client in php, currently running it on ubuntu 22.4.1, using the command: php sample1.php 127.0.0.1 10001 myCluster admin admin -->Person: name=diego…
diegao15
  • 61
  • 3
2
votes
0 answers

Insert data from Oracle to griddb

I want to use open source db called griddb. Basically optimised for IOT devices. I want to create and use it for developing An application for IOT devices in smart home setup to store data and define automations. I'm interested to know how to…
pramod m nair
  • 39
  • 3
2
votes
1 answer

Cannot run GridDB docker in Fixed List mode

Running GridDB docker in fixed list mode e.g. docker run -dt --network="host" -e NOTIFICATION_MEMBER=1 griddb/griddb:latest leads to the following error: Fixed List mode Execution failed. See message logs /start-griddb.sh: line 94: exec: griddb: not…
Arqish Mithani
  • 73
  • 4
2
votes
1 answer

GridDB SQL error: Invalid syntax near 'GROUP'

I'm working with GridDB's SQL interface in Ubuntu and trying to retrieve the count of sensor data records where the value is greater than 100, grouped by the sensor ID. However, when executing the query, I receive an error message saying: Invalid…
John Woods
  • 71
  • 2
2
votes
0 answers

How do you update griddb running on AWS?

I have a running griddb on AWS marketplace. I have not updated the software yet. Could you provide me guidance on how to do it?
Pavel Fedotov
  • 748
  • 1
  • 7
  • 29
2
votes
0 answers

How to setting for GridDB JDBC connect to GridDB Server run with Fix_list or provider mode?

I want to setup the server with fixed list ( or provider method) method to run GridDB Java JDBC sample. However, I only found the guide to run with multicast method for GridDB JDBC. I think I must setup GridDB JDBC with fixed list mode like the…
Tung Duong
  • 103
  • 6
2
votes
0 answers

fallocate on MacOS for GridDB configure

I have been trying to install GridDB on MacOS to do some big data work, but hitting issues. I have checked other questions on SO, and took the advice here to try from source code. The configure step fails with: checking whether…
jedison
  • 908
  • 6
  • 15
2
votes
1 answer

How to install/setup GridDB in Ubuntu?

Besides using DOCKER, downloading CentOS, and setting up GridDB, How to setup a GridDB client and server on Ubuntu? Its docs have RPM/YUM methods only. I want to do a quick explore GridDB using Python to interface with JayDeBeApi on…
GildedProtagonist
  • 61
  • 2
2
votes
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
  • 129
  • 5
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
  • 129
  • 5
2
votes
1 answer

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
  • 103
  • 6
1
2 3
…
17 18