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
0 answers

Crate DB not starting up

I recently did an upgrade on my Ubuntu system, after which Crate DB process is unable to start with the following error, if anyone has run into anything similar please let me know how to get around this problem: Jan 23 14:15:44 systemd[1]: Started…
Nachiketh
  • 193
  • 2
  • 18
0
votes
1 answer

How to query based on object value?

I have a crate db table with records like the one below: { "businessareaname": "test", "profile": { "phone": "", "fullname": "", "email": "abe-10@spatially.com" } } I've tried querying with: select * from myTable…
Abe Miessler
  • 82,532
  • 99
  • 305
  • 486
0
votes
1 answer

Can Circuit break exception be avoided using horizontal scaling?

I am using crate 1.0.2 which internally uses elasticsearch. So my question is applicable for both. For certain queries I get circuit break exception. CircuitBreakingException: [parent] Data too large, data for [collect: 0] would be larger than limit…
vinayakshukre
  • 185
  • 1
  • 10
0
votes
2 answers

How to store timestamp in memsql?

I want to export data from a crate database to memsql. The crate database stores its timestamps in milliseconds based on UTC. Yet when importing this as such to a memsql database, my values get zeroed out. How should I import my timetamps in memsql?
k0pernikus
  • 60,309
  • 67
  • 216
  • 347
0
votes
1 answer

Unable to access port inside Docker

What could be wrong if the docker port cannot be accessed via the Access URL: https://hub.docker.com/r/library/crate/
quarks
  • 33,478
  • 73
  • 290
  • 513
0
votes
2 answers

error loading java classes in crate

I just updated crate via debian apt from 1.1.1. to 1.1.3. Starting crate I get following error: [2017-05-29 16:59:59,858][ERROR][bootstrap ] Exception java.lang.IllegalStateException: jar hell! class:…
Christoph
  • 69
  • 4
0
votes
1 answer

how to avoid data query laterncy in crate

crate version: 1.1.3 after inserting data into crate, I send a key to activemq to query this data immediately, but unfortunately, it failed everytime, so I sleep the thread for 2000ms, it worked, so I guess the cluster need some time to sync…
MayI
  • 53
  • 1
  • 9
0
votes
1 answer

Getting 'stuck' while querying on Crate

I ran loops and intensively queried a lot of data in each loop. My database is built using Crate. Sometimes, the loops paused since Crate didn't respond back my query results. (This is not always happening though) The pseudo code is as…
TripleH
  • 447
  • 7
  • 16
0
votes
2 answers

What's the best practice to store performance data in CrateDB?

My application stores performance time series data in CrateDB, and in order to get the setup right, I have a few questions, since it's going to be around 72M records a day and it should scale properly :). My goal is to visualize the resulting data…
claus
  • 377
  • 2
  • 9
0
votes
2 answers

Inserting objects/dictionary in an array of objects (Crate, python)

I have an array of objects in a crate table and when I make a SELECT and fetchall() command, it gives me the following list of dictionaries: [{"key": "two", "id": "1", "value": "three", "tag": False}, etc..] After that I want to change a value…
Vasile
  • 801
  • 2
  • 13
  • 31
0
votes
1 answer

How to tune cratedb to get 40000 inserts per second as mentioned in official website

I am benchmarking cratedb with each record having 40 columns and record size varies between 300bytes to 1kb. I am able to get only 500 inserts per second on single thread. Using cratedb 1.0.1 with python client. Machine having 16 CPUs and 32GB…
Carbonrock
  • 457
  • 2
  • 15
0
votes
2 answers

Crate SQL query using curl with basic access authentication

From the crate.io documentation I am told that an SQL query can be performed like this: curl -sSXPOST 'CLUSTER_IP:4200/_sql?pretty' -d '{"stmt":"select name from sys.cluster"}' The database I am trying to connect to requires a username and…
Alex
  • 12,078
  • 6
  • 64
  • 74
0
votes
1 answer

Sqoop Export from HDFS to Crate.io DB With No Error/Output

I'm trying to export my hdfs to Crate.io DB and I'm using Sqoop to do it. I've imported the required .jar files and my sqoop file looks like:…
Augmented Jacob
  • 1,567
  • 19
  • 45
0
votes
1 answer

How to query an item from an sql object (CRATE DB)

I am trying to use the new crate db. link I have a table which contains an "infrastructure" and "network" objects: CREATE TABLE servers (infrastructure object(strict) as ( #etc... os_name string, …
Vasile
  • 801
  • 2
  • 13
  • 31
0
votes
2 answers

Is it possible to issue a spatial join with shapes from two tables?

I want to be able to run a query like: select A.* from A join B on match(A.geom,B.wkt) using within; But i get: ERROR: UnhandledServerException: java.lang.IllegalArgumentException: queryTerm must be a literal Sample schema: create table…
nicerobot
  • 9,145
  • 6
  • 42
  • 44
1 2 3
…
9 10