Toggle navigation sidebar
Toggle in-page Table of Contents
About
Introduction
Community and support
milestones
change_logs
Quickstart
OpenMLDB Quickstart
Concept
Workflow and Execution Modes
CLI
SDK
Java SDK
Python SDK
[Alpha] Go SDK
[Alpha] C++ SDK
REST API
Essential Reading for Getting Started
Functional Boundary
Tutorials
Cluster vs. Standalone Versions
The Workflow of Cluster Version and Execution Mode
SQL for Feature Extraction (Part 1)
SQL for Feature Extraction (Part 2)
Data Import
OpenMLDB Spark Distribution
AutoFE
Online-offline data synchronization
Use Cases
OpenMLDB + LightGBM: Taxi Trip Duration Prediction
Importing Real-Time Data Streams from Pulsar
Importing Real-Time Data Streams from Kafka
Building End-to-End MLOps Workflows (OpenMLDB + DolphinScheduler)
OpenMLDB + XGBoost: TalkingData Ad Tracking Fraud Detection
OpenMLDB + OneFlow: Prediction of Purchase Intention for High Potential Customers
Airflow OpenMLDB Provider
Build End-to-end Machine Learning Applications Based on SQL (OpenMLDB + Byzer)
Deployment
Install and Deploy
Configuration File
Compilation from Source Code
Hadoop Integration
[Alpha] Offline engine using Kubernetes backend (optional)
[Alpha] Online engine based on Kubernetes deployment
Maintenance
Upgrade
Update Configuration
Backup and Restore
Monitoring
Operations in CLI
Maintenance Command Status
Operation and Maintenance FAQ
Scale-Out and Scale-In
Diagnostic Tool
Operation Tool
Developers
Contributing
Code Structure
Built-In Function Development
SDK Development Guidelines
Python SDK/Tool Development Guideline
UDF Function Development Guideline
References
Architecture
Online Module Architecture
SQL
Language Structure
Keywords
SQL Object Name
Literal Value
Case Sensitive
Notes
Data Type
Numeric Type
String Type
Date and Time Type
Built-in Functions
Data Query Statement (DQL)
SELECT Overview
JOIN Clause
WHERE Clause
GROUP BY Clause
Having Clause
WINDOW Clause
Limit Clause
WITH CLAUSE
No-table SELECT
SELECT INTO
Data Manipulation Statement(DML)
INSERT
LOAD DATA INFILE
DELETE
ALTER
Data Definition Statement (DDL)
CREATE DATABASE
SHOW DATABASES
USE DATABASE
DROP DATABASE
DESC
CREATE TABLE
DROP TABLE
SHOW COMPONENTS
SHOW TABLES
SHOW VARIABLES
SHOW TABLE STATUS
SET STATEMENT
CREATE INDEX
DROP INDEX
CREATE FUNCTION
SHOW FUNCTIONS
DROP FUNCTION
SHOW CREATE TABLE
TRUNCATE TABLE
DEPLOYMENT Management
DEPLOY
Delete DEPLOYMENT
View DEPLOYMENTS List
View DEPLOYMENT Details
Online Specifications and Requirements for SQL
Task Management
SHOW JOBS
SHOW JOB
SHOW JOBLOG
STOP JOB
SUBMIT JOB
IP Configuration
Client Configuration
Spark Client Configuration
Current Version: main Versions:
main
v0.4
v0.5
v0.6
v0.7
v0.8
.rst
.pdf
OpenMLDB Docs (main)
OpenMLDB Docs (main)
#
About
Quickstart
Tutorials
Use Cases
Deployment
Maintenance
Developers
References