MatrixOrigin MatrixOrigin Docs
Product docs
MatrixOne Current product MatrixOne Intelligence
About Get Started Develop Tutorial Deploy Operations Migrate Test Performance Security Reference Troubleshooting FAQs Release Notes Glossary Contribute
/
Contents Menu Expand Light mode Dark mode Auto light/dark, in light mode Auto light/dark, in dark mode Skip to content
MatrixOne Docs
MatrixOne Docs
  • Home
  • Overview
    • MatrixOne Feature List
    • MatrixOne Feature Overview
      • Git for Data
      • Multi-Account
      • Scalability
      • Cost-Effective
      • High Availability
      • Timing
      • Streams
      • User-defined functions
      • MySQL Compatibility
      • Feature Overview
      • Native SQL Tasks
      • Stored procedures
    • MatrixOne Architecture
      • Transactional Analytical Engine Architecture
      • Detailed Logservice Architecture
      • Logtail Protocol Architecture
      • Transaction and Lock Mechanisms Architecture
      • Detailed Proxy Architecture
      • WAL Technology Explained
      • Detailed Caching and Hot-Cold Data Separation Architecture
      • Detailed Stream Engine Architecture
      • MatrixOne-Operator design and implementation
      • SQL Tasks and TaskService
      • Index, external engine, branch and inference lifecycles
      • Kernel observability and diagnosis
      • GIS type and function execution boundaries
      • Catalog, startup readiness and upgrade boundaries
      • Object lifecycle, recovery and GC
      • Distributed execution, memory and spill
      • SQL planning and statistics
      • Transaction visibility, errors and retry boundaries
    • Comparisons with Other Databases
      • MatrixOne vs. common OLTP databases
    • What's New
    • Getting Started
      • Deploy on macOS
        • Using binary package
        • Using Docker
      • Deploy on Linux
        • Using binary package
        • Using Docker
      • Basic SQL
      • Installation choices and acceptance
    • Developing Guide
      • Java connect to MatrixOne
        • Connect MatrixOne with Java ORMs
      • Python connect to MatrixOne
      • General Python SDK
      • C# connect to MatrixOne
      • Connecting to MatrixOne with Golang
      • MatrixOne SSL connection
      • Connecting to MatrixOne with TypeScript
      • Connecting to MatrixOne with ODBC
      • Connecting to MatrixOne with Power BI
      • Lakehouse Ecosystem Tutorials
        • Prepare connections, fixtures and acceptance checks
        • Batch loading with pandas, PETL, Polars and Dask
        • PyArrow IPC and DuckDB Parquet bridges to MatrixOne
        • PyIceberg append/scan with an explicit SQL bridge
        • Airflow MySqlHook DAG and idempotent retries
        • dbt-mysql model builds and data tests
        • DolphinScheduler Shell and native SQL tasks
        • Local testing with the official Fivetran Connector SDK
        • Airbyte connector protocol and destination acceptance
        • NiFi Record flows and MatrixOne JDBC writes
        • Kafka Connect, Debezium and JDBC CDC sinks
        • Exact event loading with Redpanda Connect and kafka-python
        • Read fidelity with ConnectorX, Ibis and database drivers
        • dlt loading and Singer state-protocol adapters
        • Job acceptance for DataX, SeaTunnel, Spark, Flink and Trino
        • Native DataX source scans and exact-value writes
        • Native Spark JDBC reads, writes, types and partitions
        • Native Flink MySQL CDC into MatrixOne and recovery acceptance
      • Schema Design
        • Create Database
        • Create Table
        • Replication table
        • Create View
        • Create Temporary Table
        • Create Secondary Index
        • Vector
        • Data Integrity
          • NOT NULL Constraints
          • UNIQUE KEY Constraints
          • PRIMARY KEY Constraints
          • FOREIGN KEY Constraints
          • AUTO INCREMENT Constraints
      • Write Data
        • Bulk Load
          • Load csv format data
          • Load jsonlines format data
          • Load data from S3
          • Load data by using the `source`
        • Update Data
        • DML Target and Conflict Semantics
        • Delete Data
        • Prepared
      • Export Data
        • Export data by MODUMP
      • Read Data
        • Multi-table Join Queries
        • Subquery
        • Views
        • Common Table Expression
        • Window Function
          • Time Window
          • Analytical Windows
      • Data de-duplication
        • BITMAP
      • Account Design
        • Publish-Subscribe
      • Transactions
        • Transaction by MatrixOne Server
          • Explicit Transaction
          • Implicit Transaction
          • Pessimistic Transaction
          • Optimistic Transaction
          • Isolation Level
          • MVCC
          • User Guide
            • Scenario
          • Scenario
      • User-defined function
        • UDF python advanced
      • Vector
        • Vector Search
        • IVF Rank Options
        • Query-level IVF Probe Count
        • Cluster Centers
        • Scalar Vector Query
        • IVF Equi-join Vector Query
      • Data Type Fidelity
      • Ecological Tools
        • BI integration guides and compatibility
          • Shared BI dataset and KPI checks
          • Connect Metabase and build metrics
          • Superset analytic connection checks
          • Grafana MySQL datasource and compatibility checks
          • Connect Redash and save analytic queries
          • Connect DataEase and preview SQL datasets
          • Evidence MySQL source and compatibility checks
          • Rill ingestion and native metrics
          • Apache Zeppelin JDBC notebooks
          • SQLPad saved SQL analyses
          • Lightdash direct-connection boundary
        • Visualizing MatrixOne Reports with Yonghong BI
        • Visual Monitoring of MatrixOne with Superset
        • ETL Tools
          • Writing Data from MySQL to MatrixOne
          • Writing Data from Oracle to MatrixOne
          • Using DataX to write data to MatrixOne
            • Writing Data from MySQL to MatrixOne
            • Writing Data from Oracle to MatrixOne
            • Writing Data from PostgreSQL to MatrixOne
            • Writing Data from SQL Server to MatrixOne
            • Writing Data from MongoDB to MatrixOne
            • Writing Data from TiDB to MatrixOne
            • Writing Data from ClickHouse to MatrixOne
            • Writing Data from Doris to MatrixOne
            • Writing Data from InfluxDB to MatrixOne
            • Writing Data from Elasticsearch to MatrixOne
        • Computing Engine
          • Writing Data from MySQL to MatrixOne
          • Writing Data from Hive to MatrixOne
          • Writing Data from Doris to MatrixOne
          • Using Flink to Write Real-Time Data to MatrixOne
            • Writing Data from MySQL to MatrixOne
            • Writing Data from Oracle to MatrixOne
            • Writing Data from SQL Server to MatrixOne
            • Writing Data from PostgreSQL to MatrixOne
            • Writing Data from MongoDB to MatrixOne
            • Writing Data from TiDB to MatrixOne
            • Writing Data from Kafka to MatrixOne
        • Scheduling Tools
      • Ecosystem Tools Overview
        • DataX
          • Writing Data from MySQL to MatrixOne
          • Writing Data from Oracle to MatrixOne
          • Writing Data from PostgreSQL to MatrixOne
          • Writing Data from SQL Server to MatrixOne
          • Writing Data from MongoDB to MatrixOne
          • Writing Data from TiDB to MatrixOne
          • Writing Data from ClickHouse to MatrixOne
          • Writing Data from Doris to MatrixOne
          • Writing Data from InfluxDB to MatrixOne
          • Writing Data from Elasticsearch to MatrixOne
        • SeaTunnel
          • Writing Data from MySQL to MatrixOne
          • Writing Data from Oracle to MatrixOne
          • Using DataX to write data to MatrixOne
            • Writing Data from MySQL to MatrixOne
            • Writing Data from Oracle to MatrixOne
            • Writing Data from PostgreSQL to MatrixOne
            • Writing Data from SQL Server to MatrixOne
            • Writing Data from MongoDB to MatrixOne
            • Writing Data from TiDB to MatrixOne
            • Writing Data from ClickHouse to MatrixOne
            • Writing Data from Doris to MatrixOne
            • Writing Data from InfluxDB to MatrixOne
            • Writing Data from Elasticsearch to MatrixOne
        • Spark
          • Writing Data from MySQL to MatrixOne
          • Writing Data from Hive to MatrixOne
          • Writing Data from Doris to MatrixOne
          • Using Flink to Write Real-Time Data to MatrixOne
            • Writing Data from MySQL to MatrixOne
            • Writing Data from Oracle to MatrixOne
            • Writing Data from SQL Server to MatrixOne
            • Writing Data from PostgreSQL to MatrixOne
            • Writing Data from MongoDB to MatrixOne
            • Writing Data from TiDB to MatrixOne
            • Writing Data from Kafka to MatrixOne
        • Flink
          • Writing Data from MySQL to MatrixOne
          • Writing Data from Oracle to MatrixOne
          • Writing Data from SQL Server to MatrixOne
          • Writing Data from PostgreSQL to MatrixOne
          • Writing Data from MongoDB to MatrixOne
          • Writing Data from TiDB to MatrixOne
          • Writing Data from Kafka to MatrixOne
        • BI integrations
          • Shared BI dataset and KPI checks
          • Connect Metabase and build metrics
          • Superset analytic connection checks
          • Grafana MySQL datasource and compatibility checks
          • Connect Redash and save analytic queries
          • Connect DataEase and preview SQL datasets
          • Evidence MySQL source and compatibility checks
          • Rill ingestion and native metrics
          • Apache Zeppelin JDBC notebooks
          • SQLPad saved SQL analyses
          • Lightdash direct-connection boundary
        • CDC
          • mo_cdc command reference
            • From MatrixOne to MySQL
            • From MatrixOne to MatrixOne
          • MatrixOne to MySQL
          • MatrixOne to MatrixOne
        • S3 and MinIO
          • Load from S3
          • Import from MinIO
          • Deploy with S3 storage
            • Plan MatrixOne Cluster Topology
              • Experience Environment Deployment Plan
              • Minimum Production Environment Deployment Plan
              • Recommended Production Environment Deployment Plan
              • Production readiness and acceptance
            • Cluster Deployment Guide
              • Deployed Kubernetes and object storage environment
            • Cluster Operations Management
              • Updating
              • Health check and resource monitoring
              • Scaling
              • Managing CN Groups with Proxy
              • Import data from local Minio to MatrixOne
              • Operator Management
                • Kubernetes Operator acceptance operations
            • Deploy Matrixone Cluster
        • Lakehouse ecosystem tutorials
          • Prepare connections, fixtures and acceptance checks
          • Batch loading with pandas, PETL, Polars and Dask
          • PyArrow IPC and DuckDB Parquet bridges to MatrixOne
          • PyIceberg append/scan with an explicit SQL bridge
          • Airflow MySqlHook DAG and idempotent retries
          • dbt-mysql model builds and data tests
          • DolphinScheduler Shell and native SQL tasks
          • Local testing with the official Fivetran Connector SDK
          • Airbyte connector protocol and destination acceptance
          • NiFi Record flows and MatrixOne JDBC writes
          • Kafka Connect, Debezium and JDBC CDC sinks
          • Exact event loading with Redpanda Connect and kafka-python
          • Read fidelity with ConnectorX, Ibis and database drivers
          • dlt loading and Singer state-protocol adapters
          • Job acceptance for DataX, SeaTunnel, Spark, Flink and Trino
          • Native DataX source scans and exact-value writes
          • Native Spark JDBC reads, writes, types and partitions
          • Native Flink MySQL CDC into MatrixOne and recovery acceptance
        • Workflow orchestration
          • DolphinScheduler
        • Application, AI and data development
          • Dify Platform Integration Guide for MatrixOne
          • Prerequisites
          • Steps
          • RAG application foundation
          • Git for Data
        • Database administration, migration and backup tools
          • mo_ctl Distributed Edition
          • mo_ctl Standalone Edition
          • Migration overview
            • MySQL
            • Data migration compatibility cookbook
            • Oracle
              • Heterogeneous type acceptance
            • SQL Server
            • PostgreSQL
            • Reconciliation and cutover
          • Data migration compatibility cookbook
          • MySQL migration guide
          • Oracle migration guide
            • Heterogeneous type acceptance
          • PostgreSQL migration guide
          • SQL Server migration guide
          • mo-dump export utility
          • mo-dump backup and restore
          • mo_br backup and recovery
            • mo_br regular physical backup recovery
            • mo_br snapshot backup recovery
            • mo_br pitr
          • Backup and recovery overview
            • Backup and Recovery Concepts
            • Backup and Restore by using mo-dump
            • mo_br Backup and Recovery
              • mo_br regular physical backup recovery
              • mo_br snapshot backup recovery
              • mo_br pitr
            • MatrixOne active/standby disaster recovery
            • cdc
              • From MatrixOne to MySQL
              • From MatrixOne to MatrixOne
            • Mount Data
            • DECIMAL256 index upgrade
            • Recovery selection and acceptance
            • Operations overview
      • Develop Overview
      • AI Agent Tools
        • Query MatrixOne Documentation with AI Agent
      • Qualify an Ecosystem Integration
      • Failure Recovery
      • Ecosystem tools index
        • ETL Tools Index
        • Compute Engines Index
        • BI Tools Index
      • Data import index
      • Data export index
      • Vector search index
    • Tutorial
    • Deploying
      • Plan MatrixOne Cluster Topology
        • Experience Environment Deployment Plan
        • Minimum Production Environment Deployment Plan
        • Recommended Production Environment Deployment Plan
        • Production readiness and acceptance
      • Cluster Deployment Guide
        • Deployed Kubernetes and object storage environment
      • Cluster Operations Management
        • Updating
        • Health check and resource monitoring
        • Scaling
        • Managing CN Groups with Proxy
        • Import data from local Minio to MatrixOne
        • Operator Management
          • Kubernetes Operator acceptance operations
      • Deploy Matrixone Cluster
    • Maintenance
      • Backup and Recovery Concepts
      • Backup and Restore by using mo-dump
      • mo_br Backup and Recovery
        • mo_br regular physical backup recovery
        • mo_br snapshot backup recovery
        • mo_br pitr
      • MatrixOne active/standby disaster recovery
      • cdc
        • From MatrixOne to MySQL
        • From MatrixOne to MatrixOne
      • Mount Data
      • DECIMAL256 index upgrade
      • Recovery selection and acceptance
      • Operations overview
    • Migrating
      • MySQL
      • Data migration compatibility cookbook
      • Oracle
        • Heterogeneous type acceptance
      • SQL Server
      • PostgreSQL
      • Reconciliation and cutover
    • Testing
      • TPCH Test with MatrixOne
      • TPCC Test with MatrixOne
      • Testing Tool
        • MO-Tester Specification
    • Performance Tuning
      • Understanding the Query Execution Plan
        • Using EXPLAIN to learn the execution plan
        • Explain Statements Using JOIN
        • Explain Statements Using Subqueries
        • Explain Statements Using Aggregation
        • EXPLAIN Statements Using Views
      • Performance tuning best practices
        • Scaling CN for better performance
        • Partition Pruning
        • Usage scenarios of Partition Pruning in KEY Partitioned Tables
        • Usage scenarios of Partition Pruning in HASH Partitioned Tables
        • Performance Tuning Examples for Partition Pruning
        • Constraints
        • Performance Tuning with Partitioned Tables
      • Optimizer Hints
    • Privilege
      • Authentication and Authorization
      • Password Management
      • Access Control
        • Privilege Management Scenario
        • Best Practices
        • SQL File Access
        • Role Grant Consistency
      • SQL File Access
      • User Guide
        • Create accounts, Verify Resource Isolation
        • Use the new account to creates users, roles, grant the privilege
      • Data Transmission Encryption
      • Security Audit
    • Reference
      • System Variables parameters
        • Save query result support
        • Timezone support
        • Lower case table names support
        • Foreign key checking support
        • User-specified case consistency support for query result set column names
        • Illegal login restrictions
        • Password complexity verification
        • Connection whitelist
        • Enable remap hint
      • cte_max_memory_bytes
      • cte_max_recursion_depth
      • enable_explain_scheduling
      • event_scheduler
      • experimental_cagra_index
      • experimental_fulltext_index
      • experimental_fulltext2_index
      • experimental_hnsw_index
      • experimental_ivf_index
      • experimental_ivfpq_index
      • fulltext_bloom_filter_pushdown
      • ft2_relevancy_algorithm
      • group_concat_max_len
      • lock_wait_timeout
      • mo_rollback_txn_on_error
      • protected_databases
      • query_max_workers
      • query_pool_strict
      • remap_rewrites
      • remapdb
      • sort_spill_mem
      • Custom variable
      • SQL Language Structure
        • Comments
      • Data Types
        • Data Type Conversion
        • Date and Time Types
          • YEAR Type
        • Geometry Type
        • JSON Data Type
        • BLOB and TEXT Type
        • DATALINK Type
        • ENUM Type
        • UUID Type
        • VECTOR Type
        • Fixed-Point Types (Exact Value) - DECIMAL
        • Set Type
      • SQL Statements
        • Data Definition Language
          • CREATE INDEX
          • CREATE INDEX...USING IVFFLAT
          • CREATE INDEX...USING HNSW
          • CREATE FULLTEXT INDEX
          • CREATE TABLE
          • CREATE TABLE AS SELECT
          • CREATE TABLE ... LIKE
          • CREATE EXTERNAL TABLE
          • CREATE EXTERNAL TABLE ... ENGINE = DATASTREAM
          • CREATE EXTERNAL TABLE ... ENGINE = SQL|ESQL
          • CREATE EXTERNAL TABLE ... ENGINE = KAFKA
          • External Table Error Mode
          • CREATE FULLTEXT2 INDEX
          • CREATE ICEBERG CATALOG
          • ALTER ICEBERG CATALOG
          • DROP ICEBERG CATALOG
          • CREATE MONGODB CONNECTION
          • ALTER MONGODB CONNECTION
          • DROP MONGODB CONNECTION
          • CREATE CLUSTER TABLE
          • CREATE CLONE
          • CREATE PITR
          • CREATE PUBLICATION
          • CREATE SEQUENCE
          • CREATE STAGE
          • CREATE...FROM...PUBLICATION...
          • CREATE VIEW
          • CREATE FUNCTION...LANGUAGE SQL AS
          • CREATE FUNCTION...LANGUAGE PYTHON AS
          • CREATE SOURCE
          • CREATE DYNAMIC TABLE
          • CREATE SNAPSHOT
          • CREATE BRANCH
          • DELETE BRANCH
          • DIFF BRANCH
          • MERGE BRANCH
          • ALTER TABLE
          • ALTER TABLE ... ALTER REINDEX
          • ALTER PITR
          • ALTER PUBLICATION
          • ALTER SEQUENCE
          • ALTER STAGE
          • ALTER VIEW
          • DROP DATABASE
          • DROP INDEX
          • DROP TABLE
          • DROP PITR
          • DROP PUBLICATION
          • DROP SEQUENCE
          • DROP STAGE
          • DROP SNAPSHOT
          • DROP VIEW
          • DROP FUNCTION
          • TRUNCATE TABLE
          • RENAME TABLE
          • RESTORE PITR
          • RESTORE SNAPSHOT
          • Branch Protect Snapshots
          • Data Branch Pick
          • Sql Task
          • Data Branch Privilege
          • CREATE PROCEDURE / CALL / DROP PROCEDURE
        • Data Manipulation Language
          • INSERT INTO SELECT
          • DELETE
          • UPDATE
          • LOAD DATA INFILE
          • LOAD DATA INLINE
          • UPSERT
            • INSERT ON DUPLICATE KEY UPDATE
            • INSERT IGNORE
            • REPLACE
          • MERGE
          • RETURNING
          • Information Functions
            • LAST_INSERT_ID()
            • ROW_COUNT()
            • Current_Role
          • Case
          • Replace
        • Data Query Language
          • OUTER APPLY
          • JOIN
            • INNER JOIN
            • LEFT JOIN
            • RIGHT JOIN
            • FULL JOIN
            • OUTER JOIN
            • Examples
            • NATURAL JOIN
            • Cross Join
          • SELECT
          • BY RANK WITH OPTION
          • SUBQUERY
            • Derived Tables
            • Comparisons Using Subqueries
            • SUBQUERY with ANY or SOME
            • SUBQUERY with ALL
            • SUBQUERY with EXISTS
            • SUBQUERY with IN
          • With CTE
          • Combining Queries
            • UNION
            • INTERSECT
            • MINUS
        • Data Control Language
          • ALTER ACCOUNT
          • CREATE ROLE
          • CREATE USER
          • ALTER USER
          • DROP ACCOUNT
          • DROP USER
          • DROP ROLE
          • GRANT
          • REVOKE
          • Role Rule
        • Other
          • SHOW DATABASES
          • SHOW CREATE TABLE
          • SHOW CREATE VIEW
          • SHOW CREATE PUBLICATION
          • SHOW TABLES
          • SHOW INDEX
          • SHOW COLLATION
          • SHOW COLUMNS
          • SHOW FUNCTION STATUS
          • SHOW GRANT
          • SHOW PROCESSLIST
          • SHOW PUBLICATIONS
          • SHOW PITRS
          • SHOW ROLES
          • SHOW SEQUENCES
          • SHOW STAGE
          • SHOW SUBSCRIPTIONS
          • SHOW VARIABLES
          • SHOW ICEBERG CATALOGS
          • SHOW ICEBERG NAMESPACES
          • SHOW ICEBERG TABLES
          • SHOW MONGODB CONNECTIONS
          • SHOW PROFILE
          • Show Create Database
          • Show Table Status
          • SET
          • USE
            • ANALYZE TABLE
            • DUMP TABLE
            • LOAD TABLE
            • PERFORM
            • Starlark Procedure Error Reporting
          • KILL
          • Prepared Statements
            • EXECUTE
            • DEALLOCATE
          • Explain
            • EXPLAIN Output Format
            • Explain Analyze
            • Explain Prepared
          • Describe
          • ANALYZE TABLE
          • DUMP TABLE
          • LOAD TABLE
          • PERFORM
          • Starlark Procedure Error Reporting
      • Operators
        • OPERATORS
          • OPERATORS Precedence
          • Arithmetic Operators
            • %,MOD
            • *
            • +
            • -
            • -
            • /
            • DIV
          • Assignment Operators
            • =
          • Bit Functions and Operators
            • &
            • >>
            • <<
            • ^
            • |
            • ~
          • Cast Functions and Operators
            • BINARY
            • CAST
            • CONVERT
            • DECODE
            • ENCODE
            • SERIAL
            • SERIAL_FULL
          • Comparison Functions and Operators
            • >
            • >=
            • <
            • <>,!=
            • <=
            • =
            • BETWEEN ... AND ...
            • IN
            • IS
            • IS NOT
            • IS NOT NULL
            • IS NULL
            • ILIKE
            • ISNULL
            • LIKE
            • NOT BETWEEN ... AND ...
            • NOT IN
            • NOT LIKE
            • COALESCE
            • Function_Interval
            • Function_Greatest
            • Function_Least
            • Function_Strcmp
            • Null Safe Equal
          • Flow Control Functions
            • CASE WHEN
            • IF
            • IFNULL
            • NULLIF
          • Logical Operators
            • AND,&&
            • NOT,!
            • OR
            • XOR
      • Functions and Operators
        • Aggregate Functions
          • AVG
          • APPROX_PERCENTILE
          • BITMAP
          • BIT_AND
          • BIT_OR
          • BIT_XOR
          • COUNT
          • GROUP_CONCAT
          • HLL_ADD_AGG
          • HLL_CARDINALITY
          • HLL_MERGE_AGG
          • MAX
          • MAX_BY
          • MAX_BY_NON_NULL
          • MEDIAN
          • MIN
          • STDDEV_POP
          • SUM
          • VARIANCE
          • VAR_POP
        • Datetime
          • CURDATE()
          • CURRENT_TIMESTAMP()
          • DATE()
          • DATE_ADD()
          • DATE_FORMAT()
          • DATE_SUB()
          • DATE_TRUNC()
          • DATEDIFF()
          • DAY()
          • DAYOFYEAR()
          • EXTRACT()
          • HOUR()
          • FROM_UNIXTIME
          • MINUTE()
          • MONTH()
          • NOW()
          • SECOND()
          • STR_TO_DATE()
          • SYSDATE()
          • TIME()
          • TIMEDIFF()
          • TIMESTAMP()
          • TIMESTAMPDIFF()
          • TO_DATE()
          • TO_DAYS()
          • TO_SECONDS()
          • UNIX_TIMESTAMP
          • UTC_TIMESTAMP()
          • WEEK()
          • WEEKDAY()
          • YEAR()
          • Addtime
          • Curtime
          • Dayname
          • Get Format
          • Maketime
          • Monthname
          • Quarter
          • Subtime
          • Time Format
          • Timestampadd
          • Yearweek
        • Geo Functions
          • H3 Index Functions
          • MBRContains
          • MBRCoveredBy
          • MBRCovers
          • MBRDisjoint
          • MBREquals
          • MBRIntersects
          • MBROverlaps
          • MBRTouches
          • MBRWithin
          • S2 Cell Functions
          • ST_Area()
          • ST_AsGeoJSON
          • ST_AsText()
          • ST_AsWKB()
          • ST_Boundary()
          • ST_Buffer()
          • ST_Centroid()
          • ST_Collect()
          • ST_Contains()
          • ST_ConvexHull()
          • ST_CoveredBy()
          • ST_Covers()
          • ST_Crosses()
          • ST_Difference()
          • ST_Dimension()
          • ST_Disjoint()
          • ST_Distance()
          • ST_Distance_Sphere()
          • ST_EndPoint()
          • ST_Envelope()
          • ST_Equals()
          • ST_ExteriorRing()
          • ST_FrechetDistance()
          • ST_GeoHash
          • ST_GeomCollFromText()
          • ST_GeomCollFromWKB()
          • ST_GeometryN()
          • ST_GeometryType()
          • ST_GeomFromGeoJSON
          • ST_GeomFromText()
          • ST_GeomFromWKB()
          • ST_HausdorffDistance()
          • ST_InteriorRingN()
          • ST_Intersection()
          • ST_Intersects()
          • ST_IsClosed()
          • ST_IsCollection()
          • ST_IsEmpty()
          • ST_IsRing()
          • ST_IsSimple()
          • ST_IsValid()
          • ST_LatFromGeoHash
          • ST_Latitude()
          • ST_Length()
          • ST_LineFromText()
          • ST_LineFromWKB()
          • ST_LineInterpolatePoint()
          • ST_LineInterpolatePoints()
          • ST_LongFromGeoHash
          • ST_Longitude()
          • ST_MakeEnvelope()
          • ST_MLineFromText()
          • ST_MLineFromWKB()
          • ST_MPointFromText()
          • ST_MPointFromWKB()
          • ST_MPolyFromText()
          • ST_MPolyFromWKB()
          • ST_NumGeometries()
          • ST_NumInteriorRings()
          • ST_NumPoints()
          • ST_Overlaps()
          • ST_PointAtDistance()
          • ST_PointFromGeoHash
          • ST_PointFromText()
          • ST_PointFromWKB()
          • ST_PointN()
          • ST_PointOnSurface()
          • ST_PolyFromText()
          • ST_PolyFromWKB()
          • ST_Simplify()
          • ST_SRID()
          • ST_StartPoint()
          • ST_SwapXY()
          • ST_SymDifference()
          • ST_Touches()
          • ST_Union()
          • ST_Validate()
          • ST_Within()
          • ST_X()
          • ST_Y()
        • Mathematical
          • ACOS()
          • ATAN()
          • BIT_COUNT()
          • CEIL()
          • CEILING()
          • COS()
          • COT()
          • CRC32()
          • EXP()
          • FLOOR()
          • LN()
          • LOG()
          • LOG2()
          • LOG10()
          • PI()
          • POWER()
          • ROUND()
          • RAND()
          • SIN()
          • SINH()
          • TAN()
          • Atan2
          • Degrees
          • Radians
          • Sign
          • Truncate
        • String
          • BIT_LENGTH()
          • CHAR_LENGTH()
          • CONCAT()
          • CONCAT_WS()
          • EMPTY()
          • ENDSWITH()
          • FIELD()
          • FIND_IN_SET()
          • FORMAT()
          • FROM_BASE64()
          • HEX()
          • INSTR()
          • LCASE()
          • LEFT()
          • LENGTH()
          • LOCATE()
          • LOWER()
          • LPAD()
          • LTRIM()
          • MD5()
          • NAME_CONST()
          • OCT()
          • REPEAT()
          • REVERSE()
          • RPAD()
          • RTRIM()
          • SHA1()/SHA()
          • SHA2()
          • SPACE()
          • SPLIT_PART()
          • STARTSWITH()
          • STRCMP()
          • SUBSTRING()
          • SUBSTRING_INDEX()
          • TO_BASE64()
          • TRIM()
          • UCASE()
          • UNHEX()
          • UPPER()
          • Regular Expressions
            • NOT REGEXP
            • REGEXP_INSTR()
            • REGEXP_LIKE()
            • REGEXP_REPLACE()
            • REGEXP_SUBSTR()
          • Aes_Decrypt
          • Aes_Encrypt
          • Elt
          • Quote
          • Right
        • Vector
          • Mathematical Calculations
          • CLUSTER_CENTERS()
          • COSINE_SIMILARITY()
          • COSINE_DISTANCE()
          • INNER_PRODUCT()
          • L1_NORM()
          • L1_DISTANCE() (unavailable)
          • L2_NORM()
          • L2_DISTANCE()
          • L2_DISTANCE_SQ()
          • NORMALIZE_L2()
          • SUBVECTOR()
          • VECTOR_DIMS()
        • Table
          • UNNEST()
          • SQL_TVF()
          • ESQL_TVF()
        • Window Functions
          • RANK()
          • ROW_NUMBER()
          • Cume_Dist
          • Percent_Rank
        • JSON Functions
          • JSON_EXTRACT()
          • JSON_EXTRACT_FLOAT64()
          • JSON_EXTRACT_STRING()
          • JSON_QUOTE()
          • JSON_ROW()
          • JSON_SET()
          • JSON_UNQUOTE()
          • TRY_JQ()
          • Json Arrow
          • JSON_ARRAY()
            • JSON_CONTAINS()
            • JSON_CONTAINS_PATH()
            • JSON_KEYS()
            • JSON_LENGTH()
            • JSON_MERGE_PATCH()
            • JSON_MERGE_PRESERVE()
            • JSON_OBJECT()
            • JSON_OVERLAPS()
            • JSON_PRETTY()
            • JSON_REMOVE()
            • JSON_SCHEMA_VALID()
            • JSON_SCHEMA_VALIDATION_REPORT()
            • JSON_TYPE()
            • JSON_VALID()
            • JSON_VALUE()
          • JSON_KEYS()
          • JSON_LENGTH()
          • JSON_OBJECT()
          • JSON_PRETTY()
          • JSON_SCHEMA_VALID()
          • JSON_SCHEMA_VALIDATION_REPORT()
          • JSON_TYPE()
          • JSON_VALID()
          • JSON_VALUE()
        • Other Functions
          • SAVE_FILE()
          • SAMPLE()
          • SERIAL_EXTRACT()
          • SLEEP()
          • STAGE_LIST()
          • ONNX_RUN()
          • UUID()
          • FOREIGN CONNECTION FUNCTIONS
          • LAST_KAFKA_MESSAGE_ID()
        • System OPS Functions
          • CURRENT_ROLE()
          • CURRENT_USER_NAME()
          • CURRENT_USER()
          • PURGE_LOG()
          • GET_LOCK()
          • RELEASE_LOCK()
          • IS_FREE_LOCK()
          • IS_USED_LOCK()
          • RELEASE_ALL_LOCKS()
          • Version
      • System Paramaters
        • Standalone Common Parameters Configuration
        • Distributed Common Parameters Configuration
      • MatrixOne Catalog
      • Privilege Control Types
      • Limitations
        • Partitioning supported features list
      • MatrixOne Directory Structure
      • MatrixOne tools index
      • Task-based tool selection
        • mo_ctl Standalone Tools Guide
        • Standalone mo_ctl scheduled operations
        • mo_ctl Distributed Edition Tool Guide
        • mo-service profiling flags
        • mo-tool advanced diagnostics and offline inspection
        • mo_datax_writer Tool Guide
        • mo_ssb_open Tool Guide
        • mo_tpch_open Tool Guide
        • mo_ts_perf_test Tool Guide
      • Mysql Compatibility Matrix
      • Mysql Unsupported Features
    • Troubleshooting
      • Common statistic data query
      • Database statistics
      • Error Code
    • FAQs
      • Deployment FAQs
      • SQL FAQs
    • Release Notes
    • Glossary
    • Contribution Guide
      • How to Contribute
        • Preparation
          • Kernel developer reading and verification guide
        • Report an Issue
        • Contribute Code
        • Review a Pull Request
        • Contribute Documentation
        • Make a Design
      • Code Style
        • Code Comment Style
        • Commit & Pull Request Style
    • Capability map and product boundaries
    • GIS spatial analysis
  • Get Started
    • Deploy on macOS
      • Using binary package
      • Using Docker
    • Deploy on Linux
      • Using binary package
      • Using Docker
    • Basic SQL
    • Installation choices and acceptance
  • Application development
    • Connections and drivers
      • Java connect to MatrixOne
        • Connect MatrixOne with Java ORMs
      • Python connect to MatrixOne
      • General Python SDK
      • C# connect to MatrixOne
      • Connecting to MatrixOne with Golang
      • MatrixOne SSL connection
      • Connecting to MatrixOne with TypeScript
      • Connecting to MatrixOne with ODBC
      • Connecting to MatrixOne with Power BI
      • Lakehouse Ecosystem Tutorials
        • Prepare connections, fixtures and acceptance checks
        • Batch loading with pandas, PETL, Polars and Dask
        • PyArrow IPC and DuckDB Parquet bridges to MatrixOne
        • PyIceberg append/scan with an explicit SQL bridge
        • Airflow MySqlHook DAG and idempotent retries
        • dbt-mysql model builds and data tests
        • DolphinScheduler Shell and native SQL tasks
        • Local testing with the official Fivetran Connector SDK
        • Airbyte connector protocol and destination acceptance
        • NiFi Record flows and MatrixOne JDBC writes
        • Kafka Connect, Debezium and JDBC CDC sinks
        • Exact event loading with Redpanda Connect and kafka-python
        • Read fidelity with ConnectorX, Ibis and database drivers
        • dlt loading and Singer state-protocol adapters
        • Job acceptance for DataX, SeaTunnel, Spark, Flink and Trino
        • Native DataX source scans and exact-value writes
        • Native Spark JDBC reads, writes, types and partitions
        • Native Flink MySQL CDC into MatrixOne and recovery acceptance
      • Schema Design
        • Create Database
        • Create Table
        • Replication table
        • Create View
        • Create Temporary Table
        • Create Secondary Index
        • Vector
        • Data Integrity
          • NOT NULL Constraints
          • UNIQUE KEY Constraints
          • PRIMARY KEY Constraints
          • FOREIGN KEY Constraints
          • AUTO INCREMENT Constraints
      • Write Data
        • Bulk Load
          • Load csv format data
          • Load jsonlines format data
          • Load data from S3
          • Load data by using the `source`
        • Update Data
        • DML Target and Conflict Semantics
        • Delete Data
        • Prepared
      • Export Data
        • Export data by MODUMP
      • Read Data
        • Multi-table Join Queries
        • Subquery
        • Views
        • Common Table Expression
        • Window Function
          • Time Window
          • Analytical Windows
      • Data de-duplication
        • BITMAP
      • Account Design
        • Publish-Subscribe
      • Transactions
        • Transaction by MatrixOne Server
          • Explicit Transaction
          • Implicit Transaction
          • Pessimistic Transaction
          • Optimistic Transaction
          • Isolation Level
          • MVCC
          • User Guide
            • Scenario
          • Scenario
      • User-defined function
        • UDF python advanced
      • Vector
        • Vector Search
        • IVF Rank Options
        • Query-level IVF Probe Count
        • Cluster Centers
        • Scalar Vector Query
        • IVF Equi-join Vector Query
      • Data Type Fidelity
      • Ecological Tools
        • BI integration guides and compatibility
          • Shared BI dataset and KPI checks
          • Connect Metabase and build metrics
          • Superset analytic connection checks
          • Grafana MySQL datasource and compatibility checks
          • Connect Redash and save analytic queries
          • Connect DataEase and preview SQL datasets
          • Evidence MySQL source and compatibility checks
          • Rill ingestion and native metrics
          • Apache Zeppelin JDBC notebooks
          • SQLPad saved SQL analyses
          • Lightdash direct-connection boundary
        • Visualizing MatrixOne Reports with Yonghong BI
        • Visual Monitoring of MatrixOne with Superset
        • ETL Tools
          • Writing Data from MySQL to MatrixOne
          • Writing Data from Oracle to MatrixOne
          • Using DataX to write data to MatrixOne
            • Writing Data from MySQL to MatrixOne
            • Writing Data from Oracle to MatrixOne
            • Writing Data from PostgreSQL to MatrixOne
            • Writing Data from SQL Server to MatrixOne
            • Writing Data from MongoDB to MatrixOne
            • Writing Data from TiDB to MatrixOne
            • Writing Data from ClickHouse to MatrixOne
            • Writing Data from Doris to MatrixOne
            • Writing Data from InfluxDB to MatrixOne
            • Writing Data from Elasticsearch to MatrixOne
        • Computing Engine
          • Writing Data from MySQL to MatrixOne
          • Writing Data from Hive to MatrixOne
          • Writing Data from Doris to MatrixOne
          • Using Flink to Write Real-Time Data to MatrixOne
            • Writing Data from MySQL to MatrixOne
            • Writing Data from Oracle to MatrixOne
            • Writing Data from SQL Server to MatrixOne
            • Writing Data from PostgreSQL to MatrixOne
            • Writing Data from MongoDB to MatrixOne
            • Writing Data from TiDB to MatrixOne
            • Writing Data from Kafka to MatrixOne
        • Scheduling Tools
      • Ecosystem Tools Overview
        • DataX
          • Writing Data from MySQL to MatrixOne
          • Writing Data from Oracle to MatrixOne
          • Writing Data from PostgreSQL to MatrixOne
          • Writing Data from SQL Server to MatrixOne
          • Writing Data from MongoDB to MatrixOne
          • Writing Data from TiDB to MatrixOne
          • Writing Data from ClickHouse to MatrixOne
          • Writing Data from Doris to MatrixOne
          • Writing Data from InfluxDB to MatrixOne
          • Writing Data from Elasticsearch to MatrixOne
        • SeaTunnel
          • Writing Data from MySQL to MatrixOne
          • Writing Data from Oracle to MatrixOne
          • Using DataX to write data to MatrixOne
            • Writing Data from MySQL to MatrixOne
            • Writing Data from Oracle to MatrixOne
            • Writing Data from PostgreSQL to MatrixOne
            • Writing Data from SQL Server to MatrixOne
            • Writing Data from MongoDB to MatrixOne
            • Writing Data from TiDB to MatrixOne
            • Writing Data from ClickHouse to MatrixOne
            • Writing Data from Doris to MatrixOne
            • Writing Data from InfluxDB to MatrixOne
            • Writing Data from Elasticsearch to MatrixOne
        • Spark
          • Writing Data from MySQL to MatrixOne
          • Writing Data from Hive to MatrixOne
          • Writing Data from Doris to MatrixOne
          • Using Flink to Write Real-Time Data to MatrixOne
            • Writing Data from MySQL to MatrixOne
            • Writing Data from Oracle to MatrixOne
            • Writing Data from SQL Server to MatrixOne
            • Writing Data from PostgreSQL to MatrixOne
            • Writing Data from MongoDB to MatrixOne
            • Writing Data from TiDB to MatrixOne
            • Writing Data from Kafka to MatrixOne
        • Flink
          • Writing Data from MySQL to MatrixOne
          • Writing Data from Oracle to MatrixOne
          • Writing Data from SQL Server to MatrixOne
          • Writing Data from PostgreSQL to MatrixOne
          • Writing Data from MongoDB to MatrixOne
          • Writing Data from TiDB to MatrixOne
          • Writing Data from Kafka to MatrixOne
        • BI integrations
          • Shared BI dataset and KPI checks
          • Connect Metabase and build metrics
          • Superset analytic connection checks
          • Grafana MySQL datasource and compatibility checks
          • Connect Redash and save analytic queries
          • Connect DataEase and preview SQL datasets
          • Evidence MySQL source and compatibility checks
          • Rill ingestion and native metrics
          • Apache Zeppelin JDBC notebooks
          • SQLPad saved SQL analyses
          • Lightdash direct-connection boundary
        • CDC
          • mo_cdc command reference
            • From MatrixOne to MySQL
            • From MatrixOne to MatrixOne
          • MatrixOne to MySQL
          • MatrixOne to MatrixOne
        • S3 and MinIO
          • Load from S3
          • Import from MinIO
          • Deploy with S3 storage
            • Plan MatrixOne Cluster Topology
              • Experience Environment Deployment Plan
              • Minimum Production Environment Deployment Plan
              • Recommended Production Environment Deployment Plan
              • Production readiness and acceptance
            • Cluster Deployment Guide
              • Deployed Kubernetes and object storage environment
            • Cluster Operations Management
              • Updating
              • Health check and resource monitoring
              • Scaling
              • Managing CN Groups with Proxy
              • Import data from local Minio to MatrixOne
              • Operator Management
                • Kubernetes Operator acceptance operations
            • Deploy Matrixone Cluster
        • Lakehouse ecosystem tutorials
          • Prepare connections, fixtures and acceptance checks
          • Batch loading with pandas, PETL, Polars and Dask
          • PyArrow IPC and DuckDB Parquet bridges to MatrixOne
          • PyIceberg append/scan with an explicit SQL bridge
          • Airflow MySqlHook DAG and idempotent retries
          • dbt-mysql model builds and data tests
          • DolphinScheduler Shell and native SQL tasks
          • Local testing with the official Fivetran Connector SDK
          • Airbyte connector protocol and destination acceptance
          • NiFi Record flows and MatrixOne JDBC writes
          • Kafka Connect, Debezium and JDBC CDC sinks
          • Exact event loading with Redpanda Connect and kafka-python
          • Read fidelity with ConnectorX, Ibis and database drivers
          • dlt loading and Singer state-protocol adapters
          • Job acceptance for DataX, SeaTunnel, Spark, Flink and Trino
          • Native DataX source scans and exact-value writes
          • Native Spark JDBC reads, writes, types and partitions
          • Native Flink MySQL CDC into MatrixOne and recovery acceptance
        • Workflow orchestration
          • DolphinScheduler
        • Application, AI and data development
          • Dify Platform Integration Guide for MatrixOne
          • Prerequisites
          • Steps
          • RAG application foundation
          • Git for Data
        • Database administration, migration and backup tools
          • mo_ctl Distributed Edition
          • mo_ctl Standalone Edition
          • Migration overview
            • MySQL
            • Data migration compatibility cookbook
            • Oracle
              • Heterogeneous type acceptance
            • SQL Server
            • PostgreSQL
            • Reconciliation and cutover
          • Data migration compatibility cookbook
          • MySQL migration guide
          • Oracle migration guide
            • Heterogeneous type acceptance
          • PostgreSQL migration guide
          • SQL Server migration guide
          • mo-dump export utility
          • mo-dump backup and restore
          • mo_br backup and recovery
            • mo_br regular physical backup recovery
            • mo_br snapshot backup recovery
            • mo_br pitr
          • Backup and recovery overview
            • Backup and Recovery Concepts
            • Backup and Restore by using mo-dump
            • mo_br Backup and Recovery
              • mo_br regular physical backup recovery
              • mo_br snapshot backup recovery
              • mo_br pitr
            • MatrixOne active/standby disaster recovery
            • cdc
              • From MatrixOne to MySQL
              • From MatrixOne to MatrixOne
            • Mount Data
            • DECIMAL256 index upgrade
            • Recovery selection and acceptance
            • Operations overview
      • Develop Overview
      • AI Agent Tools
        • Query MatrixOne Documentation with AI Agent
      • Qualify an Ecosystem Integration
      • Failure Recovery
      • Ecosystem tools index
        • ETL Tools Index
        • Compute Engines Index
        • BI Tools Index
      • Data import index
      • Data export index
      • Vector search index
  • Tutorial
    • Tools and Integrations
      • AI and Search
        • Vector Search
          • Pinecone-Compatible Vector Search
          • IVF Index Health Monitoring
          • HNSW Vector Index
          • Filtered Vector Top-K
          • Search with a Saved Query Vector
          • Vector Search with an Equality JOIN
          • Vector Search Reference
        • Full-Text Search
          • Natural Language Full-Text Search (Python SDK)
          • Boolean Full-Text Search (Python SDK)
          • JSON Full-Text Search (Python SDK)
          • FULLTEXT2 Phrase and Boolean Search (SQL)
          • JSONLine to JSON Path Search (SQL)
          • Full-Text Index SQL Reference
        • Hybrid Search and Analytics
          • Hybrid Search: Vector, Full-Text, and SQL
          • Search and Analytics SQL Recipes
            • FULLTEXT2 phrase and Boolean search
            • Load JSONLine and query JSON paths
            • Filtered vector Top-K search
            • Search with a stored query vector
            • Search vectors through an equi-join
            • Fill missing time windows for device readings
        • AI Applications and Integrations
          • RAG Application Demo
          • Picture and Text-to-Picture Search Demo
          • Dify Platform Integration Guide for MatrixOne
          • Prerequisites
          • Steps
      • Data Workflows
        • External Data and Files Index
          • External Data Sources and Connectors
            • Read a Bounded Set from MongoDB
            • Read and Resume a Kafka Partition
            • Compare Filter Pushdown for Remote SQL
            • Read a File or JDBC Source through DataStream
          • File Loading, Stage, and Table Export
            • Write to Stage and Read through an External Table
            • Load Multiple and Compressed Files
            • Route Malformed Rows to a Rejects Table
            • Restore a Table through Stage with DUMP/LOAD TABLE
        • Git4Data Demo
      • Iceberg
        • Iceberg orders tutorial
        • Delete and verify Iceberg rows
      • Data Management and SQL
        • Application SQL Recipes
          • Save and reuse a query result
          • Return the final row after DML
          • Reject invalid orders with CHECK
          • Classify SQL errors in a Starlark procedure
        • Data Branching and Sharing
          • Persist and Review Data Branch Differences
          • Publish and Subscribe across Two Accounts
        • Backup and Recovery
          • Point-in-Time Recovery Drill
          • Backup and Restore Guide
            • Backup and Recovery Concepts
            • Backup and Restore by using mo-dump
            • mo_br Backup and Recovery
              • mo_br regular physical backup recovery
              • mo_br snapshot backup recovery
              • mo_br pitr
            • MatrixOne active/standby disaster recovery
            • cdc
              • From MatrixOne to MySQL
              • From MatrixOne to MatrixOne
            • Mount Data
            • DECIMAL256 index upgrade
            • Recovery selection and acceptance
            • Operations overview
      • Spatial and GIS
        • GIS Types and Data Import
        • GIS Geofences and Regional Analysis
        • GIS Nearby-Store Distance Ranking
        • Geofence and Distance SQL Recipe
    • Application and Scenario Examples
      • Python Application Examples
        • Python CRUD Demo
          • Separate public mo-vector package lab
        • SQLAlchemy CRUD Demo
        • Django CRUD Demo
      • Java Application Examples
        • Java JDBC CRUD Demo
        • SpringBoot and JPA CRUD Demo
        • SpringBoot and MyBatis CRUD Demo
      • Other Language Application Examples
        • Golang CRUD Demo
        • Gorm CRUD Demo
        • C# CRUD Demo
        • TypeScript Basic Example
      • HTAP Application demo
      • Analytics and Machine Learning
        • pandas and NumPy data handling
        • Point-in-time features and revisions
        • Multi-table analysis without double counting
        • Calendar and rolling features
        • Spark and Flink analytical pipelines
        • Model weights, preprocessing and prediction readback
        • Window statistics migration
        • Ten business-analysis seeds
        • Measurement and troubleshooting
      • Safe Production Upgrade with Instant Rollback
      • Instant Clone for Multi-Team Development
    • SDK and Development Basics
      • General Python SDK basics
      • Separate vector SDK
      • Python Data Science and Machine Learning
        • Data Science with the Python SDK
          • SDK, pandas and SQL exploration
          • SDK and scikit-learn: train, evaluate and write back
        • DataFrame Operations with the SDK
        • Machine Learning Workflows with the SDK
    • Data Workflows and Use Cases
      • Native SQL Task experiments
      • MySQL migration and reconciliation lab
      • Stored procedures: parameters and rollback
    • Database Labs
      • Database Recovery Labs
        • Updates, Deletes, and Protected History
        • Restart Recovery of Committed Data
      • Query and Transaction Labs
        • Sorting, JOIN, and Spill
        • From JOIN SQL to an Execution Plan
        • Statement Errors, Rollback, and Two-Session Isolation
        • Commit and Visibility across Two CNs
  • Deploy
    • Plan MatrixOne Cluster Topology
      • Experience Environment Deployment Plan
      • Minimum Production Environment Deployment Plan
      • Recommended Production Environment Deployment Plan
      • Production readiness and acceptance
    • Cluster Deployment Guide
      • Deployed Kubernetes and object storage environment
    • Cluster Operations Management
      • Updating
      • Health check and resource monitoring
      • Scaling
      • Managing CN Groups with Proxy
      • Import data from local Minio to MatrixOne
      • Operator Management
        • Kubernetes Operator acceptance operations
    • Deploy Matrixone Cluster
  • Operations
    • Backup and Recovery Concepts
    • Backup and Restore by using mo-dump
    • mo_br Backup and Recovery
      • mo_br regular physical backup recovery
      • mo_br snapshot backup recovery
      • mo_br pitr
    • MatrixOne active/standby disaster recovery
    • cdc
      • From MatrixOne to MySQL
      • From MatrixOne to MatrixOne
    • Mount Data
    • DECIMAL256 index upgrade
    • Recovery selection and acceptance
    • Operations overview
  • Migrate
    • MySQL
    • Data migration compatibility cookbook
    • Oracle
      • Heterogeneous type acceptance
    • SQL Server
    • PostgreSQL
    • Reconciliation and cutover
  • Test
    • TPCH Test with MatrixOne
    • TPCC Test with MatrixOne
    • Testing Tool
      • MO-Tester Specification
  • Performance
    • Understanding the Query Execution Plan
      • Using EXPLAIN to learn the execution plan
      • Explain Statements Using JOIN
      • Explain Statements Using Subqueries
      • Explain Statements Using Aggregation
      • EXPLAIN Statements Using Views
    • Performance tuning best practices
      • Scaling CN for better performance
      • Partition Pruning
      • Usage scenarios of Partition Pruning in KEY Partitioned Tables
      • Usage scenarios of Partition Pruning in HASH Partitioned Tables
      • Performance Tuning Examples for Partition Pruning
      • Constraints
      • Performance Tuning with Partitioned Tables
    • Optimizer Hints
  • Security
    • Authentication and Authorization
    • Password Management
    • Access Control
      • Privilege Management Scenario
      • Best Practices
      • SQL File Access
      • Role Grant Consistency
    • SQL File Access
    • User Guide
      • Create accounts, Verify Resource Isolation
      • Use the new account to creates users, roles, grant the privilege
    • Data Transmission Encryption
    • Security Audit
  • Reference
    • System Variables parameters
      • Save query result support
      • Timezone support
      • Lower case table names support
      • Foreign key checking support
      • User-specified case consistency support for query result set column names
      • Illegal login restrictions
      • Password complexity verification
      • Connection whitelist
      • Enable remap hint
    • cte_max_memory_bytes
    • cte_max_recursion_depth
    • enable_explain_scheduling
    • event_scheduler
    • experimental_cagra_index
    • experimental_fulltext_index
    • experimental_fulltext2_index
    • experimental_hnsw_index
    • experimental_ivf_index
    • experimental_ivfpq_index
    • fulltext_bloom_filter_pushdown
    • ft2_relevancy_algorithm
    • group_concat_max_len
    • lock_wait_timeout
    • mo_rollback_txn_on_error
    • protected_databases
    • query_max_workers
    • query_pool_strict
    • remap_rewrites
    • remapdb
    • sort_spill_mem
    • Custom variable
    • SQL Language Structure
      • Comments
    • Data Types
      • Data Type Conversion
      • Date and Time Types
        • YEAR Type
      • Geometry Type
      • JSON Data Type
      • BLOB and TEXT Type
      • DATALINK Type
      • ENUM Type
      • UUID Type
      • VECTOR Type
      • Fixed-Point Types (Exact Value) - DECIMAL
      • Set Type
    • SQL Statements
      • Data Definition Language
        • CREATE INDEX
        • CREATE INDEX...USING IVFFLAT
        • CREATE INDEX...USING HNSW
        • CREATE FULLTEXT INDEX
        • CREATE TABLE
        • CREATE TABLE AS SELECT
        • CREATE TABLE ... LIKE
        • CREATE EXTERNAL TABLE
        • CREATE EXTERNAL TABLE ... ENGINE = DATASTREAM
        • CREATE EXTERNAL TABLE ... ENGINE = SQL|ESQL
        • CREATE EXTERNAL TABLE ... ENGINE = KAFKA
        • External Table Error Mode
        • CREATE FULLTEXT2 INDEX
        • CREATE ICEBERG CATALOG
        • ALTER ICEBERG CATALOG
        • DROP ICEBERG CATALOG
        • CREATE MONGODB CONNECTION
        • ALTER MONGODB CONNECTION
        • DROP MONGODB CONNECTION
        • CREATE CLUSTER TABLE
        • CREATE CLONE
        • CREATE PITR
        • CREATE PUBLICATION
        • CREATE SEQUENCE
        • CREATE STAGE
        • CREATE...FROM...PUBLICATION...
        • CREATE VIEW
        • CREATE FUNCTION...LANGUAGE SQL AS
        • CREATE FUNCTION...LANGUAGE PYTHON AS
        • CREATE SOURCE
        • CREATE DYNAMIC TABLE
        • CREATE SNAPSHOT
        • CREATE BRANCH
        • DELETE BRANCH
        • DIFF BRANCH
        • MERGE BRANCH
        • ALTER TABLE
        • ALTER TABLE ... ALTER REINDEX
        • ALTER PITR
        • ALTER PUBLICATION
        • ALTER SEQUENCE
        • ALTER STAGE
        • ALTER VIEW
        • DROP DATABASE
        • DROP INDEX
        • DROP TABLE
        • DROP PITR
        • DROP PUBLICATION
        • DROP SEQUENCE
        • DROP STAGE
        • DROP SNAPSHOT
        • DROP VIEW
        • DROP FUNCTION
        • TRUNCATE TABLE
        • RENAME TABLE
        • RESTORE PITR
        • RESTORE SNAPSHOT
        • Branch Protect Snapshots
        • Data Branch Pick
        • Sql Task
        • Data Branch Privilege
        • CREATE PROCEDURE / CALL / DROP PROCEDURE
      • Data Manipulation Language
        • INSERT INTO SELECT
        • DELETE
        • UPDATE
        • LOAD DATA INFILE
        • LOAD DATA INLINE
        • UPSERT
          • INSERT ON DUPLICATE KEY UPDATE
          • INSERT IGNORE
          • REPLACE
        • MERGE
        • RETURNING
        • Information Functions
          • LAST_INSERT_ID()
          • ROW_COUNT()
          • Current_Role
        • Case
        • Replace
      • Data Query Language
        • OUTER APPLY
        • JOIN
          • INNER JOIN
          • LEFT JOIN
          • RIGHT JOIN
          • FULL JOIN
          • OUTER JOIN
          • Examples
          • NATURAL JOIN
          • Cross Join
        • SELECT
        • BY RANK WITH OPTION
        • SUBQUERY
          • Derived Tables
          • Comparisons Using Subqueries
          • SUBQUERY with ANY or SOME
          • SUBQUERY with ALL
          • SUBQUERY with EXISTS
          • SUBQUERY with IN
        • With CTE
        • Combining Queries
          • UNION
          • INTERSECT
          • MINUS
      • Data Control Language
        • ALTER ACCOUNT
        • CREATE ROLE
        • CREATE USER
        • ALTER USER
        • DROP ACCOUNT
        • DROP USER
        • DROP ROLE
        • GRANT
        • REVOKE
        • Role Rule
      • Other
        • SHOW DATABASES
        • SHOW CREATE TABLE
        • SHOW CREATE VIEW
        • SHOW CREATE PUBLICATION
        • SHOW TABLES
        • SHOW INDEX
        • SHOW COLLATION
        • SHOW COLUMNS
        • SHOW FUNCTION STATUS
        • SHOW GRANT
        • SHOW PROCESSLIST
        • SHOW PUBLICATIONS
        • SHOW PITRS
        • SHOW ROLES
        • SHOW SEQUENCES
        • SHOW STAGE
        • SHOW SUBSCRIPTIONS
        • SHOW VARIABLES
        • SHOW ICEBERG CATALOGS
        • SHOW ICEBERG NAMESPACES
        • SHOW ICEBERG TABLES
        • SHOW MONGODB CONNECTIONS
        • SHOW PROFILE
        • Show Create Database
        • Show Table Status
        • SET
        • USE
          • ANALYZE TABLE
          • DUMP TABLE
          • LOAD TABLE
          • PERFORM
          • Starlark Procedure Error Reporting
        • KILL
        • Prepared Statements
          • EXECUTE
          • DEALLOCATE
        • Explain
          • EXPLAIN Output Format
          • Explain Analyze
          • Explain Prepared
        • Describe
        • ANALYZE TABLE
        • DUMP TABLE
        • LOAD TABLE
        • PERFORM
        • Starlark Procedure Error Reporting
    • Operators
      • OPERATORS
        • OPERATORS Precedence
        • Arithmetic Operators
          • %,MOD
          • *
          • +
          • -
          • -
          • /
          • DIV
        • Assignment Operators
          • =
        • Bit Functions and Operators
          • &
          • >>
          • <<
          • ^
          • |
          • ~
        • Cast Functions and Operators
          • BINARY
          • CAST
          • CONVERT
          • DECODE
          • ENCODE
          • SERIAL
          • SERIAL_FULL
        • Comparison Functions and Operators
          • >
          • >=
          • <
          • <>,!=
          • <=
          • =
          • BETWEEN ... AND ...
          • IN
          • IS
          • IS NOT
          • IS NOT NULL
          • IS NULL
          • ILIKE
          • ISNULL
          • LIKE
          • NOT BETWEEN ... AND ...
          • NOT IN
          • NOT LIKE
          • COALESCE
          • Function_Interval
          • Function_Greatest
          • Function_Least
          • Function_Strcmp
          • Null Safe Equal
        • Flow Control Functions
          • CASE WHEN
          • IF
          • IFNULL
          • NULLIF
        • Logical Operators
          • AND,&&
          • NOT,!
          • OR
          • XOR
    • Functions and Operators
      • Aggregate Functions
        • AVG
        • APPROX_PERCENTILE
        • BITMAP
        • BIT_AND
        • BIT_OR
        • BIT_XOR
        • COUNT
        • GROUP_CONCAT
        • HLL_ADD_AGG
        • HLL_CARDINALITY
        • HLL_MERGE_AGG
        • MAX
        • MAX_BY
        • MAX_BY_NON_NULL
        • MEDIAN
        • MIN
        • STDDEV_POP
        • SUM
        • VARIANCE
        • VAR_POP
      • Datetime
        • CURDATE()
        • CURRENT_TIMESTAMP()
        • DATE()
        • DATE_ADD()
        • DATE_FORMAT()
        • DATE_SUB()
        • DATE_TRUNC()
        • DATEDIFF()
        • DAY()
        • DAYOFYEAR()
        • EXTRACT()
        • HOUR()
        • FROM_UNIXTIME
        • MINUTE()
        • MONTH()
        • NOW()
        • SECOND()
        • STR_TO_DATE()
        • SYSDATE()
        • TIME()
        • TIMEDIFF()
        • TIMESTAMP()
        • TIMESTAMPDIFF()
        • TO_DATE()
        • TO_DAYS()
        • TO_SECONDS()
        • UNIX_TIMESTAMP
        • UTC_TIMESTAMP()
        • WEEK()
        • WEEKDAY()
        • YEAR()
        • Addtime
        • Curtime
        • Dayname
        • Get Format
        • Maketime
        • Monthname
        • Quarter
        • Subtime
        • Time Format
        • Timestampadd
        • Yearweek
      • Geo Functions
        • H3 Index Functions
        • MBRContains
        • MBRCoveredBy
        • MBRCovers
        • MBRDisjoint
        • MBREquals
        • MBRIntersects
        • MBROverlaps
        • MBRTouches
        • MBRWithin
        • S2 Cell Functions
        • ST_Area()
        • ST_AsGeoJSON
        • ST_AsText()
        • ST_AsWKB()
        • ST_Boundary()
        • ST_Buffer()
        • ST_Centroid()
        • ST_Collect()
        • ST_Contains()
        • ST_ConvexHull()
        • ST_CoveredBy()
        • ST_Covers()
        • ST_Crosses()
        • ST_Difference()
        • ST_Dimension()
        • ST_Disjoint()
        • ST_Distance()
        • ST_Distance_Sphere()
        • ST_EndPoint()
        • ST_Envelope()
        • ST_Equals()
        • ST_ExteriorRing()
        • ST_FrechetDistance()
        • ST_GeoHash
        • ST_GeomCollFromText()
        • ST_GeomCollFromWKB()
        • ST_GeometryN()
        • ST_GeometryType()
        • ST_GeomFromGeoJSON
        • ST_GeomFromText()
        • ST_GeomFromWKB()
        • ST_HausdorffDistance()
        • ST_InteriorRingN()
        • ST_Intersection()
        • ST_Intersects()
        • ST_IsClosed()
        • ST_IsCollection()
        • ST_IsEmpty()
        • ST_IsRing()
        • ST_IsSimple()
        • ST_IsValid()
        • ST_LatFromGeoHash
        • ST_Latitude()
        • ST_Length()
        • ST_LineFromText()
        • ST_LineFromWKB()
        • ST_LineInterpolatePoint()
        • ST_LineInterpolatePoints()
        • ST_LongFromGeoHash
        • ST_Longitude()
        • ST_MakeEnvelope()
        • ST_MLineFromText()
        • ST_MLineFromWKB()
        • ST_MPointFromText()
        • ST_MPointFromWKB()
        • ST_MPolyFromText()
        • ST_MPolyFromWKB()
        • ST_NumGeometries()
        • ST_NumInteriorRings()
        • ST_NumPoints()
        • ST_Overlaps()
        • ST_PointAtDistance()
        • ST_PointFromGeoHash
        • ST_PointFromText()
        • ST_PointFromWKB()
        • ST_PointN()
        • ST_PointOnSurface()
        • ST_PolyFromText()
        • ST_PolyFromWKB()
        • ST_Simplify()
        • ST_SRID()
        • ST_StartPoint()
        • ST_SwapXY()
        • ST_SymDifference()
        • ST_Touches()
        • ST_Union()
        • ST_Validate()
        • ST_Within()
        • ST_X()
        • ST_Y()
      • Mathematical
        • ACOS()
        • ATAN()
        • BIT_COUNT()
        • CEIL()
        • CEILING()
        • COS()
        • COT()
        • CRC32()
        • EXP()
        • FLOOR()
        • LN()
        • LOG()
        • LOG2()
        • LOG10()
        • PI()
        • POWER()
        • ROUND()
        • RAND()
        • SIN()
        • SINH()
        • TAN()
        • Atan2
        • Degrees
        • Radians
        • Sign
        • Truncate
      • String
        • BIT_LENGTH()
        • CHAR_LENGTH()
        • CONCAT()
        • CONCAT_WS()
        • EMPTY()
        • ENDSWITH()
        • FIELD()
        • FIND_IN_SET()
        • FORMAT()
        • FROM_BASE64()
        • HEX()
        • INSTR()
        • LCASE()
        • LEFT()
        • LENGTH()
        • LOCATE()
        • LOWER()
        • LPAD()
        • LTRIM()
        • MD5()
        • NAME_CONST()
        • OCT()
        • REPEAT()
        • REVERSE()
        • RPAD()
        • RTRIM()
        • SHA1()/SHA()
        • SHA2()
        • SPACE()
        • SPLIT_PART()
        • STARTSWITH()
        • STRCMP()
        • SUBSTRING()
        • SUBSTRING_INDEX()
        • TO_BASE64()
        • TRIM()
        • UCASE()
        • UNHEX()
        • UPPER()
        • Regular Expressions
          • NOT REGEXP
          • REGEXP_INSTR()
          • REGEXP_LIKE()
          • REGEXP_REPLACE()
          • REGEXP_SUBSTR()
        • Aes_Decrypt
        • Aes_Encrypt
        • Elt
        • Quote
        • Right
      • Vector
        • Mathematical Calculations
        • CLUSTER_CENTERS()
        • COSINE_SIMILARITY()
        • COSINE_DISTANCE()
        • INNER_PRODUCT()
        • L1_NORM()
        • L1_DISTANCE() (unavailable)
        • L2_NORM()
        • L2_DISTANCE()
        • L2_DISTANCE_SQ()
        • NORMALIZE_L2()
        • SUBVECTOR()
        • VECTOR_DIMS()
      • Table
        • UNNEST()
        • SQL_TVF()
        • ESQL_TVF()
      • Window Functions
        • RANK()
        • ROW_NUMBER()
        • Cume_Dist
        • Percent_Rank
      • JSON Functions
        • JSON_EXTRACT()
        • JSON_EXTRACT_FLOAT64()
        • JSON_EXTRACT_STRING()
        • JSON_QUOTE()
        • JSON_ROW()
        • JSON_SET()
        • JSON_UNQUOTE()
        • TRY_JQ()
        • Json Arrow
        • JSON_ARRAY()
          • JSON_CONTAINS()
          • JSON_CONTAINS_PATH()
          • JSON_KEYS()
          • JSON_LENGTH()
          • JSON_MERGE_PATCH()
          • JSON_MERGE_PRESERVE()
          • JSON_OBJECT()
          • JSON_OVERLAPS()
          • JSON_PRETTY()
          • JSON_REMOVE()
          • JSON_SCHEMA_VALID()
          • JSON_SCHEMA_VALIDATION_REPORT()
          • JSON_TYPE()
          • JSON_VALID()
          • JSON_VALUE()
        • JSON_KEYS()
        • JSON_LENGTH()
        • JSON_OBJECT()
        • JSON_PRETTY()
        • JSON_SCHEMA_VALID()
        • JSON_SCHEMA_VALIDATION_REPORT()
        • JSON_TYPE()
        • JSON_VALID()
        • JSON_VALUE()
      • Other Functions
        • SAVE_FILE()
        • SAMPLE()
        • SERIAL_EXTRACT()
        • SLEEP()
        • STAGE_LIST()
        • ONNX_RUN()
        • UUID()
        • FOREIGN CONNECTION FUNCTIONS
        • LAST_KAFKA_MESSAGE_ID()
      • System OPS Functions
        • CURRENT_ROLE()
        • CURRENT_USER_NAME()
        • CURRENT_USER()
        • PURGE_LOG()
        • GET_LOCK()
        • RELEASE_LOCK()
        • IS_FREE_LOCK()
        • IS_USED_LOCK()
        • RELEASE_ALL_LOCKS()
        • Version
    • System Paramaters
      • Standalone Common Parameters Configuration
      • Distributed Common Parameters Configuration
    • MatrixOne Catalog
    • Privilege Control Types
    • Limitations
      • Partitioning supported features list
    • MatrixOne Directory Structure
    • MatrixOne tools index
    • Task-based tool selection
      • mo_ctl Standalone Tools Guide
      • Standalone mo_ctl scheduled operations
      • mo_ctl Distributed Edition Tool Guide
      • mo-service profiling flags
      • mo-tool advanced diagnostics and offline inspection
      • mo_datax_writer Tool Guide
      • mo_ssb_open Tool Guide
      • mo_tpch_open Tool Guide
      • mo_ts_perf_test Tool Guide
    • Mysql Compatibility Matrix
    • Mysql Unsupported Features
  • Troubleshooting
    • Common statistic data query
    • Database statistics
    • Error Code
  • FAQs
    • Deployment FAQs
    • SQL FAQs
  • Release Notes
    • MatrixOne v26.4.2.8 Release Notes
    • MatrixOne v26.4.2.7 Release Notes
    • MatrixOne v26.4.2.6 Release Notes
    • MatrixOne v26.4.2.5 Release Notes
    • MatrixOne v26.4.2.4 Release Notes
    • MatrixOne v26.4.2.3 Release Notes
    • MatrixOne v26.4.2.2 Release Notes
    • MatrixOne v26.4.2.1 Release Notes
    • MatrixOne v26.4.2.0 Release Notes
    • MatrixOne v26.4.1.4 Release Notes
    • MatrixOne v26.4.1.3 Release Notes
    • MatrixOne v26.4.1.2 Release Notes
    • MatrixOne v26.4.1.1 Release Notes
    • MatrixOne v26.4.1.0 Release Notes
    • MatrixOne v26.4.0.0-rc4 Release Notes
    • MatrixOne v26.4.0.0-rc3 Release Notes
    • MatrixOne v26.4.0.0-rc2 Release Notes
    • MatrixOne v26.4.0.0-rc1 Release Notes
    • MatrixOne v26.3.0.10 Release Notes
    • MatrixOne v26.3.0.11 Release Notes
    • MatrixOne v26.3.0.12 Release Notes
    • MatrixOne v26.3.0.13 Release Notes
    • MatrixOne v26.3.0.14 Release Notes
    • MatrixOne v26.3.0.15 Release Notes
    • MatrixOne v26.3.0.5 Release Notes
    • MatrixOne v26.3.0.6 Release Notes
    • MatrixOne v26.3.0.7 Release Notes
    • MatrixOne v26.3.0.8 Release Notes
    • MatrixOne v26.3.0.9 Release Notes
    • MatrixOne v25.2.0.2 Release Notes
    • MatrixOne v25.2.0.3 Release Notes
    • MatrixOne v25.2.1.0 Release Note
    • MatrixOne v25.2.1.1 Release Notes
    • MatrixOne v25.2.2.0 Release Notes
    • MatrixOne v25.2.2.1 Release Notes
    • MatrixOne v25.2.2.2 Release Notes
    • MatrixOne v25.3.0.0 Release Note
    • MatrixOne v25.3.0.1 Release Notes
    • MatrixOne v25.3.0.2 Release Notes
    • MatrixOne v25.3.0.3 Release Notes
    • MatrixOne v25.3.0.4 Release Notes
    • Key Improvements
    • MatrixOne v24.1.1.1 Release Notes
    • MatrixOne v24.1.1.2 Release Notes
    • MatrixOne v24.1.1.3 Release Notes
    • MatrixOne v24.1.2.0 Release Notes
    • MatrixOne v24.1.2.1 Release Notes
    • MatrixOne v24.1.2.2 Release Notes
    • MatrixOne v24.1.2.3 Release Notes
    • MatrixOne v24.1.2.4 Release Notes
    • MatrixOne v24.2.0.0 Release Notes
    • MatrixOne v24.2.0.1 Release Notes
    • MatrixOne v23.0.7.0 Release Notes
    • MatrixOne v0.8.0 Release Notes
    • MatrixOne v23.1.0.0 Release Notes
    • MatrixOne v23.1.0.0-RC1 Release Notes
    • MatrixOne v23.1.0.0-RC2 Release Notes
    • MatrixOne v23.1.0.1 Release Notes
    • MatrixOne v23.1.0.2 Release Notes
    • MatrixOne v23.1.1.0 Release Notes
    • MatrixOne v22.0.2.0 Release Notes
    • MatrixOne v22.0.3.0 Release Notes
    • Docker
    • Features
    • Known issues
    • Contributors
    • MatrixOne v22.0.4.0 Release Notes
    • Docker
    • Features
    • Known issues
    • Contributors
    • MatrixOne v22.0.5.0 Release Notes
    • MatrixOne v22.0.5.1 Release Notes
    • MatrixOne v220.6.0 Release Notes
    • MatrixOne v21.0.1.0 Release Notes
  • Glossary
  • Contribute
    • How to Contribute
      • Preparation
        • Kernel developer reading and verification guide
      • Report an Issue
      • Contribute Code
      • Review a Pull Request
      • Contribute Documentation
      • Make a Design
    • Code Style
      • Code Comment Style
      • Commit & Pull Request Style
