# CrateDB **URL:** https://community.cratedb.com/c/cratedb/18.md?page=2 [Latest](https://community.cratedb.com/latest.md) · [Categories](https://community.cratedb.com/categories.md) · [Tags](https://community.cratedb.com/tags.md) **Page:** 3 --- ## [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… --- ## [After upgrading from version 5.10.1 to 5.10.2, some statements could not be completed](https://community.cratedb.com/t/after-upgrading-from-version-5-10-1-to-5-10-2-some-statements-could-not-be-completed/1992)
**Author:** [@Jun\_Zhou](https://community.cratedb.com/u/Jun_Zhou)\ **Replies:** 3\ **Last updated:** [March 11, 2025, 8:27am UTC](https://community.cratedb.com/t/after-upgrading-from-version-5-10-1-to-5-10-2-some-statements-could-not-be-completed/1992 "2025-03-11T08:27:10Z")
After the upgrade, there are seventy-one statements related to inserting into the Prometheus table metrics that are still in an active status. I’m not sure if this issue is related to the upgrade, but the start timestamp… --- ## [How to distribute the primary shards more evenly across multiple nodes?](https://community.cratedb.com/t/how-to-distribute-the-primary-shards-more-evenly-across-multiple-nodes/1989)
**Author:** [@Jun\_Zhou](https://community.cratedb.com/u/Jun_Zhou)\ **Replies:** 2\ **Last updated:** [March 10, 2025, 9:38am UTC](https://community.cratedb.com/t/how-to-distribute-the-primary-shards-more-evenly-across-multiple-nodes/1989 "2025-03-10T09:38:29Z")
I have stored Prometheus monitoring data in CrateDB 5.10.1, with the table name being doc.metrics . After rolling the upgrade to version 5.10.2, I noticed that most of the primary shards are concentrated on a single node… --- ## [HTTP Endpoint: Multiple Statements in Transaction possible?](https://community.cratedb.com/t/http-endpoint-multiple-statements-in-transaction-possible/1978)
**Author:** [@davidpace](https://community.cratedb.com/u/davidpace)\ **Replies:** 3\ **Last updated:** [March 5, 2025, 12:04pm UTC](https://community.cratedb.com/t/http-endpoint-multiple-statements-in-transaction-possible/1978 "2025-03-05T12:04:19Z")
Hi all, is it possible to execute multiple statements (say, an ALTER and an UPDATE statement) using the HTTP endpoint in a single transaction? --- ## [Removal of \_doc in 5.10.0 version](https://community.cratedb.com/t/removal-of-doc-in-5-10-0-version/1976)
**Author:** [@Snehal\_Jadhav](https://community.cratedb.com/u/Snehal_Jadhav)\ **Replies:** 1\ **Last updated:** [March 4, 2025, 2:31pm UTC](https://community.cratedb.com/t/removal-of-doc-in-5-10-0-version/1976 "2025-03-04T14:31:10Z")
I have a table with defination as follows : CREATE TABLE users ( id INT PRIMARY KEY, name STRING, age INT ); I have 2 records in it. The count(\_doc) for users table is also 2. As per latest release doc, \_d… --- ## [Partitioning strategy](https://community.cratedb.com/t/partitioning-strategy/1831)
**Author:** [@bfmcneill](https://community.cratedb.com/u/bfmcneill)\ **Replies:** 3\ **Last updated:** [February 6, 2025, 2:42pm UTC](https://community.cratedb.com/t/partitioning-strategy/1831 "2025-02-06T14:42:22Z")
Hello, I have ~30 Million records that could be naturally partitioned into months. that would create around36 partitions. I am running crate on a 2 node cluster. each node has 32gb ram and 2 cpu w/ 8 cores per cpu. i… --- ## [Prepared Statement Query Returns Duplicate Records but CrateDB Console Query Doesn’t](https://community.cratedb.com/t/prepared-statement-query-returns-duplicate-records-but-cratedb-console-query-doesn-t/1966)
**Author:** [@Sunil](https://community.cratedb.com/u/Sunil)\ **Replies:** 1\ **Last updated:** [January 23, 2025, 2:43pm UTC](https://community.cratedb.com/t/prepared-statement-query-returns-duplicate-records-but-cratedb-console-query-doesn-t/1966 "2025-01-23T14:43:08Z")
Hello, When we execute a query using a prepared statement, it returns duplicate records, while running the same query directly on the CrateDB console gives the correct results. This issue can be reproduced using this d… --- ## [Academy course: wrong analyzer?](https://community.cratedb.com/t/academy-course-wrong-analyzer/1931)
**Author:** [@MirtoBusico](https://community.cratedb.com/u/MirtoBusico)\ **Replies:** 2\ **Last updated:** [January 14, 2025, 8:54pm UTC](https://community.cratedb.com/t/academy-course-wrong-analyzer/1931 "2025-01-14T20:54:58Z")
Hi all, seems that there is an error in defining the analyzer in the tables defined for the Academy CrateDB Fundamentals course. What have I to do? Going on with the course accepting different results from the lesson? … --- ## [Disproportional space usage](https://community.cratedb.com/t/disproportional-space-usage/1951)
**Author:** [@ibrhmkoz](https://community.cratedb.com/u/ibrhmkoz)\ **Replies:** 4\ **Last updated:** [January 13, 2025, 5:55pm UTC](https://community.cratedb.com/t/disproportional-space-usage/1951 "2025-01-13T17:55:46Z")
Given the table definitions below. create table posts\_v2 ( id varchar primary key, channel varchar, external\_id varchar, published\_at timestamp with time zone, created\_at timestamp with tim… --- ## [How to format output in HTTP endpoint?](https://community.cratedb.com/t/how-to-format-output-in-http-endpoint/1945)
**Author:** [@MirtoBusico](https://community.cratedb.com/u/MirtoBusico)\ **Replies:** 6\ **Last updated:** [January 10, 2025, 8:12pm UTC](https://community.cratedb.com/t/how-to-format-output-in-http-endpoint/1945 "2025-01-10T20:12:33Z")
Hi all, I’m trying to obtain the same type of output for the HTTP endpoint as in the HTTP endpoint documentation sh$ curl -sS -H 'Content-Type: application/json' \\ ... -X POST '127.0.0.1:4200/\_sql' \\ ... -d '{"stmt":"s… --- ## [“HTTP/1.1 307 Temporary Redirect” error when uploading a blob](https://community.cratedb.com/t/http-1-1-307-temporary-redirect-error-when-uploading-a-blob/1944)
**Author:** [@MirtoBusico](https://community.cratedb.com/u/MirtoBusico)\ **Replies:** 6\ **Last updated:** [January 4, 2025, 1:18pm UTC](https://community.cratedb.com/t/http-1-1-307-temporary-redirect-error-when-uploading-a-blob/1944 "2025-01-04T13:18:54Z")
Hi all, when I try to upload a file (in this case a .pdf) sometimes I receive the error HTTP/1.1 307 Temporary Redirect I tried to upload a .png file and an .mp4 file without errors. Then I tried with another .pdf … --- ## [Unable to create tarball for crate db on ubunutu](https://community.cratedb.com/t/unable-to-create-tarball-for-crate-db-on-ubunutu/1940)
**Author:** [@Rhythm\_Narula](https://community.cratedb.com/u/Rhythm_Narula)\ **Replies:** 2\ **Last updated:** [January 1, 2025, 4:38pm UTC](https://community.cratedb.com/t/unable-to-create-tarball-for-crate-db-on-ubunutu/1940 "2025-01-01T16:38:53Z")
I am facing this issue when trying to run → ./mvnw package -DskipTests=true Artifact: io.crate:jlink-jdk:jlink:5.10.0 (included by module) does not have an artifact with a file. Please ensure the package phase is run … --- ## [Panic: restarting the kubernetes cluster loses all blobs but retains the doc tables](https://community.cratedb.com/t/panic-restarting-the-kubernetes-cluster-loses-all-blobs-but-retains-the-doc-tables/1941)
**Author:** [@MirtoBusico](https://community.cratedb.com/u/MirtoBusico)\ **Replies:** 8\ **Last updated:** [December 31, 2024, 1:05pm UTC](https://community.cratedb.com/t/panic-restarting-the-kubernetes-cluster-loses-all-blobs-but-retains-the-doc-tables/1941 "2024-12-31T13:05:48Z")
Hi all, in my home-lab I’m using CrateDB installed in kubernetes using the crate-operator. I created a blob table and uploaded three files: sysop@h5a-dev:~/h5a/software/pcams/storehouse/cratedb/attachments$ crash --ve… --- ## [How to upload a blob using curl?](https://community.cratedb.com/t/how-to-upload-a-blob-using-curl/1939)
**Author:** [@MirtoBusico](https://community.cratedb.com/u/MirtoBusico)\ **Replies:** 3\ **Last updated:** [December 30, 2024, 9:15am UTC](https://community.cratedb.com/t/how-to-upload-a-blob-using-curl/1939 "2024-12-30T09:15:27Z")
I’m trying to upload a blob using curl; but I receive an authorization error. Im following the example at using blob tables - upload The example code don’t use any kind of authentication sh$ curl -isSX PUT '127.0.0.1:… --- ## [Problem with distance query](https://community.cratedb.com/t/problem-with-distance-query/1932)
**Author:** [@joheams](https://community.cratedb.com/u/joheams)\ **Replies:** 2\ **Last updated:** [December 28, 2024, 5:53pm UTC](https://community.cratedb.com/t/problem-with-distance-query/1932 "2024-12-28T17:53:40Z")
Hey there, I have a problem with some geospacial queries in crateDB, especially distance I have a query like SELECT date, creation\_date, code, distance(\[latitude, longitude\], \[48.58916271607118, 2.0338593032353143 \]):… --- ## [Hello Currently my crate db ui shows my cluster is unhealthy](https://community.cratedb.com/t/hello-currently-my-crate-db-ui-shows-my-cluster-is-unhealthy/1934)
**Author:** [@Yusuf\_Cansiz](https://community.cratedb.com/u/Yusuf_Cansiz)\ **Replies:** 2\ **Last updated:** [December 26, 2024, 11:28am UTC](https://community.cratedb.com/t/hello-currently-my-crate-db-ui-shows-my-cluster-is-unhealthy/1934 "2024-12-26T11:28:51Z")
Hello my crate db cluster health status is red right now but my application works normally and all the table shards are green. When I check network logs of the ui I see some bad request. I think this is some sort of bug … --- ## [Query using MAX on column using calculated partition key on that column not performing as expected](https://community.cratedb.com/t/query-using-max-on-column-using-calculated-partition-key-on-that-column-not-performing-as-expected/1918)
**Author:** [@ness](https://community.cratedb.com/u/ness)\ **Replies:** 13\ **Last updated:** [December 18, 2024, 11:03am UTC](https://community.cratedb.com/t/query-using-max-on-column-using-calculated-partition-key-on-that-column-not-performing-as-expected/1918 "2024-12-18T11:03:55Z")
I have a table with billions of records, that looks something like: CREATE TABLE IF NOT EXISTS "public"."locations" ( "last\_response" TIMESTAMP WITHOUT TIME ZONE NOT NULL, "id" BIGINT DEFAULT CAST(current\_timestam… --- ## [CreateDB Sql Console Logout](https://community.cratedb.com/t/createdb-sql-console-logout/1927)
**Author:** [@thunderbug1](https://community.cratedb.com/u/thunderbug1)\ **Replies:** 1\ **Last updated:** [December 16, 2024, 2:40pm UTC](https://community.cratedb.com/t/createdb-sql-console-logout/1927 "2024-12-16T14:40:40Z")
Is there a way to logout of the Console and sign in as a different user? Either it is a basic feature that is missing or very well hidden. --- ## [SQL syntax for geospatial data](https://community.cratedb.com/t/sql-syntax-for-geospatial-data/1930)
**Author:** [@MirtoBusico](https://community.cratedb.com/u/MirtoBusico)\ **Replies:** 3\ **Last updated:** [December 16, 2024, 10:17am UTC](https://community.cratedb.com/t/sql-syntax-for-geospatial-data/1930 "2024-12-16T10:17:45Z")
Hi all, I’m trying the lesson Hands-on: Geospatial Data and I’m stuck in the test at the lesson end. I tried two form of query but I receive always an error: First using intersect cr\> SELECT name, … --- ## [Export data to Azure blob storage](https://community.cratedb.com/t/export-data-to-azure-blob-storage/1928)
**Author:** [@thunderbug1](https://community.cratedb.com/u/thunderbug1)\ **Replies:** 3\ **Last updated:** [December 13, 2024, 9:37am UTC](https://community.cratedb.com/t/export-data-to-azure-blob-storage/1928 "2024-12-13T09:37:34Z")
I am trying to export a table to an azure blob store. The query looks like this: COPY "remoteserviceassistant"."faq\_raw" TO DIRECTORY 'az://myblobstore.blob.core.windows.net/faqdata/faq' WITH ( key = 'awnefaofawenf… --- ## [How allowedCIDRs works?](https://community.cratedb.com/t/how-allowedcidrs-works/1923)
**Author:** [@MirtoBusico](https://community.cratedb.com/u/MirtoBusico)\ **Replies:** 3\ **Last updated:** [December 10, 2024, 5:57pm UTC](https://community.cratedb.com/t/how-allowedcidrs-works/1923 "2024-12-10T17:57:03Z")
Sorry, I’m here again. I don’t understand how allowedCIDRs works or mybe I don’t understand host authentication. Before restricting network access with allowedCIDRs I was able to access the CrateDB UI both from the loa… --- ## [Installing crash with pipx fails](https://community.cratedb.com/t/installing-crash-with-pipx-fails/1922)
**Author:** [@MirtoBusico](https://community.cratedb.com/u/MirtoBusico)\ **Replies:** 3\ **Last updated:** [December 8, 2024, 6:09pm UTC](https://community.cratedb.com/t/installing-crash-with-pipx-fails/1922 "2024-12-08T18:09:29Z")
Hi all, I’m trying to install crash in a docker container with Debian stable operating system following instructions at https://cratedb.com/docs/crate/crash/en/latest/getting-started.html#python-package But my pipx don… --- ## [DataGrip Limited Compatibility](https://community.cratedb.com/t/datagrip-limited-compatibility/1187)
**Author:** [@confused\_sailor](https://community.cratedb.com/u/confused_sailor)\ **Replies:** 2\ **Last updated:** [December 5, 2024, 5:51pm UTC](https://community.cratedb.com/t/datagrip-limited-compatibility/1187 "2024-12-05T17:51:06Z")
I have followed the instructions offered for using CrateDB with Datagrip. It’s function seems limited to the query console however. The sidebar table lists do not work, nor can I use the traditional table view. I notice… --- ## [How to enable HBA when using crate-operator?](https://community.cratedb.com/t/how-to-enable-hba-when-using-crate-operator/1916)
**Author:** [@MirtoBusico](https://community.cratedb.com/u/MirtoBusico)\ **Replies:** 5\ **Last updated:** [December 4, 2024, 12:14pm UTC](https://community.cratedb.com/t/how-to-enable-hba-when-using-crate-operator/1916 "2024-12-04T12:14:09Z")
Hi all, I’m trying to install and configure CrateDB using the crate-operator. I’m using a reverse proxy in front of the kubernetes cluster and I need to restrict the crate loadbalancer access to the internal network. F… --- ## [Disk Space Allocation Concerns with Longhorn](https://community.cratedb.com/t/disk-space-allocation-concerns-with-longhorn/1915)
**Author:** [@MirtoBusico](https://community.cratedb.com/u/MirtoBusico)\ **Replies:** 1\ **Last updated:** [December 3, 2024, 8:24pm UTC](https://community.cratedb.com/t/disk-space-allocation-concerns-with-longhorn/1915 "2024-12-03T20:24:55Z")
Hi all, I’ve setup CrateDB using the crate-operator on a K3S cluster using Longhorn storage. I have some concerns about the disk allocation. I defined a debug disk of 4GB and a data disk of 16GB. This on a 3 node Crat… --- ## [How to tier partitions onto cheaper disks](https://community.cratedb.com/t/how-to-tier-partitions-onto-cheaper-disks/1868)
**Author:** [@ness](https://community.cratedb.com/u/ness)\ **Replies:** 3\ **Last updated:** [December 3, 2024, 1:01pm UTC](https://community.cratedb.com/t/how-to-tier-partitions-onto-cheaper-disks/1868 "2024-12-03T13:01:35Z")
Hi, new to Crate, apologies if this is covered in the docs, but I couldn’t find it. I want to partition my data by date so that very old shards live on slower, much cheaper disks, on all the nodes. Is this possible? Or … --- ## [Using crate-operator the installation fails with "AttachVolume.Attach failed for volume"](https://community.cratedb.com/t/using-crate-operator-the-installation-fails-with-attachvolume-attach-failed-for-volume/1909)
**Author:** [@MirtoBusico](https://community.cratedb.com/u/MirtoBusico)\ **Replies:** 6\ **Last updated:** [November 30, 2024, 6:30pm UTC](https://community.cratedb.com/t/using-crate-operator-the-installation-fails-with-attachvolume-attach-failed-for-volume/1909 "2024-11-30T18:30:56Z")
Hi all, I’m trying to install CrateDB using crate-operator; but the installation fails giving the same error on every PV created: 32s Warning FailedAttachVolume pod/crate-data-hot-my-cluster-1 … --- ## [Getting error "Too many open files in system"](https://community.cratedb.com/t/getting-error-too-many-open-files-in-system/1903)
**Author:** [@Amod](https://community.cratedb.com/u/Amod)\ **Replies:** 3\ **Last updated:** [November 29, 2024, 2:42pm UTC](https://community.cratedb.com/t/getting-error-too-many-open-files-in-system/1903 "2024-11-29T14:42:43Z")
Hi, We are getting error “Too many open files in system” in our Crate 5.8.2 cluster setup. We are not seeing large no. of files getting opened in any of crate cluster node. Here is the output of the query: SELECT… --- ## [Primary key and partitioning fundamentally incompatible?](https://community.cratedb.com/t/primary-key-and-partitioning-fundamentally-incompatible/1908)
**Author:** [@ness](https://community.cratedb.com/u/ness)\ **Replies:** 4\ **Last updated:** [November 27, 2024, 3:20pm UTC](https://community.cratedb.com/t/primary-key-and-partitioning-fundamentally-incompatible/1908 "2024-11-27T15:20:15Z")
A primary key has high cardinality, so cannot be a partition key. If a primary key is defined, you cannot use any other column as the partition key. You cannot use a generated column (eg (ID % 1000000)) as the partitio… --- ## [Crate-operator how to disable loadbalancer?](https://community.cratedb.com/t/crate-operator-how-to-disable-loadbalancer/1906)
**Author:** [@MirtoBusico](https://community.cratedb.com/u/MirtoBusico)\ **Replies:** 1\ **Last updated:** [November 26, 2024, 1:12pm UTC](https://community.cratedb.com/t/crate-operator-how-to-disable-loadbalancer/1906 "2024-11-26T13:12:10Z")
Hi all, I’m new to cratedb and I’m trying to install cratedb in a local deployed kubernetes cluster using the crate-operator. Reading the documentation seems that the operator creates a loadbalancer that exposes crated… [Previous page](https://community.cratedb.com/c/cratedb/18.md?page=1) [Next page](https://community.cratedb.com/c/cratedb/18.md?page=3)