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-04-21 (revision: 69447)

---

Table of Contents

Preface and Legal Notices

1 Introduction

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

5 Unloading Tables

6 Running Queries

7 Table Load and Query Example

8 Best Practices

9 Troubleshooting

10 Reference

10.1 Supported Data Types

10.2 Supported Functions and Operators

10.2.1 Aggregate Functions

10.2.2 Arithmetic Operators

10.2.3 Cast Functions and Operators

10.2.4 Comparison Functions and Operators

10.2.5 Control Flow Functions and Operators

10.2.6 Date and Time Functions

10.2.7 Logical Operators

10.2.8 Mathematical Functions

10.2.9 String Functions and Operators

10.3 Supported SQL Modes

10.4 String Column Encoding Reference

10.4.1 Variable-length Encoding

10.4.2 Dictionary Encoding

10.5 Metadata Queries

10.6 Limitations

10.7 System Variables

10.8 Secondary Engine Variables

10.9 Status Variables

10.10 Performance Schema Tables

10.10.1 The rpd_exec_stats Table

10.10.2 The rpd_nodes Table

10.10.3 The rpd_table_id Table

10.10.4 The rpd_tables Table

10.10.5 The rpd_column_id Table

10.10.6 The rpd_columns Table

10.10.7 The rpd_query_stats Table

10.11 Generating tpch Sample Data