Stack Overflow
Stack Overflow

Questions tagged [crate]

Avoid this ambiguous tag. For CrateDB, use [cratedb]. For Rust crates, use [rust-crates]. For Ruby crate, use [ruby-crate].

CrateDB is a new breed of database to serve today’s mammoth data needs. Based on the familiar SQL syntax, CrateDB combines high availability, resiliency, and scalability in a distributed design that allows you to query mountains of data in realtime.

More questions? Join us on Slack!

148 questions
1
vote
2 answers

Starting a node with an specific HEAP amount in crate.yml

I'm editing the Crate.yml file in order to start a new node, my file is: cluster.name: name node.name: "name" node.master: true node.data: true CRATE_HEAP_SIZE: 4g When setting up Crate heap with 4g of RAM, it doesn't work when creating the…
Andres Palacios
  • 23
  • 3
1
vote
2 answers

What are the concerns of using Crate.io as a primary datastore?

If I am correct, crate (crate.io) is backed by Elasticsearch (Lucene). Weren't there a few articles a month ago that said that ES lost some writes under heavy load? Are there any other concerns?
user3918343
  • 11
  • 2
1
vote
1 answer

Does anyone have any luck with running multiple crate.io nodes on virtualized environment?

I'm using crate.io to test replication between nodes. I've two instances running on two separate Ubuntu machines running on VirtualBox on the same local network. The instance is not able to recognize additional nodes - seems like each one is running…
Rajesh Beri
  • 33
  • 1
  • 3
1
vote
0 answers

Shards remains unreplicated

I met the problem of a small number of shards of a large table remains in the state of "Underreplicated". My small cluster has 5 nods to hold this single table. This table has 200M records, 5 shards, 2 replicas (partitioned into 200 partitions). And…
Newair
  • 33
  • 2
1
vote
3 answers

Importing data from csv files into Cratedb

I have created a table in Crate 0.38.x with columns having integer, string and timestamp data types. I want to load data into this table from delimited text files. Is there a utility to do a bulk import? Sorry, but I could not find one in the…
user3769537
  • 13
  • 3
1
vote
1 answer

How to Convert MYSQL Polling Database Structure into CrateData Tables

Hi, I just want to convert this Mysql Table structure into crateData tables. Below is list of tables associated with this Polling App. user (User details) Poll (Poll details) Rating (Rating for a poll) PollComment (Comments belongs to a poll by…
Ramesh_D
  • 689
  • 1
  • 7
  • 25
1
vote
1 answer

Updating an array of objects fields in crate

I created a table with following syntax: create table poll(poll_id string primary key, poll_type_id integer, poll_rating array(object as (rating_id integer,fk_user_id string, israted_image1 integer, israted_image2 integer, updatedDate timestamp,…
Ramesh_D
  • 689
  • 1
  • 7
  • 25
1
vote
1 answer

ES to Crate data transfer

I want to migrate the data from ES (1.0.0) to Crate (currently available version 0.26.0) to check it out, how could I do it? What should I do with indexes, does ES index fit Crate? One might think of several flows: Smooth transition, e.g. when I…
Vlad Vlaskin
  • 110
  • 8
1
vote
1 answer

Stopwords in Crate Fulltext Search

I'm using Crate for a german news site and use fulltext search extensively (which generally works well enough). However I was wondering about stop words usage. I'd like to minimize this since search is plenty fast so I'm not too worried about…
Peter Sabaini
  • 45
  • 1
  • 5
0
votes
1 answer

Subscription between Orion context broker and Quantumleap works, but table is not created in CrateDB

Cheers! I've been working for a couple of months with Fiware, using Quantumleap and CrateDB to store historical data (which will then be displayed in Grafana). I have created about 14 successful subscriptions through Postman for different sensors,…
Galhrrera
  • 5
  • 2
0
votes
1 answer

How do I read user input in uefi-rs (UEFI Rust wrapper)

I want to know if there is any way I can read user input in UEFI using the uefi-rs Rust wrapper. (or possibly any other way I can gather user input in UEFI with Rust) I have tried many different approaches with read_key, the key event, and one…
Skyslycer
  • 43
  • 5
0
votes
1 answer

How can check if data is inserted or not in crate db using python?

I am trying to insert data in crate DB using the crate client python package. I am not able to check if data is inserted in crate db or not? if one record is inserted in one table and another record has not been inserted into another table. How can…
Tejaswini Jadhav
  • 15
  • 1
  • 2
0
votes
1 answer

CRATE db tables are causing an error when upgrading to CRATE:4.3.4 from CRATE:4.2.7

Facing the below error while restoring snapshots or upgrade cratedb to a higher version from 4.2.7 to 4.3.4 SnapshotRestoreException[[repo_name:snapshot_name/******] cannot restore index [schema_name.table_name] because it cannot be…
hgsongra
  • 1,454
  • 15
  • 25
0
votes
1 answer

Ask for FIWARE project recommendations: 3D plot monitoring of entity attrs

The goal of the project is to plot the x,y,z coordinates (attrs from an entity) in a 3D graph which updates as they change. Note: it's not important how the value of x,y,z changes, it can be for example by hand through the prompt, using curl. At…
rluq
  • 37
  • 1
  • 8
0
votes
1 answer

SQLActionException[UnsupportedFeatureException: Unknown function: to_object_array and to_object CrateDB 4.2.7 and upwards

I'm facing below error in CrateDB after upgrading Crate version 4.1.8 to 4.2.7 error during main processing: SQLActionException[UnsupportedFeatureException: Unknown function: to_object_array(db_name.tbl_name."object_array_type_col_name")] error :…
hgsongra
  • 1,454
  • 15
  • 25
1 2 3
…
9 10