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

Running CrateDB on a single server

Is one node related to one VM or PC ? Is a server the same as a node. Can CrateDB run on only one node/server. If "yes" does it makes sens to run CreateDB in production on one node/server (e.g. small server with a raid).
Urs
  • 19
  • 1
1
vote
1 answer

Crate db cannot query data in a shard

I have a instance of Crate 1.0.2 and I dropped a table from it. Then re-created table with same name and slightly modified schema. Then I imported data using copy from command. File argument to copy from command consists of 10,000 records and copy…
vinayakshukre
  • 185
  • 1
  • 10
1
vote
0 answers

Crate.io: Can't connect remotely

I've installed a Crate DB on a Virtual Machine Ubuntu (xenial). Since I want to connect to it from both my VM and my Windows host, I've tried to set the VM's IP on both params in crate.yml: network.host network.publish_host The rest of the…
Will1v
  • 143
  • 2
  • 11
1
vote
2 answers

Start ERROR: E is not a recognized option

Crate Version : 2.1.5 OS : Windows I have an error when starting whith crate.bat: PS D:\Dev\Crate\crate-2.1.5\bin> .\crate.bat starts CrateDB Option Description -C Configure a setting -V, --version Prints CrateDB…
user8467070
  • 11
  • 1
1
vote
2 answers

Crate DB Timestamp query

I have created a table in crate DB with timestamp column. However while inserting records into it, there is not timezone information passed along as mentioned in the docs. insert into t1 values(2,'2017-06-30T02:21:20'); this gets stored as: 2 |…
Nachiketh
  • 193
  • 2
  • 18
1
vote
2 answers

Crate.io: Facets for search?

Does https://crate.io support facets (for faceted search)? I didn't find anything in the docs. ElasticSearch replaced facets with aggregations in 2014, but the aggregation section in the crate docs only talks about SQL aggregation functions. My use…
cweiske
  • 30,033
  • 14
  • 133
  • 194
1
vote
1 answer

Is it possible to use UNION ALL in CREATE query?

crate version: 1.1.3 I can't find union all syntax in CREATE to do complex query, I also search the doc, but got nothing (SELECT col1, col2, col3 FROM tab1) UNION ALL (SELECT col1, col2, col3 FROM tab2) how to execute this sql in crate
MayI
  • 53
  • 1
  • 9
1
vote
2 answers

Is it possible to download CrateDB results in CSV file?

I need to query the database, and drop the results in a csv file. I remember I did this with sql server, is it possible to do this CrateDB?
juan garcia
  • 1,326
  • 2
  • 23
  • 56
1
vote
1 answer

Crate join queries takes too much time

Pre Requirement : I need to find all the matching result in one query which is more than 40K results. Requirement : Two tables - product and product_category. I am trying to fetch all the products with matching category from product_category table.…
Sanjay Kumar
  • 1,474
  • 14
  • 22
0
votes
0 answers

Fiware QuantumLeap Error when receiving subscription message "AttributeError: 'int' object has no attribute 'get'"

Fiware QuantumLeap throws an Error when receiving a subscription message from Orion-LD: time=2023-04-10 09:05:48.876 | level=ERROR | corr=None | from=172.24.0.8 | srv=None | subserv=None | op=log_exception | comp=server.wsgi | msg=Exception on…
timka
  • 1
0
votes
0 answers

Data loss when using Fiware Orion Broker, QuantumLeap and CrateDB

I'm using Fiware Orion Broker, QuantumLeap and CrateDB, with the aim of recording all temporal data in cratedb. My docker-compose configuration is this: orion: image: fiware/orion:${ORION_VERSION} hostname: orion container_name:…
Nuno Rolo
  • 25
  • 8
0
votes
1 answer

Group data with a single statement on CrateDB nested SELECT

How can I group the following query to the time frame in CrateDB? SELECT * FROM ( SELECT ( SELECT date_bin('1 day'::INTERVAL, time_index, 0) AS time_frame, count(*) FROM schema.status WHERE processstatus IN ('State_01') …
drypatrick
  • 437
  • 1
  • 4
  • 17
0
votes
0 answers

Avoid duplicate columns select on nested select

In CrateDB is there a way to avoid to re-select the same column in nested SELECT statement, to show the value in the results? e.i. in the following query, is there any way to avoid re-selecting A and B through the nested SELECT? Ideally would be…
drypatrick
  • 437
  • 1
  • 4
  • 17
0
votes
1 answer

Keep update a table created from another table

In CrateDB, after creating a table from data of another table, is it possible to keep the new table updated with the insertion of new lines from the original table? Query to create the new_table from enter code here: CREATE TABLE…
drypatrick
  • 437
  • 1
  • 4
  • 17
0
votes
1 answer

Multi-value object search in CrateDB when this one is within an array of objects

I'm trying to migrate our current ES to CrateDB and one of the issues I'm facing is searching for two specific values within the same object when this object is part of an array of objects. CREATE TABLE test.artefact ( id INTEGER, …
Skeith
  • 101
  • 5
1 2
3
…
8 9