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

Crate DB how to set the parameter "wait_for_active_shards" when create a table?

I set up a crateDB cluster of 5 nodes. And the situations are as follows: (the number_of_replicas is 2, the wait_for_active_shards is "all") When one node down, the write process will report an error: Not enough active copies to meet shard count of…
Spike
  • 5
  • 2
0
votes
2 answers

Search in all columns in crate

As elastic search has _all field I am not able to find anything regarding that in cratedb. SO do we need to maintain our own analyzed field for that purpose or does crate provide something in built?
Dhruv Pal
  • 849
  • 2
  • 10
  • 25
0
votes
1 answer

Accessing Cratedb via HTTP Endoint vs PostgreSQL Wire Protocol

I was wondering if anyone has tried comparing the speed in querying (lets just say any arbitrary query for this exercise) using either HTTP end point and the PostgreSQL connection to cratedb. Considering what's under the hood is elastic search…
metase
  • 1,169
  • 2
  • 16
  • 29
0
votes
1 answer

Is there a way to optimize this CrateDB relational query?

I am testing CrateDB with a data set of 80 million events sent from a web app, both as a normalized, relational solution, and also as a denormalized, single database solution. I imported all 80 million denormalized events into a table, and ran the…
James Jensen
  • 255
  • 1
  • 2
  • 11
0
votes
1 answer

Does CrateDB have Mechanism for expiring old data？

since the data may become huge , currently, i can only use delete partitions to delete old metircs, does CrateDB have Mechanism for expiring old data？
jason
  • 11
  • 1
0
votes
1 answer

How to perform ip/date/histogram range query(like in Elasticsearch) in crateDB?

I have looked up the crateDB official documentation, but I have not found how to perform a range query. In Elasticsearch it is done as follows: curl -X GET "localhost:9200/_search" -H 'Content-Type: application/json' -d' { "aggs" : { …
iqiye
  • 1
  • 1
0
votes
1 answer

Running CrateDB in production

As suggested by https://crate.io/docs/crate/guide/en/latest/deployment/cloud/aws/ec2-setup.html. I've been trying to setup a CrateDb (3.0.2) cluster. However setting network.host: _site_ prevents the node from starting. Setting everything back to…
metase
  • 1,169
  • 2
  • 16
  • 29
0
votes
1 answer

Loading JSON data with apostrophe (single quote) i

This is specifically regarding insert of data into CrateDB, I have a table with one column of type OBJECT. I am trying to insert JSON data into that using python and it is going along fine. create table users (userdata OBJECT); However, my data has…
Glen Stokes
  • 1
0
votes
1 answer

Crate DB Trigger implementation

Our application has a requirement to be notified so that we launch a Python application, everytime a record gets inserted into a particular table, in traditional Databases it can be done using DB Triggers, is there a way to achieve similar…
Nachiketh
  • 193
  • 2
  • 18
0
votes
1 answer

Cratedb: One node went down abruptly from 2 node cluster

We are using 2 node cratedb cluster (v2.3.4). It was running fine for more than a month without any issues. Recently we came to know that one node went away without any external interference. We are unable to find the Root cause for this…
Carbonrock
  • 457
  • 2
  • 15
0
votes
1 answer

CrateDB - setting custom column as primary key automatically sets it as "_id" column

Assume I create table users with columns (firstname, lastname, email, address etc.). CrateDB automatically adds _id column, whose values are some kind of weird strings. If I set email column as PRIMARY KEY on table creation, then _id column becomes…
user3681549
0
votes
1 answer

What does return value -3 indicate when sending a JDBC bulk insert to crate.io

I try to do Batch inserts with JDBC to a Crate instance: for(...) { statement.setLong(1, startTime); statement.setInt(2, i); ... statement.addBatch(); } results = uaStatement.executeBatch(); …
centic
  • 15,565
  • 9
  • 68
  • 125
0
votes
1 answer

How to deal with time-series and table relations?

I have a few questions regarding CrateDB. I have been told that CrateDB does not support foreign key relations. Why is that? or has CrateDB another way of dealing with relations between tables? I have read that CrateDB is very efficient regarding…
Dánjal Salberg Adlersson
  • 711
  • 1
  • 6
  • 18
0
votes
1 answer

passing a multipolygon rather than the boundary box via a Crate DB table

I have a geopandas dataframe called geodf. The geometry for each row in that dataframe is a multipolygon. For instance, if we consider the first row in the geometry column via the geodataframe: bound = geodf['geometry'].iloc[0] print(bound) it…
M3105
  • 519
  • 2
  • 7
  • 20
0
votes
1 answer

SQL select with multiple different conditions

I am still learning SQL and can't find a proper way to find the following information: I have created a table "employees" with the following columns: 'department', 'age', 'salary', 'bonus'; I am trying to design a query that will give me all…
thomas
  • 71
  • 6
1 2 3
…
8 9