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

How does cratedb handle updates to the path.data?

Specifically, regarding the pseudo-RAID0 setup: path.data: /path/to/data1,/path/to/data2 How does cratedb handle it if i add more paths to an existing node? Will it work? Will it rebalance the data or only balance as new data arrives?
nicerobot
  • 9,145
  • 6
  • 42
  • 44
0
votes
1 answer

does crate have a slow log to show like elasticsearch

i did some pressure measurement on crate-1.1.1，and got a very low tps, 300 more or less, there 2 Physical machine and 10G JVM , 3G data and 14 shard, 70+ fields, my sql is just like : > select count(*) from mytable where field1='abcd' and…
tony
  • 3
  • 4
0
votes
1 answer

can not compile cratedb correctly

i download the source of cratedb, but can not compile correctly,here is the detail: jdk:1.8 /workspace/crate$ ./gradlew compileJava :compileJava UP-TO-DATE :es:es-core:compileJava UP-TO-DATE :es:es-core:processResources…
tony
  • 3
  • 4
0
votes
1 answer

Expression evaluated to TRUE does not take affect in WHERE clause

Take a look at the following three queries. I cannot understand how a condition that evaluates to TRUE will not return rows when attached to where clause. I expect to get User1 in the second query, as the first query shows that the condition…
pjotr_dolphin
  • 1,207
  • 9
  • 34
0
votes
1 answer

How to "GROUP BY" array column in Cratedb

For example I have the following script: CREATE TABLE test ( items array(string) ) INSERT INTO test (items) VALUES (array['a', 'b']); INSERT INTO test (items) VALUES (array['a']) Is it possible to count number of items in the table?…
Maxim Vershinin
  • 13
  • 4
0
votes
1 answer

Log file configuration using Crate.IO database docker image

The docker image is generating logs on console. Is there any configuration to setup rolling log files
Raman
  • 11
0
votes
1 answer

Setting up CrateDB on an ec2

I've got an ec2 running the CrateDB AMI. It's in a security group that allows incoming traffic on ports 4200 and 4300. And it's running under an IAM that allows DescribeInstances. I've verified this much is working by connecting through the web…
Lucian Thorr
  • 1,997
  • 1
  • 21
  • 29
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
1 answer

Bulk inserts and INSERT INTO IGNORE with CrateDB

I'd like to insert huge amounts of data, What should I use: Single insert into statements, or do I have to use bulk inserts? Is there something else? The reason I ask is, that my CrateDB node's disk is only busy at 11kb/s on average while the disk…
claus
  • 377
  • 2
  • 9
0
votes
1 answer

How to group by multiple columns in cratedb

Can someone help me on group by multiple columns in crate? For ex. SELECT COUNT(1), x, y from table GROUP BY x,y Thanks in Advance.
Carbonrock
  • 457
  • 2
  • 15
-1
votes
1 answer

CrateDB statement returning unexpected results during AND comparison

I have a query as such SELECT "deviceId", "transactionStatus" FROM scp_service_transaction.transactions_v2 WHERE "tenantId" = 'aptos-denim' AND TRY_CAST("deviceId" AS BIGINT) >= 100 AND TRY_CAST("deviceId" AS BIGINT) <= 150 ORDER BY…
The Coder
  • 293
  • 2
  • 15
-1
votes
1 answer

Unable to use Crate JDBC 2.6.0 in read only mode

I want to restrict delete/update statements This is what I am trying ResultSet rs = stmt.executeQuery("delete from test where id=243640033") Ideally executeQuery method of JDBC should not allow update, delete and etc. But Crate Database is simply…
Chandan
  • 640
  • 4
  • 10
-1
votes
2 answers

How to edit/drop analyzers in CrateDB?

In CrateDB's documentation: https://crate.io/docs/crate/reference/en/latest/sql/statements/index.html there's no reference as to how to delete an analyzer or to edit it? I have a sample query, and executing it multiple times gives no errors: CREATE…
PIYUSH CHUGH
  • 304
  • 4
  • 15
-1
votes
2 answers

Does Crate IO database supports backup from one cluster and restore to different cluster?

If we persist snapshots from one cluster, is it possible to restore these snapshots in different Crate IO cluster? If it has same schema?
Raman
  • 11
-2
votes
3 answers

Split string in MYSQL via CRATE

I want to split a string in CRATE. I tried with substr, but it takes only substr(string,long,long). I want something like a function which can take delimiter string. Example : value=1234-5656 select SUBSTR(value, '-',1) as first from XYZ; I want to…
goosebump
  • 96
  • 1
  • 2
  • 13
1 2 3
…
8
9