139 questions
1
vote
1
answer
46
views
Authentication for CrateDB SU crate failed using CrateDB 5.10.3 with JDBC Driver
I'm trying to connect my CrateDB (running locally) with Java using JDBC.
public class Main {
private static String connectionURL = "jdbc:postgresql://localhost:5432/";
public ...
- 11
0
votes
1
answer
137
views
Connecting CrateDB using JDBC driver from python
import jaydebeapi
print("LOADING.....")
conn = jaydebeapi.connect(
"io.crate.client.jdbc.CrateDriver",
"jdbc:crate://127.0.0.1:2000/",
["user", &...
- 13
0
votes
1
answer
224
views
How should I export results of cratedb database from a remote server
In self-host red hat managed remote server I have connected to cratedb and done some queries in python script then how should I export results of database to another tool or anything else
Like for ...
0
votes
1
answer
79
views
Why Orion-ld after 0.8.0 is not supporting the formation of service/subservice in quantumleap logs?
Any version of orion-ld after 0.8.0 is not supporting the formation of service/subservice in quantumleap logs, thereby no table-schema formed with "mt" prefix in crate-db. But tables are ...
- 25
2
votes
1
answer
116
views
How to get the missing table Schema while using quantumleap in cratedb using orion LD context broker though the subscriptions are working?
{
"cols": [
"schema_name"
],
"rows": [
[
"blob"
],
[
"doc"
],
[
...
- 25
1
vote
1
answer
93
views
How to send NGSIv2 metadata to CrateDB
I need to send attributes in the northbound direction containing metadata to the CrateDB time series. Sample of the attribute format:
{
"object_id": "AGV_Error",
"name&...
- 759
0
votes
0
answers
203
views
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}
...
- 47
0
votes
1
answer
98
views
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....
- 654
0
votes
0
answers
43
views
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 ...
- 654
0
votes
1
answer
83
views
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 ...
- 654
0
votes
1
answer
135
views
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 ...
- 93
1
vote
0
answers
210
views
How to do round-robin queries to multiple nodes in a CrateDB cluster from pgx?
I'd like to connect to multiple nodes in a CrateDB cluster from pgx and execute queries in a round robin fashion.
Ideally if a node fails queries would be retried on the other nodes.
There's a client ...
- 11
1
vote
1
answer
234
views
CrateDB as timeseries database for Django
I am trying to use CrateDB as timeseries database for Django. I am deploying both services on docker for development.
I started by deploying the following versions:
Django: 4.1.3
CrateDB: 5.1.0
...
- 759
0
votes
1
answer
207
views
CrateDB drop column not working and throwing an error
Hello stackoverflow so I have a cratedb database instance with about 3 million records in my table. I am trying to run the following command.
ALTER TABLE "transactions_v2" DROP COLUMN "...
- 353
0
votes
1
answer
325
views
What can be the reason why I can't connect to CateDB with grafana and locally with Dbeaver?
Cheers
I am currently trying to reproduce the tutorial to develop an application / solution with Fiware seen in: Desarrolla tu primer aplicación en Fiware and I am having difficulty connecting Grafana ...
