Getting Started with SingleStore Helios
Connect to SingleStore
Create a Database
Load Data
Query Data
Manage Data
Managed Container Service
Developer Resources
User and Workspace Administration
Security
Reference
Configuration Reference
Information Schema Reference
SQL Reference
SQL Command Syntax
SQL Commands List
SQL Functions List
Comparison Operators and Functions
Database Object Case-Sensitivity
Data Types
Character Encoding
Operations that Take Either a Database or a Workspace Level Lock
User-Defined Variables
Restricted Keywords
Aggregate Functions
BSON Functions
Workspace Management Commands
Code Generation Functions
Conditional Functions
Data Definition Language DDL
Data Manipulation Language DML
Date and Time Functions
Distinct Count Estimation Functions
Full-Text Search Functions
Geospatial Functions
Identifier Generation Functions
Information Functions
JSON Functions
Numeric Functions
Operational Commands
Pipelines Commands
Procedural SQL Reference
Anonymous Code Blocks
Control Flow Statements
Exceptions and Exception Handling
MySQL Client Delimiters
Transactions in Stored Procedures
Extensions
CREATE AGGREGATE
CREATE [OR REPLACE] EXTERNAL FUNCTION
CREATE FUNCTION (UDF)
CREATE FUNCTION (TVF)
CREATE PROCEDURE
CREATE [OR REPLACE] TEMPORARY PROCEDURE …
DROP FUNCTION
DROP PROCEDURE
DROP AGGREGATE
SHOW AGGREGATES
SHOW CREATE FUNCTION
SHOW CREATE AGGREGATE
SHOW FUNCTIONS
SHOW PROCEDURES
%ROWTYPE and %TYPE
ARRAY
CALL
CREATE_ARRAY
COLLECT
ECHO
ECHO SELECT
EXECUTE IMMEDIATE
INSERT_ALL
RECORD
ROW
QUERY
SCALAR
TO_QUERY
Regular Expression Functions
Resource Pool Commands
Security Management Commands
SHOW Commands
String Functions
Time Series Functions
Trace Event Commands
Vector Functions
Window Functions
Fusion SQL Reference
Troubleshooting Reference
System Databases
Master Aggregator High Availability After Availability Zone Failure
Data API
Management API
Code Engine - Powered by Wasm
SingleStore Kai
Release Notes
Support
Glossary
See SHOW FUNCTIONS.
Last modified: May 6, 2021
Note: You must install cosign to verify the authenticity of the SingleStore file.
Use the following steps to verify the authenticity of singlestoredb-server, singlestoredb-toolbox, singlestoredb-studio, and singlestore-client SingleStore files that have been downloaded.
singlestoredb-server
singlestoredb-toolbox
singlestoredb-studio
singlestore-client
You may perform the following steps on any computer that can run cosign, such as the main deployment host of the cluster.
cosign
(Optional) Run the following command to view the associated signature files.
curl undefined
Download the signature file from the SingleStore release server.
Option 1: Click the Download Signature button next to the SingleStore file.
Option 2: Copy and paste the following URL into the address bar of your browser and save the signature file.
Option 3: Run the following command to download the signature file.
curl -O undefined
After the signature file has been downloaded, run the following command to verify the authenticity of the SingleStore file.
echo -n undefined | cosign verify-blob --certificate-oidc-issuer https://oidc.eks.us-east-1.amazonaws.com/id/CCDCDBA1379A5596AB5B2E46DCA385BC \ --certificate-identity https://kubernetes.io/namespaces/freya-production/serviceaccounts/job-worker \ --bundle undefined \ --new-bundle-format -
Verified OK