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 Snapshot size

I have setup a python script which creates a crate db snapshot everyday at noon. The query I ran to setup the repo is: CREATE REPOSITORY repo_name TYPE FS WITH (LOCATION='/path/to/folder', compress=true); The query I run everyday in order to create…
Kunal Jagadish
  • 95
  • 2
  • 8
0
votes
1 answer

Index corruption on large table

I have a large table with around 123 million records in cratedb. I noticed that during a snapshot to s3 (or indeed to file system) an index corruption occurs on each shard. Consequently this causes a partial snapshot. Once crate is restarted the…
metase
  • 1,169
  • 2
  • 16
  • 29
0
votes
1 answer

Setting Up CrateDB 4.0.4 Cluster

I am trying to set up a CrateDB 4.0.4 Community Cluster with 3 Nodes in Docker. Update: At the end I got the cluster in crate 4.0.4 coming up. It only worked for me with Cnode.name property. By using the Hostname cluster did not come up. crate01: …
Benedikt Luecke
  • 31
  • 3
0
votes
1 answer

Logstash support for Crate DB

I'm trying to import data from Crate DB(https://crate.io) to logstash using logstash jdbc input plugin. But I'm getting this error. "LoadError: no such file to load -- sequel/adapters/crate" I've included crate DB driver in configuration with…
Mathivanan
  • 371
  • 2
  • 16
0
votes
1 answer

Can you bulk import in crateDB in a table with an array of objects column?

So I run CrateDB 3.3.3 and I have a table which has a column of type array of objects CREATE TABLE IF NOT EXISTS "doc"."testarray" ( "id" INTEGER, "myarraycol" ARRAY(OBJECT (DYNAMIC) AS ( "avg" DOUBLE, "eventconditiondefid" INTEGER, "max"…
Danielle Paquette-Harvey
  • 1,691
  • 1
  • 16
  • 31
0
votes
1 answer

Query Crate Database by SQLAlchemy Dialect: No more Servers available

I'd like to give it a try with crate. I first tried it by loading some twitter data and query from admin UI successfully. However, when I tried to make a query with SQLAlchemy, I've got the following error. OperationalError:…
bensw
  • 2,818
  • 5
  • 21
  • 31
0
votes
1 answer

CrateDB 3.3 - Can't get COPY FROM to import a CSV file in Windows

I'm getting errors attempting to import a csv on Windows, can someone provide the correct syntax? I'm trying this: copy checking from 'file://C:\Users\jdoe\Downloads\testfile.csv' return summary; and variations and get a…
MRB
  • 39
  • 4
0
votes
1 answer

Create.io Order of column when creating a table

I have CrateDb version 3.2.7 running under Windows Server 2012. I create a table like this: create table test3 (firstcolumn bigint primary key, secondcolumn int, thirdcolumn timestamp, fourthcolumn double, fifthcolumn double, sixtcolumn smallint,…
Danielle Paquette-Harvey
  • 1,691
  • 1
  • 16
  • 31
0
votes
1 answer

Crate.io Copy From 0 rows affected

I have a Crate.io database, running CrateDB version 3.2.7, under Windows Server 2012. (I know it's not the best, it's only for testing purposes right now and will not be the final setup.) I have create the table dbo.snapshots I exported the data…
Danielle Paquette-Harvey
  • 1,691
  • 1
  • 16
  • 31
0
votes
1 answer

Internal db logic/operation to group/compress result

I have a CrateDB table storing various information for zipcodes. It contains around 30k zipcodes, and I need my query to return certain profiling information for all zipcodes at once. I understand that typically it wouldn't be feasible, but since I…
Alexander Tsepkov
  • 3,946
  • 3
  • 35
  • 59
0
votes
4 answers

How to write cratedb migration scripts ? Migration Scripts not working

we have a database which has a table called Students with columns id,name,age,school. Now i want to write a migration script to copy 3 columns (lets assume i have millions of records) from Students table to New_students table . Below is my sample…
LearnerForLife
  • 147
  • 1
  • 12
0
votes
0 answers

io.crate.shade.org.postgresql.util.PSQLException: FATAL: trust authentication failed for user "ABC"

I have a cratedb and i do have a ssh access to that machine . Lets say my username is ABC . So i have written a spring boot code , which uses jooq and connects to the crate db to query . Whenever i try to execute my query through my rest api ,…
LearnerForLife
  • 147
  • 1
  • 12
0
votes
1 answer

How can I use the es client to query crateDB

I wanna query crateDB through ES client.But failed I set the es.api.enabled: true in the crate.yml and I used the ES java-rest-high-level-client to connect crateDB via port 4200, but I cannot get any response public class crateAPI { public…
Spike
  • 5
  • 2
0
votes
0 answers

Mass updates in crate

sorry for my English, I write through Google translator. I use cratedb and PHP. I have a table (cakes) in crate, that currently has 1 million records. For part of the records, I want to do an update on a condition on column lastmode. Do select to…
remaru
  • 1
0
votes
1 answer

How to load data from a sensor into CrateDB?

We have a sensor that publishes data to a TCP socket. How could we create an ingest rule in CrateDB to read from that specific socket? Do we need to use MQTT to read data from the Socket and then publish it as topics so a CrateDB ingest rule can…
romulog
  • 33
  • 5
1 2 3
…
8 9