Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results-json-non-json.html
This topic contains the following sections: Before You Begin Syntax Parameter Descriptions Examples What's Next Before You Begin Review the following: Overview of Exporting Query Results Requirements to Export Query Results Syntax Use the following ... The option to export query results as an ND-JSON file is available as of MySQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results-parquet-json.html
SELECT sum(l_quantity) from lineitem limit 1000 INTO OUTFILE WITH PARAMETERS '{"file":[{ "uri":"oci://bucket_1@tenancy1/data_files_1/"}], "dialect": {"format": "parquet" } }'; Example for PAR The following example uses a specified PAR URL to export ... This topic shows the different ways to export query results to Parquet ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-table-syntax-json.html
is_strict_mode: Loads data in strict mode or non-strict mode, based on the selected option. Lakehouse validates primary key and unique key constraints during the initial load based on the selected option. mysql> CREATE EXTERNAL TABLE table_1( col_1 ... External tables use table-level and column-level ENGINE_ATTRIBUTE options of the CREATE TABLE statement to specify the parameters needed to process data stored externally in Object ...
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) FILES = (URI = 'oci://mybucket@mynamespace/data_files/data_file_1.csv') AUTO_REFRESH_SOURCE = 'ocid1.stream.oc1.iad...'; STRICT_LOAD: Loads data in ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-query-prerequisites.html
Ensure that the following requirements are met before offloading queries to MySQL HeatWave: Use a SELECT statement. SELECT statements are supported, but only the SELECT portion is offloaded to MySQL HeatWave. Define all tables accessed by the query ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-predict-table.html
If NULL is selected, only the log segments tagged with is_anomaly are used to generate summaries. ML_PREDICT_TABLE generates predictions for an entire table of unlabeled data and saves the results to an output table. ML_PREDICT_TABLE Overview ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-24.html
For example, the following query, where L_LINESTATUS is a VARLEN-encoded string column, can now be offloaded to MySQL HeatWave: SELECT COUNT(*) FROM lineitem WHERE L_LINESTATUS >= 1 and L_LINESTATUS <= 10; (Bug #31721399) MySQL HeatWave now supports ... Functionality Added or Changed Comparison of different temporal type values is now ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-creating-endpoint.html
VPC: VPC: Select the VPC in which to create the endpoint. Only subnets that are in the same Availability Zone as the DB System will be available for selection. Subnet(s): Select the subnet(s) in which you wish to create the endpoint. The AWS console ... Creating an Endpoint for a Query PrivateLink 6.1.3 Creating an Endpoint for a Query PrivateLink Use the AWS Management Console to create an endpoint in the same region and availability zone as the DB ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-dbsystem-edit.html
Do the following to edit a DB System: In the MySQL HeatWave Console, select the Resources tab. Select Automatic for MySQL HeatWave on AWS to choose the Start day and Start time. Select Manual to specify the maintenance window Start day and Start ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-heatwave-creating.html
To create a MySQL HeatWave Cluster, do the following: In the MySQL HeatWave Console, select the Resources tab, and then the MySQL HeatWave Clusters tab. DB System Name: Select a DB System from the drop down menu. MySQL HeatWave Cluster ... Creating ...