MySQL HeatWave User Guide

Abstract

This document describes how to use MySQL HeatWave. It covers how to load data, run queries, optimize analytics workloads, and use HeatWave Machine Learning capabilities.

For information about creating and managing HeatWave Clusters, refer to the MySQL Database Service Guide.

For MySQL Server documentation, refer to the MySQL Reference Manual.

For information about the latest MySQL 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: 2022-05-16 (revision: 73217)

Table of Contents

Preface and Legal Notices

1 Overview

2 HeatWave

2.1 Before You Begin

2.2 Loading Data

2.2.1 Prerequisites
2.2.2 Loading Data Manually
2.2.3 Loading Data Using Auto Parallel Load
2.2.4 Monitoring Load Progress
2.2.5 Checking Load Status
2.2.6 Change Propagation

2.3 Running Queries

2.4 Modifying Tables

2.5 Unloading Tables

2.6 Table Load and Query Example

2.7 Workload Optimization

2.7.1 Encoding String Columns
2.7.2 Defining Data Placement Keys
2.7.3 Workload Optimization using Advisor

2.8 Data Compression

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 Date and Time Functions
2.12.7 Logical Operators
2.12.8 Mathematical Functions
2.12.9 String Functions and Operators
2.12.10 Window Functions

2.13 String Column Encoding Reference

2.13.1 Variable-length Encoding
2.13.2 Dictionary Encoding
2.13.3 Column Limits

2.14 Troubleshooting

2.15 Metadata Queries

2.16 Limitations

3 HeatWave ML

3.1 Before You Begin

3.2 Getting Started

3.3 Preparing Data

3.4 Training a Model

3.5 Predictions

3.6 Explanations

3.7 Managing Models

3.7.1 The Model Catalog
3.7.2 Loading Models
3.7.3 Unloading Models
3.7.4 Viewing Models
3.7.5 Scoring Models
3.7.6 Model Explanations
3.7.7 Model Handles
3.7.8 Deleting Models
3.7.9 Sharing Models

3.8 HeatWave ML Routines

3.8.1 ML_TRAIN
3.8.2 ML_PREDICT_ROW
3.8.3 ML_PREDICT_TABLE
3.8.4 ML_EXPLAIN_ROW
3.8.5 ML_EXPLAIN_TABLE
3.8.6 ML_SCORE
3.8.7 ML_MODEL_LOAD
3.8.8 ML_MODEL_UNLOAD

3.9 Supported Data Types

3.10 Monitoring

3.11 HeatWave ML Error Messages

3.12 Limitations

4 System and Status Variables

4.1 System Variables
4.2 Status Variables

5 HeatWave Performance Schema Tables

5.1 The rpd_column_id Table
5.2 The rpd_columns Table
5.3 The rpd_exec_stats Table
5.4 The rpd_nodes Table
5.5 The rpd_preload_stats Table
5.6 The rpd_query_stats Table
5.7 The rpd_table_id Table
5.8 The rpd_tables Table

6 HeatWave Quickstarts

6.1 tpch Analytics Quickstart
6.2 AirportDB Analytics Quickstart
6.3 Iris Data Set Machine Learning Quickstart

HOME NEXT