Skip to content

MatrixOne Docs

Cast Functions and Operators Overview

matrixorigin/matrixone

MatrixOne Docs

matrixorigin/matrixone

MatrixOne
MatrixOne
- Home
- Overview
  Overview
- Getting Started
  Getting Started
  - Deploy standalone MatrixOne
    Deploy standalone MatrixOne
    
    Overview
    
    Deploy on macOS
    Deploy on macOS
    
    Building from source code
    
    Using binary package
    
    Using Docker
    
    Deploy on Linux
    Deploy on Linux
    
    Building from source code
    
    Using binary package
    
    Using Docker
  - Basic SQL
- Developing Guide
  Developing Guide
  - Schema Design
    Schema Design
    
    Overview
    
    Create Database
    
    Create Table
    
    Data Integrity
    Data Integrity
    
    Data Integrity Constraints Overview
    
    NOT NULL Constraints
    
    UNIQUE KEY Constraints
    
    PRIMARY KEY Constraints
    
    FOREIGN KEY Constraints
  - Connect to MatrixOne
    Connect to MatrixOne
    
    MatrixOne SSL connection
    
    Connecting to MatrixOne with Database Client Tool
    
    Java connect to MatrixOne
    Java connect to MatrixOne
    
    Connect MatrixOne with JDBC
    
    Connect MatrixOne with Java ORMs
    
    Python connect to MatrixOne
  - Import Data
    Import Data
    
    Insert
    
    Bulk Load
    Bulk Load
    
    Bulk Load Overview
    
    Import .csv format data
    
    Import jsonlines format data
    
    Import data from S3
  - Export Data
    Export Data
    
    Export data by SELECT INTO...OUTFILE
    
    Export data by modump
  - Read Data
    Read Data
    
    Query Data from a Single Table
    
    Multi-table Join Queries
    
    Subquery
    
    Views
    
    Common Table Expression
  - Transactions
    Transactions
    
    General Transaction Overview
    
    Transaction by MatrixOne Server
    Transaction by MatrixOne Server
    
    Transaction Overview
    
    Explicit Transaction
    
    Implicit Transaction
    
    Optimistic Transaction
    
    How to use transaction
    
    Isolation Level
    
    MVCC
    
    Transaction Scenario
- Deploying
  Deploying
  - MatrixOne distributed cluster deployment
- Tutorials
  Tutorials
- Maintenance
  Maintenance
  - Backup and Restore
  - Mount Data
    Mount Data
    
    Mount directory to Docker container
- Migrating
  Migrating
  - From MySQL to MatrixOne
- Testing
  Testing
  - Performance Testing
    Performance Testing
    
    SSB Test with MatrixOne
    
    TPCH Test with MatrixOne
    
    TPCC Test with MatrixOne
  - Testing Tool
    Testing Tool
    
    MO-Tester
    
    MO-Tester Specification
- Performance Tuning
  Performance Tuning
  - SQL Performance Tuning Methods Overview
  - Understanding the Query Execution Plan
    Understanding the Query Execution Plan
    
    Query Execution Plan Overview
    
    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
    Performance tuning best practices
    
    Using Cluster by for performance tuning
- Privilege
  Privilege
  - TLS Introduction
  - What is MatrixOne Privilege Management
    What is MatrixOne Privilege Management
    
    About MatrixOne Privilege Management
    
    Best Practices
  - User Guide
    User Guide
    
    Quick Start
    Quick Start
    
    Create accounts, Verify Resource Isolation
    
    Use the new account to creates users, roles, grant the privilege
    
    Privileges Management User guide
  - Application Scenario
