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
0
votes
0 answers

Constraint Violation in Sampling Period in GridDB

I was working with the Twitter API and working on a data analysis project of sentiment analysis where I uploaded my data on GridDB and wrote a TQL query to extract the number of tweets after 1st January 2022 till date categorized according to the…
Emad Bin Abid
  • 61
  • 5
0
votes
0 answers

Unauthorized Column Operation in GridDB

Unauthorized Column Operation in GridDB I was attempting to write a TQL query in GridDB to add the retweets and favorites columns together within the sum() function to calculate the total engagement for each hour, which is shown as follows: SELECT…
Ismail Vohra
  • 79
  • 7
0
votes
0 answers

To Find Average population Countrywise and rounding off to its nearest value in GRID DB

I am working on a business request. I have two tables Country and State. In the Country table there are 3 columns(CountryID,CountryName, TotalArea. In the State Table there are 4 columns(StateID,StateName,CountryID,Population). I want to write a…
Harshal
  • 31
  • 1
0
votes
0 answers

Finding Employee's 2nd Highest salary in GRID DB

I have got a technical requirement in my current project. I have created an employee table having 4 columns(Empid, empname, Department and salary). I want to display Empid, Empname, Salary and the 2nd highest salary departmentwise. So can he write a…
Harshal
  • 31
  • 1
0
votes
0 answers

How can I optimize GridDB's performance for time-series data?

I'm storing a large amount of time-series data in GridDB, and I want to optimize the database's performance for this data type. However, I must figure out what settings or configurations I must adjust to achieve the best performance. Here's what I…
SimoIT
  • 79
  • 4
0
votes
0 answers

Compiler error when using Java with GridDB

I'm trying to write a test Java program to access data in GridDB, similar to the example in the GridDB documentation here: https://docs.griddb.net/latest/gettingstarted/java/#simulate-iot-data-with-java. Before putting any actual action into the…
JillT
  • 21
  • 1
0
votes
0 answers

How can I configure GridDB's replication settings for high availability?

I'm using GridDB in a production environment and want to ensure high availability in case of node failures. I've read the GridDB documentation; replication is the way to go. However, how can I configure the replication settings to achieve the level…
SimoIT
  • 79
  • 4
0
votes
0 answers

How to auto-generate new passwords for old GridDB database users?

As a database administrator, I can change the password of any user of a database, and the user can also change it themself. However, I have a database representing all the users of a database, their passwords, and when the password was changed last.…
Emmanuel Oluwatosin
  • 41
  • 3
0
votes
1 answer

How to filter a GridDB column where there is a particular substring?

I have a database stored in a GridDB container. I need to filter out a column (of codes) and get all the rows where the value has "INB" in its code. Like this: ''' id | codes ----+--------------- 0 | UIGTF0941H9RBD 1 | UIHGG83G31H9G3 2 |…
Emmanuel Oluwatosin
  • 41
  • 3
0
votes
0 answers

How to format the IDs for a timeseries database in GridDB?

I have a timeseries database, and it has a column called user_id. The user ids are in this format 0000, 0001, 0002, 0003, 0004,... However, I would like to add something like a "tag" at the beginning of every id, to mark that the timeseries is for a…
Emmanuel Oluwatosin
  • 41
  • 3
0
votes
0 answers

Failure to Update Rows in GridDB

I am using GridDB for the Data Analysis project on a CSV file related to loans and wanted to update some records. The file and the code are as follows: Container container = store.getContainer(studentinfo); if ( container == null ){ …
Ismail Vohra
  • 79
  • 7
0
votes
0 answers

How to remove database priviliges from inactive database users?

As a database administrator in a company, I need to manage the users of am employees database. I would like to revoke database access rights from every user that has been logged in to the database at least 2 years ago. This is indicated by a column…
Emmanuel Oluwatosin
  • 41
  • 3
0
votes
0 answers

How to perform range queries efficiently in GridDB for both ascending and descending order without creating separate containers?

Using GridDB, I have a use case where I need to perform range queries on the data stored in a container. Sometimes I need to retrieve data in ascending order of a certain column, while other times I need to retrieve data in descending order of that…
Hajar S
  • 41
  • 3
0
votes
0 answers

How does gridDB ensures that 100% of the data is persisted?

How does gridDB ensures that 100% of the data is persisted on storage as it follows memory first and storage second approach? or is it susceptible to data loss in case of sudden shutdowns? The gridDB documentation is not very clear on it or may be I…
Ashif Shaikh
  • 29
  • 2
0
votes
0 answers

Cluster failure in Grid DB when restarting the cluster

I'm getting repeated cluster failures while working on the Grid DB Node Js connector for my project, and I can't figure out why. I initialized and ran the cluster once, and it worked flawlessly, but when I closed the cluster and Grid DB for a while…
Ismail Vohra
  • 79
  • 7
1 2 3
…
17 18