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

Crate AMI Performance Lower With Flask-RESTful Endpoint on EC2

Launched a Simple Crate AMI EC2 Instance and opened up the ports for Crate on 4200 and 5000 for Flask. When I run the EC2 instance with Crate AMI, the speeds are slower but still fast enough (~1-2 Second), but when I call the same with the Flask…
Augmented Jacob
  • 1,567
  • 19
  • 45
0
votes
1 answer

Creating a CA certificate (.pem) file to connect to crate database

I am trying to connect to a crate database with python from crate import client url = '434.342.435.2:4400' # Faked these numbers for purposes of this post conn = client.connect(url) It seems like I need to pass the cert_file and key_file arguments…
Alex
  • 12,078
  • 6
  • 64
  • 74
0
votes
1 answer

camelCase Column Names in CrateDB crash vs JDBC

Does CrateDB allow having upper case or camel case attribute names for object columns? I have a table like this: create table objecttest( age integer, name string, attrs object ); Using the insert statement: insert into objecttest…
claus
  • 377
  • 2
  • 9
0
votes
1 answer

Set the right partitions for Crate Database

I am modelling for the Database CrateDB. I have an avg. of 400 customers and the produce different amounts of time-series data every day. (Between 5K and 500K; avg. ~15K) Later I should be able to query per customer_year_month and per…
duichwer
  • 157
  • 1
  • 14
0
votes
1 answer

How should i evaluate the insert benchmark from CrateDB?

I am trying to understand and interpret the benchmark which is provided from CrateDB. (https://staging.crate.io/benchmark/) I am interested on how many elements can be inserted during one second. I know that this may vary on the size of the tuples.…
duichwer
  • 157
  • 1
  • 14
0
votes
1 answer

Crate Common Crawl Example not working

I am trying to use this example of Crate with Common Crawl: https://github.com/crate/crate-commoncrawl I have setup the Crate and even created the table schema using the instructions from the example. I am accessing CRATE using the URL:…
Jaffer Wilson
  • 7,029
  • 10
  • 62
  • 139
0
votes
1 answer

Does Crate.io support nested documents

I couldn't find the answer in their documentation. I know they support complex objects, but i want to know if they support nested documents that are mapped with the nested document schema as in elasticsearch, which should allow querying capabilities…
Roman
  • 2,108
  • 1
  • 18
  • 20
0
votes
2 answers

Spring Data Crate custom queries

I am trying to implement Spring Data Crate API in a project. Following the instructions provided here: https://crate.io/a/using-sprint-data-crate-with-your-java-rest-application/ Inserts/Updates/FindById methods are covered. My question is how to…
Rod Salas
  • 5
  • 1
0
votes
1 answer

Crate fulltext query syntax

I'm thinking about migration from Sphinx to Crate, but I can't find any documentation for fulltext query syntax. In Sphinx I can search: ("black cat" -catalog) | (awesome creature) this stands for EITHER exact phrase "black cat" and no term…
Anton Burtsev
  • 55
  • 1
  • 6
0
votes
1 answer

Crate database - relation between shards and partitions and nodes

I am new to crate database and trying to understand relation between shards, partitions and nodes. How many partitions corresponds to one shard? Can I configure to send data of a particular partition to be part of particular shard? Can I…
vinayakshukre
  • 185
  • 1
  • 10
0
votes
1 answer

java.sql.SQLException: Validation failed for : 'null' cannot be cast to type double

I am using logstash to create a pipeline from elasticsearch to crate.io. Below is the config. input{ elasticsearch { hosts => ":9200" index => "index1" query => '{ "size":10,"query": {"match_all": {} } }' } } filter{ …
ashivan
  • 23
  • 8
0
votes
1 answer

crate.io jdbc connection failed

I've just started playing around with Crate (version crate-0.55.2). I want to connect to Crate via JDBC. Here's my sample java code: import java.sql.*; //import io.crate.*; public class CrateTestDemo { private Connection connection; public…
mi_h
  • 54
  • 5
0
votes
2 answers

Crate.io - failed to send join request to master

I am trying to connect two Crate.io nodes which are in different data centers. Node 1 is the master and is already running. When I try to get Node 2 to join the cluster I get the following error:- [2016-06-23 09:29:30,475][INFO ][discovery.zen]…
boeing
  • 302
  • 7
  • 19
0
votes
1 answer

Can't add column to Crate table

I have an existing table created some time ago. The table is on a Crate cluster with 3 nodes. All notes are running version 0.54.9. When I run the following command: ALTER TABLE my_table ADD COLUMN size integer I get the following error involving…
jeteon
  • 3,471
  • 27
  • 40
0
votes
1 answer

What is the recommended memory requirement for a Crate host?

How much memory does a production node need to have to be sure that all features works correctly? For example, for a dataset between 5GB and 100GB of data.
strobe
  • 519
  • 2
  • 5
  • 21
1 2 3
…
9 10