- Reference
  Reference
  - Language Structure
    Language Structure
    
    Keywords
  - SQL Reference
    SQL Reference
    
    Data Definition Language
    Data Definition Language
    
    CREATE DATABASE
    
    CREATE INDEX
    
    CREATE TABLE
    
    CREATE EXTERNAL TABLE
    
    CREATE VIEW
    
    ALTER VIEW
    
    DROP DATABASE
    
    DROP INDEX
    
    DROP TABLE
    
    DROP VIEW
    
    TRUNCATE TABLE
    
    Data Manipulation Language
    Data Manipulation Language
    
    INSERT
    
    INSERT INTO SELECT
    
    DELETE
    
    UPDATE
    
    LOAD DATA
    
    INTERVAL
    
    Information Functions
    Information Functions
    
    LAST_QUERY_ID()
    
    LAST_INSERT_ID()
    
    OPERATORS
    OPERATORS
    
    OPERATORS Overview
    
    OPERATORS Precedence
    
    Arithmetic Operators
    Arithmetic Operators
    
    Arithmetic Operators Overview
    
    %,MOD
    
    *
    
    +
    
    -
    
    -
    
    /
    
    DIV
    
    Assignment Operators
    Assignment Operators
    
    Assignment Operators Overview
    
    =
    
    Bit Functions and Operators
    Bit Functions and Operators
    
    Bit Functions and Operators Overview
    
    &
    
    >>
    
    <<
    
    ^
    
    |
    
    ~
    
    Cast Functions and Operators
    Cast Functions and Operators
    
    Cast Functions and Operators Overview
    
    CAST
    
    CONVERT
    
    Comparison Functions and Operators
    Comparison Functions and Operators
    
    Comparison Functions and Operators Overview
    
    >
    
    >=
    
    <
    
    <>,!=
    
    <=
    
    =
    
    BETWEEN ... AND ...
    
    IN
    
    IS
    
    IS NOT
    
    IS NOT NULL
    
    IS NULL
    
    LIKE
    
    NOT BETWEEN ... AND ...
    
    NOT LIKE
    
    COALESCE
    
    Flow Control Functions
    Flow Control Functions
    
    Flow Control Functions Overview
    
    CASE WHEN
    
    IF
    
    Logical Operators
    Logical Operators
    
    Logical Operators Overview
    
    AND,&&
    
    NOT,!
    
    OR
    
    XOR
    
    Data Query Language
    Data Query Language
    
    SELECT
    
    SUBQUERY
    SUBQUERY
    
    SUBQUERY Overview
    
    Derived Tables
    
    Comparisons Using Subqueries
    
    SUBQUERY with ANY or SOME
    
    SUBQUERY with ALL
    
    SUBQUERY with EXISTS
    
    SUBQUERY with IN
    
    JOIN
    JOIN
    
    JOIN Overview
    
    INNER JOIN
    
    LEFT JOIN
    
    RIGHT JOIN
    
    FULL JOIN
    
    OUTER JOIN
    
    NATURAL JOIN
    
    With CTE
    
    Combining Queries
    Combining Queries
    
    Combining Queries Overview
    
    UNION
    
    INTERSECT
    
    MINUS
    
    Data Control Language
    Data Control Language
    
    CREATE ACCOUNT
    
    ALTER ACCOUNT
    
    CREATE ROLE
    
    CREATE USER
    
    DROP ACCOUNT
    
    DROP USER
    
    DROP ROLE
    
    GRANT
    
    REVOKE
    
    Other
    Other
    
    SHOW
    SHOW
    
    SHOW ACCOUNTS
    
    SHOW DATABASES
    
    SHOW CREATE TABLE
    
    SHOW CREATE VIEW
    
    SHOW TABLES
    
    SHOW INDEX
    
    SHOW COLLATION
    
    SHOW COLUMNS
    
    SHOW GRANT
    
    SHOW VARIABLES
    
    SET
    SET
    
    SET ROLE
    
    USE
    USE
    
    USE DATABASE
    
    Prepared Statements
    Prepared Statements
    
    Prepared Statements Overview
    
    PREPARE
    
    EXECUTE
    
    DEALLOCATE
    
    Explain
    Explain
    
    EXPLAIN
    
    EXPLAIN Output Format
    
    Explain Analyze
    
    Aggregate Functions
    Aggregate Functions
    
    ANY_VALUE
    
    AVG
    
    BIT_AND
    
    BIT_OR
    
    BIT_XOR
    
    COUNT
    
    GROUP_CONCAT
    
    MAX
    
    MEDIAN
    
    MIN
    
    SLEEP
    
    STDDEV_POP
    
    SUM
    
    System variable
    System variable
    
    Custom variable
  - Data Types
    Data Types
    
    Data Types Overview
    
    Data Type Conversion
    
    Timestamp Initialization
    
    JSON Data Type
    
    BLOB and TEXT Type
    
    Fixed-Point Types (Exact Value) - DECIMAL
  - Builtin Functions
    Builtin Functions
    
    Mathematical
    Mathematical
    
    ABS()
    
    ACOS()
    
    ATAN()
    
    CEIL()
    
    COS()
    
    COT()
    
    EXP()
    
    FLOOR()
    
    LN()
    
    LOG()
    
    PI()
    
    POWER()
    
    ROUND()
    
    SIN()
    
    SINH()
    
    TAN()
    
    UUID()
    
    Datetime
    Datetime
    
    CURDATE()
    
    CURRENT_TIMESTAMP()
    
    DATE()
    
    DATE_ADD()
    
    DATE_FORMAT()
    
    DATE_SUB()
    
    DATEDIFF()
    
    DAY()
    
    DAYOFYEAR()
    
    EXTRACT()
    
    FROM_UNIXTIME
    
    MONTH()
    
    TIMEDIFF()
    
    TIMESTAMP()
    
    TO_DATE()
    
    UNIX_TIMESTAMP
    
    UTC_TIMESTAMP()
    
    WEEKDAY()
    
    YEAR()
    
    String
    String
    
    BIN()
    
    BIT_LENGTH()
    
    CHAR_LENGTH()
    
    CONCAT()
    
    CONCAT_WS()
    
    EMPTY()
    
    ENDSWITH()
    
    FIELD()
    
    FIND_IN_SET()
    
    FORMAT()
    
    HEX()
    
    LEFT()
    
    LENGTH()
    
    LPAD()
    
    LTRIM()
    
    OCT()
    
    REVERSE()
    
    RPAD()
    
    RTRIM()
    
    SPACE()
    
    STARTSWITH()
    
    SUBSTRING()
    
    SUBSTRING_INDEX()
    
    TRIM()
  - System Paramaters
    System Paramaters
    
    Boot Parameters for standalone installation
    
    Time Zone Support
  - MatrixOne Catalog
  - Privilege Control Types
  - Limitations
    Limitations
    
    JDBC supported features list
    
    Partitioning supported features list
  - MatrixOne Directory Structure
- Troubleshooting
  Troubleshooting
- FAQs
  FAQs
- Release Notes
  Release Notes
  - Release Timeline
  - v0.7.0
  - v0.6.0
  - v0.5.1
  - v0.5.0
  - v0.4.0
  - v0.3.0
  - v0.2.0
  - v0.1.0
- Glossary
- Contribution Guide
  Contribution Guide
  - Make Your First Contribution
  - How to Contribute
    How to Contribute
    
    Types of Contributions
    
    Preparation
    
    Report an Issue
    
    Contribute Code
    
    Review a Pull Request
    
    Contribute Documentation
    
    Make a Design
  - Code Style
    Code Style
    
    Code of Conduct
    
    Code Comment Style
    
    Commit & Pull Request Style

Cast Functions and Operators

Name	Description
CAST()	Cast a value as a certain type
CONVERT()	Cast a value as a certain type