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
1
vote
1 answer

SQLAlchemy - override orm.Query.count for a database without subselect

I am using sqlalchemy with a database that doesn't support subselects. What that means is that something like this wouldn't work (where Calendar is a model inheriting a declarative base): Calendar.query.filter(uuid=uuid).count() I am trying to…
synic
  • 26,359
  • 20
  • 111
  • 149
1
vote
1 answer

Trying to use Crate.io NoSql database with an existing Spring Data / Mysql project

I'm attempting to add Crate.IO capability to an existing Spring Data/Eclipselink/MySql web application. For this specific use case, we want to persist data to both MySql AND Crate (for evaluation purposes) in the most painless way possible. I'm…
looselycoupled
  • 629
  • 1
  • 7
  • 16
1
vote
2 answers

How to specify multicast group for Crate cluster

I'm currently trying to make a cluster of N nodes on n computer. But (I'm not a network expert), in my office network, multicast is only allowed on specific multicasr groups and port. I didn't find in crate config how to specify group ip, Hazelcast…
user2789185
  • 21
  • 2
1
vote
2 answers

RJDBC driver with crate do not find class

I am trying to create a RJDBC driver for crate. Whenever I ran jdbcDriver <- JDBC(driverClass = 'io.crate.client.jdbc.CrateDriver', '../../private/tmp/crate-jdbc-standalone-1.0.4.jar') I got: Fehler (Error) in…
Robert Kirsten
  • 474
  • 2
  • 5
  • 12
1
vote
2 answers

how to update array in crate

I would like to know how I can update a value stored in an array, in crate.io I have a blog table - blog_tbl A column, with data type array - tags A id column Inside the tags column I have - ["tag1","tag2","tag3"] I would to know how I would go…
Blowfish Tech
  • 11
  • 2
1
vote
1 answer

Use Crate SQL module(plugin) in Elasticsearch

I am using Elasticsearch on linux sever but Quering is a little bit difficult because form of query is not SQL structure. In crate, there is a sql plugin, so I put this plugin into my own Elasticsearch Is it possible? If not, how can I adopt Crate…
Jehyun Shim
  • 91
  • 2
  • 11
1
vote
2 answers

Search inside full search column using certain letters

I want to search inside a full search column using certain letters, I mean: select "Name","Country","_score" from datatable where match("Country", 'China'); Returns many rows and is ok. My question is, how can I search for example: select…
chan go
  • 137
  • 11
1
vote
1 answer

Choosing a NoSQL database

I need a NoSQL database that will run on Windows Azure that works well for the following parameters. Right now Azure Table Storage, HBase and Cassandra seems to be the most promising options. 1 billion entities up to 100 reads per second, though…
Postman Bob
  • 11
  • 1
1
vote
1 answer

Crate PDO driver installation using composer.phar fails

I'm trying to install the Crate PDO driver from here: https://github.com/crate/crate-pdo The manual says to use composer.phar like so: php composer.phar require crate/crate-pdo:~0.0.3 However, that produces the following: Your requirements could…
Michael
  • 1,247
  • 1
  • 8
  • 18
1
vote
0 answers

'In-Crate' updates instead of client programs?

This is a simplified example scenario. I collect interval temperature data from a room's heating, let's say every minute. Additionally, there is a light switch, which sends its status (on/off) when someone switches the light on or off. All events…
nodot77
  • 11
  • 3
1
vote
1 answer

Schema in crate

I have a requirement like keep two tables with same name in crate, In mysql we can achieve it using different schema. Any solution like this in crate? I saw information schema and partitioned table in crate but that not helping me in this case.
Abdul
  • 321
  • 4
  • 22
1
vote
2 answers

Crate/PDO Usage Examples

Has anyone successfully installed Crate/PDO. I seem to be banging my head against this one. I have used composer to create the json file and when i try to
Graham
  • 13
  • 2
1
vote
1 answer

Adding column(s) inside nested object columns

I've been trying to add a column in an object column inside another object column but not able to do so (for nested objects). Adding columns Adding a column inside an object is straight forward. How to add column inside nested object which is one…
Hasnain
  • 1,879
  • 2
  • 13
  • 12
1
vote
1 answer

Using CrateData to index and store 1 millions of PDF files

We are looking to find a solution that would allow us to index and store millions of PDF files. We currently use Lucene+Tika but store the PDFs on the file system as blobs (ZODB blobs). Can Crate.io be used to both index and store large amounts…
Oliver Marx
  • 73
  • 5
1
vote
1 answer

Tips for querying dynamic object fields in Crate

I have a table such as the one at the end of this question. I insert into the peers_array field a dynamically keyed array/object such as: { "130":{ "to":5 }, "175":{ "fr":0 }, "188":{ "fr":0 }, …
Dale Dude
  • 13
  • 2
1 2 3
…
9 10