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

GridDB connection with SQL workbench

I have been trying to make a connection of GridDB with SQL Workbench. I am getting an issue with the password. I have reset the password many times but getting the same error again and again. The password is correct as I had it noted during the…
Muhammad Waheed
  • 1,048
  • 1
  • 13
  • 30
1
vote
0 answers

How to Perform Inner Join in Grid DB using TQL

As a data analyst, I frequently work with many kinds of data, each stored in its own GridDB container. I wanted to perform an Inner Join using GridDB's TQL syntax, which as follows: SELECT customers.customer_id, orders.order_id,…
Ismail Vohra
  • 79
  • 7
1
vote
0 answers

GridDB: Error Code 9201 - Authentication failure when connecting to the database

I am attempting to connect to a GridDB database, but I am receiving an authentication failure error with code 9201. The error message states: "Failed to connect to the database due to authentication failure." I have already confirmed that the…
Razedul Raj
  • 21
  • 2
1
vote
0 answers

How to efficiently retrieve the count of unique values in a GridDB column?

I'm working with GridDB, a distributed NoSQL database, and I have a specific requirement where I need to retrieve the count of unique values in a column within a GridDB container. The column contains a large number of values, and I'm looking for an…
Razedul Raj
  • 21
  • 2
1
vote
0 answers

Integration Error between GridDB and MongoDB

I am facing an integration error while trying to connect and interact with both GridDB and MongoDB in my application. The error occurs when I attempt to transfer data between the two databases. // Establish connection to GridDB GridStoreFactory…
Muaaz Hasni
  • 51
  • 3
1
vote
0 answers

having some Error on GridDB Server while query

I am experiencing a error on my GridDB server and need assistance in resolving it. The error is occurring when I try to perform certain operations on the server, such as querying or updating data. I have a code that demonstrates the issue, but I'm…
Muaaz Hasni
  • 31
  • 3
1
vote
1 answer

How can I export data from GridDB to a CSV file using SQL?

I have a GridDB database and want to export data from a specific container to a CSV file using SQL. I'm familiar with SQL queries but unsure how to achieve this in GridDB. Here's what I have so far: SELECT * FROM my_container This query retrieves…
SimoIT
  • 79
  • 4
1
vote
0 answers

How can I perform a multi-table join and update operation in GridDB using SQL?

I have multiple containers in my GridDB database and I need to perform a join operation involving multiple tables, followed by an update operation based on the joined results. However, I'm not sure how to achieve this using GridDB's SQL…
SimoIT
  • 79
  • 4
1
vote
0 answers

How can I perform aggregation operations in GridDB using SQL?

I have a GridDB database, and I need to perform aggregation operations, such as calculating a column's sum, average, or maximum value. However, I'm unsure how to achieve this using GridDB's SQL syntax. Here's an example of what I want to…
SimoIT
  • 79
  • 4
1
vote
0 answers

Is gs_sh limited to show exact row data with SQL statements?

I am manipulating data within GridDB, using its shell cliet gs_sh. While I create and insert successfully, I found it not showing exact data with select cluase. Seems nobody want to select within this tool, but what does select clause mean if it…
Xavier Z.
  • 128
  • 10
1
vote
0 answers

How can I perform a full-text search in GridDB using SQL?

I am currently using a GridDB database and need to search for specific records in a column through a full-text search. However, I am having trouble with the SQL syntax for GridDB. Can you help me with this? Here's an example of what I want to…
SimoIT
  • 79
  • 4
1
vote
1 answer

How to retrieve data from GridDB using a Python client?

I'm working on a Python project and need to fetch data from GridDB. Is there a Python client library available for GridDB? How can I retrieve data from GridDB using Python? Is there an official python client library or should I use JDBC driver using…
Ibrahim Paracha
  • 43
  • 2
1
vote
0 answers

Error executing query in GridDB Statement execution failed

I'm encountering an error while executing a query in GridDB. The error message I receive is Statement execution failed, but I'm not sure what is causing this issue. import com.toshiba.mwcloud.gs.*; public class GridDBQueryExample { public…
Muaaz Hasni
  • 51
  • 3
1
vote
1 answer

Demo griddb help required and SQL queries are not working

I'm currently exploring the GridDB demo and attempting to utilize the SQL capabilities mentioned in the documentation https://www.toshiba-sol.co.jp/en/pro/griddb/docs-en/v4_5/GridDB_SQL_Reference.html#sql-description-format, That we can use SQL…
Junaid umer
  • 67
  • 4
1
vote
1 answer

Getting GridDB dependency for pom.xml

I am trying to use GridDB with my Java application, and I am following this tutorial (https://medium.com/griddb/migrating-from-mysql-to-griddb-8e1ad82e1cee) to play around with it. So before starting, I am required to get the GridDB dependency into…
Chuah Cheng Jun
  • 243
  • 1
  • 3
  • 17
1 2 3
…
17 18