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

Text case-insitive search with crate.io SQL

What is the proper SQL syntax to search an array text in the crate database? My example table is: create table tasks(user string, entry array(object as (taskid string, eTime timestamp))). I tried the following which give a syntax error: select…
Geoffrey Wells
  • 3
  • 1
0
votes
1 answer

Create database partitioning for analyzing time-series

I have 100 000 sources/sensors/symbols. From each one I read a value on a daily basis. I load a database table with these daily data/values. One row for each value AND symbol, thats 100 000 rows per day. Query1: As I want to analyze daily data over…
user5889512
  • 13
  • 3
0
votes
1 answer

How to calculate median in Crate

I am using Crate 0.54.7 and have the following table definition: CREATE TABLE test (id int PRIMARY KEY, val int); Now I want to get the median of val. The query I used in Postgresql so far did not work: SELECT percentile_cont(0.5) WITHIN GROUP…
alippmann
  • 1
  • 1
0
votes
1 answer

Crate IN operator and args value

I am unable to send the String[] or List as an args to the "IN" operator. Can you please suggest me how to send the an input value for IN operator using crate java client.
Anil Kandacharam
  • 1
  • 1
0
votes
1 answer

Access Crate with postman through REST API?

Can postman be used to access CrateIO through the REST API ? How is the syntax different from the curl syntax.
user5889512
  • 13
  • 3
0
votes
1 answer

Recent Release of crate io with jar details

Hi Could you give me the following details 1.What is the latest release of crate io with supported jar files 1.crate io jar (version) 2 .crate jdbc jar( version)
Vinayagam S
  • 1
  • 1
0
votes
1 answer

Partitioning tables after creation using Crate

I was wondering if it's possible to do partitioning after table creation. I'm trying to import ~2 million entries in a table (cluster), and if I partition the table before adding entries I get memory exceptions.
Helge Waastad
  • 151
  • 1
  • 11
0
votes
1 answer

Backing up multi-node crate cluster

I have seen docs on how to import data but how do I do backups? Is there tooling, is there an API, or is it safe to copy the files on the file system?
denixtry
  • 2,928
  • 1
  • 21
  • 19
0
votes
4 answers

How to insert array into crate?

How do I insert an array into crate? I'm using the latest Crate-PDO, but keep receiving this notice Notice: Array to string conversion in .../Crate/PDO/PDOStatement.php on line 610 and Array to string conversion in .../myPdoClass.php on line…
Blowfish Tech
  • 11
  • 2
0
votes
1 answer

Crate write behaviour

I have a question on crate write behavior. From crate documentation One reason is that replicas are written synchronously. Thus making a write task wait for the replicas to be written somewhere in a data center hundreds of miles away can lead…
Albin Joseph
  • 1,020
  • 3
  • 16
  • 25
0
votes
1 answer

Benchmarks for Crate.io

Are there any benchmarks for Crate.io? I am particularly interested in storing a binary file (using shards and replicas of Crate.io) and to access it using the provided SQL similar language.
mojovski
  • 581
  • 7
  • 21
0
votes
1 answer

CRATE IO:search using symbol @ in crate io

Hi I am storing the email id in Crate Io but while searching i am not able to search because of the @ symbol its not searching the records.is there any solution for this problem?
Lakesh Kumar
  • 3
  • 1
0
votes
1 answer

Is there http health monitoring in crate?

is there an interface in crate like there is in ES - like this one /_cluster/health?pretty=true I know i can enable the ES one, just wondering if there was one more specific to crate.
mike_l
  • 108
  • 6
0
votes
2 answers

How to add geopoint array, via PDO to crate*

I have crateio set up and it's working fine using the PDO class. I'm, trying to get a set of geopoints into the db using binds. I have tried foreach but doesn't seem to work, I've tried this - which also doesn't work. The geopoint column is set to…
bazbaz
  • 53
  • 1
  • 2
  • 6
0
votes
1 answer

Does crate have an oplog to create a Meteor ddp driver from

I'm looking to develop a Meteor ddp (https://github.com/meteor/meteor/blob/devel/packages/ddp/DDP.md) driver for crate db. Currently, Meteor has native support for mongodb. Redis support has been added via…
quame
  • 1
  • 2
1 2 3
…
9
10