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

Elasticsearch CrateData Compatibily?

All, I've been playing around with CrateData, and was wondering if you can utilize existing Elasticsearch tools such as drivers and add-ons like Logstash. For example, can you use an Elasticsearch river…
Nick Pavlica
  • 1
0
votes
1 answer

The efficiency of the Update Query in CrateData

When executing an update query which triggers a lot of (e.g. a million) records to be updated. As I understand, the underlying index system needs to re-ingest the doc. So for this kind of "heavy" job, is there a way to control its working load,…
Newair
  • 33
  • 2
0
votes
1 answer

What is the proper procedure for upgrading a multi-node Crate cluster?

I have a crate cluster consisting of multiple nodes. The cluster is currently running 0.39.1 utilizing the Ubuntu stable repository. I would like to upgrade to 0.40.2 with no down time on the cluster. Is it wise to simply use the ES rolling upgrade…
jeffnappi
  • 3
  • 1
0
votes
1 answer

Crate DB exception, no viable alternative at input 'VARCHAR'

I'm using Elastic search to store large amount of data to make it searchable, but for configuration items I'm still using HSQL DB. Is it possible to eliminate HSQL DB completely and use my existing Elastic search in combination with Crate DB? Things…
user3788005
  • 27
  • 1
  • 7
0
votes
1 answer

how to increase the queue capacity when doing a lot of queries in parallel?

I'm doing a benchmark with crate and insert a lot of records at the same time. It seems like I hit some limit (queue capacity 50) and I didn't find how to change the configuration. Exception in thread Thread-1: Traceback (most recent call last): …
Jodok Batlogg
  • 373
  • 1
  • 9
0
votes
1 answer

Uploading images using Crate blob table

Is it really possible to upload image using Crate Blob table. i found this link (https://crate.io/docs/reference/blob.html) which is able to upload text on blob table. Similarly, i am looking to upload images to crate Blob table. I didn't find the…
Ramesh_D
  • 689
  • 1
  • 7
  • 25
0
votes
1 answer

How to workout Arrays, objects and Arrays within object in crate?

I have done preliminary studies on Crate. Now i would like to work on Objects, Arrays and Arrays within Object using crate. It seems very basic document was given on https://crate.io/docs/current/sql/ddl.html#object. I need advanced examples using…
Ramesh_D
  • 689
  • 1
  • 7
  • 25
0
votes
1 answer

Complex Queries in Crate DB possible?

i just want to convert my all MYSQL tables into crate tables. This is actually an mobile app backend. Is it really possible in Crate to do exact query operation similar to MYSQL. I didn't see any JOIN, Intersect, union ..etc. Even i can't use…
Ramesh_D
  • 689
  • 1
  • 7
  • 25
0
votes
1 answer

Does Crate work only with HTTP protocol?

I couldn't find this information on tech specs... Although REST is very convenient to a variety of scenarios, a native protocol sounds like much more high speed. Does the current implementation support native binary protocol ?
user3047313
  • 1
0
votes
2 answers

UDFs or Probabilistic data structures in a roadmap

We're interested here in working with high-cardinality indexes. (Which are known to be a problem for Elastic Search) We already know from you that for select count(distinct high_cardinality_field) from my_table you already have some optimizations…
Vlad Vlaskin
  • 110
  • 8
-1
votes
1 answer

COPY FROM remote desktop

Is possible to upload a json file using the COPY from a remote desktop? Command: crash --host 192.100.1.15:4200 -c "COPY doc.test FROM '/test.json'" The file: {"id": 1, "name": "foo"} Error: SQLActionException[SQLParseException: Column reference…
Wk Ali
  • 21
  • 1
  • 4
-2
votes
1 answer

Selective model lib

how can i have crate that depend on with feature use another version of same crate like below [features] serde_1 = ["dep_serde_1"] serde_1_0_133 = ["dep_serde_1_0_133"] [dependencies] dep_serde_1 = { package = "serde", version = "1.0.0", optional =…
Ali Mirghasemi
  • 462
  • 2
  • 7
-2
votes
3 answers

Split string in MYSQL via CRATE

I want to split a string in CRATE. I tried with substr, but it takes only substr(string,long,long). I want something like a function which can take delimiter string. Example : value=1234-5656 select SUBSTR(value, '-',1) as first from XYZ; I want to…
goosebump
  • 96
  • 1
  • 2
  • 13
1 2 3
…
9
10