Abstract
This document describes how to use HeatWave. It covers how to load data, run queries, optimize analytics workloads, and use HeatWave machine learning capabilities.
For information about creating and managing a HeatWave Cluster on Oracle Cloud Infrastructure (OCI), see HeatWave on OCI Service Guide.
For information about creating and managing a HeatWave Cluster on Amazon Web Services (AWS), see HeatWave on AWS Service Guide.
For information about creating and managing a HeatWave Cluster on Oracle Database Service for Azure (ODSA), see HeatWave for Azure Service Guide.
For MySQL Server documentation, refer to the MySQL Reference Manual.
For information about the latest HeatWave features and updates, refer to the HeatWave Release Notes.
For legal information, see the Legal Notices.
For help with using MySQL, please visit the MySQL Forums, where you can discuss your issues with other MySQL users.
Document generated on: 2024-12-09 (revision: 80426)
Table of Contents
- Preface and Legal Notices
- 1 Overview
- 2 HeatWave MySQL
- 2.1 Before You Begin
- 2.2 Loading Data to HeatWave MySQL
- 2.3 Running Queries
- 2.4 Modifying Tables
- 2.5 Unloading Data from HeatWave MySQL
- 2.6 Table Load and Query Example
- 2.7 Workload Optimization for OLAP
- 2.8 Workload Optimization for OLTP
- 2.9 Best Practices
- 2.10 Supported Data Types
- 2.11 Supported SQL Modes
- 2.12 Supported Functions and Operators
- 2.12.1 Aggregate Functions
- 2.12.2 Arithmetic Operators
- 2.12.3 Cast Functions and Operators
- 2.12.4 Comparison Functions and Operators
- 2.12.5 Control Flow Functions and Operators
- 2.12.6 Data Masking and De-Identification Functions
- 2.12.7 Encryption and Compression Functions
- 2.12.8 JSON Functions
- 2.12.9 Logical Operators
- 2.12.10 Mathematical Functions
- 2.12.11 String Functions and Operators
- 2.12.12 Temporal Functions
- 2.12.13 Vector Functions
- 2.12.14 Window Functions
- 2.13 SELECT Statement
- 2.14 String Column Encoding Reference
- 2.15 Troubleshooting
- 2.16 Metadata Queries
- 2.17 Bulk Ingest Data to MySQL Server
- 2.18 HeatWave MySQL Limitations
- 2.18.1 Change Propagation Limitations
- 2.18.2 Data Type Limitations
- 2.18.3 Functions and Operator Limitations
- 2.18.4 Index Hint and Optimizer Hint Limitations
- 2.18.5 Join Limitations
- 2.18.6 Partition Selection Limitations
- 2.18.7 Variable Limitations
- 2.18.8 Bulk Ingest Data to MySQL Server Limitations
- 2.18.9 Other Limitations
- 3 HeatWave AutoML
- 3.1 HeatWave AutoML Features
- 3.2 HeatWave AutoML Prerequisites
- 3.3 Getting Started
- 3.4 Preparing Data
- 3.5 Training a Model
- 3.6 Training Explainers
- 3.7 Predictions
- 3.8 Explanations
- 3.9 Forecasting
- 3.10 Anomaly Detection
- 3.11 Recommendations
- 3.11.1 Recommendation Model Types
- 3.11.2 Training a Recommendation Model
- 3.11.3 Using a Recommendation Model
- 3.11.4 Generating Recommendations for Ratings and Rankings
- 3.11.5 Generating Item Recommendations for Users
- 3.11.6 Generating User Recommendations for Items
- 3.11.7 Generating Recommendations for Similar Items
- 3.11.8 Generating Recommendations for Similar Users
- 3.12 HeatWave AutoML and Lakehouse
- 3.13 Topic Modeling
- 3.14 Managing Models
- 3.15 Progress tracking
- 3.16 HeatWave AutoML Routines
- 3.16.1 ML_TRAIN
- 3.16.2 ML_EXPLAIN
- 3.16.3 ML_MODEL_EXPORT
- 3.16.4 ML_MODEL_IMPORT
- 3.16.5 ML_PREDICT_ROW
- 3.16.6 ML_PREDICT_TABLE
- 3.16.7 ML_EXPLAIN_ROW
- 3.16.8 ML_EXPLAIN_TABLE
- 3.16.9 ML_SCORE
- 3.16.10 ML_MODEL_LOAD
- 3.16.11 ML_MODEL_UNLOAD
- 3.16.12 ML_MODEL_ACTIVE
- 3.16.13 Model Types
- 3.16.14 Optimization and Scoring Metrics
- 3.17 Supported Data Types
- 3.18 HeatWave AutoML Error Messages
- 3.19 HeatWave AutoML Limitations
- 4 HeatWave GenAI
- 5 HeatWave Lakehouse
- 5.1 Overview
- 5.2 Loading Structured Data to HeatWave Lakehouse
- 5.3 Loading Unstructured Data to HeatWave Lakehouse
- 5.4 Access Object Storage
- 5.5 External Table Recovery
- 5.6 Data Types
- 5.7 Exporting Query Results to Object Storage
- 5.8 HeatWave Lakehouse Error Messages
- 5.9 HeatWave Lakehouse Limitations
- 6 System and Status Variables
- 7 HeatWave Performance and Monitoring
- 8 HeatWave Quickstarts