Queries against one of the tables or schemes defined in the mappingĪttributes are run against the corresponding remote entity. For example, the following system callįlushes the metadata caches for all schemas in the example catalog This may negatively impact performance for some queries.įlush JDBC metadata caches. Session property is join_pushdown_enabled. Maximum number of statements in a batched execution.ĭo not change this setting from the default. Maximum number of objects stored in the metadata cache Trino to disambiguate between schemas and tables with similar names inĬase-insensitive-name-matching.refresh-periodįrequency with which Trino checks the name matching configuration fileĭuration for which metadata, including table and column statistics, isĬache the fact that metadata, including table and column statistics, is Path to a name mapping configuration file in JSON format that allows Support case insensitive schema and table names.Ĭnfig-file The following table describes general catalog configuration properties for the ForĮxample, if you name the property file sales.properties, TrinoĬreates a catalog named sales using the configured connector. With a different name, making sure it ends in. MySQL servers, simply add another properties file to etc/catalog You can have as many catalogs as you need, so if you have additional You can set the sslMode paremeter in the catalog configuration file byĪppending it to the connection-url configuration property:Ĭonnection-url = jdbc:mysql://:3306/?sslMode=REQUIREDįor more information on TLS configuration options, see the MySQL JDBC security You canĪlso set this parameter to REQUIRED which causes the connection to fail if PREFERRED which secures the connection if enabled by the server. Parameter to secure the connection with TLS. Source by appending a parameter to the JDBC connection string set in theĬonnection-url catalog configuration property.įor example, with version 8.0 of MySQL Connector/J, use the sslMode If you have TLS configured with a globally-trusted certificate installed on yourĭata source, you can enable TLS between your cluster and the data Use secrets to avoid actual values in the catalog The connection-user and connection-password are typically required andĭetermine the user credentials for the connection, often a service user. Connection-url=jdbc:mysql://:3306?serverTimezone=UTC
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |