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

FIWARE: GPS DATA ON CrateDB AND VISUALIZATION ON GRAFANA

Actually, I am experimenting with FIWARE and IoT systems and I need to visualize on Grafana the localization of a specific device using a GPS. All data that GPS sends to Orion Context Broker (OCB) is latitude, longitude, altitude and they are in…
Laura Hr
  • 21
  • 3
1
vote
0 answers

Cratedb custom sorting

For example, we have elements like 12345678 23487653 12475805 23382349 when we search for 234 I want to see order as 23487653 12345678 23382349 For searching, I am using ngram analyzer, but not able to figure out how to do the sorting.I tried…
Dhruv Pal
  • 849
  • 2
  • 10
  • 25
1
vote
1 answer

How to add TimeInstant, CreationDate and ModifiedDate into CrateDB with Orion Context Broker?

I'm setting up a Firmware-Framework, where I unforutunately have to add historically Sensor Values. But I also need the creationDate and the modificationDate for other usecases. Therefore I add the Attribute "Metadata" with the variable…
Hirschdude
  • 127
  • 3
  • 10
1
vote
1 answer

Crate DB - Exporting tables to different S3 endpoint with COPY TO command

I have a need to export a Crate DB table to S3, I can do this with COPY TO command by providing s3 endpoint. But I need this to be exported to a different S3 endpoint and not default AWS S3 endpoint. How to provide the alternate s3 endpoint and…
Mathivanan
  • 371
  • 2
  • 16
1
vote
2 answers

CrateDB cannot connect in HttpEndpoint to remote secure server

I've been testing crateDB 3.3.4 for a few weeks now, and I've always been connecting through localhost (127.0.0.1) in http. I've been bulk importing data with HttpEndpoint on my localhost successfully. I'm now testing on a cloud cluster in https. I…
Danielle Paquette-Harvey
  • 1,691
  • 1
  • 16
  • 31
1
vote
1 answer

Backslash (\) and Quote (') in search/insert query jdbc

I am using JDBC with cratedb(which almost uses PSQL protocols). It happens that when I try to execute a query like this String query = "select * from test where col1='dhruv\'"; It gives me Parser exception. Caused by:…
Dhruv Pal
  • 849
  • 2
  • 10
  • 25
1
vote
2 answers

How to subtract days to a Timestamp in CrateDB SQL query?

How can i subtract days to a timestamp in CrateDB SQL query? Exist something similar to this? TIMESTAMP_SUB(CURRENT_TIMESTAMP(), INTERVAL 14 DAY)
lascarayf
  • 3,423
  • 3
  • 19
  • 24
1
vote
0 answers

CrateDB & Elasticsearch problem running as root and binding IP

so i am trying to install CrateDB on a brand new centos7 box and i am running into issues. When running ./crate -Cnetwork.host=[myip] i recieve the following errors [2018-11-23T11:05:20,857][INFO ][o.e.n.Node ] [Tête de Gaulent]…
Samuel A
  • 13
  • 2
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

order of columns in primary key in cratedb

Does the order of columns in the primary key impact the performance of related queries depending on the order of columns given in the select statement? Example: primary key (col1, col2, col3); select col2, col3 from table; -> would this select use…
Sebas
  • 21,192
  • 9
  • 55
  • 109
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

Querying into CrateDB objects and skip if property not exists

I'm trying to make a query into my CrateDB querying in objects where a property may exist. But I'm having some issues getting a ColumnUnknownException. My query looks quite easy: SELECT "attrs","location" FROM "doc"."raw_foo" WHERE…
Pablo D
  • 393
  • 2
  • 6
  • 22
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
2
3
…
8 9