# Community **URL:** https://community.cratedb.com/c/community/38.md [Latest](https://community.cratedb.com/latest.md) · [Categories](https://community.cratedb.com/categories.md) · [Tags](https://community.cratedb.com/tags.md) --- ## [About the Community category](https://community.cratedb.com/t/about-the-community-category/1040)
**Author:** [@proddata](https://community.cratedb.com/u/proddata)\ **Replies:** 0
Here we share upcoming events and webinars, practical applications of CrateDB and job openings, call for speakers, and open discussions about the latest releases. --- ## [CCLA/ICLA Github Bot validation](https://community.cratedb.com/t/ccla-icla-github-bot-validation/2150)
**Author:** [@Amine\_Djebbi](https://community.cratedb.com/u/Amine_Djebbi)\ **Replies:** 2\ **Last updated:** [August 3, 2026, 10:07am UTC](https://community.cratedb.com/t/ccla-icla-github-bot-validation/2150 "2026-08-03T10:07:41Z")
Hi all, I have an issue with ICLA validation to be able to contribute to a fix I made to SSO authentication in the code. Could someone help me. I’ve signed the online document but it is still blocked by the GitHub bot. … --- ## [Maximum High Availability with acceptable data loss](https://community.cratedb.com/t/maximum-high-availability-with-acceptable-data-loss/2149)
**Author:** [@Egor\_Sharin](https://community.cratedb.com/u/Egor_Sharin)\ **Replies:** 2\ **Last updated:** [July 27, 2026, 11:44pm UTC](https://community.cratedb.com/t/maximum-high-availability-with-acceptable-data-loss/2149 "2026-07-27T23:44:01Z")
Hi, Are there settings which would create a CrateDB cluster with 3 nodes, so that even if 2 nodes go down, the 1 remaining node retains the write (and read) capability? Similarly, for a 5-node cluster, can only 2 nodes… --- ## [New CrateDB stable release: CrateDB 6.4](https://community.cratedb.com/t/new-cratedb-stable-release-cratedb-6-4/2148)
**Author:** [@ThomasBestfleischCra](https://community.cratedb.com/u/ThomasBestfleischCra)\ **Replies:** 0\ **Last updated:** [July 20, 2026, 2:27pm UTC](https://community.cratedb.com/t/new-cratedb-stable-release-cratedb-6-4/2148 "2026-07-20T14:27:30Z")
We are happy to announce a new CrateDB 6.4 stable release available for all users and customers. CrateDB 6.4 brings performance and resilience improvements, as well as SQL standard and PostgreSQL compatibility improveme… --- ## [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](https://community.cratedb.com/t/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/2089)
**Author:** [@anujjaiswar](https://community.cratedb.com/u/anujjaiswar)\ **Replies:** 3\ **Last updated:** [January 8, 2026, 6:39am UTC](https://community.cratedb.com/t/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/2089 "2026-01-08T06:39:04Z")
For example, the query below returns an empty result: SELECT \* FROM table WHERE message ILIKE ‘%A user account was%’; But the actual message column value is: A user account was deleted accountid : amit --- ## [Adaptive partitioning](https://community.cratedb.com/t/adaptive-partitioning/1974)
**Author:** [@ibrhmkoz](https://community.cratedb.com/u/ibrhmkoz)\ **Replies:** 1\ **Last updated:** [December 4, 2025, 7:38am UTC](https://community.cratedb.com/t/adaptive-partitioning/1974 "2025-12-04T07:38:24Z")
CREATE TABLE projects\_posts ( project\_id VARCHAR, labels ARRAY (VARCHAR), sentiment VARCHAR CHECK (sentiment IN ('negative', 'positive', 'neutral')), favorited\_at TIMESTAMP WITH TIME ZONE, hidden\_at T… --- ## [Add default value to column](https://community.cratedb.com/t/add-default-value-to-column/2078)
**Author:** [@Bhupendra\_Rane](https://community.cratedb.com/u/Bhupendra_Rane)\ **Replies:** 1\ **Last updated:** [December 1, 2025, 1:26pm UTC](https://community.cratedb.com/t/add-default-value-to-column/2078 "2025-12-01T13:26:24Z")
I have a table in CrateDB, and I need to add the default value for a column of type timestamp with time zone. How can I do that? My CrateDB version is 5.10.9. --- ## [Alter table quey](https://community.cratedb.com/t/alter-table-quey/2076)
**Author:** [@Gayatri\_Lakule](https://community.cratedb.com/u/Gayatri_Lakule)\ **Replies:** 1\ **Last updated:** [December 1, 2025, 12:44pm UTC](https://community.cratedb.com/t/alter-table-quey/2076 "2025-12-01T12:44:56Z")
Hello, I want to update an existing table sampletable by setting the default value of the auditdate column to CURRENT\_TIMESTAMP. However, the following query is not working: ALTER TABLE sampletable ALTER COLUMN audit… --- ## [Mitigation for TLS renegotiation Vulnerability](https://community.cratedb.com/t/mitigation-for-tls-renegotiation-vulnerability/1791)
**Author:** [@Baur](https://community.cratedb.com/u/Baur)\ **Replies:** 0\ **Last updated:** [June 24, 2024, 12:55pm UTC](https://community.cratedb.com/t/mitigation-for-tls-renegotiation-vulnerability/1791 "2024-06-24T12:55:59Z")
CrateDB versions earlier than 5.7.2 are exposed to the client initiated renegotiation vulnerability. We have released CrateDB 5.7.2 with TLS renegotiation disabled by default. See Client initialized Session-Renegotiati… --- ## [CrateDB connection issue while using JDBC Driver](https://community.cratedb.com/t/cratedb-connection-issue-while-using-jdbc-driver/1767)
**Author:** [@Anandub](https://community.cratedb.com/u/Anandub)\ **Replies:** 9\ **Last updated:** [May 16, 2024, 12:47pm UTC](https://community.cratedb.com/t/cratedb-connection-issue-while-using-jdbc-driver/1767 "2024-05-16T12:47:08Z")
CRATE connection issue when using JDBC import jaydebeapi print("LOADING.....") conn = jaydebeapi.connect( "io.crate.client.jdbc.CrateDriver", "jdbc:crate://127.0.0.1:2000/", \["user", "password"\], "/home… --- ## [Cluster does not respond after synchronization is complete](https://community.cratedb.com/t/cluster-does-not-respond-after-synchronization-is-complete/1747)
**Author:** [@ilbee](https://community.cratedb.com/u/ilbee)\ **Replies:** 1\ **Last updated:** [April 3, 2024, 8:11am UTC](https://community.cratedb.com/t/cluster-does-not-respond-after-synchronization-is-complete/1747 "2024-04-03T08:11:37Z")
Hello, I allow myself to dig up my ticket: SQL Freeze after sync done After several version upgrades (4.4 to 4.6) the problem is still present. As long as the synchronization does not reach 100%, the 3 nodes remain ac… --- ## [CrateDB v5.6 Stable Release: Support for Roles, Renaming Columns, and More](https://community.cratedb.com/t/cratedb-v5-6-stable-release-support-for-roles-renaming-columns-and-more/1715)
**Author:** [@smu](https://community.cratedb.com/u/smu)\ **Replies:** 0\ **Last updated:** [February 2, 2024, 3:00pm UTC](https://community.cratedb.com/t/cratedb-v5-6-stable-release-support-for-roles-renaming-columns-and-more/1715 "2024-02-02T15:00:03Z")
We are happy to announce a new CrateDB 5.6 stable release available for all users and customers. CrateDB 5.6 brings support for roles and role inheritance (and such privilege inheritance), renaming columns, join perform… --- ## [Mitigations for Reported Vulnerability](https://community.cratedb.com/t/mitigations-for-reported-vulnerability/1676)
**Author:** [@smu](https://community.cratedb.com/u/smu)\ **Replies:** 9\ **Last updated:** [December 27, 2023, 8:02am UTC](https://community.cratedb.com/t/mitigations-for-reported-vulnerability/1676 "2023-12-27T08:02:08Z")
On 21 Dec a vulnerability was reported to CrateDB regarding authentication that could potentially affect all users. We have taken immediate action to remediate and have posted details here: Disable trust of HTTP X-Real-I… --- ## [COPY FROM using python http module as source .csv](https://community.cratedb.com/t/copy-from-using-python-http-module-as-source-csv/1672)
**Author:** [@bfmcneill](https://community.cratedb.com/u/bfmcneill)\ **Replies:** 7\ **Last updated:** [December 14, 2023, 3:20pm UTC](https://community.cratedb.com/t/copy-from-using-python-http-module-as-source-csv/1672 "2023-12-14T15:20:35Z")
Hello, I was trying to get COPY FROM using http://192.168.252.1:8000/lr-sql-scada/output\_sqlt\_data\_1\_2017\_11.csv' which is the ip of my host. The CrateDb is running as a shard with docker compose on the same host. I c… --- ## [Introduction to CrateDB Webinar - November 7](https://community.cratedb.com/t/introduction-to-cratedb-webinar-november-7/1625)
**Author:** [@maria.skvoznova](https://community.cratedb.com/u/maria.skvoznova)\ **Replies:** 0\ **Last updated:** [October 17, 2023, 1:11pm UTC](https://community.cratedb.com/t/introduction-to-cratedb-webinar-november-7/1625 "2023-10-17T13:11:01Z")
Join us for the upcoming webinar “Introduction to CrateDB: Key Concepts, Architecture, and Live Demo” :sound: Are you interested in the latest trends in the database market? :globe\_with\_meridians: Join our introductory … --- ## [CrateDB Workshop - October 10 and 11](https://community.cratedb.com/t/cratedb-workshop-october-10-and-11/1616)
**Author:** [@Marija](https://community.cratedb.com/u/Marija)\ **Replies:** 0\ **Last updated:** [October 4, 2023, 6:55am UTC](https://community.cratedb.com/t/cratedb-workshop-october-10-and-11/1616 "2023-10-04T06:55:20Z")
We are delighted to announce the 2nd Edition of the CrateDB workshop! Don’t miss the opportunity to get a hands-on learning experience on the fundamental concepts of CratteDB. The workshop is divided into 5 independent … --- ## [Join Us for CrateDB office hours! 📣](https://community.cratedb.com/t/join-us-for-cratedb-office-hours/1613)
**Author:** [@Marija](https://community.cratedb.com/u/Marija)\ **Replies:** 0\ **Last updated:** [September 29, 2023, 9:18am UTC](https://community.cratedb.com/t/join-us-for-cratedb-office-hours/1613 "2023-09-29T09:18:02Z")
Our team of CrateDB experts is ready to provide solutions and insights during this interactive session. Don’t miss out on the fantastic opportunity to get your CrateDB questions answered by the experts, connect with the … --- ## [CrateDB office hours: Wednesday, 13 September, 2023](https://community.cratedb.com/t/cratedb-office-hours-wednesday-13-september-2023/1567)
**Author:** [@Marija](https://community.cratedb.com/u/Marija)\ **Replies:** 0\ **Last updated:** [August 22, 2023, 9:51am UTC](https://community.cratedb.com/t/cratedb-office-hours-wednesday-13-september-2023/1567 "2023-08-22T09:51:20Z")
Join us for the next session of CrateDB office hour. We are meeting again on September 13, 2023, at 5 PM CET/ 11 AM ET. This time we will dive deep into the topic of full-text search. Specifically, we will discuss: How… --- ## [CrateDB office hours: Wednesday, August 2 2023](https://community.cratedb.com/t/cratedb-office-hours-wednesday-august-2-2023/1548)
**Author:** [@Marija](https://community.cratedb.com/u/Marija)\ **Replies:** 1\ **Last updated:** [August 2, 2023, 2:07pm UTC](https://community.cratedb.com/t/cratedb-office-hours-wednesday-august-2-2023/1548 "2023-08-02T14:07:06Z")
The next office hour session begins on August 2 at 3 PM CET/ 9 AM ET, and this time we will show you some of the cool features available in CrateDB 5.4: How to use statement\_timeout to stop long-running queries How to … --- ## [How we scaled ingestion to one million rows per second](https://community.cratedb.com/t/how-we-scaled-ingestion-to-one-million-rows-per-second/1069)
**Author:** [@hammerhead](https://community.cratedb.com/u/hammerhead)\ **Replies:** 1\ **Last updated:** [August 2, 2023, 12:07pm UTC](https://community.cratedb.com/t/how-we-scaled-ingestion-to-one-million-rows-per-second/1069 "2023-08-02T12:07:18Z")
Scaling ingestion throughput is a common requirement when using CrateDB. To gain first-hand practical experience on what challenges one can meet on the way, we set ourselves a goal: Find a realistic use case, start with … --- ## [CrateDB 5.4 is available for testing](https://community.cratedb.com/t/cratedb-5-4-is-available-for-testing/1542)
**Author:** [@smu](https://community.cratedb.com/u/smu)\ **Replies:** 0\ **Last updated:** [July 12, 2023, 1:23pm UTC](https://community.cratedb.com/t/cratedb-5-4-is-available-for-testing/1542 "2023-07-12T13:23:38Z")
We have just released CrateDB 5.4 to the testing channels and thus we invite everyone to start trying it out! Please be aware, that we do not recommend to run this in production yet. Please read the release notes for a… --- ## [CrateDB office hours: Wednesday, July 5 2023](https://community.cratedb.com/t/cratedb-office-hours-wednesday-july-5-2023/1526)
**Author:** [@Marija](https://community.cratedb.com/u/Marija)\ **Replies:** 1\ **Last updated:** [July 5, 2023, 1:28pm UTC](https://community.cratedb.com/t/cratedb-office-hours-wednesday-july-5-2023/1526 "2023-07-05T13:28:19Z")
Join us for the next session of CrateDB Office hour. This time we are meeting on July 5 starting at 3 PM CET / 9 AM ET. Use this opportunity to learn more about CrateDB from our engineers, ask questions, and share your i… --- ## [Live Demo: How to replicate data from other databases to CrateDB with Debezium and Kafka](https://community.cratedb.com/t/live-demo-how-to-replicate-data-from-other-databases-to-cratedb-with-debezium-and-kafka/1530)
**Author:** [@alicecrateio](https://community.cratedb.com/u/alicecrateio)\ **Replies:** 0\ **Last updated:** [June 30, 2023, 2:46pm UTC](https://community.cratedb.com/t/live-demo-how-to-replicate-data-from-other-databases-to-cratedb-with-debezium-and-kafka/1530 "2023-06-30T14:46:58Z")
Join us for our upcoming Live Demo: How to replicate data from other databases to CrateDB with Debezium and Kafka Date: July 13th, 2023, from 04:00–04:45 pm CET 2023-07-13T14:00:00Z (UTC)→2023-07-13T14:45:00Z (UTC) Wh… --- ## [CrateDB Workshop - June 28](https://community.cratedb.com/t/cratedb-workshop-june-28/1522)
**Author:** [@alicecrateio](https://community.cratedb.com/u/alicecrateio)\ **Replies:** 0\ **Last updated:** [June 23, 2023, 8:36am UTC](https://community.cratedb.com/t/cratedb-workshop-june-28/1522 "2023-06-23T08:36:33Z")
CrateDB Workshop is coming soon! June 28th, 2023, from 02:00 to 5:00 pm CET (possibility to join at a specific time, see below) 2023-06-28T12:00:00Z (UTC)→2023-06-28T15:00:00Z (UTC) Who is it for: Data Engineer, Datab… --- ## [Today's Live Demo on Mastering Monitoring: A Step-by-Step Guide to Using Prometheus and Grafana with CrateDB Cloud](https://community.cratedb.com/t/todays-live-demo-on-mastering-monitoring-a-step-by-step-guide-to-using-prometheus-and-grafana-with-cratedb-cloud/1500)
**Author:** [@alicecrateio](https://community.cratedb.com/u/alicecrateio)\ **Replies:** 0\ **Last updated:** [May 31, 2023, 8:19am UTC](https://community.cratedb.com/t/todays-live-demo-on-mastering-monitoring-a-step-by-step-guide-to-using-prometheus-and-grafana-with-cratedb-cloud/1500 "2023-05-31T08:19:10Z")
:loudspeaker: Did you already save your spot for today’s webinar? We’ll discuss Mastering Monitoring and guide you step-by-step to using Prometheus and Grafana with CrateDB Cloud :wink: May 31st, 2023 at 3:00 pm CET Yo… --- ## [CrateDB Workshop on June 28!](https://community.cratedb.com/t/cratedb-workshop-on-june-28/1490)
**Author:** [@Marija](https://community.cratedb.com/u/Marija)\ **Replies:** 0\ **Last updated:** [May 25, 2023, 12:47pm UTC](https://community.cratedb.com/t/cratedb-workshop-on-june-28/1490 "2023-05-25T12:47:10Z")
It is our pleasure to announce the next CrateDB Workshop that will take place on June 28 starting at 2 PM CET/8 AM ET/5 AM PDT. Don’t miss the opportunity to get a hands-on learning experience about the fundamental conce… --- ## [CrateDB office hours: Wednesday, June 7 2023](https://community.cratedb.com/t/cratedb-office-hours-wednesday-june-7-2023/1486)
**Author:** [@Marija](https://community.cratedb.com/u/Marija)\ **Replies:** 0\ **Last updated:** [May 16, 2023, 3:16pm UTC](https://community.cratedb.com/t/cratedb-office-hours-wednesday-june-7-2023/1486 "2023-05-16T15:16:32Z")
Are you interested in learning more about CrateDB, the open-source distributed SQL database? Or do you have questions about using CrateDB in your own projects? Then don’t miss our next CrateDB Office Hour session on June… --- ## [CrateDB office hours: Wednesday, May 10, 2023](https://community.cratedb.com/t/cratedb-office-hours-wednesday-may-10-2023/1466)
**Author:** [@Marija](https://community.cratedb.com/u/Marija)\ **Replies:** 1\ **Last updated:** [May 10, 2023, 3:54pm UTC](https://community.cratedb.com/t/cratedb-office-hours-wednesday-may-10-2023/1466 "2023-05-10T15:54:06Z")
Join us in the next session of CrateDB office hours on May 10, 2023, at 5 PM CET/11 AM ET. Do not miss the opportunity to talk to CrateDB engineers and share your use case :slight\_smile: The session is hosted by develop… --- ## [Live Demo - Mastering Monitoring: A Step-by-Step Guide to Using Prometheus and Grafana with CrateDB Cloud](https://community.cratedb.com/t/live-demo-mastering-monitoring-a-step-by-step-guide-to-using-prometheus-and-grafana-with-cratedb-cloud/1472)
**Author:** [@alicecrateio](https://community.cratedb.com/u/alicecrateio)\ **Replies:** 0\ **Last updated:** [May 8, 2023, 12:43pm UTC](https://community.cratedb.com/t/live-demo-mastering-monitoring-a-step-by-step-guide-to-using-prometheus-and-grafana-with-cratedb-cloud/1472 "2023-05-08T12:43:46Z")
Hi there! :wave: Have you registered for our upcoming Live Demo? :wink: In this interactive live demo, learn, step-by-step, how to use Prometheus and Grafana with CrateDB Cloud. CrateDB Cloud users can implement their… --- ## [Upcoming Live Demo: Learn simple No-Code Data Import and Visualization with CrateDB Cloud](https://community.cratedb.com/t/upcoming-live-demo-learn-simple-no-code-data-import-and-visualization-with-cratedb-cloud/1459)
**Author:** [@alicecrateio](https://community.cratedb.com/u/alicecrateio)\ **Replies:** 0\ **Last updated:** [April 24, 2023, 8:28am UTC](https://community.cratedb.com/t/upcoming-live-demo-learn-simple-no-code-data-import-and-visualization-with-cratedb-cloud/1459 "2023-04-24T08:28:18Z")
Last chance to register for our CrateDB Cloud Live Demo :date: Date: Thursday, April 27th, 4:00 pm CET Topic: Learn simple No-Code Data Import and Visualization with CrateDB Cloud :desktop\_computer: Who is it for: Sof… [Next page](https://community.cratedb.com/c/community/38.md?page=1)