Topics tagged sql

Topic	Replies	Views	Activity
The LIKE/ILIKE keyword in CrateDB does not work when the target string contains newline (\n) or tab (\t) characters. This causes pattern matching to fail for multi-line or formatted text values Community sql	3	60	January 8, 2026
Circuit Breaker Error on COLLECT_SET Aggregation - "breaker would use 18gb in total. Limit is 18gb" CrateDB sql	1	54	December 5, 2025
How to access nested object keys CrateDB sql	7	62	August 19, 2025
Created_at not populated with default value during insert in CrateDB via C# SQL sql	1	47	August 14, 2025
How to perform a fuzzy search on the elements of a text array SQL sql	4	55	August 11, 2025
Kafka connect failed sink data to cratedb while the data doesn't exist in record CrateDB sql , integration	5	85	August 4, 2025
Min() and max() functions return null values even if the field contains data CrateDB fundamentals , sql	6	111	June 13, 2025
Does CrateDB Support Materialized Views? Any Workarounds? CrateDB sql	5	165	May 26, 2025
Create read-only database user by using "GRANT DQL" Tutorials sql , privileges	0	77	May 17, 2025
Poor Performance: Snapshot creation takes over an hour for a 5-row table CrateDB sql	0	50	March 27, 2025
Couldn't decrease number of shards for table CrateDB data-storage , sql	2	58	March 26, 2025
Prepared Statement Query Returns Duplicate Records but CrateDB Console Query Doesn’t CrateDB sql	1	64	January 23, 2025
Resampling time-series data with DATE_BIN Tutorials sql , fundamentals	5	2281	October 15, 2024
How to import csv file which contains into table which have json columns CrateDB data-storage , sql	0	35	October 1, 2024
How do we access words' frequencies? CrateDB sql	0	47	September 30, 2024
Failed to update from joined table CrateDB sql	1	41	September 11, 2024
Drop user or drop schema? CrateDB Cloud sql , getting-started	5	120	July 25, 2024
Query partition size from table SQL data-storage , architecture , sql	2	123	June 13, 2024
Sharding and partitioning guide for time-series data Tutorials performance , fundamentals , getting-started , sql	0	5071	July 2, 2021
Cluster does not respond after synchronization is complete Community sql	1	143	April 3, 2024
Alter table and add new column if already exists CrateDB sql	1	210	April 3, 2024
Using common table expressions to speed up queries Tutorials performance , sql	0	708	February 22, 2024
LTTB downsampling to work around Grafana SQL limits SQL sql	10	843	February 27, 2024
Retrieving records in bulk with a list of primary key values Tutorials sql	0	603	February 23, 2024
Importing and exporting data in CrateDB Tutorials sql , getting-started	0	2464	August 8, 2022
Objects in CrateDB Tutorials sql , fundamentals , getting-started	0	1799	August 8, 2022
Poor performance with five tables using join CrateDB sql	7	490	December 19, 2023
Error occurs while using COPY FROM json file when sequence of the records in a file mismatch CrateDB sql	4	238	December 13, 2023
Searching DB with where clause on column whose data type is Array SQL sql	5	1475	October 17, 2023
View with column swapping SQL sql	2	370	June 29, 2023