Building from source code - MatrixOne Docs

Skip to content

MatrixOne Docs

Building from source code

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 Building from source code
    Table of contents
    
    Step 1: Install Go as necessary dependency
    
    Step 2: Install GCC as necessary dependency
    
    Step 3: Get MatrixOne code
    
    Step 4: Launch MatrixOne server
    
    Step 5: Connect to standalone MatrixOne
    
    Install and configure MySQL Client
    
    Connect to MatrixOne
    
    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 ...