Catalog properties for Presto (Java)

You can customize the catalog properties through an API for Presto (Java).
Table 1. Catalog properties
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-refreshIntegererval 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 Boolean True or False
<catalog-name>.parquet.metadata-cache-enabled Boolean 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 Boolean True or False
hive.parquet-batch-read-optimization-enabled Boolean True or False
hive.parquet.writer.version String Any string
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.storage-format String Any string
iceberg.file-format String Any string
hive.pushdown-filter-enabled Boolean True or False
hive.max-partitions-per-writers Integer Limit {1, 10000}
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.metastore-refresh-interval String Limit {1,1e13}
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