# \#developer

**URL:** https://www.singlestore.com/forum/tag/developer/10.md

[Latest](https://www.singlestore.com/forum/latest.md) · [Categories](https://www.singlestore.com/forum/categories.md) · [Tags](https://www.singlestore.com/forum/tags.md)

---

## [Increase in query time after I created a sharded key on one of the join columns](https://www.singlestore.com/forum/t/increase-in-query-time-after-i-created-a-sharded-key-on-one-of-the-join-columns/8363)

<div class="topic-metadata">

**Author:** [@shanelobo18](https://www.singlestore.com/forum/u/shanelobo18)\
**Replies:** 4\
**Last updated:** [September 15, 2025, 5:57pm UTC](https://www.singlestore.com/forum/t/increase-in-query-time-after-i-created-a-sharded-key-on-one-of-the-join-columns/8363 "2025-09-15T17:57:10Z")

</div>

Hi team, So I was using sample data from the employees table (from the s3 bucket singlestore-education/datasets/db\_employees/) and was tuning the below query SELECT e.first\_name, e.last\_name, d.dept\_name, t.title, t.fr…

---

## [DECLARE TABLE & PRINT statement \[T-SQL\] Equivalent in Singlestore](https://www.singlestore.com/forum/t/declare-table-print-statement-t-sql-equivalent-in-singlestore/8263)

<div class="topic-metadata">

**Author:** [@soufiane.mbk](https://www.singlestore.com/forum/u/soufiane.mbk)\
**Replies:** 2\
**Last updated:** [June 14, 2025, 1:28am UTC](https://www.singlestore.com/forum/t/declare-table-print-statement-t-sql-equivalent-in-singlestore/8263 "2025-06-14T01:28:11Z")

</div>

Hi everybody, I hope you’re well! I’m currently working with SingleStore and I would like to know if there is an equivalent of the PRINT T-SQL statement in SingleStore stored procedure. how can i replace If not, will t…

---

## [The recovery process seems to be stuck](https://www.singlestore.com/forum/t/the-recovery-process-seems-to-be-stuck/8246)

<div class="topic-metadata">

**Author:** [@Thao158](https://www.singlestore.com/forum/u/Thao158)\
**Replies:** 1\
**Last updated:** [June 3, 2025, 11:00pm UTC](https://www.singlestore.com/forum/t/the-recovery-process-seems-to-be-stuck/8246 "2025-06-03T23:00:02Z")

</div>

Hi team, Our singlestore cluster is deployed on OCP environment, using ICOS bucket as bottomless. Recently we have seen the following error: Leaf Error (node-memsql-cluster-leaf-ag2-9.svc-memsql-cluster:3306): Failed …

---

## [Singlestore is queuing most queries, but CPU or Memory is not at maximum usage](https://www.singlestore.com/forum/t/singlestore-is-queuing-most-queries-but-cpu-or-memory-is-not-at-maximum-usage/8234)

<div class="topic-metadata">

**Author:** [@pablo\_at\_neodash](https://www.singlestore.com/forum/u/pablo_at_neodash)\
**Replies:** 1\
**Last updated:** [May 9, 2025, 10:53pm UTC](https://www.singlestore.com/forum/t/singlestore-is-queuing-most-queries-but-cpu-or-memory-is-not-at-maximum-usage/8234 "2025-05-09T22:53:00Z")

</div>

Singlestore is queuing most queries, but CPU or Memory is not at maximum usage I have version 8.9 (self-managed), and it has 5 databases. For example, one database has a table with over 70 million records. This is just …

---

## [Clarification on "OPTIMIZE TABLE" Behavior in SingleStore 5.7.32](https://www.singlestore.com/forum/t/clarification-on-optimize-table-behavior-in-singlestore-5-7-32/8227)

<div class="topic-metadata">

**Author:** [@bruce.chen](https://www.singlestore.com/forum/u/bruce.chen)\
**Replies:** 1\
**Last updated:** [May 6, 2025, 3:52pm UTC](https://www.singlestore.com/forum/t/clarification-on-optimize-table-behavior-in-singlestore-5-7-32/8227 "2025-05-06T15:52:00Z")

</div>

Hi Team, I’m currently running SingleStore version 5.7.32 (Self-Managed) and would like to clarify the behavior of the OPTIMIZE TABLE command. Specifically, I’d like to know: Does running OPTIMIZE TABLE on a rowstore…

---

## [Unusual behaviour with bottomless storage](https://www.singlestore.com/forum/t/unusual-behaviour-with-bottomless-storage/8190)

<div class="topic-metadata">

**Author:** [@buituanh2002](https://www.singlestore.com/forum/u/buituanh2002)\
**Replies:** 1\
**Last updated:** [April 22, 2025, 11:31pm UTC](https://www.singlestore.com/forum/t/unusual-behaviour-with-bottomless-storage/8190 "2025-04-22T23:31:30Z")

</div>

Hi everyone, I am currently using SingleStore Self Managed v8.1 with bottomless storage on S3 buckets. I have encountered an issue where the data volume—including actual data, blob cache, etc.—is abnormally inflated whe…

---

## [Memory Allocation Error in SingleStore for SQL Query with Aggregation](https://www.singlestore.com/forum/t/memory-allocation-error-in-singlestore-for-sql-query-with-aggregation/8178)

<div class="topic-metadata">

**Author:** [@salih.kilic](https://www.singlestore.com/forum/u/salih.kilic)\
**Replies:** 2\
**Last updated:** [April 8, 2025, 8:12am UTC](https://www.singlestore.com/forum/t/memory-allocation-error-in-singlestore-for-sql-query-with-aggregation/8178 "2025-04-08T08:12:50Z")

</div>

Hello There Community, We are encountering a recurring issue with running a specific query on our SingleStore cluster, even after restarting services and increasing the memory capacity. The query in question is as follo…

---

## [SingleStore Self-Managed Deployment Script](https://www.singlestore.com/forum/t/singlestore-self-managed-deployment-script/8122)

<div class="topic-metadata">

**Author:** [@heychazza](https://www.singlestore.com/forum/u/heychazza)\
**Replies:** 2\
**Last updated:** [February 26, 2025, 2:38pm UTC](https://www.singlestore.com/forum/t/singlestore-self-managed-deployment-script/8122 "2025-02-26T14:38:02Z")

</div>

Hey SingleStore community, I’ve been a long-time user of SingleStore and have experienced the hurdles when building a SaaS (Software-as-a-Service) with it. It all started when I got an Apple Silicon Macbook and couldn’t…

---

## [AMD Configuration](https://www.singlestore.com/forum/t/amd-configuration/8112)

<div class="topic-metadata">

**Author:** [@mcharles](https://www.singlestore.com/forum/u/mcharles)\
**Replies:** 3\
**Last updated:** [February 25, 2025, 1:00am UTC](https://www.singlestore.com/forum/t/amd-configuration/8112 "2025-02-25T01:00:56Z")

</div>

Does anyone have experience running S2 on AMD hardware?

---

## [How to look at prepared statements?](https://www.singlestore.com/forum/t/how-to-look-at-prepared-statements/8040)

<div class="topic-metadata">

**Author:** [@jlevin2](https://www.singlestore.com/forum/u/jlevin2)\
**Replies:** 1\
**Last updated:** [January 13, 2025, 10:24pm UTC](https://www.singlestore.com/forum/t/how-to-look-at-prepared-statements/8040 "2025-01-13T22:24:51Z")

</div>

Hi, we recently hit the max\_prepared\_stmt\_count limit in our environment. We believe we have a work around but while looking at the issue I felt a bit like I was working blind. In particular I was trying to find a way …

---

## [Unusual Index disk usage](https://www.singlestore.com/forum/t/unusual-index-disk-usage/8047)

<div class="topic-metadata">

**Author:** [@bhaskar](https://www.singlestore.com/forum/u/bhaskar)\
**Replies:** 1\
**Last updated:** [January 2, 2025, 7:00pm UTC](https://www.singlestore.com/forum/t/unusual-index-disk-usage/8047 "2025-01-02T19:00:40Z")

</div>

One of my table has 10 GB of Index disk usage while the data disk size of the table is 3 GB. How come it is possible that index disk usage is more than data disk size?

---

## [How to load multiple parquet in one go in singlestore?](https://www.singlestore.com/forum/t/how-to-load-multiple-parquet-in-one-go-in-singlestore/8019)

<div class="topic-metadata">

**Author:** [@bhaskar](https://www.singlestore.com/forum/u/bhaskar)\
**Replies:** 2\
**Last updated:** [December 6, 2024, 11:34am UTC](https://www.singlestore.com/forum/t/how-to-load-multiple-parquet-in-one-go-in-singlestore/8019 "2024-12-06T11:34:16Z")

</div>

How to load multiple parquet files from folder into table in one go? LOAD DATA S3 's3://bucket-name/example\_table/' CONFIG '{"region" : "ap-south-1"}' CREDENTIALS '{"aws\_access\_key\_id" : "{aws\_access\_key\_id}", "aws\_secr…

---

## [Using multiple containers to run a multi-node cluster using Docker](https://www.singlestore.com/forum/t/using-multiple-containers-to-run-a-multi-node-cluster-using-docker/6355)

<div class="topic-metadata">

**Author:** [@Anjana](https://www.singlestore.com/forum/u/Anjana)\
**Replies:** 4\
**Last updated:** [November 11, 2024, 9:47pm UTC](https://www.singlestore.com/forum/t/using-multiple-containers-to-run-a-multi-node-cluster-using-docker/6355 "2024-11-11T21:47:39Z")

</div>

Hello everyone, I was following this guide: Spin Up a SingleStore Cluster on Docker Desktop in 10 Minutes to create a multi-node cluster and I realized that it only shows how to create one node using the memsql/cluster-…

---

## [How to do upsert without causing too much memory spike?](https://www.singlestore.com/forum/t/how-to-do-upsert-without-causing-too-much-memory-spike/7847)

<div class="topic-metadata">

**Author:** [@bhaskar](https://www.singlestore.com/forum/u/bhaskar)\
**Replies:** 4\
**Last updated:** [November 4, 2024, 3:18pm UTC](https://www.singlestore.com/forum/t/how-to-do-upsert-without-causing-too-much-memory-spike/7847 "2024-11-04T15:18:48Z")

</div>

Hi, We have to do around 100k records upsert into a table. The table has around 200-300 columns. What we are currently doing is dividing that 100k records into 1k batch and doing the upserts. But this is causing a high …

---

## [Write only replica for the table](https://www.singlestore.com/forum/t/write-only-replica-for-the-table/7849)

<div class="topic-metadata">

**Author:** [@bhaskar](https://www.singlestore.com/forum/u/bhaskar)\
**Replies:** 3\
**Last updated:** [October 7, 2024, 11:57pm UTC](https://www.singlestore.com/forum/t/write-only-replica-for-the-table/7849 "2024-10-07T23:57:35Z")

</div>

Hi, We have one table where we need to do heavy write each day around 100 K records with upsert. Currently our table is columnar so upsert is taking too much memory. Is there a way that we can have write heavy and read …

---

## [JDBC sequential URL and its usage with singlestore-jdbc-client-1.2.1.jar](https://www.singlestore.com/forum/t/jdbc-sequential-url-and-its-usage-with-singlestore-jdbc-client-1-2-1-jar/7665)

<div class="topic-metadata">

**Author:** [@muhammadosama.hassan](https://www.singlestore.com/forum/u/muhammadosama.hassan)\
**Replies:** 1\
**Last updated:** [September 11, 2024, 9:50am UTC](https://www.singlestore.com/forum/t/jdbc-sequential-url-and-its-usage-with-singlestore-jdbc-client-1-2-1-jar/7665 "2024-09-11T09:50:54Z")

</div>

have any body used and give me an example of singlestore-jdbc-client-1.2.1.jar i want to enable a failover JDBC connection with my aggregator node as it will be promoted to Master incase of primary failure.

---

## [Did not receive developer badge, even after finishing comprehensive developer training](https://www.singlestore.com/forum/t/did-not-receive-developer-badge-even-after-finishing-comprehensive-developer-training/5443)

<div class="topic-metadata">

**Author:** [@rajan.vishwakarma](https://www.singlestore.com/forum/u/rajan.vishwakarma)\
**Replies:** 7\
**Last updated:** [August 21, 2024, 4:57pm UTC](https://www.singlestore.com/forum/t/did-not-receive-developer-badge-even-after-finishing-comprehensive-developer-training/5443 "2024-08-21T16:57:51Z")

</div>

Did not receive developer badge, even after finishing comprehensive developer training.

---

## [Average\_Roundtrip\_Latency\_ms going to very high value in 1 sec](https://www.singlestore.com/forum/t/average-roundtrip-latency-ms-going-to-very-high-value-in-1-sec/7562)

<div class="topic-metadata">

**Author:** [@ann.minnu](https://www.singlestore.com/forum/u/ann.minnu)\
**Replies:** 4\
**Last updated:** [June 24, 2024, 7:00pm UTC](https://www.singlestore.com/forum/t/average-roundtrip-latency-ms-going-to-very-high-value-in-1-sec/7562 "2024-06-24T19:00:52Z")

</div>

The Average\_Roundtrip\_Latency\_ms in show leaves output is going to a 13 digit value in just 1 second gap. memsql version : 8.1.7 There is no latency observed between the servers , ie, master aggregator and leaf nodes. …

---

## [Code Quality Check using SonarQube or other tool](https://www.singlestore.com/forum/t/code-quality-check-using-sonarqube-or-other-tool/7693)

<div class="topic-metadata">

**Author:** [@vasanth.ramu](https://www.singlestore.com/forum/u/vasanth.ramu)\
**Replies:** 0\
**Last updated:** [May 14, 2024, 10:29am UTC](https://www.singlestore.com/forum/t/code-quality-check-using-sonarqube-or-other-tool/7693 "2024-05-14T10:29:34Z")

</div>

We are using CICD deployments from Dev to SIT and Prod. We are having tools like SonarQube. Is there any plugin or any tool for SingleStore using which we can do automated code quality check and score. We are now manual…

---

## [Change / alter studio.log location](https://www.singlestore.com/forum/t/change-alter-studio-log-location/7690)

<div class="topic-metadata">

**Author:** [@muhammadosama.hassan](https://www.singlestore.com/forum/u/muhammadosama.hassan)\
**Replies:** 0\
**Last updated:** [May 14, 2024, 9:21am UTC](https://www.singlestore.com/forum/t/change-alter-studio-log-location/7690 "2024-05-14T09:21:34Z")

</div>

stop the studio services and locate the file " singlestoredb-studio.hcl " and change the log path variable to desired location. create a file with touch command in that directory and make sure the permission of the files…

---

## [The operating system failed to allocate memory -alma linux](https://www.singlestore.com/forum/t/the-operating-system-failed-to-allocate-memory-alma-linux/7113)

<div class="topic-metadata">

**Author:** [@Johanna\_Rosero](https://www.singlestore.com/forum/u/Johanna_Rosero)\
**Replies:** 4\
**Last updated:** [May 13, 2024, 5:06am UTC](https://www.singlestore.com/forum/t/the-operating-system-failed-to-allocate-memory-alma-linux/7113 "2024-05-13T05:06:49Z")

</div>

line 34: ER\_MEMSQL\_OOM (1712), Leaf Error (127.0.0.1:3307): The operating system failed to allocate memory (MemSQL memory use 18658.88 Mb). The request was not processed. See Memory Errors · SingleStore Documentation for…

---

## [Master aggregator's memory](https://www.singlestore.com/forum/t/master-aggregators-memory/7589)

<div class="topic-metadata">

**Author:** [@Thao158](https://www.singlestore.com/forum/u/Thao158)\
**Replies:** 4\
**Last updated:** [April 10, 2024, 8:52am UTC](https://www.singlestore.com/forum/t/master-aggregators-memory/7589 "2024-04-10T08:52:22Z")

</div>

Hello everyone! I have a question that what memory (RAM) of master aggregator stores and how can i manage them? Typically my Singlestore cluster uses very little memory from the master aggregator. But because of some err…

---

## [Use Our SQrL AI Chatbot to Answer Questions About SingleStoreDB](https://www.singlestore.com/forum/t/use-our-sqrl-ai-chatbot-to-answer-questions-about-singlestoredb/6717)

<div class="topic-metadata">

**Author:** [@hanson](https://www.singlestore.com/forum/u/hanson)\
**Replies:** 2\
**Last updated:** [April 2, 2024, 7:47am UTC](https://www.singlestore.com/forum/t/use-our-sqrl-ai-chatbot-to-answer-questions-about-singlestoredb/6717 "2024-04-02T07:47:23Z")

</div>

It’s my pleasure to announce that we now have an AI Chatbot called SQrL that can answer your SingleStore questions amazingly well. It is trained on all our documentation, forum posts, and other SingleStore-specific conte…

---

## [Index for simple arrays (int or string) or JsonArrays?](https://www.singlestore.com/forum/t/index-for-simple-arrays-int-or-string-or-jsonarrays/7235)

<div class="topic-metadata">

**Author:** [@losch](https://www.singlestore.com/forum/u/losch)\
**Replies:** 9\
**Last updated:** [January 30, 2024, 1:02am UTC](https://www.singlestore.com/forum/t/index-for-simple-arrays-int-or-string-or-jsonarrays/7235 "2024-01-30T01:02:11Z")

</div>

Do I understand correctly that Singlestore does not currently support any kind of index for a simple array (int or string) or JsonArray? We often have data like tags = \[“home”, “office”, “worldwide”\] tag\_ids = \[3839,3…

---

## [License Expiration](https://www.singlestore.com/forum/t/license-expiration/7428)

<div class="topic-metadata">

**Author:** [@Novian](https://www.singlestore.com/forum/u/Novian)\
**Replies:** 1\
**Last updated:** [January 23, 2024, 9:23am UTC](https://www.singlestore.com/forum/t/license-expiration/7428 "2024-01-23T09:23:31Z")

</div>

Please can someone explain the expired license on the Self-managed “Premium Trial License”. After the license expires, will the singlestore cluster still run and be able to read and write? So what is the real impact of…

---

## [Data Type and String comparison issue when using SELECT INTO S3 ... FORMAT PARQUET](https://www.singlestore.com/forum/t/data-type-and-string-comparison-issue-when-using-select-into-s3-format-parquet/7403)

<div class="topic-metadata">

**Author:** [@neelesh.nirmal](https://www.singlestore.com/forum/u/neelesh.nirmal)\
**Replies:** 2\
**Last updated:** [January 5, 2024, 1:03pm UTC](https://www.singlestore.com/forum/t/data-type-and-string-comparison-issue-when-using-select-into-s3-format-parquet/7403 "2024-01-05T13:03:00Z")

</div>

Our use case is that we have a table in Singlestore, that we want to export to S3 in parquet format so that downline ETL piplines can consume the data from S3 directly. Here is the create table query which we want to ex…

---

## [Column comments available to ChatGPT plugin](https://www.singlestore.com/forum/t/column-comments-available-to-chatgpt-plugin/7356)

<div class="topic-metadata">

**Author:** [@sindri](https://www.singlestore.com/forum/u/sindri)\
**Replies:** 5\
**Last updated:** [December 7, 2023, 1:54pm UTC](https://www.singlestore.com/forum/t/column-comments-available-to-chatgpt-plugin/7356 "2023-12-07T13:54:55Z")

</div>

Hello SingleStore I have been playing around with the ChatGPT plugin and it works quite well but it would be even better if it could provide column comments included in the schema as ChatGPT can then use the comments to…

---

## [Getting access to Named Stored Procedure Query Data Type Return Value](https://www.singlestore.com/forum/t/getting-access-to-named-stored-procedure-query-data-type-return-value/7339)

<div class="topic-metadata">

**Author:** [@jc\_mtlstatic](https://www.singlestore.com/forum/u/jc_mtlstatic)\
**Replies:** 3\
**Last updated:** [November 29, 2023, 4:18pm UTC](https://www.singlestore.com/forum/t/getting-access-to-named-stored-procedure-query-data-type-return-value/7339 "2023-11-29T16:18:44Z")

</div>

My Spring Boot Java application consumes a SingleStore Named Stored Procedure using MariaDB JDBC driver( I have also observed the same behavior with the SingleStore jdbc driver as well). The NSP has an json input and pro…

---

## [Singlestore Pipeline Error After Upgrade to 8.1.x](https://www.singlestore.com/forum/t/singlestore-pipeline-error-after-upgrade-to-8-1-x/7329)

<div class="topic-metadata">

**Author:** [@swateek](https://www.singlestore.com/forum/u/swateek)\
**Replies:** 2\
**Last updated:** [November 28, 2023, 9:23am UTC](https://www.singlestore.com/forum/t/singlestore-pipeline-error-after-upgrade-to-8-1-x/7329 "2023-11-28T09:23:52Z")

</div>

We were running SingleStore 7.9.5 in a self-managed cluster before, and everything was working well till we decided to spin up a new cluster with the latest 8.1.x The pipelines which were running well in the previous cl…

---

## [\[HY000\]\[1706\] Feature 'FORMAT PARQUET in non-pipeline LOAD DATA.' is not supported by SingleStore](https://www.singlestore.com/forum/t/hy000-1706-feature-format-parquet-in-non-pipeline-load-data-is-not-supported-by-singlestore/7291)

<div class="topic-metadata">

**Author:** [@nick\_jackob](https://www.singlestore.com/forum/u/nick_jackob)\
**Replies:** 5\
**Last updated:** [November 21, 2023, 8:59am UTC](https://www.singlestore.com/forum/t/hy000-1706-feature-format-parquet-in-non-pipeline-load-data-is-not-supported-by-singlestore/7291 "2023-11-21T08:59:10Z")

</div>

Hey all, I’m trying to load parquet file into singlestore, but the error states that i can’t do that in non-pipeline LOAD DATA. The query is: load data infile ‘path/loadable.parquet’ into table test\_db.test\_table(even…

[Next page](https://www.singlestore.com/forum/tag/developer/10.md?match_all_tags=true&page=1&tags%5B%5D=developer)
