---
name: watsonxdata-api_custom_ctg_pjcw
title: Catalog properties for Presto (Java)
description: You can customize the catalog properties through an API for Presto (Java).
last-updated: 2024-12-07
---

> ## Documentation Index
> The table of contents for this documentation set is at https://cloud.ibm.com/docs/watsonxdata?format=markdown
> The index for all IBM Cloud docs is at: https://cloud.ibm.com/docs/llms.txt
> Use these files to discover more information as needed.

# Catalog properties for Presto (Java)
{: #api_custom_ctg_pjcw}

You can customize the catalog properties through an API 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` | 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, 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.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. For more information, see [ignore-unsupported-datatypes](#ignore) |
{: caption="Catalog properties for Presto (Java)" caption-side="bottom"}

   **ignore-unsupported-datatypes**{: #ignore}

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