logo
  • 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: main
Versions：
  • main
  • v0.4
  • v0.5
  • v0.6
  • v0.7
  • v0.8
  • v0.9

Theme by the Executable Book Project
  • .rst

OpenMLDB Blogs

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

previous

Server FAQ

next

Integrating Apache Hive — Offline Data for OpenMLDB

By OpenMLDB
© Copyright 2022, OpenMLDB.
Last updated on Nov 7, 2024, 2:26:03 PM.