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

How to concatenate two different tables in two separate GridDB containers

I have two separate GridDB containers storing different databases. The two tables in the databases do not have columns in common. I want a way to concatenate them side by side so I can have a single container at the end, having a single table, with…
Jessica Chris
  • 31
  • 2
0
votes
0 answers

How to convert an existing table in GridDB into a partitioned table?

I have a table with data similar to the following: gs[public]> gs[public]> tql t1 select *; 9 results. (11 ms) gs[public]>…
dogs Cute
  • 564
  • 3
  • 9
0
votes
0 answers

Getting transaction timeout while loading CSV file in GridDB container

For data analysis, I use the Grid DB Node js connector on Linux Ubuntu 22.04.1 LTS. I received the following error while loading my csv into the container: [Server] 50000, 50001 [Client] 70000 [Description] Transaction timeout [Format] Timeout…
Emad Bin Abid
  • 61
  • 5
0
votes
1 answer

How to create composite indexes in GridDB?

For reference: This is how we do it in SQL Server: create index indexname on tablename (col1, col2) I checked the documentation https://docs.griddb.net/architecture/database-function/#transaction-isolation-level and didn't find anything specific to…
Ashif Shaikh
  • 29
  • 2
0
votes
0 answers

Is there a way I can use explicit Read_uncommited isolation level in GridDB?

As per documentation, GridDB supports ReadUncommited Transaction Isolation Level. However, I wanted to know how can I use this transaction level explicitly. For eg: This is how we do it in SQL Server: SET TRANSACTION ISOLATION LEVEL READ…
Ashif Shaikh
  • 29
  • 2
0
votes
0 answers

How to group by with a having clause in gridDB?

Is there a way or what is the equivalent of group by with having clause in GridDB when compared to RDBMS?
Ashif Shaikh
  • 29
  • 2
0
votes
0 answers

Troubleshooting securing memory in GridDB

I was working with GridDB Node Js Connector and trying to load all the data from a csv file into the GridDB Container using TQL, but I received the following error: [Error code]: 1001 [Description] (Error in securing memory) [Format] Error…
Ismail Vohra
  • 79
  • 7
0
votes
0 answers

Statistics in GridDB using TQL

Is there a built-in library or function to calculate statistics (i.e., mean, median, mode, etc.) in GridDB using TQL? P.S. I did not find any command in the GridDB Documentation. The link to the documentation is attached below. Reference:…
Emad Bin Abid
  • 61
  • 5
0
votes
0 answers

"Error while loading GridDB libraries." when importing GridDB Connector for Python

I am using GridDB Connector for Python to start my data analysis script. I first need to import the GridDB connector as follows: import griddb_python I keep getting this error even after installing all the needed dependencies: ModuleNotFoundError …
SimoIT
  • 79
  • 4
0
votes
0 answers

How to install GridDB Python Client module on Google Colab instance using pip?

I am trying to install the GridDB Python Client Library in Google Colab using the pip command as follows: !pip install griddb-python-client Once I executed the code the following error code was returned: Looking in indexes: https://pypi.org/simple,…
SimoIT
  • 79
  • 4
0
votes
0 answers

How to setup GridDB on Windows

What is the best way to set up GridDB in Windows and use it with Anaconda navigator? What are the steps needed to add GridDB to the Anaconda navigator? Is there an executable file that can be used to run GridDB, or should I use a pip install while…
SimoIT
  • 79
  • 4
0
votes
0 answers

How to limit a table to only 50 rows?

I am not talking about getting data from a table and limiting the output to only 50 rows. I want to place a restriction on a database table in such a way that if a new row is added, it throws an error. The table can be updated or rows deleted, but…
Jessica Chris
  • 31
  • 2
0
votes
0 answers

Multiple Tables in a Single Container

I'm using the GridDB Node js Connector and was wondering how I could add multiple tables in a single container while retaining data for all of the tables? P.S. I went through the SQL documentation for GridDB, so using the JOIN command is not…
Ismail Vohra
  • 79
  • 7
0
votes
0 answers

GridDB on arm64

At this moment(12.10.22) griddb is available on some processors based on arm64 in MC like Rock Pi 4B? Im trying to using guide from here https://griddb.net/en/blog/griddb-on-arm-time-series-database-for-your-raspberry-pi/ step by step, but get some…
Kaladar Shd
  • 1
0
votes
0 answers

How to delete a list of griddb databases according to conditions?

I have a list of databases I want to drop under a certain condition. I know GridDB SQL is not like Python where you can write commands under a condition block. But I would like to know if I can delete databases that have been updated only in the…
Jessica Chris
  • 31
  • 2
1 2 3
…
17 18