Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-auto-loading-data.html
After setting up an external table with the files to load into the table, you run HEATWAVE_LOAD command to automatically create the table and load the data. This topic contains the following sections: Before You Begin Load External Data Using ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-other.html
UNION ALL queries with an ORDER BY or LIMIT clause, between dictionary-encoded columns, or between ENUM columns. EXCEPT, EXCEPT ALL, INTERSECT, INTERSECT ALL, and UNION queries with or without an ORDER BY or LIMIT clause, between dictionary-encoded ...For a list of supported SQL modes, see Section 5.2, “Supported SQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-run-query.html
mysql> EXPLAIN SELECT airline_id, COUNT(*) AS flight_id FROM flight WHERE flight_id <= 66810 GROUP BY airline_id ORDER BY airline_id; *************************** 1. mysql> SELECT airline_id, COUNT(*) AS flight_id FROM flight WHERE flight_id <= 66810 ... This topic describes how to use the EXPLAIN statement to analyze query execution and verify whether a query is offloaded to MySQL HeatWave for accelerated ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-select.html
QUALIFY clause is added between the WINDOW clause and the ORDER BY clause. However, this optimization technique changes the order of operations performed as compared to a standard SQL execution of the SELECT statement on MySQL. This topic provides ...
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-connection.html
'ConnectionLifecycleInterceptors' are stackable, more than one interceptor may be specified via the configuration property as a comma-delimited list, with the interceptors executed in order from left to right. Since Version 3.1.5 clientInfoProvider ... connectionAttributes A comma-delimited list of user-defined "key:value" pairs, in addition to standard MySQL-defined "key:value" pairs, to be passed to MySQL Server for display as connection attributes in the 'PERFORMANCE_SCHEMA' tables 'session_account_connect_attrs' and ...
https://dev.mysql.com/doc/refman/8.4/en/adding-collation.html
Add configuration information that names the collation and describes the character-ordering rules. Note If you modify an existing user-defined collation, that may affect the ordering of rows for indexes on columns that use the collation. Warning ...
https://dev.mysql.com/doc/refman/8.4/en/alter-user.html
Order of REQUIRE options does not matter, but no option can be specified twice. ALTER USER 'jeffrey'@'localhost' REQUIRE SUBJECT '/C=SE/ST=Stockholm/L=Stockholm/ O=MySQL demo client certificate/ CN=client/emailAddress=client@example.com'; MySQL does ... ALTER USER [IF EXISTS] user [auth_option] [, user [auth_option]] ...
https://dev.mysql.com/doc/refman/8.4/en/bnl-bka-optimization.html
The rows are fetched by the MRR functions in an optimal way: They are fetched in the row ID (primary key) order. This improves performance because reads are in disk order rather than random order. In MySQL, a Batched Key Access (BKA) Join algorithm ...
https://dev.mysql.com/doc/refman/8.4/en/character-arrays.html
<collation> elements indicate character ordering for comparison and sorting, one element per collation. Binary collations need no <map> element because the character codes themselves provide the ordering. For example: lower['A'] should contain 'a' ... Each simple character set has a configuration file located in the sql/share/charsets ...
https://dev.mysql.com/doc/refman/8.4/en/charset-collate.html
With the COLLATE clause, you can override whatever the default collation is for a comparison.