|
About the SQL category
|
|
0
|
739
|
November 26, 2018
|
|
The fetchSize setting is not being honored when using JDBC with a PreparedStatement
|
|
5
|
149
|
September 4, 2025
|
|
SQL syntax for a left join where the matching clause is between a text_array and a text
|
|
10
|
115
|
September 2, 2025
|
|
Created_at not populated with default value during insert in CrateDB via C#
|
|
1
|
45
|
August 14, 2025
|
|
How to perform a fuzzy search on the elements of a text array
|
|
4
|
54
|
August 11, 2025
|
|
Performance Question: Any impact of replacing CTEs with VIEWs?
|
|
0
|
32
|
April 4, 2025
|
|
After upgrading from version 5.10.1 to 5.10.2, some statements could not be completed
|
|
3
|
86
|
March 11, 2025
|
|
Academy course: wrong analyzer?
|
|
2
|
50
|
January 14, 2025
|
|
SQL syntax for geospatial data
|
|
3
|
73
|
December 16, 2024
|
|
IN clause on primary key column does not return all the records if it has more than 5k inputs
|
|
3
|
188
|
November 13, 2024
|
|
Query partition size from table
|
|
2
|
122
|
June 13, 2024
|
|
Syntax error on if statement with exists
|
|
5
|
370
|
May 28, 2024
|
|
Min/max a value with a fixed number using SQL
|
|
3
|
170
|
March 15, 2024
|
|
LTTB downsampling to work around Grafana SQL limits
|
|
10
|
834
|
February 27, 2024
|
|
Error on using copy from csv file with a timestamp
|
|
3
|
229
|
November 29, 2023
|
|
How to aggregate Children to Parents
|
|
3
|
294
|
November 21, 2023
|
|
Searching DB with where clause on column whose data type is Array
|
|
5
|
1472
|
October 17, 2023
|
|
UPDATE from joined table
|
|
2
|
849
|
October 11, 2023
|
|
Problem connecting with Apache Superset
|
|
4
|
1308
|
September 19, 2023
|
|
Error in Left Join
|
|
1
|
292
|
August 7, 2023
|
|
View with column swapping
|
|
2
|
368
|
June 29, 2023
|
|
Trying to use: INSERT ON CONFLICT UPDATE SET
|
|
5
|
576
|
June 27, 2023
|
|
MS SQL server to CrateDB convert
|
|
3
|
1088
|
April 12, 2023
|
|
Add interval to date does not work anymore
|
|
2
|
605
|
March 15, 2023
|
|
Import data into crateDB table from multiple json files
|
|
2
|
438
|
February 3, 2023
|
|
Declaring variables
|
|
2
|
363
|
January 29, 2023
|
|
Very Slow Query Performance
|
|
14
|
871
|
January 12, 2023
|
|
How to set Limit of total fields [1000] in index
|
|
2
|
756
|
November 22, 2022
|
|
Specify column type with bulk insert
|
|
2
|
582
|
November 7, 2022
|
|
SQL - cast to class java.lang.String error
|
|
15
|
986
|
October 19, 2022
|