Catalog properties for Presto (Java)
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 |
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