Questions tagged [singlestore]

For database related questions relating to the use of Singlestore (formerly known as MemSQL), which is a distributed SQL database. Add an additional version-specific tag like [singlestore-7.8] if that context is relevant.

Filter by
Sorted by
Tagged with
0 votes
1 answer
13 views

How to change transaction logs size in singlestore

We have a table that memsql studio says is in 5gb in size, though on disk we see approx 27gb in the data folder. After further analyzing it seems the data/logs is holding approx 16gb. Is this needed ? ...
user avatar
0 votes
1 answer
17 views

'Query Performance plan' query in singlestore

when I go to memsqlOps > Explore > Query. I’m able to see query performance and active long running queries. What table or tables can I select from to get that same information?
user avatar
1 vote
1 answer
26 views

SingleStore: Sign Up Log In Cannot get source metadata for pipeline. Failed to create consumer: ssl.ca.location failed: No further error info

below is the command that i am using, but when i create the kafka pipeline command i get the below error: ERROR 1933 ER_EXTRACTOR_EXTRACTOR_GET_LATEST_OFFSETS: Cannot get source metadata for pipeline. ...
user avatar
1 vote
1 answer
20 views

SingleStore Execute Immediate a SP/Func inside SP from a query table

I’m having trouble to execute immediate a SP inside a SP from a table. because i have a lot of SP stored in a table (as a data/string). in oracle we can use “select sp_1(:1,:2) from dual” and running ...
user avatar
1 vote
1 answer
59 views

SingleStore exception no_data_found

I’m having difficulty finding the exception no_data_found in singlestore. In Oracle, we use no_data_found exception. Is there any alternative solution in singlestore for the no_data_found exception?
user avatar
1 vote
1 answer
43 views

SSL Encryption for Kafka Pipelines

Any [SingleStore] users out there? For enabling SSL encryption (only) for Kafka pipelines, we created the pipeline like below: CREATE PIPELINE `kafka_ssl` AS LOAD DATA KAFKA '<kafka-host>:<...
user avatar
1 vote
2 answers
150 views

Primary Key issue in MemSQL doesn't support case sensitive

Creating table in MemSQL and creating composite primary key. Lets create simple table with following structure: Table User Data Name userid Primary Key (userid) And assume application support case ...
user avatar
2 votes
1 answer
193 views

WEHRE IN array values using stored procedure

I have a select query that uses a WHERE IN clause in a MemSQL database. The list of values searched in are a result of another select query. Before, I inserted the values for that clause as a string ...
user avatar
  • 123
0 votes
1 answer
1k views

MySQL syntax error 1064 near IN stored procedure

an aspiring DBA Here. I'm trying to create a stored procedure for a query I'm running. It is a memsql server which is MySQL based. The procedure is as such: delimiter // CREATE PROCEDURE ...
user avatar
  • 123