Related Documentation Download this Manual
PDF (US Ltr) - 0.6Mb
PDF (A4) - 0.6Mb


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: 2022-02-25 (revision: 72087)


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 Modifying Tables
6 Unloading Tables
7 Running Queries
8 Table Load and Query Example
9 Workload Optimization using Advisor
9.1 Auto Encoding
9.2 Auto Data Placement
9.3 Query Insights
9.4 Advisor Examples
9.5 Advisor Report Table
10 Best Practices
11 Troubleshooting
12 Reference
12.1 Column Limits
12.2 Supported Data Types
12.3 Supported Functions and Operators
12.3.1 Aggregate Functions
12.3.2 Arithmetic Operators
12.3.3 Cast Functions and Operators
12.3.4 Comparison Functions and Operators
12.3.5 Control Flow Functions and Operators
12.3.6 Date and Time Functions
12.3.7 Logical Operators
12.3.8 Mathematical Functions
12.3.9 String Functions and Operators
12.3.10 Window Functions
12.4 Supported SQL Modes
12.5 String Column Encoding Reference
12.5.1 Variable-length Encoding
12.5.2 Dictionary Encoding
12.6 Metadata Queries
12.7 Limitations
12.8 System Variables
12.9 Secondary Engine Variables
12.10 Status Variables
12.11 Performance Schema Tables
12.11.1 The rpd_exec_stats Table
12.11.2 The rpd_nodes Table
12.11.3 The rpd_table_id Table
12.11.4 The rpd_tables Table
12.11.5 The rpd_column_id Table
12.11.6 The rpd_columns Table
12.11.7 The rpd_query_stats Table
12.12 Generating tpch Sample Data