# CrateDB **URL:** https://community.cratedb.com/c/cratedb/18.md?page=1 [Latest](https://community.cratedb.com/latest.md) · [Categories](https://community.cratedb.com/categories.md) · [Tags](https://community.cratedb.com/tags.md) **Page:** 2 --- ## [Kafka connect failed sink data to cratedb while the data doesn't exist in record](https://community.cratedb.com/t/kafka-connect-failed-sink-data-to-cratedb-while-the-data-doesnt-exist-in-record/2058)
**Author:** [@Jun\_Zhou](https://community.cratedb.com/u/Jun_Zhou)\ **Replies:** 5\ **Last updated:** [August 4, 2025, 10:53am UTC](https://community.cratedb.com/t/kafka-connect-failed-sink-data-to-cratedb-while-the-data-doesnt-exist-in-record/2058 "2025-08-04T10:53:03Z")
We’re using CrateDB 5.10.11, and using kafka connect sink data to it, after running for a while the connect encounter below error. But the record don’t contain the value 08:11:26.000Z, so I confused, how to locate the r… --- ## [Integration of Django and CrateDB](https://community.cratedb.com/t/integration-of-django-and-cratedb/1756)
**Author:** [@zamanganji](https://community.cratedb.com/u/zamanganji)\ **Replies:** 2\ **Last updated:** [July 24, 2025, 9:36pm UTC](https://community.cratedb.com/t/integration-of-django-and-cratedb/1756 "2025-07-24T21:36:54Z")
I want to integrate Django and CrateDB. Unfortunately there is no support for the Django database by CrateDB. --- ## [Questions about user roles](https://community.cratedb.com/t/questions-about-user-roles/2050)
**Author:** [@andreas.schneider](https://community.cratedb.com/u/andreas.schneider)\ **Replies:** 4\ **Last updated:** [July 8, 2025, 2:15pm UTC](https://community.cratedb.com/t/questions-about-user-roles/2050 "2025-07-08T14:15:04Z")
Hello Team, I have a few questions about user roles. SET UP Empty database (login as user crate) Execute the following commands CREATE USER admin; CREATE USER testUser; CREATE ROLE role\_admin; CREATE ROLE role\_te… --- ## [Map failed Exception resulting in node crash](https://community.cratedb.com/t/map-failed-exception-resulting-in-node-crash/2046)
**Author:** [@swati](https://community.cratedb.com/u/swati)\ **Replies:** 3\ **Last updated:** [July 7, 2025, 7:32am UTC](https://community.cratedb.com/t/map-failed-exception-resulting-in-node-crash/2046 "2025-07-07T07:32:37Z")
Hi Team, I have upgraded to crate 5.10.9 last week. my application with crate configuration was working fine alomost for a week. Suddenly started getting exception mentioned below. With this memory exception, it took … --- ## [Circuit breaker exception and Java heap space issue](https://community.cratedb.com/t/circuit-breaker-exception-and-java-heap-space-issue/2045)
**Author:** [@swati](https://community.cratedb.com/u/swati)\ **Replies:** 4\ **Last updated:** [June 26, 2025, 9:12am UTC](https://community.cratedb.com/t/circuit-breaker-exception-and-java-heap-space-issue/2045 "2025-06-26T09:12:00Z")
Hi Team, On June 17, I updated the crate version from 5.10.7 (Stable) to 5.10.9 (testing). Regarding the Java heap space issue, I observed a single behavioral difference. Using several group by clauses in my query use… --- ## [Increased cost in AWS inter-zone transfers](https://community.cratedb.com/t/increased-cost-in-aws-inter-zone-transfers/2039)
**Author:** [@AncilHumph](https://community.cratedb.com/u/AncilHumph)\ **Replies:** 8\ **Last updated:** [June 20, 2025, 3:36pm UTC](https://community.cratedb.com/t/increased-cost-in-aws-inter-zone-transfers/2039 "2025-06-20T15:36:41Z")
For several years, our Production cluster (v3.3) has been a 3-node, multi-zone (3 zones) cluster hosted on AWS. So each node was in its own zone. Each partition is setup for 2 primary shards, each with 2 replicas. For… --- ## [5.10.8 stable version](https://community.cratedb.com/t/5-10-8-stable-version/2042)
**Author:** [@swati](https://community.cratedb.com/u/swati)\ **Replies:** 4\ **Last updated:** [June 17, 2025, 9:21am UTC](https://community.cratedb.com/t/5-10-8-stable-version/2042 "2025-06-17T09:21:08Z")
This URL says that crate version 5.10.8 got released on 10 June 2025. When I am trying to download same, noticed that, its still in testing phase. Link I am following to download is Download CrateDB. can someone conf… --- ## [Min() and max() functions return null values even if the field contains data](https://community.cratedb.com/t/min-and-max-functions-return-null-values-even-if-the-field-contains-data/2036)
**Author:** [@Jun\_Zhou](https://community.cratedb.com/u/Jun_Zhou)\ **Replies:** 6\ **Last updated:** [June 13, 2025, 1:18pm UTC](https://community.cratedb.com/t/min-and-max-functions-return-null-values-even-if-the-field-contains-data/2036 "2025-06-13T13:18:27Z")
Hi Team, we have a table metrics that store prometheus data in cratedb 5.10.7, while both the min() and max() functions return null values, even if the field day\_\_generated itself contains data. cr\> select version(); +-… --- ## [HTTP endpoint insert size](https://community.cratedb.com/t/http-endpoint-insert-size/2029)
**Author:** [@djbestenergy](https://community.cratedb.com/u/djbestenergy)\ **Replies:** 2\ **Last updated:** [June 12, 2025, 2:06pm UTC](https://community.cratedb.com/t/http-endpoint-insert-size/2029 "2025-06-12T14:06:09Z")
Hi Does anyone know when using the http endpoint, if its more efficient for a 3 node crate cluster to accept more bulk data infrequently or smaller bulk data with more frequent insertions. So for instance I might inser… --- ## [Issue post upgrade from 5.9.+ to 5.10.+](https://community.cratedb.com/t/issue-post-upgrade-from-5-9-to-5-10/2035)
**Author:** [@atish11pune](https://community.cratedb.com/u/atish11pune)\ **Replies:** 3\ **Last updated:** [June 5, 2025, 6:49am UTC](https://community.cratedb.com/t/issue-post-upgrade-from-5-9-to-5-10/2035 "2025-06-05T06:49:39Z")
I have upgraded CrateDB from version 5.9 to 5.10. Prior to the upgrade, I was able to retrieve records without any issues. However, after the upgrade, newly inserted records are showing null values when queried, although… --- ## [Does CrateDB Support Materialized Views? Any Workarounds?](https://community.cratedb.com/t/does-cratedb-support-materialized-views-any-workarounds/2002)
**Author:** [@Dennis\_Jose](https://community.cratedb.com/u/Dennis_Jose)\ **Replies:** 5\ **Last updated:** [May 26, 2025, 11:54am UTC](https://community.cratedb.com/t/does-cratedb-support-materialized-views-any-workarounds/2002 "2025-05-26T11:54:55Z")
I’m exploring CrateDB and found that it supports downsampling using DATE\_BIN and the LTTB algorithm. However, I couldn’t find direct support for materialized views where the results are stored in a table for efficient qu… --- ## [Version upgrading : The correct sequence?](https://community.cratedb.com/t/version-upgrading-the-correct-sequence/2032)
**Author:** [@cocoa](https://community.cratedb.com/u/cocoa)\ **Replies:** 1\ **Last updated:** [May 23, 2025, 8:26am UTC](https://community.cratedb.com/t/version-upgrading-the-correct-sequence/2032 "2025-05-23T08:26:47Z")
I would like to upgrade CrateDB from version 5.6.3 to version 5.10.6. In the recommendations on GitHub I find written in the release notes “We recommend that you upgrade to the latest 5.9 release before moving to 5.10.6… --- ## [Not null columns](https://community.cratedb.com/t/not-null-columns/2028)
**Author:** [@djbestenergy](https://community.cratedb.com/u/djbestenergy)\ **Replies:** 6\ **Last updated:** [May 22, 2025, 9:39am UTC](https://community.cratedb.com/t/not-null-columns/2028 "2025-05-22T09:39:20Z")
Hi, I’ve got several tables that have completely null records in ,even though the primary key field is a varchar with not null constraint. The only field that is actually populated is a generated field ( from a timestam… --- ## [Crate version update in K8S not fully automated?](https://community.cratedb.com/t/crate-version-update-in-k8s-not-fully-automated/1995)
**Author:** [@DarinVenkov](https://community.cratedb.com/u/DarinVenkov)\ **Replies:** 1\ **Last updated:** [May 7, 2025, 2:21pm UTC](https://community.cratedb.com/t/crate-version-update-in-k8s-not-fully-automated/1995 "2025-05-07T14:21:01Z")
Hi all, We have a Kubernetes cluster with a crate-operator (version 2.45.0) and a Crate cluster with 3 instances created from a CrateDB resource. As a result in the cluster we have one pod for the crate-operator (creat… --- ## [2 node cluster recurrent issue with request timing out](https://community.cratedb.com/t/2-node-cluster-recurrent-issue-with-request-timing-out/2026)
**Author:** [@echarlus](https://community.cratedb.com/u/echarlus)\ **Replies:** 4\ **Last updated:** [April 14, 2025, 3:35pm UTC](https://community.cratedb.com/t/2-node-cluster-recurrent-issue-with-request-timing-out/2026 "2025-04-14T15:35:01Z")
Hi All, I’m running a 2 nodes integration-testing cluster on version 5.6.5, same version as my production version. I’ve got a very basic setup on each node : # Networking: Bind to an IP address or interface other than… --- ## [Shards of prometheus metrics table are in underreplicated state](https://community.cratedb.com/t/shards-of-prometheus-metrics-table-are-in-underreplicated-state/1728)
**Author:** [@Jun\_Zhou](https://community.cratedb.com/u/Jun_Zhou)\ **Replies:** 9\ **Last updated:** [April 8, 2025, 12:52am UTC](https://community.cratedb.com/t/shards-of-prometheus-metrics-table-are-in-underreplicated-state/1728 "2025-04-08T00:52:23Z")
We are using createdb-prometheus-adapter write data to CrateDB 5.6.2, while the shards of table partition are in underreplicated state. For details please see the below figure. We couldn’t find related solutions in commu… --- ## [Performance Question: Any impact of replacing CTEs with VIEWs?](https://community.cratedb.com/t/performance-question-any-impact-of-replacing-ctes-with-views/2025)
**Author:** [@robd003](https://community.cratedb.com/u/robd003)\ **Replies:** 0\ **Last updated:** [April 4, 2025, 11:09pm UTC](https://community.cratedb.com/t/performance-question-any-impact-of-replacing-ctes-with-views/2025 "2025-04-04T23:09:43Z")
I’m using a lot of common CTEs throughout my queries and I was wondering if there would be any performance impact if I just “saved” these as VIEWs. --- ## [Efcore 8.0.11 update table with migration not working](https://community.cratedb.com/t/efcore-8-0-11-update-table-with-migration-not-working/2023)
**Author:** [@shweta](https://community.cratedb.com/u/shweta)\ **Replies:** 1\ **Last updated:** [April 4, 2025, 7:50am UTC](https://community.cratedb.com/t/efcore-8-0-11-update-table-with-migration-not-working/2023 "2025-04-04T07:50:49Z")
I am trying to update existing table using ef core with migration command. Its always creating migration history table. Migration history table created once i created table. How we can do update column name or add new c… --- ## [Poor Performance: Snapshot creation takes over an hour for a 5-row table](https://community.cratedb.com/t/poor-performance-snapshot-creation-takes-over-an-hour-for-a-5-row-table/2017)
**Author:** [@Jun\_Zhou](https://community.cratedb.com/u/Jun_Zhou)\ **Replies:** 0\ **Last updated:** [March 27, 2025, 8:17am UTC](https://community.cratedb.com/t/poor-performance-snapshot-creation-takes-over-an-hour-for-a-5-row-table/2017 "2025-03-27T08:17:04Z")
In CrateDB 5.5.2, snapshot creation for a 5-row table takes over an hour. What might cause this? cr\> select count(\*) from xxaps.cs\_test; +----------+ | count(\*) | +----------+ | 5 | +----------+ SELECT 1 row in s… --- ## [CrateDB supports restore snapshot in different version cluster?](https://community.cratedb.com/t/cratedb-supports-restore-snapshot-in-different-version-cluster/2015)
**Author:** [@Jun\_Zhou](https://community.cratedb.com/u/Jun_Zhou)\ **Replies:** 2\ **Last updated:** [March 27, 2025, 8:04am UTC](https://community.cratedb.com/t/cratedb-supports-restore-snapshot-in-different-version-cluster/2015 "2025-03-27T08:04:13Z")
Hi, I created snapshot in CrateDB 5.5.2 and I also created new cluster of CrateDB 5.10.3, can I restore the snapshot to 5.10.3 CrateDB? --- ## [Couldn't decrease number of shards for table](https://community.cratedb.com/t/couldnt-decrease-number-of-shards-for-table/2014)
**Author:** [@Jun\_Zhou](https://community.cratedb.com/u/Jun_Zhou)\ **Replies:** 2\ **Last updated:** [March 26, 2025, 8:33am UTC](https://community.cratedb.com/t/couldnt-decrease-number-of-shards-for-table/2014 "2025-03-26T08:33:46Z")
I’m using CrateDB 5.10.3 and I want decrease the number of shards for some tables, while getting below error. cr\> SET GLOBAL PERSISTENT "cluster.max\_shards\_per\_node" = '1500'; SET OK, 1 row affected (0.078 sec) cr\> ALTE… --- ## [It doesn't work after increasing total\_shards\_per\_node](https://community.cratedb.com/t/it-doesnt-work-after-increasing-total-shards-per-node/2012)
**Author:** [@Jun\_Zhou](https://community.cratedb.com/u/Jun_Zhou)\ **Replies:** 2\ **Last updated:** [March 26, 2025, 1:26am UTC](https://community.cratedb.com/t/it-doesnt-work-after-increasing-total-shards-per-node/2012 "2025-03-26T01:26:40Z")
Hi team, I’m using CrateDB 5.10.3 and created more than 150 tables with default value 8 of number\_of\_shards, so that I encounter below error. I try to set "cluster.routing.allocation.total\_shards\_per\_node" = '5000'; and … --- ## [CrateDB Incremental model materialization not working with dbt-core](https://community.cratedb.com/t/cratedb-incremental-model-materialization-not-working-with-dbt-core/2010)
**Author:** [@Ayas\_Rasheed](https://community.cratedb.com/u/Ayas_Rasheed)\ **Replies:** 4\ **Last updated:** [March 25, 2025, 1:06pm UTC](https://community.cratedb.com/t/cratedb-incremental-model-materialization-not-working-with-dbt-core/2010 "2025-03-25T13:06:27Z")
I am trying to use CrateDB with dbt Core 1.9.3 for incremental model materialization. The initial data loads successfully, but the incremental model is not working as expected. Here is the model I used: {{ config(mater… --- ## [Kafka connect don't sink data to cratedb after adding more than 100 topics](https://community.cratedb.com/t/kafka-connect-dont-sink-data-to-cratedb-after-adding-more-than-100-topics/2007)
**Author:** [@Jun\_Zhou](https://community.cratedb.com/u/Jun_Zhou)\ **Replies:** 3\ **Last updated:** [March 25, 2025, 9:17am UTC](https://community.cratedb.com/t/kafka-connect-dont-sink-data-to-cratedb-after-adding-more-than-100-topics/2007 "2025-03-25T09:17:22Z")
Hi Team, we are using CrateDB 5.10.2 and using kafka connect to sink data to CrateDB, the firstly created the connect could running normally and create automatically nineteen tables in CrateDB. After adding more topics t… --- ## [CrateDB Operator for Kubernetes, and automated backups (CLUSTER\_BACKUP\_IMAGE?)](https://community.cratedb.com/t/cratedb-operator-for-kubernetes-and-automated-backups-cluster-backup-image/2011)
**Author:** [@pmumby\_flowcoffee](https://community.cratedb.com/u/pmumby_flowcoffee)\ **Replies:** 1\ **Last updated:** [March 25, 2025, 7:44am UTC](https://community.cratedb.com/t/cratedb-operator-for-kubernetes-and-automated-backups-cluster-backup-image/2011 "2025-03-25T07:44:34Z")
Hi, we have an on-prem deploy of CrateDB in our Kubernetes cluster, and we’re using the operator to deploy it. We have everything working great, tiered storage, data retention policies, etc… However, in the operator I no… --- ## [Can I connect with crate using PowerBI?](https://community.cratedb.com/t/can-i-connect-with-crate-using-powerbi/398)
**Author:** [@miguel.arregui](https://community.cratedb.com/u/miguel.arregui)\ **Replies:** 1\ **Last updated:** [March 24, 2025, 4:10pm UTC](https://community.cratedb.com/t/can-i-connect-with-crate-using-powerbi/398 "2025-03-24T16:10:46Z")
How can I connect with crate using PowerBI? --- ## [Evaluating storage space reduction in size on disk with Crate 5.10](https://community.cratedb.com/t/evaluating-storage-space-reduction-in-size-on-disk-with-crate-5-10/1975)
**Author:** [@Amod](https://community.cratedb.com/u/Amod)\ **Replies:** 5\ **Last updated:** [March 14, 2025, 10:41am UTC](https://community.cratedb.com/t/evaluating-storage-space-reduction-in-size-on-disk-with-crate-5-10/1975 "2025-03-14T10:41:09Z")
Hi, This is regarding storage space reduction as documented for version 5.10. It is mentioned that with new table storage format, we can see around 50% storage space reduction in size on disk We created sample table as… --- ## [OPTIMIZE TABLE table\_name WITH (only\_expunge\_deletes = true) seems like never ending](https://community.cratedb.com/t/optimize-table-table-name-with-only-expunge-deletes-true-seems-like-never-ending/2000)
**Author:** [@Yusuf\_Cansiz](https://community.cratedb.com/u/Yusuf_Cansiz)\ **Replies:** 1\ **Last updated:** [March 14, 2025, 2:39am UTC](https://community.cratedb.com/t/optimize-table-table-name-with-only-expunge-deletes-true-seems-like-never-ending/2000 "2025-03-14T02:39:09Z")
Hello, I have a table in cratedb which had almost 360 million records. I deleted 100 million records from the table but size of the table did not decreased. I started the query OPTIMIZE TABLE table\_name WITH (only\_exp… --- ## [Crate db full text search phrase\_prefix does not return everything need to be returned](https://community.cratedb.com/t/crate-db-full-text-search-phrase-prefix-does-not-return-everything-need-to-be-returned/1937)
**Author:** [@Yusuf\_Cansiz](https://community.cratedb.com/u/Yusuf_Cansiz)\ **Replies:** 2\ **Last updated:** [March 14, 2025, 2:12am UTC](https://community.cratedb.com/t/crate-db-full-text-search-phrase-prefix-does-not-return-everything-need-to-be-returned/1937 "2025-03-14T02:12:42Z")
In CrateDB we are makıng Fulltext search we have a huge data like 69 million rows. When we make searches with analyzer only with standart tokenizer and lowercase filter and phrase\_prefix included it seems like cratedb do… --- ## [Crate Operator on OpenShift not working](https://community.cratedb.com/t/crate-operator-on-openshift-not-working/1997)
**Author:** [@FrancescoL96](https://community.cratedb.com/u/FrancescoL96)\ **Replies:** 0\ **Last updated:** [March 11, 2025, 12:39pm UTC](https://community.cratedb.com/t/crate-operator-on-openshift-not-working/1997 "2025-03-11T12:39:57Z")
I am having issues with the crate-operator on an openshift cluster, I have detailed the problem on a github issue: In short, OpenShift handles some objects differently from Kubernetes and it stops the operator from wor… [Previous page](https://community.cratedb.com/c/cratedb/18.md) [Next page](https://community.cratedb.com/c/cratedb/18.md?page=2)