HeatWave User Guide

Abstract

This is the HeatWave User Guide. This document provides information and procedures about loading data into HeatWave and running queries. For information about creating and managing a HeatWave cluster, refer to the MySQL Database Service User Guide.

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: 2021-10-07 (revision: 71006)

---

Table of Contents

Preface and Legal Notices

1 Introduction

1.1 Architecture

1.2 MySQL Autopilot

2 Before You Begin

3 Preparing Data

3.1 Identifying Tables to Load

3.2 Excluding Table Columns

3.3 Encoding String Columns

3.4 Defining Data Placement Keys

3.5 Defining the Secondary Engine

4 Loading Data

4.1 Auto Parallel Load

4.2 Change Propagation

5 Unloading Tables

6 Running Queries

7 Table Load and Query Example

8 Workload Optimization using Advisor

8.1 Auto Encoding

8.2 Auto Data Placement

8.3 Query Insights

8.4 Advisor Examples

8.5 Advisor Report Table

9 Best Practices

10 Troubleshooting

11 Reference

11.1 Supported Data Types

11.2 Supported Functions and Operators

11.2.1 Aggregate Functions

11.2.2 Arithmetic Operators

11.2.3 Cast Functions and Operators

11.2.4 Comparison Functions and Operators

11.2.5 Control Flow Functions and Operators

11.2.6 Date and Time Functions

11.2.7 Logical Operators

11.2.8 Mathematical Functions

11.2.9 String Functions and Operators

11.2.10 Window Functions

11.3 Supported SQL Modes

11.4 String Column Encoding Reference

11.4.1 Variable-length Encoding

11.4.2 Dictionary Encoding

11.5 Metadata Queries

11.6 Limitations

11.7 System Variables

11.8 Secondary Engine Variables

11.9 Status Variables

11.10 Performance Schema Tables

11.10.1 The rpd_exec_stats Table

11.10.2 The rpd_nodes Table

11.10.3 The rpd_table_id Table

11.10.4 The rpd_tables Table

11.10.5 The rpd_column_id Table

11.10.6 The rpd_columns Table

11.10.7 The rpd_query_stats Table

11.11 Generating tpch Sample Data