Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-change-propagation.html
After tables are loaded into MySQL HeatWave, data changes are automatically propagated from DB System tables to their counterpart tables in the MySQL HeatWave Cluster. DML operations, INSERT, UPDATE, and DELETE, on the DB System do not wait for ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-dictionary-encoding.html
Dictionary encoding (SORTED) has the following characteristics: Best suited to string columns with a low number of distinct values relative to the cardinality of the table. Dictionary encoding reduces the space required for column values on the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-auto-parallel-load-overview.html
If you use an ambiguous format to specify temporal data types (for example, date_format as %m:%d:%y and time_format as %h:%i:%s), and the data matches both formats, the following order of precedence is used for inferring the data type: DATE > TIME > ... Lakehouse Auto Parallel Load, which extends the Auto Parallel Load feature of MySQL HeatWave, facilitates the process of loading data from Object Storage into MySQL HeatWave by automating many of the steps involved, including: Excluding schemas, tables, and columns that Auto Parallel Load cannot ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-result-outputfile.html
Exported query results are in CSV, Parquet, or JSON (As of MySQL 9.3.1) format. The number of output files and size of individual files depends on the amount of data generated by the query. The names for the output files are auto-generated and ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-result-par-redact.html
The pre-authenticated request (PAR) URL is hidden in the log file for security reasons. The following example exports the query results as a CSV file to the object storge location represented as a PAR URL. It also displays the latest query results ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-incremental-load.html
Available as of MySQL 9.0.0, Lakehouse Incremental Load allows you to refresh the data in an external table. This topic contains the following sections: Before You Begin Refresh Data Overview Perform Initial Load Refresh Data What's Next Before You ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-limitations-parquet.html
MySQL HeatWave Lakehouse has the following limitations for Parquet files. Consider the following limitations: To load Parquet files with the VECTOR data type (from Parquet strings or from Parquet (numeric) Lists), you must load the table manually ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-load-event-based.html
Keep in mind the following when setting up event-based incremental load: There is no guarantee that updates to external tables will be applied in the same order as updates to the files in Object Storage. As of MySQL 9.4.1, you can load data from ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-table-syntax-sql.html
mysql> CREATE EXTERNAL TABLE table_1( col_1 int, col_2 int, col_3 int) FILE_FORMAT = (FORMAT csv HEADER ON IGNORE 1 LINES) FILES = (URI = 'oci://mybucket@mynamespace/data_files/data_file_1.csv'); Additional Syntax Examples The following examples ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-bulk-load.html
It fails if the input data requires rounding or truncation in order to be loaded. MySQL HeatWave on OCI does not support LOAD DATA with ALGORITHM=BULK. MySQL HeatWave on AWS does support LOAD DATA with ALGORITHM=BULK, but does not support the ...