![]() For example, the following system callįlushes the metadata caches for all schemas in the example catalog The domain-compaction-threshold catalog configuration property or theĭomain_compaction_threshold catalog session property can be used to adjust the default value ofįlush JDBC metadata caches. Increasing this threshold may improve pushdown of large Performance when the data source is capable of taking advantage of large If necessary, the threshold for this compaction can be increased to improve Trino compacts large predicates into a simpler range predicateīy default to ensure a balance between performance and predicate pushdown. Pushing down a large list of predicates to the data source can compromise However, it can also increase latency for some queries. Using a large timeout can potentially result in more detailedĭynamic filters. Maximum duration for which Trino will wait for dynamicįilters to be collected from the build side of joins before starting a Push down dynamic filters into JDBC queries 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 The duration for which metadata, includingĬache the fact that metadata, including table and column statistics, is Trino to disambiguate between schemas and tables with similar names inĬ-periodįrequency with which Trino checks the name matching configuration fileįor changes. 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 If you name the property file sales.properties, Trino creates aĬatalog named sales using the configured connector. With a different name, making sure it ends in. ![]() To add another catalog, simply add another properties file to etc/catalog Multiple instances of the PostgreSQL connector. Or want to connect to multiple PostgreSQL servers, you must configure ![]() Thus, if you have multiple PostgreSQL databases, The PostgreSQL connector can only access a single database withinĪ PostgreSQL server. Multiple PostgreSQL databases or servers # Password for the password key store entity. Name of the key store entity to use as the password. Password for the user name key store entity. Name of the key store entity to use as the user name. The location of the Java Keystore file, from which to read credentials.įile format of the keystore file, for example JKS or PEM. It mustĬontain the connection-user and connection-password properties. Location of the properties file where credentials are present. Name of the extra credentials property, whose value to use as the See extraCredentials in Parameter reference. Name of the extra credentials property, whose value to use as the user The following table describes configuration properties You can use secrets to avoid storing sensitive ![]() Inline, in the connector configuration fileĪs extra credentials set when connecting to Trino The connector can provide credentials for the data source connection Source by appending a parameter to the JDBC connection string set in theĬonnection-url catalog configuration property.įor example, with version 42 of the PostgreSQL JDBC driver, enable TLS byĪppending the ssl=true parameter to the connection-url configurationĬonnection-url = jdbc:postgresql://:5432/database?ssl=trueįor more information on TLS configuration options, see the PostgreSQL JDBCĭriver documentation. 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. ![]() Some parameters can have adverse effects on the connector behavior or not work The parameters for the URL are available in the The connection-url defines the connection information and parameters to pass
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |