Toggle navigation sidebar
Toggle in-page Table of Contents
About
Introduction
Milestones
Release Notes
Quickstart
OpenMLDB Quickstart
Java SDK Quickstart
Python SDK Quickstart
Go SDK Quickstart
REST APIs
Data Import Quickstart
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
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
Build
Install and Deploy
Configuration File
Maintenance
Upgrade
Backup and Restore
Monitoring
Operations in CLI
Operation and Maintenance FAQ
Scale-Out and Scale-In
Diagnostic Tool
Operation Tool
Data Export 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
Expressions, Functions, and Operations
Operator
Built-in Functions
Data Query Statement （DQL）
SELECT Overview
JOIN Clause
WHERE Clause
GROUP BY Clause
Having Clause
WINDOW Clause
Limit Clause
No-table SELECT
SELECT INTO
Data Manipulation Statement（DML）
INSERT
LOAD DATA INFILE
DELETE
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
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: v0.6 Versions：
main
v0.4
v0.5
v0.6
v0.7
v0.8
v0.9
.rst
.pdf
Data Definition Statement (DDL)
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
