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

Crate DB 2 Node Setup

I'm trying to setup a 2 node Crate cluster, I have set the following configuration values on the 2 nodes: gateway.recover_after_nodes: 1 gateway.expected_nodes: 2 However the check is failing as per the documentation: (E / 2) < R <= E where R is…
Nachiketh
  • 193
  • 2
  • 18
1
vote
1 answer

CrateDB create custom analyzer

I'm trying to create a custom analyzer, following the syntax from https://crate.io/docs/crate/reference/en/latest/sql/statements/create-analyzer.html however when I attempt to create the following : create analyzer FullAddressAnalyzer ([TOKENIZER…
metase
  • 1,169
  • 2
  • 16
  • 29
1
vote
1 answer

Crate - Records ingested in Crate but records not showing via select query

I need a help for a Crate issue, I have a crate cluster of version 1.0.2. Last few days we observing strange issue related to "select query" query on Crate server. We found that via "select query" records are not showing for few specific dates…
Goutam Motghare
  • 11
  • 1
1
vote
1 answer

Crate JDBC driver load balancing issue

Q1. I have a crate cluster of version 1.0.2 and I am using older version of crate JDBC driver to connect to it from java program. I have specified all nodes of crate in the JDBC driver URL by separating them with comma. When I fire queries from my…
vinayakshukre
  • 185
  • 1
  • 10
1
vote
1 answer

How can I perform a bulk insert with python in CrateDB?

I'm trying to do a bulk insert using python in CrateDB. The command executemany doesn't really perform a bulk insert, in the same way it does with SQL Server using pyodbc. With pyodbc I can use this: cursor.fast_executemany = True to solve the…
Davide Mizzaro
  • 13
  • 3
1
vote
2 answers

CRATE DB: WHERE IN on timestamp data results in NullPointerException

The following select doesn't work: SELECT * FROM "myschema"."timetable" WHERE "start_time" in (1519705800000, 1519710840000, 1519705800000, 1519718400000) Start_time is a timestamp column. Crate responds…
Alex J Gr
  • 83
  • 6
1
vote
1 answer

How to pass a location parameter in when calculating distance?

I would like to execute the following query from my Go application SELECT hour, count FROM location_counts WHERE distance(point, 'POINT(-80.205 26.14)') <= 100 I will be passing in the POINT(-80.205 26.14) and 100 values and I'm not quite sure…
Abe Miessler
  • 82,532
  • 99
  • 305
  • 486
1
vote
1 answer

How to get ResultSet string array?

I have a query that is hitting a table that has an array column. When I am processing my records I would like to take the array column's data and treat it like a string array and grab the first value. I had assumed I could do the following: while…
Abe Miessler
  • 82,532
  • 99
  • 305
  • 486
1
vote
1 answer

Using crate's HTTP API to insert an array of objects : error 4003

I’m trying to insert a row using Crate's 2.1.8 HTTP endpoint but it fails systematically with error 4003: My table contains a column which is an array of objects and it fails with error 4003 : “SQLActionException[ColumnValidationException:…
echarlus
  • 13
  • 3
1
vote
1 answer

Streamsets DC and Crate exception. ERROR: SQLParseException: line 1:13: no viable alternative at input 'CHARACTERISTICS'

I am trying to connect to Crate as a Streamsets Data collector pipeline origin ( JDBC Consumer ). However I get this error: "JDBC_00 - Cannot connect to specified database: com.streamsets.pipeline.api.StageException: JDBC_06 - Failed to initialize…
gashey
  • 13
  • 2
1
vote
1 answer

crate.io FULLTEXT SEARCH fuzziness

I would like to use Levenshtein and Im looking for some examples. I already read the documentation, but I dont know how to implement it. I tried to build my own Analyzer, but it crashed everytime I used it. Here is the documentation I…
Wk Ali
  • 21
  • 1
  • 4
1
vote
0 answers

Error in crate.io SQL nested select

I am performing this query from the crate.io admin console, and it fails with the an UnsupportedOperationException error: Cannot create plan for: io.crate.analyze.QueriedSelectRelation Here is the query: SELECT url FROM ( SELECT url FROM…
Alex
  • 12,078
  • 6
  • 64
  • 74
1
vote
1 answer

Is there any alternative to 32K string limits?

I want to store WKT that can be quite large but I'm running into the 32K limit while storing them in object values. create table A (id integer, wkt object);
nicerobot
  • 9,145
  • 6
  • 42
  • 44
1
vote
2 answers

Can I replace mysql large table with cratedb

I have a mysql table with around 200 million records and this will soon grow to 2 billion. I am looking at options , sharding in mysql or use a different database like Cratedb. These record have 12 columns with 3 Full-Text indexed columns and a…
Ram
  • 1,155
  • 13
  • 34
1
vote
1 answer

NiFi-1.0.0 - ExecuteSQL CrateIO

I am trying to execute an sql statement (ExecuteSql proc) for creating a table, table's name is based on a filename attribute, and when ExecuteSQl gets executed, it creates the table but does not route the file to any relationship. I think this is…
bsd
  • 1,207
  • 4
  • 15
  • 28
1 2
3
…
9 10