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
1 answer

Connection Port for Java GridDB using java

I want to write an application in Java that accesses data from GridDB. In the documentation, I see the connection port defaults to 31999. By coincidence, I already have an application running on this port. Is it possible to change the default…
JillT
  • 21
  • 1
1
vote
0 answers

Unable to access gs_sh after installing GridDB on Ubuntu

I've installed GridDB on Ubuntu using dpkg as per the installation guide here: https://docs.griddb.net/gettingstarted/using-apt/#install-with-deb I am able to change user to gsadm and to start and stop the service. However, when I try to access…
JillT
  • 21
  • 1
1
vote
1 answer

How to replace a column with another column from another table?

I have a database stored in a GridDB container. The main table in the database contains a column with outdated data. I would like to replace the whole column with a new column from another table (with the same total number of rows). Is there any way…
Emmanuel Oluwatosin
  • 41
  • 3
1
vote
0 answers

How to delete any column containing too many NULL values?

On my Ubuntu machine, I am using the Python client for GridDB. I need to search through a database stored in a GridDB container and delete the column(s) containing too many NULL values. The NULL values are "too many" when there are more NULL values…
Emmanuel Oluwatosin
  • 41
  • 3
1
vote
0 answers

How to delete a user based on time last logged in?

I am an administrator for a GridDB database, and I would like to delete inactive users. I would like to check the last time a user was active, or when last they logged in to the database. If it's been more than 6 months ago, I want the user to get…
Emmanuel Oluwatosin
  • 41
  • 3
1
vote
0 answers

GridDB Cluster Keeps Resetting

I have been working on a personal project and conducting data analysis by storing the data in the GridDB cluster. I created the schema in the cluster, but the cluster keeps resetting, and the names of the columns keep disappearing. The code for…
Ismail Vohra
  • 79
  • 7
1
vote
0 answers

Exporting Data from GridDB to any other Database

I have been working on a personal project where I collect different types of data from sensors like timestamps, integer values, etc., and storing it in the GridDB cluster because it supports high-throughput data ingestion and real-time querying…
Emad Bin Abid
  • 61
  • 5
1
vote
0 answers

How do I troubleshoot the "ORA-00001: unique constraint violated" error in GridDB?

Can you assist me in determining the issue with my code? import griddb_python as gdb # Connect to the GridDB server factory = gdb.StoreFactory.get_instance() store = factory.get_store(host='localhost', port=31999) # Insert a new customer into the…
Hajar S
  • 41
  • 3
1
vote
0 answers

How does GridDB handle performance and scalability for large time-series data and compare it to traditional databases?

How does the use of GridDB improve performance and scalability when handling large amounts of time series data, such as sensor data from IoT devices, in comparison to traditional relational databases? And how does GridDB handle data consistency and…
Hajar S
  • 41
  • 3
1
vote
0 answers

What is the most efficient way to organize and query large amounts of sensor data in GridDB?

I am currently working on a project that involves storing and querying large amounts of sensor data. I have chosen to use GridDB as the database for my project due to its support for high-throughput data ingestion and real-time querying…
Hajar S
  • 41
  • 3
1
vote
0 answers

How do I troubleshoot the "PLS-00103: Encountered the symbol 'end-of-file' when expecting one of the following" error in Griddb?

My Code: CREATE OR REPLACE PROCEDURE get_employee_name (p_id IN NUMBER, p_name OUT VARCHAR) AS BEGIN SELECT name INTO p_name FROM employees WHERE id = p_id; END; / BEGIN get_employee_name(1, v_name); DBMS_OUTPUT.PUT_LINE('Employee name: '…
Hajar S
  • 41
  • 3
1
vote
0 answers

How to setup Disaster recovery for GridDB?

I know the backup and restore process of GridDB which is specified here, however, I would like to know how to setup Disaster Recovery (To a different site) using methods such as log shipping, Distributed Clustering, etc.
Ashif Shaikh
  • 29
  • 2
1
vote
0 answers

How to distribute data from GridDB to different data warehouses？

I am currently collecting data from different PLC devices to GridDB for storage. The format of the data is as follows: D_NAME DATA MSG Siemens 2021/10/4 acbdfg Omron 2021/10/4 ponged It is necessary to distribute the row whose device…
dogs Cute
  • 564
  • 3
  • 9
1
vote
0 answers

Trigger constraint violation occurred in GridDB

I'm using the GridDB Node js connector to do data analysis using the CSV file that I saved in the GridDB container, and I'm getting the following error: [Server]: 140001/145001/170003/10040 [Description] (Trigger constraint violation) As far as I…
Emad Bin Abid
  • 61
  • 5
1
vote
0 answers

Error when execute UPDATE with inherit target and inherited source table in GridDB

This error occurs when I execute UPDATE with inherit target and inherited source table. The scenario is as follows: create table foo (f1 int, f2 int); create foreign table foo2 (f3 int) inherits (foo) server griddb_svr options (table_name…
Salman Khwaja
  • 117
  • 4
1 2 3
…
17 18