Key Default Type Description
cache-enabled
true Boolean Controls whether the catalog will cache databases, tables, manifests and partitions.
cache.deletion-vectors.max-num
100000 Integer Controls the maximum number of deletion vector meta that can be cached.
cache.expire-after-access
10 min Duration Cache expiration policy: marks cache entries to expire after a specified duration has passed since their last access.
cache.expire-after-write
30 min Duration Cache expiration policy: marks cache entries to expire after a specified duration has passed since their last refresh.
cache.manifest.max-memory
(none) MemorySize Controls the maximum memory to cache manifest content.
cache.manifest.small-file-memory
128 mb MemorySize Controls the cache memory to cache small manifest files.
cache.manifest.small-file-threshold
1 mb MemorySize Controls the threshold of small manifest file.
cache.manifest.soft-values
true Boolean If true (default), manifest cache entries are held with soft references and may be reclaimed by the GC under memory pressure. This can trigger a cache-thrash spiral where reclaimed entries are refetched, spiking heap and forcing further reclamation. Set to false to hold entries with strong references, breaking the spiral; the cache then stays bounded by weight up to 'cache.manifest.max-memory' (size the total heap memory to at least roughly twice that value).
cache.partition.max-num
0 Long Controls the max number for which partitions in the catalog are cached.
cache.snapshot.max-num-per-table
20 Integer Controls the max number for snapshots per table in the catalog are cached.
case-sensitive
(none) Boolean Indicates whether this catalog is case-sensitive.
catalog-options-table.enabled
false Boolean Whether to support the sys.catalog_options table.
client-pool-size
2 Integer Configure the size of the connection pool.
file-io.allow-cache
true Boolean Whether to allow static cache in file io implementation. If not allowed, this means that there may be a large number of FileIO instances generated, enabling caching can lead to resource leakage.
format-table.enabled
true Boolean Whether to support format tables, format table corresponds to a regular csv, parquet or orc table, allowing read and write operations. However, during these processes, it does not connect to the metastore; hence, newly added partitions will not be reflected in the metastore and need to be manually added as separate partition operations.
local-cache.block-size
1 mb MemorySize Block size for local cache.
local-cache.dir
(none) String Directory for local block cache on disk. If not configured, memory cache is used instead.
local-cache.enabled
false Boolean Whether to enable local block cache for file reads. If local-cache.dir is configured, disk cache is used; otherwise memory cache is used.
local-cache.max-size
(none) MemorySize Maximum total size of the local block cache. Unlimited by default.
local-cache.whitelist
"meta,global-index" String Comma-separated list of file types to cache. Supported values: meta, global-index, bucket-index, data, file-index.
lock-acquire-timeout
8 min Duration The maximum time to wait for acquiring the lock.
lock-check-max-sleep
8 s Duration The maximum sleep time when retrying to check the lock.
lock.enabled
(none) Boolean Enable Catalog Lock.
lock.type
(none) String The Lock Type for Catalog, such as 'hive', 'zookeeper'.
metastore
"filesystem" String Metastore of paimon catalog, supports filesystem, hive and jdbc.
resolving-file-io.enabled
false Boolean Whether to enable resolving fileio, when this option is enabled, in conjunction with the table's property data-file.external-paths, Paimon can read and write to external storage paths, such as OSS or S3. In order to access these external paths correctly, you also need to configure the corresponding access key and secret key.
sync-all-properties
true Boolean Sync all table properties to the catalog metastore (e.g. Hive metastore, JDBC catalog store)
table.type
managed

Enum

Type of table.

Possible values:
  • "managed": Paimon owned table where the entire lifecycle of the table data is managed.
  • "external": The table where Paimon has loose coupling with the data stored in external locations.
uri
(none) String Uri of metastore server.
warehouse
(none) String The warehouse root path of catalog.