Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results-csv-json.html
INTO OUTFILE WITH PARAMETERS 'file_URI_JSON "file": begin-array ("uri": "OCIFS_URI") | ("uri": "PAR_URI") | ("uri": "NATIVE_URI"), [, "dialect": begin-object dialect_option [, dialect_option]... SELECT * FROM example INTO OUTFILE WITH PARAMETERS ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results-parquet-json.html
INTO OUTFILE WITH PARAMETERS 'file_URI_JSON "file": begin-array ("uri": "OCIFS_URI") | ("uri": "PAR_URI") | ("uri": "NATIVE_URI"), [, "dialect": begin-object dialect_option [, dialect_option]... SELECT sum(l_quantity) from lineitem limit 1000 INTO ... This topic shows the different ways to export query results to Parquet ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-incremental-load.html
Perform Initial Load The following example performs an initial automatic load of three files in an Object Storage folder, and then does a subsequent refresh of the data in the external table by loading an additional two files into the table. Create ... Available as of MySQL 9.0.0, Lakehouse Incremental Load allows you to refresh the data in an external ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-overview.html
While Lakehouse provides in-memory query processing on data in Object Storage, it does not load data into a DB System table. Workflows You have three options to load data into MySQL HeatWave Cluster: uniform resource identifiers (URIs) (as of MySQL ... The Lakehouse feature of MySQL HeatWave enables query processing on data in Object ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-silos.html
The number of nodes required depends on the size of the data and the amount of compression achieved when loading data into MySQL HeatWave Cluster. Data loaded into MySQL HeatWave is automatically stored in Object Storage, allowing for quick ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-learn-with-genai.html
This includes detailed instructions to do the following: Join your dataset's various tables into a single table. | | \n\nFirst, let's integrate the tables into one full table using a `CREATE TABLE ... | | \n\nAlso, ensure that the model is loaded ...
https://dev.mysql.com/doc/connector-j/en/connector-j-time-instants.html
For example: When storing java.sql.Timestamp to, for example, a DATETIME column, you might not get back the same instant value when retrieving it into a client that is in a different time zone than the one the client was in when storing the value.
https://dev.mysql.com/doc/refman/8.4/en/index-preloading.html
Preloading enables you to put the table index blocks into a key cache buffer in the most efficient way: by reading the index blocks from disk sequentially. Without preloading, the blocks are still placed into the key cache as needed by queries. To ... If there are enough blocks in a key cache to hold blocks of an entire index, or at least the blocks corresponding to its nonleaf nodes, it makes sense to preload the key cache with index blocks before starting to use ...
https://dev.mysql.com/doc/refman/8.4/en/load-data-local-security.html
The LOAD DATA statement loads a data file into a table. For client programs that use the C API, local data loading capability is determined by the default compiled into the MySQL client library. For the mysql client, local data loading capability ...The statement can load a file located on the server host, or, if the LOCAL keyword is specified, on the client ...
https://dev.mysql.com/doc/refman/8.4/en/source-configuration-options.html
You can build a plugin as a static module (compiled into the server) or a dynamic module (built as a dynamic library that must be installed into the server using the INSTALL PLUGIN statement or the --plugin-load option before it can be used). The ...