Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-loading-data-par.html
Review the following examples to see the different ways to use pre-authenticated requests (PAR) to specify files when creating external tables manually. Create the external tables that will ingest the loaded data by either using SQL syntax or JSON ...You can also use name, prefix, or pattern parameters to specify files in the bucket or Object Storage ...
https://dev.mysql.com/doc/refman/9.7/en/create-table-gipks.html
MySQL 9.7 supports generated invisible primary keys for any InnoDB table that is created without an explicit primary key. This setting has no effect on tables created using any other storage engine than InnoDB. row *************************** ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-auto-loading-data-par.html
Review the following examples to see the different ways to use pre-authenticated requests (PAR) and Auto Parallel Load to specify files when creating external tables. These examples use an input_list variable to set up the creation of the external ...To learn more, see Load Structured Data Using Lakehouse Auto Parallel ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-programs-ndb-sign-keys.html
The program performs such functions as creating, signing, and retiring keys and certificates, and normally works as follows: ndb_sign_keys connects to ndb_mgmd and fetches the cluster' configuration. For each cluster node that is configured to run ... Management of TLS keys and certificates in implemented in NDB Cluster as the executable utility program ndb_sign_keys, which can normally be found in the MySQL bin ...
https://dev.mysql.com/doc/refman/9.7/en/create-table-ndb-comment-options.html
NDB_COLUMN Options In NDB Cluster, a column comment in a CREATE TABLE or ALTER TABLE statement can also be used to specify an NDB_COLUMN option. NDB_TABLE Options For an NDB Cluster table, the table comment in a CREATE TABLE or ALTER TABLE statement ... NDB_COLUMN Options NDB_TABLE Options It is possible to set a number of options specific to NDB Cluster in the table comment or column comments of an NDB ...
https://dev.mysql.com/doc/refman/9.7/en/using-innodb-tables.html
InnoDB tables are created using the CREATE TABLE statement; for example: CREATE TABLE t1 (a INT, b CHAR (20), PRIMARY KEY (a)) ENGINE=InnoDB; The ENGINE=InnoDB clause is not required when InnoDB is defined as the default storage engine, which it is ...Row Formats The row format of an InnoDB table determines how its rows are physically stored on ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-iam-role-cloudwatch.html
Creating an IAM Role and Policy for CloudWatch Monitoring 21.5.5 Creating an IAM Role and Policy for CloudWatch Monitoring Use the AWS Management Console to create an IAM role for using CloudWatch to monitor your DB Systems and MySQL HeatWave ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-auto-loading-data-rp.html
Review the following examples to see the different ways to use resource principals and Auto Parallel Load to specify files when creating external tables. These examples use an input_list variable to set up the creation of the external table and the ...To learn more, see Load Structured Data Using Lakehouse Auto Parallel ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-generated-columns.html
As of MySQL 9.5.1, you have the option to include stored generated columns when creating external Lakehouse tables. To learn more about generated columns, see CREATE TABLE and Generated Columns. Before You Begin Prepare to create external tables by ...col_name data_type [GENERATED ALWAYS] AS (expr) STORED [NOT NULL | NULL] [UNIQUE [KEY]] [[PRIMARY] KEY] [COMMENT 'string'], ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-loading-data-resource-principal.html
Review the following examples to see the different ways to use resource principals to specify files when creating external tables manually. Resource Principals Examples The following examples use these parameters to create the external tables and ...This topic contains the following sections: Before You Begin Resource Principals Parameters Resource Principals Examples Specify a Single File Specify Multiple Files for One External Table Specify Files with a Pattern What's Next Before You Begin Review the requirements to Access Object Storage with Resource ...