Catalog properties for Presto (Java)

You can customize the catalog properties through an API for Presto (Java).

Table 1. Catalog properties for Presto (Java)
Property name	Type	Validation added
`cache.enabled`	Boolean	True or False
`cache.base-directory`	String	Any string
`cache.type`	String	Any string
`cache.alluxio.max-cache-size`	String	Limit {1, 1e13}; supported values are numbers with or without units TB, MB, GB, B, KB
`hive.partition-statistics-based-optimization-enabled`	Boolean	True or False
`hive.metastore-cache-scope`	String	Any string
`hive.metastore-cache-ttl`	String	Limit {1, 1e13}; supported values are numbers with or without units m, s, ms, h
`hive.metastore-refreshInterval`	String	Limit {1, 1e13}; supported values are numbers with or without units m, s, ms, h, d
`hive.metastore-cache-maximum-size`	Integer	Limit {1, 1000}
`hive.partition-versioning-enabled`	Boolean	True or False
`hive.file-status-cache-expire-time`	String	Limit {1, 1e13}; supported values are numbers with or without units m, s, ms, h
`hive.file-status-cache-size`	Integer	Limit {1, 10000000000}
`hive.file-status-cache-tables`	String	Any string
`<catalog-name>.orc.file-tail-cache-enabled`	Boolean	True or False
`<catalog-name>.orc.file-tail-cache-size`	Integer	Limit{1, 1000000}
`<catalog-name>.orc.file-tail-cache-ttl-since-last-access`	String	Limit {1, 1e13}; supported values are numbers with or without units m, s, ms, h
`<catalog-name>.orc.stripe-metadata-cache-enabled`	Boolean	True or False
`<catalog-name>.orc.stripe-footer-cache-size`	Integer	Limit {1, 1000}
`<catalog-name>.orc.stripe-footer-cache-ttl-since-last-access`	String	Limit {1, 1e13}; supported values are numbers with or without units m, s, ms, h
`<catalog-name>.orc.stripe-stream-cache-size`	Integer	Limit {1, 1000}
`<catalog-name>.orc.stripe-stream-cache-ttl-since-last-access`	String	Limit {1, 1e13}; supported values are numbers with or without units m, s, ms, h
`hive.orc.use-column-names`	True	True or False
`<catalog-name>.parquet.metadata-cache-enabled`	True	True or False
`<catalog-name>.parquet.metadata-cache-size`	Integer	Limit {1, 1000}
`<catalog-name>.parquet.metadata-cache-ttl-since-last-access`	String	Limit {1, 1e13}; supported values are numbers with or without units m, s, ms, h
`hive.parquet.use-column-names`	True	True or False
`hive.parquet-batch-read-optimization-enabled`	True	True or False
`hive.node-selection-strategy`	String	Any string
`hive.max-outstanding-splits`	Integer	Limit {1, 1000}
`hive.max-initial-splits`	Integer	Limit {1, 1000}
`hive.max-initial-split-size`	Integer	Limit {1, 1000}
`hive.max-split-size`	Integer	Limit {1, 1000}
`hive.split-loader-concurrency`	Integer	Limit {1, 1000}
`hive.pushdown-filter-enabled`	Boolean	True or False
`hive.max-partitions-per-writers`	Integer	Limit {1, 1000}
`hive.s3.max-error-retries`	Integer	Limit {1, 100}
`hive.s3.connect-timeout`	String	Limit {1, 1e13}; supported values are numbers with or without units m, s, ms, h
`hive.s3.socket-timeout`	String	Limit {1, 1e13}; supported values are numbers with or without units m, s, ms, h
`hive.s3.max-connections`	Integer	Limit {1, 10000}
`hive.s3.max-client-retries`	Integer	Limit {1, 100}
`hive.collect-column-statistics-on-write`	Boolean	True or False
`hive.non-managed-table-creates-enabled`	Boolean	True or False
`hive.s3select-pushdown.enabled`	Boolean	True or False
`hive.recursive-directories`	Boolean	True or False
`hive.allow-rename-table`	Boolean	True or False
`hive.allow-add-column`	Boolean	True or False
`hive.allow-drop-column`	Boolean	True or False
`hive.allow-rename-column`	Boolean	True or False
`hive.metastore-timeout`	String	Limit {1, 1e13}; supported values are numbers with or without units m, s, ms, h
`ignore-unsupported-datatypes`	Boolean	True or False. For more information, see ignore-unsupported-datatypes

ignore-unsupported-datatypes

Presto skips columns with unsupported data types when it retrieves data from a database. The ignore-unsupported-datatypes property controls this behavior, which is set to true by default, causing unsupported columns to be skipped. You can set the property to false to make Presto raise an error when it encounters unsupported data types instead of omitting the columns. So, tables with unsupported columns do not return incomplete or inaccurate data. The property is available for the following databases:

Amazon Redshift
IBM Db2
Informix
MySQL
Oracle
PostgreSQL
SQL Server
SingleStore
Snowflake
Teradata