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
VERSION
STATUS
CLUSTER-MANUAL-CONTROL
UNFOLLOW
UNINSTALL
STOP
RESTART
FOLLOW
SSL-DISABLE
SSL-SET-CERT
AGENT-ID
MemSQL Backup Management
Overview
DATABASE-BACKUP
BACKUP-DELETE
DATABASE-RESTORE
AGENT-RESTORE
AGENT-BACKUP
BACKUP-LIST
MemSQL License Management
Overview
LICENSE-LIST
LICENSE-ADD
MemSQL Node and Cluster Management
Overview
MEMSQL-LIST
MEMSQL-DEPLOY
MEMSQL-DELETE
MEMSQL-PATH
MEMSQL-ENABLE-HIGH-AVAILABILITY
MEMSQL-OPTIMIZE
MEMSQL-UPGRADE
MEMSQL-UPDATE-ROOT-PASSWORD
MEMSQL-UPDATE-CONFIG
MEMSQL-UNMONITOR
MEMSQL-MONITOR
MEMSQL-RESTART
MEMSQL-STOP
MEMSQL-START
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-LIST
AGENT-UNINSTALL
AGENT-START
AGENT-MOVE-MEMSQL-INSTALLS-DIR
AGENT-UPGRADE
AGENT-STOP
AGENT-SET-CREDENTIAL
AGENT-SSH
AGENT-DEPLOY
AGENT-GET
AGENT-PUT
Spark Management
Overview
SPARK-PIPELINE-IMPORT
SPARK-PIPELINE-EXPORT
INTERFACE-SET-JAR
SPARK-COMPONENT-UNMONITOR
SPARK-COMPONENT-MONITOR
SPARK-UPGRADE
PIP
SPARK-COMPONENT-LIST
SPARK-COMPONENT-STOP
SPARK-COMPONENT-START
SPARK-SHELL
SPARK-CONNECT
SPARK-DEPLOY
SPARK-UNINSTALL
SPARK-DISCONNECT
SQL Reference
Overview
Data Types
Aggregate Functions
Overview
VAR_SAMP
VARIANCE
GROUP_CONCAT
STD
MAX
APPROX_COUNT_DISTINCT
MIN
AVG
COUNT
STDDEV_SAMP
SUM
Cluster Management Commands
Overview
DROP PARTITION
AGGREGATOR SET AS MASTER
ATTACH PARTITION
SHOW CLUSTER STATUS
DETACH LEAF
Node Requirements for MemSQL Commands
EXPLAIN REBALANCE PARTITIONS
ATTACH LEAF
REBALANCE PARTITIONS
COPY PARTITION
SHOW AGGREGATORS
DETACH PARTITION
ADD LEAF
REMOVE LEAF
ATTACH LEAF ALL
RESTORE REDUNDANCY
CREATE PARTITION
PROMOTE PARTITION
SHOW LEAVES
SHOW PARTITIONS
SHOW REBALANCE STATUS
Conditional Functions
Overview
SLEEP
IFNULL
ELT
CASE
GREATEST
CONVERT
IF
COALESCE
ISNULL
NULLIF
LEAST
Data Definition Language (DDL)
Overview
FLUSH TABLES
DROP TABLE
DROP ... FROM PLANCACHE
DROP VIEW
DROP INDEX
DROP DATABASE
DESCRIBE
CREATE TABLE
CREATE VIEW
CREATE INDEX
CREATE DATABASE
ALTER VIEW
ALTER TABLE
LOCK TABLES
UNLOCK TABLES
Data Manipulation Language (DML)
Overview
INSERT
WITH (Common Table Expressions)
UPDATE
COMMIT
UNION
EXPLAIN
SELECT
USE
ROLLBACK
LOAD DATA
TRUNCATE
DELETE
BEGIN
REPLACE
Date and Time Functions
Overview
TIMESTAMPDIFF
MONTH
FROM_DAYS
DATE_FORMAT
CONVERT_TZ
UTC_TIME
TO_DAYS
QUARTER
GET_FORMAT
DAY
CURRENT_TIME
WEEK
SECOND
TIMEDIFF
LAST_DAY
DAYOFWEEK
DATE
YEAR
STR_TO_DATE
TIMESTAMPADD
MINUTE
EXTRACT
DATE_ADD
ADDTIME
UTC_DATE
TIME_TO_SEC
MONTHNAME
FROM_UNIXTIME
DATE_SUB
CURRENT_DATE
UTC_TIMESTAMP
TO_SECONDS
TIME
HOUR
DAYNAME
CURRENT_TIMESTAMP
WEEKDAY
SEC_TO_TIME
TIMESTAMP
LOCALTIMESTAMP
DAYOFYEAR
DATEDIFF
TIME_FORMAT
UNIX_TIMESTAMP
Geospatial Functions
Overview
GEOGRAPHY_DISTANCE
GEOGRAPHY_LATITUDE
GEOGRAPHY_INTERSECTS
GEOGRAPHY_POINT
GEOGRAPHY_LENGTH
GEOGRAPHY_AREA
APPROX_GEOGRAPHY_INTERSECTS
GEOGRAPHY_WITHIN_DISTANCE
GEOGRAPHY_LONGITUDE
GEOGRAPHY_CONTAINS
JSON Functions
Overview
JSON_DELETE_KEY
JSON_ARRAY_PUSH_<type>
JSON_ARRAY_CONTAINS_<type>
JSON Keypaths
JSON_SPLICE_<type>
JSON_SET_<type>
JSON_LENGTH
JSON_GET_TYPE
JSON_EXTRACT_<type>
Numeric Functions
Overview
TAN
ASIN
bitwise NOT (~)
CEIL
ROUND
PI
TRUNCATE
ATAN
bitwise OR (|)
LAST_INSERT_ID
bitwise XOR (^)
COT
POW
SIN
ATAN2, ATAN
COS
BIT_COUNT
bitwise left shift (<<)
DEGREES
RAND
ABS
ACOS
bitwise AND (&)
bitwise right shift (>>)
FLOOR
SQRT
LOG
RADIANS
Operational Commands
Overview
BACKUP
ANALYZE
SHOW REPLICATION STATUS
SNAPSHOT DATABASE
SET GLOBAL
SELECT GLOBAL
PAUSE REPLICATING
RESTORE
REPLICATE DATABASE
REPAIR DATABASE
KILLALL QUERIES
KILL CONNECTION
CONTINUE REPLICATING
STOP REPLICATING
Security Management Commands
Overview
CURRENT_USER
DROP USER
GRANT
REVOKE
REVOKE GROUP
REVOKE ROLE
SHOW GRANTS
CREATE ROLE
CREATE GROUP
DROP GROUP
DROP ROLE
GRANT ROLE
GRANT GROUP
SHOW ROLES
SHOW ROLES FOR USER
SHOW ROLES FOR GROUP
SHOW GROUPS
SHOW GROUPS FOR USER
SHOW GROUPS FOR ROLE
SHOW USERS
SHOW USERS FOR ROLE
SHOW USERS FOR GROUP
Permissions Matrix
Default Mode Permissions Changes
Strict Mode Permissions
SHOW Commands
Overview
SHOW TABLES
SHOW STATUS EXTENDED
SHOW SESSION STATUS
SHOW GLOBAL STATUS
SHOW DATABASES
SHOW INDEXES
SHOW WARNINGS
SHOW TABLE STATUS
SHOW PLANCACHE
SHOW SESSION VARIABLES
SHOW PROCESSLIST
SHOW COLUMNS
SHOW GLOBAL VARIABLES
SHOW SCHEMAS
SHOW KEYS
SHOW INDEX
SHOW VARIABLES
String Functions
Overview
BINARY
UCASE
LEFT
CHARACTER_LENGTH
UNHEX
LENGTH
CONCAT
SHA1
LOCATE
CONCAT_WS
SHA2
LPAD
FIELD
SUBSTRING
LTRIM
FORMAT
SUBSTRING_INDEX
MD5
FROM_BASE64
TO_BASE64
RIGHT
HEX
AES_DECRYPT
RLIKE
INET_ATON
AES_ENCRYPT
RPAD
INET_NTOA
ASCII
RTRIM
INSTR
BIN
TRIM
LCASE
Window Functions
Overview
RANK
DENSE_RANK
ROW_NUMBER
LEAD
NTILE
PERCENT_RANK
LAG
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.