Chevron Left Icon
Bars Icon
Product
Managed Service
Cloud Database-as-a-service
Database Software
Deploy SingleStore anywhere
Stream Icon
Ingest Data
Tools Icon
Tools and Monitoring
Lock Icon
Security
Sync Icon
Replace MySQL
Solutions
Use Cases
How SingleStore is used
Customers
Learn who uses SingleStore
Briefcase Icon
Professional Services
Industry Icon
Industries
Sitemap Icon
Architectures
Check Icon
Comparisons
Docs
Documentation
Set up and use SingleStore's products and tools
How SingleStore Works
A concise overview of SingleStore
Life Ring Icon
Support
Comments Icon
Forums
List Icon
Release Notes
Learn
Developer Hub
Begin building faster data applications
Resources
Whitepapers, ebooks, videos and more
Calendar Icon
Events
Rss Icon
Blog
Newspaper Icon
News
Presentation Icon
Training
Video Icon
Product Demo
Pricing
Envelope Icon
Envelope Icon
User Circle Icon
Laptop Icon
Portal
Access Managed Service & Licenses
Comments Icon
Forums
Ask the Community
Users Class Icon
Training
Self-Paced Learning
Life Ring Icon
Enterprise Support
Submit a Ticket
Start Free
Bars Icon
Chevron Left Icon
Bars Icon
Database Icon
Product
Analytics Icon
Solutions
Code Icon
Docs
Book Icon
Learn
Dollar Sign Icon
Pricing
User Circle Icon
Sign In
Arrow Right Icon
Start Free
Cloud Icon
Managed Service
Cloud Database-as-a-service
Database Icon
Database Software
Deploy SingleStore anywhere
Stream Icon
Ingest Data
Tools Icon
Tools and Monitoring
Lock Icon
Security
Sync Icon
Replace MySQL
Lightbulb Icon
Use Cases
How SingleStore is used
Users Icon
Customers
Learn who uses SingleStore
Briefcase Icon
Professional Services
Industry Icon
Industries
Sitemap Icon
Architectures
Check Icon
Comparisons
Book Icon
Documentation
Set up and use SingleStore's products and tools
Database Icon
How SingleStore Works
A concise overview of SingleStore
Life Ring Icon
Support
Comments Icon
Forums
List Icon
Release Notes
Laptop Icon
Developer Hub
Begin building faster data applications
File Download Icon
Resources
Whitepapers, ebooks, videos and more
Calendar Icon
Events
Rss Icon
Blog
Newspaper Icon
News
Presentation Icon
Training
Video Icon
Product Demo
Laptop Icon
Portal
Access Managed Service & Licenses
Comments Icon
Forums
Ask the Community
Users Class Icon
Training
Self-Paced Learning
Life Ring Icon
Enterprise Support
Submit a Ticket
Contact Us
Back
Latest
v7.1
v7.0
v6.8
v6.7
v6.5
v6.0
v5.8
v5.7
v5.5
v5.1
v5.0
Introduction
Documentation Overview
How SingleStore DB Works
FAQs
SingleStore DB FAQ
Support FAQ
Key Concepts and Features
Distributed Architecture
Design Principles
Cluster Components
Shard Keys
Distributed DML Query Execution
Distributed SQL Surface Area
High Availability
Physical Schema Design
Choosing a Table Storage Type
Rowstore
Columnstore
How the Columnstore Works
Writing Columnstore Data
Locking in Columnstores
Managing Columnstore Segments
Encoded Data in Columnstores
Highly Selective Joins
Universal Storage
Other Schema Concepts
Reference Tables
Temporary Tables
Types of Indexes
Query Processing
Code Generation
Pipelines
Pipelines Overview
Avro Schema Evolution with Pipelines
Extractors
Transforms
Pipelines Information Schema Tables
Cluster Management
Replication and Durability
Workload Mgmt/Resource Governance
Workload Profiling
Development
Procedural Extensions
SingleStore Managed Service
Introduction
Resources
Guides
Overview
Deploy
Use
Cluster Management
Security
Tools
Packages Overview
SingleStore DB Toolbox
Toolbox Command Auto-Completion
sdb-toolbox-config
sdb-deploy
sdb-admin
sdb-report
memsqlctl
SingleStore DB Studio
Overview
Installation Guide
Upgrade Guide
Architecture
CLI
Security
Workload Monitoring
SQL Editor
Visual Explain
WebSocket Proxy
SingleStore Client
Overview
SingleStore Replicate
Overview
Reference
Configuration Reference
Configuration Reference Overview
System Limits
Engine Variables
Overview
List of Engine Variables
memsql.cnf
Cluster Configuration
Overview
System Requirements and Recommendations
Configuring SingleStore DB for NUMA
AVX2 Instruction Set Verification
AWS EC2 Best Practices
memsqlctl
Overview
memsqlctl.hcl
nodes.hcl
Toolbox
Overview
toolbox.hcl
toolbox-state.hcl
MemSQL Operator Reference
MemSQL Operator Reference Overview
Additional Deployment Methods
Helm Chart for IBM Cloud Pak for Data
Advanced Service Configuration
Apply Changes to a Cluster
Backups
Change the Admin Password
Configure Core Dumps
Configure Liveness and Readiness Probes
Configure TLS/SSL/WebSocket
Delete the Cluster or Operator
Disaster Recovery
Generate Cluster Reports
Global Variables
MemSQL Pod Scheduling
Monitor the Cluster
Mount Additional ConfigMaps/Secrets
Perform an Upgrade
Pull Images from a Private Registry
Scale a Cluster
Set System Requirements
Verify Cluster Stability
View the Operator Logs
MemSQL Ops CLI Reference
Overview
Local MemSQL Ops Agent Management
Overview
UNFOLLOW
STATUS
STOP
SSL-SET-CERT
SSL-DISABLE
API-TOKEN
AGENT-UPDATE-API-TOKEN
AGENT-ID
VERSION
UNINSTALL
START
FOLLOW
RESTART
CLUSTER-MANUAL-CONTROL
SingleStore DB Backup Management
Overview
DATABASE-BACKUP
AGENT-BACKUP
BACKUP-LIST
AGENT-RESTORE
DATABASE-RESTORE
BACKUP-DELETE
License Management
Overview
LICENSE-LIST
LICENSE-ADD
Node and Cluster Management
Overview
MEMSQL-ENABLE-HIGH-AVAILABILITY
MEMSQL-LIST
MEMSQL-OPTIMIZE
MEMSQL-PATH
MEMSQL-DEPLOY
MEMSQL-STOP
MEMSQL-UPGRADE
MEMSQL-UPDATE-ROOT-PASSWORD
MEMSQL-UPDATE-CONFIG
MEMSQL-DELETE
MEMSQL-MONITOR
MEMSQL-RESTART
MEMSQL-UNMONITOR
MEMSQL-START
MemSQL Ops File Management
Overview
FILE-DELETE
FILE-ADD
FILE-LIST
MemSQL Ops Job Management
Overview
JOB-INFO
JOB-LOGS
JOB-CANCEL
JOB-WAIT
JOB-LIST
MemSQL Ops Superuser Management
Overview
SUPERUSER-LIST
SUPERUSER-ADD
SUPERUSER-DELETE
MemSQL Ops Tools
Overview
REPORT
Remote MemSQL Ops Agent Management
Overview
AGENT-UPGRADE
AGENT-START
AGENT-UNINSTALL
AGENT-LIST
AGENT-SET-CREDENTIAL
AGENT-DEPLOY
AGENT-PUT
AGENT-SSH
AGENT-GET
AGENT-STOP
AGENT-MOVE-MEMSQL-INSTALLS-DIR
SingleStore Tools Reference
Overview
MemSQL Ops Command Mappings
Deploy SingleStore DB
Deploy SingleStore DB Offline
Deploy SingleStore DB via Tarball
Advanced Deployment Guide
Introduction
Install SingleStore Tools
Deploy SingleStore DB
Setup SingleStore DB Studio
Next Steps
Common Tool Commands
Overview
env
help
version
sdb-admin Commands
Overview
add-aggregator
add-leaf
bootstrap-aggregator
change-root-password
configure-monitoring
create-backup
create-node
delete-backup
delete-node
describe-node
disable-nodes-autostart
dump
enable-high-availability
enable-http-api
enable-nodes-autostart
enable-systemd-client
list-backups
list-nodes
optimize
put-file
query
register-node
remove-aggregator
remove-leaf
restart-node
restore-backup
set-license
show-aggregators
show-cluster
show-leaves
show-license
snapshot-database
start-monitoring-kube
start-monitoring
start-node
state
stop-monitoring
stop-node
summarize-backups
sync-ldap
unregister-node
update-config
update-node-basedir
validate-backup
sdb-deploy Commands
Overview
cluster-in-a-box
destroy-cluster
generate-cluster-file
install
list-versions
setup-cluster
state
ui
uninstall
upgrade
sdb-report Commands
Overview
calibrate
calibrate-blob-storage
check
collect-and-check
collect-kube
collect
collect-local
send-alert
state
sdb-toolbox-config Commands
Overview
describe-host
list-hosts
register-host
state
unregister-host
memsqlctl Commands
Overview
add-aggregator
add-leaf
bootstrap-aggregator
change-root-password
collect-garbage
create-node
delete-node
describe-node
enable-high-availability
list-nodes
optimize
query
register-node
remove-aggregator
remove-leaf
restart-node
set-license
show-aggregators
show-cluster
show-leaves
show-license
start-node
stop-node
unregister-node
update-config
update-node-basedir
SQL Reference
Overview
Comparison Operators and Functions
Database Object Case-Sensitivity
Data Types
Aggregate Functions
Overview
ANY_VALUE
AVG
COUNT
GROUP_CONCAT
MAX
MEDIAN
MIN
MOD
STD
STDDEV_SAMP
SUM
VARIANCE
VAR_SAMP
Cluster Management Commands
Overview
Node Requirements for SingleStore DB Commands
Leaf States
ADD AGGREGATOR
ADD LEAF
AGGREGATOR SET AS MASTER
ATTACH LEAF
ATTACH LEAF ALL
BOOTSTRAP AGGREGATOR
DETACH LEAF
EXPLAIN REBALANCE PARTITIONS
EXPLAIN RESTORE REDUNDANCY
FILL and FLUSH CONNECTION POOLS
FLUSH HOSTS
REBALANCE PARTITIONS
REMOVE AGGREGATOR
REMOVE LEAF
RESTORE REDUNDANCY
SHOW AGGREGATORS
SHOW LEAVES
SHOW CLUSTER STATUS
SHOW REBALANCE STATUS
TRIGGER GC
Code Generation Functions
Overview
NOPARAM
Conditional Functions
Overview
CASE
COALESCE
CAST or CONVERT
DECODE
ELT
GREATEST
IF
ISNULL
LEAST
NULLIF
NVL and IFNULL
SLEEP
Data Definition Language (DDL)
Overview
ALTER DATABASE
ALTER TABLE
ALTER VIEW
CREATE DATABASE
CREATE INDEX
CREATE VIEW
CREATE TABLE
DESCRIBE
DROP DATABASE
DROP INDEX
DROP ... FROM PLANCACHE
DROP TABLE
DROP VIEW
FLUSH TABLES
OPTIMIZE TABLE
TRUNCATE
UNLOCK TABLES
Data Manipulation Language (DML)
Overview
AGGREGATOR SYNC AUTO_INCREMENT
BEGIN
CLEAR LOAD ERRORS
COMMIT
CUBE, ROLLUP and GROUPING()
DELETE
EXCEPT and MINUS
EXISTS and NOT EXISTS
EXPLAIN
INSERT
INTERSECT
LOAD DATA
PROFILE
PIVOT
REPLACE
ROLLBACK
SELECT
TABLE
UNION
UPDATE
USE
WITH (Common Table Expressions)
Materializing Common Table Expressions
Query Plan Operations
Date and Time Functions
Overview
ADDTIME
CONVERT_TZ
CURRENT_DATE And CURDATE
CURRENT_TIME And CURTIME
CURRENT_TIMESTAMP
DATE
DATEDIFF
DATE_ADD
DATE_FORMAT
DATE_SUB
DATE_TRUNC
DAY
DAYNAME
DAYOFWEEK
DAYOFYEAR
EXTRACT
FROM_DAYS
FROM_UNIXTIME
GET_FORMAT
HOUR
LAST_DAY
LOCALTIMESTAMP
MICROSECOND
MINUTE
MONTH
MONTHNAME
MONTHS_BETWEEN
NOW
QUARTER
SECOND
SEC_TO_TIME
STR_TO_DATE
TIME
TIMEDIFF
TIMESTAMP
TIMESTAMPADD
TIMESTAMPDIFF
TIME_FORMAT
TIME_TO_SEC
TO_CHAR
TO_DATE
TO_DAYS
TO_SECONDS
TO_TIMESTAMP
TRUNC
UNIX_TIMESTAMP
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
WEEK
WEEKDAY
YEAR
Distinct Count Estimation Functions
Overview
APPROX_COUNT_DISTINCT
APPROX_COUNT_DISTINCT_ACCUMULATE
APPROX_COUNT_DISTINCT_COMBINE
APPROX_COUNT_DISTINCT_ESTIMATE
Full Text Search Functions
Overview
HIGHLIGHT
MATCH
Geospatial Functions
Overview
APPROX_GEOGRAPHY_INTERSECTS
GEOGRAPHY_AREA
GEOGRAPHY_CONTAINS
GEOGRAPHY_DISTANCE
GEOGRAPHY_INTERSECTS
GEOGRAPHY_LATITUDE
GEOGRAPHY_LENGTH
GEOGRAPHY_LONGITUDE
GEOGRAPHY_POINT
GEOGRAPHY_WITHIN_DISTANCE
Information Functions
Overview
CONNECTION_ID
DATABASE
ESTIMATED_QUERY_LEAF_MEMORY
ESTIMATED_QUERY_RUNTIME
LAST_INSERT_ID
ROW_COUNT
USER
JSON Functions
Overview
JSON_ARRAY_CONTAINS_<type>
JSON_ARRAY_PUSH_<type>
JSON_DELETE_KEY
JSON_EXTRACT_<type>
JSON_GET_TYPE
JSON Keypaths
JSON_LENGTH
JSON_SET_<type>
JSON_SPLICE_<type>
JSON_TO_ARRAY
TO_JSON
Numeric Functions
Overview
ABS
SIGN
EXP
ACOS
ASIN
ATAN
ATAN2, ATAN
BIT_COUNT
bitwise AND (&)
bitwise NOT (~)
bitwise OR (|)
bitwise XOR (^)
bitwise left shift (<<)
bitwise right shift (>>)
CEIL
CONV
COS
COT
LN
LOG2
LOG10
DEGREES
FLOOR
LOG
PI
POW
RADIANS
RAND
ROUND
SIGMOID
SIN
SQRT
TAN
TO_NUMBER
TRUNC
TRUNCATE
Operational Commands
Overview
Statistics, Sampling, and ANALYZE
BACKUP DATABASE
CHECK BLOB CHECKSUM
CLEAR ORPHAN DATABASES
CONTINUE REPLICATING
KILL CONNECTION
KILLALL QUERIES
PAUSE REPLICATING
REPAIR DATABASE
REPLICATE DATABASE
RESTORE DATABASE
SELECT GLOBAL
SET AGGREGATOR
SET and SET SESSION
SET CLUSTER
SET GLOBAL
SET LEAF
SHOW REPLICATION STATUS
SNAPSHOT DATABASE
STOP REPLICATING
Pipelines Commands
Overview
ALTER PIPELINE
CREATE PIPELINE
DROP PIPELINE
EXTRACT PIPELINE ... INTO OUTFILE
PROFILE PIPELINE
START PIPELINE
STOP PIPELINE
TEST PIPELINE
Procedural SQL Reference
Overview
Control Flow Statements
Exceptions and Exception Handling
MySQL Client Delimiters
Transactions in Stored Procedures
CREATE FUNCTION (UDF)
CREATE FUNCTION (TVF)
CREATE PROCEDURE
CREATE AGGREGATE
DROP FUNCTION
DROP PROCEDURE
DROP AGGREGATE
SHOW CREATE FUNCTION
SHOW CREATE AGGREGATE
SHOW FUNCTIONS
SHOW AGGREGATES
ARRAY
CALL
INSERT_ALL
CREATE_ARRAY
COLLECT
ECHO
ECHO SELECT
EXECUTE IMMEDIATE
RECORD
ROW
QUERY
SCALAR
TO_QUERY
Regular Expression Functions
Overview
REGEXP_INSTR
REGEXP_REPLACE
REGEXP_SUBSTR
RLIKE and REGEXP
Resource Pool Commands
Overview
ALTER RESOURCE POOL
CREATE RESOURCE POOL
DROP RESOURCE POOL
SHOW RESOURCE POOLS
Security Management Commands
Overview
ALTER USER
CREATE GROUP
CREATE ROLE
CREATE USER
CURRENT_USER
DROP GROUP
DROP ROLE
DROP USER
GRANT
GRANT GROUP
GRANT ROLE
REVOKE
REVOKE GROUP
REVOKE ROLE
SET PASSWORD
SHOW GRANTS
SHOW GROUPS
SHOW GROUPS FOR ROLE
SHOW GROUPS FOR USER
SHOW ROLES
SHOW ROLES FOR GROUP
SHOW ROLES FOR USER
SHOW USERS
SHOW USERS FOR GROUP
SHOW USERS FOR ROLE
Permissions Matrix
Default Mode Permissions Changes
Strict Mode Permissions
SHOW Commands
Overview
SHOW CREATE PIPELINE
SHOW COLUMNS
SHOW CREATE TABLE
SHOW CREATE VIEW
SHOW DATABASES
SHOW DATABASE STATUS
SHOW ERRORS
SHOW GLOBAL STATUS
SHOW INDEX
SHOW INDEXES
SHOW KEYS
SHOW LOAD ERRORS
SHOW LOAD WARNINGS
SHOW PIPELINES
SHOW PLAN
SHOW PLANCACHE
SHOW PROCESSLIST
SHOW SCHEMAS
SHOW SESSION STATUS
SHOW STATUS [EXTENDED]
SHOW TABLE STATUS
SHOW TABLES
SHOW VARIABLES
SHOW WARNINGS
System Status
String Functions
Overview
AES_DECRYPT
AES_ENCRYPT
ASCII
BIN
BINARY
CHAR
CHARACTER_LENGTH
CONCAT
CONCAT_WS
CRC32
FIELD
FORMAT
FROM_BASE64
QUOTE
HEX
INET_ATON
INET_NTOA
INET6_ATON
INET6_NTOA
INITCAP
INSTR
LCASE
LEFT
LENGTH
LOCATE
LPAD
LTRIM
MD5
REPLACE
RIGHT
RPAD
RTRIM
SHA1
SHA2
SPLIT
STRING_BYTES
SUBSTRING
SUBSTRING_INDEX
TO_BASE64
TRIM
UCASE
UNHEX
Time Series Functions
Overview
FIRST
LAST
TIME_BUCKET
Vector Functions
Overview
DOT_PRODUCT
VECTOR_SUB
EUCLIDEAN_DISTANCE
JSON_ARRAY_PACK
Window Functions
Overview
DENSE_RANK
FIRST_VALUE
LAG
LAST_VALUE
LEAD
NTH_VALUE
NTILE
PERCENT_RANK
PERCENTILE_CONT and Median
PERCENTILE_DISC
RANK
ROW_NUMBER
Troubleshooting Reference
Overview
Capacity Limit Error
Disk Capacity Errors
Memory Errors
SingleStore Tools Issues
Network Errors
Operations Errors
Query Errors
Workload Profiling Reference
Management View Reference
Management View Statistics Reference
Information Schema
Third-Party Integrations
Introduction
Collibra
Data Virtuality Pipes
Dremio
Informatica PowerCenter
Confluent Kafka Connector
Looker
MicroStrategy
Power BI
Sisense
Spark
StreamSets
Tableau
Talend with Open Studio
Tibco Spotfire
Vormetric Transparent Encryption
Zoomdata
Release Notes
SingleStore DB/MemSQL
7.1 Release Notes
7.0 Release Notes
6.8 Release Notes
6.7 Release Notes
6.5 Release Notes
6.0 Release Notes
5.8 Release Notes
5.7 Release Notes
5.5 Release Notes
5.1 Release Notes
5.0 Release Notes
4.1 Release Notes
4.0 Release Notes
3.2 Release Notes
3.1 Release Notes
SingleStore DB Studio
SingleStore DB Toolbox
MemSQL Kubernetes Operator
MemSQL Ops
Outdated Version
You are viewing an older version of this section.
View current production version.
/
Use
/
Topic: Select one
Topic: Design Your Physical Database Schema
Topic: Develop
Topic: Loading Data into SingleStore
Topic: Process Queries
Topic: Other
/
Guide: Select one
Guide: Options for Loading Data into SingleStore
Guide: Working with Azure Blob Pipelines
Guide: Working with File System Pipelines
Guide: Working with GCS Pipelines
Guide: Working with HDFS Pipelines
Guide: Working with Kafka Pipelines
Guide: Working with the Kafka Connector
Guide: Working with S3 Pipelines
Guide: Example: Loading TPC-H Data into SingleStore DB
Guide: Loading Geospatial Data into SingleStore
Loading Data into SingleStore
Options for Loading Data into SingleStore
read
Learn about the different options for loading data into SingleStore.
Start Guide
Working with Azure Blob Pipelines
read
Get an overview of Azure Blob pipelines and follow the quickstart.
Start Guide
Working with Filesystem Pipelines
read
Get an overview of filesystem pipelines and follow the quickstart.
Start Guide
Working with GCS Pipelines
read
Get an overview of Google Cloud Storage (GCS) pipelines and follow the quickstart.
Start Guide
Working with HDFS Pipelines
read
Get an overview of HDFS pipelines and follow the quickstart.
Start Guide
Working with Kafka Pipelines
read
Get an overview of Kafka pipelines and follow the quickstart.
Start Guide
Working with the Kafka Connector
read
Learn how to use the Kafka Connector to load data.
Start Guide
Working with S3 Pipelines
read
Get an overview of S3 pipelines and follow the quickstart.
Start Guide
Example: Loading TPC-H Data into SingleStore DB
read
Load sample TPC-H data into SingleStore DB through Amazon S3 with SingleStore Pipelines.
Start Guide
Loading Geospatial Data into SingleStore
read
Load geographic data such as points, paths, and polygons into SingleStore.
Start Guide
Was this Article Helpful?
Thanks For Your Feedback!
Need help
or have suggestions
? Go to SingleStore Forums
Was this Article Helpful?
Thanks For Your Feedback!
Sorry About That
Can you give us a little more context about what we didn’t answer for you? We’ll get back to you as soon as we can.
Question or Feedback
Please enter a valid message
Email
(if you'd like us to respond to you)
Please enter a valid email
Submit
Server error. Please try again.
Sorry About That
Can you give us a little more context about what we didn’t answer for you? We’ll get back to you as soon as we can.
Question or Feedback
Please enter a valid message
Email
(if you'd like us to respond to you)
Please enter a valid email
Submit
Server error. Please try again.