Back to top

RIGHT()¶

Returns the rightmost len characters from the string str. If len is negative, the result is an empty string. If len exceeds the string length, the full string is returned. Returns NULL if str is NULL.

Function Description¶

The RIGHT() function extracts a substring from the right side of a given string. It is multibyte-safe and works correctly with Unicode characters, including Chinese, Japanese, and other multi-byte encodings.

Syntax¶

> RIGHT(str, len)

Arguments¶

Arguments

Description

str

Required. The string to extract from.

len

Required. The number of characters to extract. If negative, returns an empty string. If larger than the string length, returns the entire string. If NULL, returns NULL.

Examples¶

DROP DATABASE IF EXISTS right_demo;
CREATE DATABASE right_demo;
USE right_demo;

SELECT RIGHT('Hello World', 5) AS result1;
SELECT RIGHT('Hello', 10) AS result2;
SELECT RIGHT('Hello', 0) AS result3;
SELECT RIGHT('abcde', -1) AS neg_result;
SELECT RIGHT('', 5) AS empty_str_result;
SELECT RIGHT(NULL, 5) AS null_str_result;

CREATE TABLE t1(str VARCHAR(50), len INT);
INSERT INTO t1 VALUES ('Hello World', 5), ('Hello', 10), ('Hello', 0), ('abcde', 3), ('test', 1);
SELECT str, len, RIGHT(str, len) AS right_result FROM t1;
DROP TABLE t1;

CREATE TABLE t2(str VARCHAR(50));
INSERT INTO t2 VALUES ('Hello World'), ('Hello'), ('test'), ('abcde');
SELECT * FROM t2 WHERE RIGHT(str, 5) = 'World';
SELECT * FROM t2 WHERE RIGHT(str, 1) = 'o';
DROP TABLE t2;

DROP DATABASE right_demo;
Next
Arithmetic operators
Previous
QUOTE()
Copyright © 2026, MatrixOrigin
Made with Sphinx and @pradyunsg's Furo
On this page
  • RIGHT()
    • Function Description
    • Syntax
    • Arguments
    • Examples