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®

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.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, 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.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 values. 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
  • SAP HANA