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

CrateDB drop column not working and throwing an error

Hello stackoverflow so I have a cratedb database instance with about 3 million records in my table. I am trying to run the following command. ALTER TABLE "transactions_v2" DROP COLUMN "itemPrices"; However I end up with this…
The Coder
  • 293
  • 2
  • 15
0
votes
1 answer

What can be the reason why I can't connect to CateDB with grafana and locally with Dbeaver?

Cheers I am currently trying to reproduce the tutorial to develop an application / solution with Fiware seen in: Desarrolla tu primer aplicación en Fiware and I am having difficulty connecting Grafana with the Crate database (recommended by…
Galhrrera
  • 5
  • 2
0
votes
0 answers

Connecting Python app to Crate-DB Docker container

I am using docker compose to set up a python app and connect it to Crate DB which is also in a container. Everything works smoothly if I connect with localhost:4200 from my local terminal, but when I add the python script to the container, it cannot…
FS93
  • 51
  • 4
0
votes
0 answers

CrateDB is failing to start

After figuring everything out I am close to finish up this project but it seems the new crateDB version is failing to start. Here is my crate docker-compose.yml file: crate: image: crate:4.1.4 hostname: crate expose: …
Srdjan Zec
  • 21
  • 4
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
3 answers

Cratedb loop over column Array and see if the values fall between X and Y

Hey stack overflow so I have a column called itemPrices that is an Array of integers; [43, 44, 55] So I have an api that gives me two numbers, X and Y. I want to take those two numbers and compare it against the Array. If the number in the object…
The Coder
  • 293
  • 2
  • 15
0
votes
1 answer

io.crate.shade.org.postgresql.util.PSQLException: ERROR: ArrayIndexOutOfBoundsException: Index 16 out of bounds for length 16

using 4.0.0 version of cratedb sample sql: select * from table where col1 = 'exp1' date BETWEEN '2019-01-01' AND '2022-02-14' right join dim.time where date BETWEEN '2019-01-01' AND '2022-02-14' in this sql we know first part is empty data, and…
storm
  • 1
  • 2
0
votes
0 answers

service not start, Format version is not supported error

i'm using CrateDB (ElsaticSearch clone) and worked fine in long time and rebooted os before, but after reboot OS yesterday, service crate not started before worked fine. i can't find any document for fix this problem service not started…
lebabo3171
  • 1
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
2 answers

How to raise an exception when bulk inserting faulty rows into crateDB using Python Pandas to_sql()

I am bulk inserting data into crateDB using pandas.to_sql(tableId, 'crate://xxxxxxx:4200', if_exists='append', index=False, chunksize=20000) The data contains a few faulty rows where one column of type 'numeric' contains a value of type 'object' /…
Jabb
  • 3,414
  • 8
  • 35
  • 58
0
votes
1 answer

Compiler state error when inserting data to CrateDb

I am trying to connect to the crateDB and insert data. Although the DB migrations work perfectly - it shows the following error when am trying to insert data TypeError: _get_crud_params() missing 1 required positional argument:…
Abhishek
  • 77
  • 1
  • 9
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
0
votes
2 answers

Can PySpark write array of strings to a database through a JDBC driver?

I am working with PySpark and I want to insert an array of strings into my database that has a JDBC driver but I am getting the following error: IllegalArgumentException: Can't get JDBC type for array This error happens when I have an…
Cande
  • 36
  • 7
0
votes
1 answer

How to process sensor time series data in batch (e.g. every 1 minute) to time series database (e.g. CrateDB) via FIWARE ORION CONTEXT BROKER?

I want to process sensor data into a time series database via FIWARE ORION CONTEXT BROKER. However, instead of writing each data individually, I want to write it collectively as a 1-minute time series. Is something like this possible? Could you help…
snkly
  • 41
  • 3
0
votes
1 answer

Fiware Quantum Leap Date Query

I am currently using Quantum Leap/CrateDB to persist time series data through the Orion Context Broker. After setting up the notification on Orion I can query data. curl -X GET…
Yannick
  • 59
  • 7
1 2 3
…
8 9