Stack Overflow
Stack Overflow

Questions tagged [cratedb]

Use this tag for questions related to CrateDB - an SQL-based database management system.

CrateDB is a database management system (DBMS) for Windows, Mac, and Linux designed to provide classic SQL-based access alongside with fast search capabilities. For more information please refer to https://crate.io.

136 questions
4
votes
1 answer

Jooq XML Database generation

I am manually defining a Database XML schema to use the Jooq capabilities to generate the corresponding code from the definition. I am using Gradle to generate the code with Jooq: jooq { version = '3.13.5' edition =…
Stefano Bossi
  • 1,138
  • 1
  • 9
  • 19
3
votes
0 answers

CrateDB Bind Local IP

I have setup 3 node with same cluster. Is there any way to bind local ip for individual createdb node which can only be accessible from same host ? I tried following but not working. crate01: image: crate container_name: raycrate01 …
Bhargav Patel
  • 1,098
  • 10
  • 23
3
votes
1 answer

How to load data from Kafka into CrateDB?

From the following issue at CrateDB GitHub page it seems it is not possible, i.e., the Kafka protocol is not supported by CrateDB. https://github.com/crate/crate/issues/7459 Is there another way to load data from Kafka into CrateDB?
romulog
  • 33
  • 5
2
votes
1 answer

CrateDB aggregate all array elements

I am working to aggregate (sum) all returned array values. The target column contains objects that contains an array of objects. e.g. Object - person: "bob" - children: - zaphod - age: 42 - ford - age: 42 In the above example, I…
Bryan
  • 53
  • 7
2
votes
1 answer

How to configure PostgreSQL ODBC Driver

I have a database on Crate DB. The database program is started through docker-compose.yml file. It is running on http://192.168.99.100:4200 (this is the docker machine's IP with the Crate's port) I want to connect the Crate DB with Power BI. When I…
John
  • 410
  • 1
  • 9
  • 21
2
votes
0 answers

Prometheus: migrate existing data to remote storage CrateDB

I have a Prometheus server which has scraped data with 30d of retention policy. Now I have installed another new Prometheus server but this one is using remote storage with CrateDB. I want to keep the existing data collected from first server, so I…
Claudio Saavedra
  • 145
  • 1
  • 1
  • 12
2
votes
2 answers

How can i access CrateDB Admin UI on Ubuntu server 18.04 across the LAN?

I installed CrateDB on an Ubuntu server 18.04 across the LAN. But I am not able to access the Admin-UI and I get the following message: Firefox can’t establish a connection to the server at 192.168.1.102:4200. How can i solve this problem? CrateDB…
R.Alamsha
  • 85
  • 1
  • 6
2
votes
1 answer

How to remove shards in crate DB?

I am new to crate.io and I am not very familiar with the term of "sherd" and I am trying to understand why when I am running my local db it creates 4 different shards? I need to reduce this to one single shard because it causes problems when I try…
Vasile
  • 801
  • 2
  • 13
  • 31
1
vote
1 answer

How to send NGSIv2 metadata to CrateDB

I need to send attributes in the northbound direction containing metadata to the CrateDB time series. Sample of the attribute format: { "object_id": "AGV_Error", "name": "AGV_Error", "type": "Integer", "value": 0, "metadata": { …
sfl0r3nz05
  • 547
  • 8
  • 14
1
vote
0 answers

How to do round-robin queries to multiple nodes in a CrateDB cluster from pgx?

I'd like to connect to multiple nodes in a CrateDB cluster from pgx and execute queries in a round robin fashion. Ideally if a node fails queries would be retried on the other nodes. There's a client in Python that supports clustering but only found…
Rob
  • 11
  • 1
  • 1
1
vote
1 answer

CrateDB as timeseries database for Django

I am trying to use CrateDB as timeseries database for Django. I am deploying both services on docker for development. I started by deploying the following versions: Django: 4.1.3 CrateDB: 5.1.0 However, I was getting compatibility error:…
sfl0r3nz05
  • 547
  • 8
  • 14
1
vote
1 answer

getting a list of tables with row counts from cratedb

I've been given the task of validating restores of crate databases from one AWS region to another. The backups and restores are already happening, but we don't have a way of validating whether the restores are succeeding without digging into each…
ajhowey
  • 41
  • 4
1
vote
1 answer

Is there a performant way to search by a non-partitioned column in crateDB?

My team and I have been using crate for one of our projects over the passed few years. We have a table with hundreds of millions of records and performance is key. As we've developed more and more features on this project, we've ran into interesting…
Nate Elliott
  • 11
  • 1
1
vote
1 answer

Querying whole OBJECT or Document using LIKE condition in CrateDB

I have a table with one of the field defined as "attributes" OBJECT (DYNAMIC). Now, my usecase is to be able to check if any particular string is part of this OBJECT. In SQL terms I want to execute a like command on this whole OBJECT or even whole…
Chandan
  • 640
  • 4
  • 10
1
vote
1 answer

How can I send sensor data from ROS to CrateDB via FIROS?

I have a vehicle with ROS installed. How can I send the sensor data of this vehicle to CrateDB via FIROS?
snkly
  • 41
  • 3
1
2 3
…
8 9