# \#partition **URL:** https://www.starburst.io/community/forum/tag/partition/1.md [Latest](https://www.starburst.io/community/forum/latest.md) · [Categories](https://www.starburst.io/community/forum/categories.md) · [Tags](https://www.starburst.io/community/forum/tags.md) --- ## [Built in backup feature for SEP?](https://www.starburst.io/community/forum/t/built-in-backup-feature-for-sep/1296)
**Author:** [@Thara](https://www.starburst.io/community/forum/u/Thara)\ **Replies:** 1\ **Last updated:** [September 10, 2025, 1:40pm UTC](https://www.starburst.io/community/forum/t/built-in-backup-feature-for-sep/1296 "2025-09-10T13:40:22Z")
Hi Starburst Community, I wanted to ask why Starburst Enterprise Platform currently does not include a built-in backup and restore process as part of its feature set. From an enterprise perspective, having this capabili… --- ## [How does dynamic filtering behave with different connectors (Hive, Delta Lake, S3)?](https://www.starburst.io/community/forum/t/how-does-dynamic-filtering-behave-with-different-connectors-hive-delta-lake-s3/1293)
**Author:** [@Thara](https://www.starburst.io/community/forum/u/Thara)\ **Replies:** 4\ **Last updated:** [September 9, 2025, 3:35pm UTC](https://www.starburst.io/community/forum/t/how-does-dynamic-filtering-behave-with-different-connectors-hive-delta-lake-s3/1293 "2025-09-09T15:35:38Z")
Hi team, I’m exploring dynamic filtering in Starburst and wanted to understand how its behavior may differ across connectors. For example, in Hive catalogs backed by a Hive Metastore, does dynamic filtering push down … --- ## [Trino query plan analysis](https://www.starburst.io/community/forum/t/trino-query-plan-analysis/1241)
**Author:** [@lester](https://www.starburst.io/community/forum/u/lester)\ **Replies:** 2\ **Last updated:** [August 22, 2025, 3:23pm UTC](https://www.starburst.io/community/forum/t/trino-query-plan-analysis/1241 "2025-08-22T15:23:38Z")
A video series on Trino query plan analysis. --- ## [Validating predicate pushdown on delta lake tables](https://www.starburst.io/community/forum/t/validating-predicate-pushdown-on-delta-lake-tables/622)
**Author:** [@lester](https://www.starburst.io/community/forum/u/lester)\ **Replies:** 0\ **Last updated:** [January 8, 2025, 6:09pm UTC](https://www.starburst.io/community/forum/t/validating-predicate-pushdown-on-delta-lake-tables/622 "2025-01-08T18:09:03Z")
This post is here to validate that predicate pushdown (specifically on a day-level and using string values) works in Trino using Delta Lake tables. The following bits were run on Starburst Galaxy, but should work on any … --- ## [Alter table execute optimize](https://www.starburst.io/community/forum/t/alter-table-execute-optimize/558)
**Author:** [@mcbenzing](https://www.starburst.io/community/forum/u/mcbenzing)\ **Replies:** 4\ **Last updated:** [July 10, 2024, 5:41pm UTC](https://www.starburst.io/community/forum/t/alter-table-execute-optimize/558 "2024-07-10T17:41:26Z")
I create partitioned Iceberg tables and try to use compaction via the optimize command. However, I can’t really understand how the optimization works yet. Does it only change the way the data is stored if I have changed … --- ## [How to determine the right num of buckets](https://www.starburst.io/community/forum/t/how-to-determine-the-right-num-of-buckets/555)
**Author:** [@mcbenzing](https://www.starburst.io/community/forum/u/mcbenzing)\ **Replies:** 1\ **Last updated:** [July 4, 2024, 1:27pm UTC](https://www.starburst.io/community/forum/t/how-to-determine-the-right-num-of-buckets/555 "2024-07-04T13:27:25Z")
I want to create a hive table with buckets. I found this formula to determine the num of blocks to be used: table\_size/block\_size=x find n such that 2^n \> x To do this, I would like to know the block size used by th… --- ## [OPTIMIZE alledgedly not supported by Hive Table](https://www.starburst.io/community/forum/t/optimize-alledgedly-not-supported-by-hive-table/549)
**Author:** [@mcbenzing](https://www.starburst.io/community/forum/u/mcbenzing)\ **Replies:** 3\ **Last updated:** [July 3, 2024, 2:41pm UTC](https://www.starburst.io/community/forum/t/optimize-alledgedly-not-supported-by-hive-table/549 "2024-07-03T14:41:03Z")
I am struggeling with the optimize function of the hive connector. It keeps saying that executing OPTIMIZE is not supported by Hive tables. I created a table with the following statement: create table tmp\_cat\_hive.hive… --- ## [Hive external table with projection partition](https://www.starburst.io/community/forum/t/hive-external-table-with-projection-partition/249)
**Author:** [@shashideore](https://www.starburst.io/community/forum/u/shashideore)\ **Replies:** 2\ **Last updated:** [July 19, 2023, 3:48am UTC](https://www.starburst.io/community/forum/t/hive-external-table-with-projection-partition/249 "2023-07-19T03:48:17Z")
Can you share any example of creating an external table in trino with projection partition enabled. When we tried running the following query it fails with SQL Error \[18\]: Query failed (#): Catalog ‘hive’ table propert…