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

Crate db metrics integration with jmx_exporter

Hi I want crate db metrics like number of connections exposed via an api. I got to know that this can be done through crate/jmx_exporter(https://github.com/crate/jmx_exporter). I have very little knowledge of java agents and jmx. Its not very clear…
Divya Spoorthy
  • 1
0
votes
1 answer

Group By day for custom time interval

I'm very new to SQL and time series database. I'm using crate database. I want to aggregate the data by day. But the I want to start each day start time is 9 AM not 12AM.. Time interval is 9 AM to 11.59 PM. Unix time stamp is used to store the…
avancho marchos
  • 180
  • 1
  • 1
  • 9
0
votes
0 answers

date_trunc value in Unix second , CrateDB

Im trying to group a set of data using date_trunc. But after executing the data i got the grouped data in Date format (DD/MM/YY). How to get it to second using query ? Table Sensor ---------------------------------- | sensorid | reading | timestamp…
june alex
  • 244
  • 4
  • 17
0
votes
1 answer

fiware quantumleap insert into cratedb not working (schema missing)

goal Use qunatumleap to move data into a crate_db to display later using Grafana. what I did follow tutorial to setup Docker images setup opc-agent to provide data to the orion broker setup quantumleap to move data from broker to crate_db on…
krenda
  • 3
  • 2
0
votes
0 answers

How to create NpgsqlConnection in C# Dotnet Core Application without DbContext

I have a C# Dotnet Core console Application. I am trying to connect NpgsqlConnection for PostgreSQL database (which is crate db). Im using this database for time series entry.I created the NpgsqlConnection in constructor of service.it's called…
june alex
  • 244
  • 4
  • 17
0
votes
0 answers

Why Alter Table Primary key is not possible - Crate DB

I can't find any info about dropping primary key in documentation of cratedb but we can drop CHECK constraint. ALTER TABLE table_ident DROP CONSTRAINT check_name below link says -there is no way to delete Primary KEY. Alter Table Primary key -…
Precision
  • 61
  • 1
  • 2
  • 8
0
votes
1 answer

How to connect crate database using .NET Npgsql client in docker environment

Im using .NET Npgsql client for crate database cratedb .Crate database is running as a docker, dcoker command is sudo docker run -p "4200:4200" crate But when i connect database through Npgsql client there is no error shows but connection is not…
june alex
  • 244
  • 4
  • 17
0
votes
1 answer

crateDB read 10k rows without iteration in Npgsql C# client

I have 10k row data in crate database. How to read the data without iteration. I am using crateDB C# Npgsql client for my service. var connString = "Host=myserver;Username=mylogin;Password=mypass;Database=mydatabase"; await using var conn = new…
june alex
  • 244
  • 4
  • 17
0
votes
1 answer

How to delete empty partitions in cratedb?

Cratedb:4.x.x We have one table in which we are doing partition based on day. we will take snapshot of tables based on that partition and after taking backup we delete the data of that day. Due to multiple partition, shards count is more than 2000…
NIrav Modi
  • 6,038
  • 8
  • 32
  • 47
0
votes
1 answer

Connecting JDBC sink connector to CrateDB

I am trying to run the jdbc sink connect with cratedb as a sink, as mentioned here. I wanted to run in docker so I created containers for the connector and for my cratedb. But upon running, I keep getting the following error in the logs. Docker logs…
Haritha
  • 167
  • 2
  • 4
  • 16
0
votes
1 answer

CrateDB number of shards and performance

so i have this table : CREATE TABLE DATA.history ( modemId text PRIMARY KEY, generationDate timestamp PRIMARY KEY, eventId integer PRIMARY KEY, speed double, altitude double INDEX OFF, latitude Double INDEX OFF, longitude Double…
cmontecinos
  • 11
  • 1
0
votes
1 answer

Can FIWARE context providers be used for historical data with QuantumLeap?

FIWARE offers using context providers to fetch data from external sources for entities that are queried through the context broker. With QuantumLeap, historical data can be stored in a time series database such as CrateDB. Is it possible to combine…
computerman
  • 135
  • 6
0
votes
1 answer

Error - mismatched input 'SWAP' expecting 'REROUTE' in CrateDB for Alter Cluster query

I am upgrading CRATE DB from version 2.x to 3.1.6 as per suggestion when I try to upgrade tables created in version 2.x using document, https://crate.io/docs/crate/reference/en/latest/admin/system-information.html#tables-need-to-be-upgraded In step…
Tushar Sutar
  • 1
  • 1
0
votes
1 answer

Restore snapshot from another Crate Cluster repository

I have a repository with snapshots in a AWS S3 bucket created from a Crate Cluster. Now I need to migrate the data to a new Crate Cluster but I cannot restore the snapshots from the previous Crate Cluster. Is that even possible? To restore snapshots…
ALeX
  • 13
  • 1
  • 3
0
votes
1 answer

CrateDB, How to drop all tables prior to restore?

CrateDB needs tables to be dropped before a restore. Options unavailable: @SQL Multiple statements copied into console/crash cli Is there an easy way to do this?
chris.fy
  • 177
  • 1
  • 12
1 2 3
…
8 9