Skip to Main Content
The world's most popular open source database
Contact MySQL
|
Login
|
Register
MySQL.com
Downloads
Documentation
Developer Zone
Developer Zone
Downloads
MySQL.com
Documentation
MySQL Server
MySQL Enterprise
Workbench
InnoDB Cluster
MySQL NDB Cluster
Connectors
More
MySQL.com
Downloads
Developer Zone
Section Menu:
Documentation Home
HeatWave User Guide
Preface and Legal Notices
Overview
HeatWave MySQL
HeatWave AutoML
HeatWave GenAI
HeatWave Lakehouse
Overview
External Tables
Lakehouse Engine
Data Storage
Loading Structured Data to HeatWave Lakehouse
System Requirements
Loading Data Using Lakehouse External Table
External Table Syntax
File Name, Pattern and Prefix Examples
Loading Data Manually
Manually Loading Data from External Storage
Loading Data Using Auto Parallel Load
Lakehouse Auto Parallel Load Schema Inference
Lakehouse Auto Parallel Load with the external_tables Option
How to Load Data from External Storage Using Auto Parallel Load
Load Configuration
Loading Lakehouse Data
Generated Load Script
Loading Unstructured Data to HeatWave Lakehouse
Updating Tables
Refreshing Data Using Incremental Load
Adding or Removing Files Using Selective Load
Access Object Storage
Pre-Authenticated Requests
Recommendations
Pre-Authenticated Request Examples
Resource Principals
Configuring a Tenancy for Resource Principal Data Loading
Uniform Resource Identifiers
External Table Recovery
Data Types
Parquet Data Type Conversions
Exporting Query Results to Object Storage
Overview of Exporting Query Results
Requirements to Export Query Results
Exporting Query Results to CSV Files
Exporting Query Results to CSV Files with SQL Syntax
Exporting Query Results to CSV Files with JSON Syntax
Exporting Query Results to Parquet Files
Exporting Query Results to Parquet Files with SQL Syntax
Exporting Query Results to Parquet Files with JSON Syntax
Exporting Query Results to ND-JSON Files
Exporting Query Results to ND-JSON Files with Non-JSON Syntax
Exporting Query Results to ND-JSON Files with JSON Syntax
Redacted PAR URLs in Exported Log Files
File Name Format for Exported Query Result Files
HeatWave Lakehouse Error Messages
HeatWave Lakehouse Limitations
Lakehouse Limitations for all File Formats
Lakehouse Limitations for the Avro Format Files
Lakehouse Limitations for the CSV File Format
Lakehouse Limitations for the JSON File Format
Lakehouse Limitations for the Parquet File Format
System and Status Variables
HeatWave Performance and Monitoring
HeatWave Quickstarts
Related Documentation
HeatWave Release Notes
Download this Manual
PDF (US Ltr)
- 2.4Mb
PDF (A4)
- 2.4Mb
HeatWave User Guide
/
...
/
HeatWave Lakehouse
/
Exporting Query Results to Object Storage
/
Exporting Query Results to CSV Files
5.8.3 Exporting Query Results to CSV Files
5.8.3.1 Exporting Query Results to CSV Files with SQL Syntax
5.8.3.2 Exporting Query Results to CSV Files with JSON Syntax
You can export the query results to a
RFC-4180
compatible
CSV
file.
PREV
HOME
UP
NEXT
Related Documentation
HeatWave Release Notes
Download this Manual
PDF (US Ltr)
- 2.4Mb
PDF (A4)
- 2.4Mb