Skip to Main Content

The world's most popular open source database

Developer Zone Downloads MySQL.com

Documentation

Section Menu:

HeatWave User Guide / HeatWave Lakehouse

Chapter 5 HeatWave Lakehouse

Table of Contents

5.1 Overview

5.1.1 External Tables
5.1.2 Lakehouse Engine
5.1.3 Data Storage

5.2 Loading Structured Data to HeatWave Lakehouse

5.2.1 System Requirements
5.2.2 Loading Data Using Lakehouse External Table
5.2.3 Loading Data Manually
5.2.4 Loading Data Using Auto Parallel Load
5.2.5 How to Load Data from External Storage Using Auto Parallel Load

5.3 Loading Unstructured Data to HeatWave Lakehouse

5.4 Updating Tables

5.4.1 Refreshing Data Using Incremental Load
5.4.2 Adding or Removing Files Using Selective Load

5.5 Access Object Storage

5.5.1 Pre-Authenticated Requests
5.5.2 Resource Principals
5.5.3 Uniform Resource Identifiers

5.6 External Table Recovery

5.7 Data Types

5.7.1 Parquet Data Type Conversions

5.8 Exporting Query Results to Object Storage

5.8.1 Overview of Exporting Query Results
5.8.2 Requirements to Export Query Results
5.8.3 Exporting Query Results to CSV Files
5.8.4 Exporting Query Results to Parquet Files
5.8.5 Exporting Query Results to ND-JSON Files
5.8.6 Redacted PAR URLs in Exported Log Files
5.8.7 File Name Format for Exported Query Result Files

5.9 HeatWave Lakehouse Error Messages

5.10 HeatWave Lakehouse Limitations

5.10.1 Lakehouse Limitations for all File Formats
5.10.2 Lakehouse Limitations for the Avro Format Files
5.10.3 Lakehouse Limitations for the CSV File Format
5.10.4 Lakehouse Limitations for the JSON File Format
5.10.5 Lakehouse Limitations for the Parquet File Format

This chapter describes HeatWave Lakehouse.

PREV HOME UP NEXT