Catalog properties for Presto (Java)

Edit online

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

watsonx.data on Red Hat® OpenShift®

watsonx.data Developer edition

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