Search before asking

• I searched in the issues and found nothing similar.

Motivation

Currently, the partition display in sys.partitions shows partition values in a simple concatenated format, which makes it difficult for users to understand which value corresponds to which partition key. This is particularly problematic when tables have multiple partition columns.

Solution

Proposed Solution:
Modify the partition display format to show key-value pairs, similar to the format: key1=value1/key2=value2/key3=value3

Reference: ODPS DataWorks Implementation
In Alibaba Cloud's ODPS (MaxCompute) DataWorks platform, partition information is displayed in a clear key-value pair format. This has proven to be much more user-friendly and intuitive for data engineers and analysts.

The ODPS approach shows partitions as:
dt=2024-01-01/region=us-west-1/category=electronics

Instead of the current:
2024-01-01,us-west-1,electronics

Anything else?

No response

Are you willing to submit a PR?

• I'm willing to submit a PR!