Toggle navigation sidebar
Toggle in-page Table of Contents
About
Introduction
Community and support
milestones
change_logs
Introduction Slides
Quickstart
OpenMLDB Quickstart
Concept
Workflow and Execution Modes
CLI
SDK
Java SDK
Python SDK
[Alpha] Go SDK
[Alpha] C++ SDK
REST API
Getting Started Guide
Functional Boundary
Tutorials
Quick Data Import
SQL for Feature Extraction (Part 1)
SQL for Feature Extraction (Part 2)
OpenMLDB Spark Distribution
Data Import
Use of Online Data Export Tools
AutoFE
Cluster vs. Standalone Versions
Standalone Usage Process
Common Architecture Integration Methods of OpenMLDB in Real-Time Decision Systems
Online-offline data synchronization
Use Cases
Taxi Trip Duration Prediction (OpenMLDB+LightGBM)
OpenMLDB + OneFlow: Prediction of Purchase Intention for High Potential Customers
OpenMLDB + XGBoost: TalkingData Ad Tracking Fraud Detection
Deployment
Install and Deploy
Configuration File
Authentication
Compilation from Source Code
[Alpha] Offline engine using Kubernetes backend (optional)
[Alpha] Kubernetes Deployment for OpenMLDB Online Engine
OpenMLDB SQL
Main Differences from Standard SQL
Language Structure
Keywords
SQL Object Name
Literal Value
Case Sensitive
Notes
Data Type
Numeric Type
String Type
Composite data type
Date and Time Type
Expressions, Functions, and Operations
Operator
Data Query Statement （DQL）
SELECT Overview
JOIN Clause
SET Operation
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
CALL
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
UDF Development Guideline
Considerations for Executing SQL Commands
Upstream and Downstream Ecology
Online Data Source
Kafka
Pulsar
RocketMQ
Offline Data Source
Hive
Amazon S3
Iceberg
TiDB
Dispatch
Airflow
DolphinScheduler
Byzer
Develop
Jupyter Notebook
Maintenance
Cluster Start Stop
Update Configuration
High Availability and Recovery
Scale-Out and Scale-In
Monitoring
Performance Tuning Guide
Version Upgrade
Operations CLI
Maintenance Command Status
[Alpha] Cross-Data Center Disaster Recovery
Diagnostic Tool
Operation Tool
References
Architecture
Online Module Architecture
Real-Time Engine Core Data Structure and Optimization Analysis
IP Configuration
Client Configuration
Spark Client Configuration
Error Codes
Developers
Contributing
Code Structure
Built-In Function Development
SDK Development Guidelines
Python SDK/Tool Development Guideline
FAQ
Client FAQ
Server FAQ
OpenMLDB Blogs
Integrating Apache Hive - Offline Data for OpenMLDB
Mastering Distributed Database Development in 10 Minutes with OpenMLDB Developer Docker Image
Ultra High-Performance Database OpenM(ysq)LDB: Seamless Compatibility with MySQL Protocol and Multi-Language MySQL Client
Comparative Analysis of Memory Consumption: OpenMLDB vs Redis Test Report
OpenMLDB v0.9.0 Release: Major Upgrade in SQL Capabilities Covering the Entire Feature Servicing Process
Introducing OpenMLDB’s New Feature: Feature Signatures — Enabling Complete Feature Engineering with SQL
📚 Application Ecosystem
FeatInsight
Introduction
Quickstart
Installation and Deployment
Docker
Installation Package
Build from Source
FeatInsight Configuration File
Version Upgrade
Application Scenarios
Taxi Trip Duration Prediction
E-commerce Recommendation System
Frequently Asked Questions
OpenMLDB SQL Emulator
Quickstart
OpenM(ysq)LDB
Introduction
Quick Start
Installation and Deployment
Current Version: v0.9 Versions：
main
v0.4
v0.5
v0.6
v0.7
v0.8
v0.9
.rst
.pdf
Expressions, Functions, and Operations
Expressions, Functions, and Operations
#
Operator
