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 MemSQL Works
FAQs
MemSQL FAQ
Support FAQ
Guides
Overview
Deploy MemSQL
Data Ingest
Development
Cluster Management
Client and Application
Concepts
Concepts Overview
Aggregator
Code Generation
Columnstore
Database
Data Skew
Distributed Architecture
Distributed SQL
Geospatial Guide
Indexes
Information Schema
JSON Guide
Leaf
Master Aggregator
Memory Management
MySQL Features Unsupported in MemSQL
Partitions
Persistent Computed Columns
Queries
System Status
System Variables
Table
Window Functions Guide
Tools
Memsql-Ops
MemSQL Ops Overview
MemSQL Ops Architecture
MemSQL Ops Command Line Interface
Status Page
Cluster Page
Schema Explorer Page
Query Explorer Page
Data Import Page
Speed Test
Reference
Configuration Reference
memsql.cnf (MemSQL Configuration)
settings.conf (MemSQL Ops Configuration)
MemSQL Ops CLI Reference
Overview
Local MemSQL Ops Agent Management
Overview
START
STOP
RESTART
FOLLOW
UNFOLLOW
UNINSTALL
STATUS
VERSION
AGENT-ID
SSL-SET-CERT
SSL-DISABLE
CLUSTER-MANUAL-CONTROL
MemSQL Backup Management
Overview
DATABASE-BACKUP
DATABASE-RESTORE
AGENT-BACKUP
AGENT-RESTORE
BACKUP-LIST
BACKUP-DELETE
MemSQL License Management
Overview
LICENSE-LIST
LICENSE-ADD
MemSQL Node and Cluster Management
Overview
MEMSQL-DEPLOY
MEMSQL-LIST
MEMSQL-START
MEMSQL-STOP
MEMSQL-RESTART
MEMSQL-MONITOR
MEMSQL-UNMONITOR
MEMSQL-UPDATE-CONFIG
MEMSQL-UPDATE-ROOT-PASSWORD
MEMSQL-UPGRADE
MEMSQL-OPTIMIZE
MEMSQL-ENABLE-HIGH-AVAILABILITY
MEMSQL-PATH
MEMSQL-DELETE
MemSQL Ops File Management
Overview
FILE-ADD
FILE-LIST
FILE-DELETE
MemSQL Ops Job Management
Overview
JOB-LIST
JOB-INFO
JOB-LOGS
JOB-CANCEL
JOB-WAIT
MemSQL Ops Superuser Management
Overview
SUPERUSER-LIST
SUPERUSER-ADD
SUPERUSER-DELETE
MemSQL Ops Tools
Overview
REPORT
Remote MemSQL Ops Agent Management
Overview
AGENT-START
AGENT-STOP
AGENT-UPGRADE
AGENT-DEPLOY
AGENT-LIST
AGENT-SET-CREDENTIAL
AGENT-UNINSTALL
AGENT-SSH
AGENT-PUT
AGENT-GET
AGENT-MOVE-MEMSQL-INSTALLS-DIR
Spark Management
Overview
SPARK-DEPLOY
SPARK-CONNECT
SPARK-SHELL
SPARK-COMPONENT-START
SPARK-COMPONENT-STOP
SPARK-COMPONENT-LIST
PIP
SPARK-UPGRADE
SPARK-COMPONENT-MONITOR
SPARK-COMPONENT-UNMONITOR
INTERFACE-SET-JAR
SPARK-PIPELINE-EXPORT
SPARK-PIPELINE-IMPORT
SPARK-UNINSTALL
SPARK-DISCONNECT
SQL Reference
Overview
Data Types
Aggregate Functions
Overview
APPROX_COUNT_DISTINCT
AVG
COUNT
GROUP_CONCAT
MAX
MIN
STD
STDDEV_SAMP
SUM
VARIANCE
VAR_SAMP
Cluster Management Commands
Overview
Node Requirements for MemSQL Commands
ADD LEAF
AGGREGATOR SET AS MASTER
ATTACH LEAF
ATTACH LEAF ALL
ATTACH PARTITION
COPY PARTITION
CREATE PARTITION
DETACH LEAF
DETACH PARTITION
DROP PARTITION
EXPLAIN REBALANCE PARTITIONS
REMOVE LEAF
PROMOTE PARTITION
REBALANCE PARTITIONS
RESTORE REDUNDANCY
SHOW CLUSTER STATUS
SHOW AGGREGATORS
SHOW LEAVES
SHOW REBALANCE STATUS
SHOW PARTITIONS
Conditional Functions
Overview
CASE
COALESCE
CONVERT
ELT
GREATEST
IF
IFNULL
ISNULL
LEAST
NULLIF
SLEEP
Data Definition Language (DDL)
Overview
ALTER TABLE
ALTER VIEW
CREATE DATABASE
CREATE INDEX
CREATE VIEW
CREATE TABLE
DESCRIBE
DROP DATABASE
DROP INDEX
DROP VIEW
DROP ... FROM PLANCACHE
DROP TABLE
FLUSH TABLES
LOCK TABLES
UNLOCK TABLES
Data Manipulation Language (DML)
Overview
BEGIN
COMMIT
DELETE
EXPLAIN
LOAD DATA
INSERT
REPLACE
SELECT
UNION
UPDATE
USE
WITH (Common Table Expressions)
ROLLBACK
TRUNCATE
Date and Time Functions
Overview
ADDTIME
CONVERT_TZ
CURRENT_DATE
CURRENT_TIME
CURRENT_TIMESTAMP
DATE
DATEDIFF
DATE_ADD
DATE_FORMAT
DATE_SUB
DAY
DAYNAME
DAYOFWEEK
DAYOFYEAR
EXTRACT
FROM_DAYS
FROM_UNIXTIME
GET_FORMAT
HOUR
LAST_DAY
LOCALTIMESTAMP
MINUTE
MONTH
MONTHNAME
QUARTER
TIME
TIMEDIFF
TIMESTAMP
TIMESTAMPADD
TIMESTAMPDIFF
TIME_TO_SEC
TO_DAYS
TO_SECONDS
SECOND
SEC_TO_TIME
STR_TO_DATE
UNIX_TIMESTAMP
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
WEEK
WEEKDAY
YEAR
TIME_FORMAT
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
JSON Functions
Overview
JSON_ARRAY_CONTAINS_<type>
JSON_ARRAY_PUSH_<type>
JSON_DELETE_KEY
JSON_EXTRACT_<type>
JSON_GET_TYPE
JSON_LENGTH
JSON_SET_<type>
JSON_SPLICE_<type>
JSON Keypaths
Numeric Functions
Overview
ABS
ACOS
ASIN
ATAN
ATAN2, ATAN
BIT_COUNT
bitwise AND (&)
bitwise NOT (~)
bitwise OR (|)
bitwise XOR (^)
bitwise left shift (<<)
bitwise right shift (>>)
CEIL
COS
COT
DEGREES
FLOOR
LAST_INSERT_ID
LOG
POW
RAND
ROUND
PI
RADIANS
SIN
SQRT
TAN
TRUNCATE
Operational Commands
Overview
ANALYZE
BACKUP
CONTINUE REPLICATING
KILL CONNECTION
KILLALL QUERIES
REPAIR DATABASE
REPLICATE DATABASE
RESTORE
PAUSE REPLICATING
SELECT GLOBAL
SET GLOBAL
SNAPSHOT DATABASE
SHOW REPLICATION STATUS
STOP REPLICATING
Security Management Commands
Overview
CURRENT_USER
DROP USER
GRANT
REVOKE
SHOW GRANTS
SHOW Commands
Overview
SHOW COLUMNS
SHOW DATABASES
SHOW GLOBAL STATUS
SHOW GLOBAL VARIABLES
SHOW INDEX
SHOW INDEXES
SHOW KEYS
SHOW PLANCACHE
SHOW PROCESSLIST
SHOW SCHEMAS
SHOW SESSION STATUS
SHOW SESSION VARIABLES
SHOW STATUS EXTENDED
SHOW TABLE STATUS
SHOW TABLES
SHOW VARIABLES
SHOW WARNINGS
String Functions
Overview
AES_DECRYPT
AES_ENCRYPT
ASCII
BIN
BINARY
CHARACTER_LENGTH
CONCAT
CONCAT_WS
FIELD
FORMAT
FROM_BASE64
HEX
INET_ATON
INET_NTOA
INSTR
LCASE
LEFT
LENGTH
LOCATE
LPAD
LTRIM
MD5
RIGHT
RLIKE
RPAD
RTRIM
TRIM
UCASE
UNHEX
SHA1
SHA2
SUBSTRING
SUBSTRING_INDEX
TO_BASE64
Window Functions
Overview
DENSE_RANK
LAG
LEAD
NTILE
PERCENT_RANK
RANK
ROW_NUMBER
Troubleshooting Reference
Overview
Capacity Limit Error
Memory Errors
MemSQL Tools Issues
Network Errors
Operations Errors
Query Errors
Release Notes
MemSQL
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
MemSQL Ops
Outdated Version
You are viewing an older version of this section.
View current production version.
/
Data Ingest
/
Option: Select one
Option: General Guidance
Data Ingest
Data Loading Options
5 min read
Learn about the different options for loading data into MemSQL.
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.