Stack Overflow
Stack Overflow

Questions tagged [cratedb]

Use this tag for questions related to CrateDB - an SQL-based database management system.

CrateDB is a database management system (DBMS) for Windows, Mac, and Linux designed to provide classic SQL-based access alongside with fast search capabilities. For more information please refer to https://crate.io.

136 questions
0
votes
1 answer

Is there automatic load balancing in CrateDB?

I am currently evaluating CrateDB and came up this question. I know that CrateDB proudly claims itself to be a no-config database. So, is there automatic load balancing? Or is it possible to add a load balancer before the dabase? After browsing the…
Georg Muehlenberg
  • 546
  • 2
  • 18
0
votes
1 answer

CrateDB cpu vs ram vs more nodes

I'm trying to setup CrateDB in Google Cloud for analytics through Metabase, availability is not important, the data can be reloaded, just query speed. Largest table is 50 million rows 40 columns. All tables are denormalized. What is more beneficial…
rubenmch
  • 143
  • 1
  • 5
0
votes
1 answer

Is there a way to clone data from CrateDB into Crate running on a new container?

I currently have one container which runs Crate, and stores all its data in the /data/ directory. I am trying to create a clone of this container for debugging purposes -- ideally, the clone would be running Crate (which I can query) using the exact…
viswajithiii
  • 449
  • 4
  • 8
0
votes
1 answer

Accessing crateDB via Apache Drill

I need to access data in my crate database via Apache Drill. Far as i have read, crate has a PostgreSQL interface, but that is not compatible with the PostgreSQL interface exposed by drill. There isn't much information on this available on the…
wingjammer1990
  • 1
  • 1
0
votes
1 answer

timeseries insert performance

I try to load a bunch of data from my SCADA System to CrateDB (4 Years, multiple CSV files, about 87GB, some billions of datapoints/rows). Writing of data is currently slow. How can i improve the speed of inserting rows? I use the crate JDBC driver…
Andreas Vogler
  • 117
  • 8
0
votes
2 answers

Alter Table Primary key - Crate DB

I want to alter a table in my Crate DB to change the primary key constraint to add a column to the existing one. If I need to drop the constraint and create a new one what would be the SQL syntax for the same. I have been trying the conventional SQL…
Nachiketh
  • 193
  • 2
  • 18
0
votes
1 answer

CrateIO 2.0.2 - Problems with Insert and Update

I've done an upgrade from Crate 1.1.4 to 2.0.2. After this I've also optimized all tables. Crate runs at one server with one instance. I have not changed any default settings, except the node name and the cluster name. But now I can't write anything…
Ragin
  • 23
  • 1
  • 5
0
votes
1 answer

Crate DB with Nginx Binding

I was wondering is there a way to bind Nginx web server with CrateDB Backend to receive JSON data over https and store them in the CrateDB.So basically CrateDB should run as an appserver with nginx binding. The longer route would be to use php or…
Nachiketh
  • 193
  • 2
  • 18
0
votes
1 answer

how to write a systemd service file for crate

I want to set crate boot with the redhat,so I write a systemd service file for crate: crate version: 1.1.2 following is crate.service: [Unit] Description=crate daemon After=network.target [Service] Type=forking ExecStart=/usr/bin/su - hadmin -c…
MayI
  • 53
  • 1
  • 9
0
votes
1 answer

How to add index to an existing table?

I create a table and filled it with approx 1Mio data. But now, the select query takes up to 16 seconds (select by date). How can I add an index to an existing table to improve the search performance? I dont quite get it from…
mojovski
  • 581
  • 7
  • 21
0
votes
1 answer

Writing values in serial fails to update immediately

I am trying to write many values into the create-io DB using a python script. Since crate does not support an auto-incrementer for fiels like ID, I query the last ID and use (+1) for the next one. However, when I send a "insert into..." command, the…
mojovski
  • 581
  • 7
  • 21
0
votes
1 answer

Problems with distinct?

At my Crate.io Database I have a table with currently 50 mio rowsand a size of 16GB. If I try to get the amount of entries per day with the following statement all works fine (except the performance, but this should not be the problem at the…
Ragin
  • 23
  • 1
  • 5
0
votes
1 answer

how to handle floating-point in cratedb

floating-point When doing math operation in cratedb, it produces floating point, here is how I create table in crate: create table: create table cash(date string, spend float); insert into cash(date, spend) values ('2017-05-03', 55.55); insert into…
MayI
  • 53
  • 1
  • 9
0
votes
1 answer

Slow performance with NOT ANY and ORDER BY in same query

It seems like there is a strange performance hit when running a query that includes both NOT 'some string' = ANY(array_column) as well as an ORDER BY statement in the same query. The following is a simplified table structure illustrating the…
Peter Henning
  • 1
  • 1
0
votes
1 answer

cratedb set default value when creating a table

I want to set default value when creating a table using cratedb, just like what it is in mysql: here is a column name phonenum: phonenum int(11) DEFAULT '0' COMMENT 'PhoneNum' I tried, but not working in the same way using cratedb, does anyone…
MayI
  • 53
  • 1
  • 9
1 2 3
…
8
9