Stack Overflow
Stack Overflow

Questions tagged [crate]

Avoid this ambiguous tag. For CrateDB, use [cratedb]. For Rust crates, use [rust-crates]. For Ruby crate, use [ruby-crate].

CrateDB is a new breed of database to serve today’s mammoth data needs. Based on the familiar SQL syntax, CrateDB combines high availability, resiliency, and scalability in a distributed design that allows you to query mountains of data in realtime.

More questions? Join us on Slack!

148 questions
2
votes
3 answers

Is Crate a relational DB?

I thought at first that it isn't a relational DB, but after I read that I can join tables and it was written on their site https://crate.io/overview/ (see Use cases), I'm not sure. Especially I got confused by the senctence: CrateDB is based on a…
duichwer
  • 157
  • 1
  • 14
2
votes
1 answer

How to scale down a CrateDB cluster?

For testing, I wanted to shrink my 3 node cluster to 2 nodes, to later go and do the same thing for my 5 node cluster. However, after following the best practice of shrinking a cluster: Back up all tables For all tables: alter table xyz set…
claus
  • 377
  • 2
  • 9
2
votes
1 answer

autoscale a crate cluster

I'm playing around deploying crate in a Rancher environment. It's working fine, but I have issues with two config params: gateway.expected_nodes and gateway.recover_after_nodes. What is best practice regarding these two when it comes to scaling…
Helge Waastad
  • 151
  • 1
  • 11
2
votes
2 answers

Crate - What is the minimum memory requirement for a node host?

I can find cheap VPS hosts with 128MB RAM, and I wonder if that is enough to run a crate node for a tiny database, initially for testing. (I'm not looking for recommended memory, but the minimum one, for not running into out-of-memory exceptions.…
Sony Santos
  • 5,435
  • 30
  • 41
2
votes
0 answers

Is there a Groovy way to update SQL rows?

I'm in the process of converting a Groovy script that updated a document from a MongoDB and saved it into MongoDB using the save method doc.save(). Now I want to use a SQL database using groovy.sql on the Crate Database but cannot use the…
Jörg Rech
  • 1,339
  • 2
  • 13
  • 25
2
votes
1 answer

Any way to install kibana with elasticsearch's kibana?

I want to know if is possible to install kibana with the elasticsearch provided by crate. I know that the integration with elasticsearch is done in a low level, but may be very useful.
chan go
  • 137
  • 11
2
votes
1 answer

Where are the ElasticSearch APIs exposed when running Crate?

I've successfully installed the elasticsearch head plugin on crate and can access its web UI but it fails to connect. I'd like to be able to use it to visualize the data in the underlying elasticsearch store. Is there a a way to access the…
papercrane
  • 672
  • 5
  • 12
2
votes
1 answer

Can't insert from python client into cratedb

Using the python client. I'm getting a connection back and then submitting a insert statement with parameter arg data hard coded. Getting an error however. from crate import client con =…
Eric Palmer
  • 79
  • 1
  • 4
2
votes
1 answer

About Composite Index

When defining a composite index, e.g. create table temptable (id integer, id2 integer, name string, INDEX ci using plain(id2, id)); The id and id2 are indexed in elasticsearch using integer, but the I see from ES's _mapping is like: "ci" : { …
Newair
  • 33
  • 2
1
vote
0 answers

How to compile rust crate using `-Zpanic-in-drop=abort`?

Compile Rust crate using -Zpanic-in-drop=abort and build-std options got lots of errors as below: error: the crate `std` is compiled with the panic-in-drop strategy `unwind` which is incompatible with this crate's strategy of `abort` error: the…
Larry
  • 155
  • 7
1
vote
1 answer

rust mysql conn.exec() fails to compile

While working with Rust's MySQL Crate I have been unable to compile with the conn.exec() function that seems to be matching with documentation as well as guides online. The line conn.exec() causes the error 52 | conn.exec(&stmt, params!…
Jared
  • 41
  • 3
1
vote
1 answer

Rust: not exposing a shared library

I'm looking for best practice defining a project structure in Rust. Let's say I have a project that consists of a client and a server component, and they share some functionality I'd like to move to a separate common library. So all in all, like…
zajic
  • 135
  • 8
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

How to construct a proper values_update call using the google_sheets4 crate?

Currently, in an attempt to just get a basic example working, I have this with which I'm trying to update cells A1:A4 with the value "1". let mut req = ValueRange::default(); req.values = Some(vec![ vec![ String::from("1"), String::from("1"),…
Mogadishu
  • 213
  • 2
  • 8
1
vote
1 answer

How to connect Orion Context Broker with SQL Server

Is there any way to send the entities from Orion Context Broker to SQL Server by using docker compose file? Right now, Orion subscribes to the entities and Quantum Leap notifies the Crate DB when there is a change for those entities. However, Crate…
John
  • 410
  • 1
  • 9
  • 21
1
2
3
…
9 10