add ability to customize json (and auto) column physical storage details on per column basis

[clintropolis]

Description

changes:

• NestedDataColumnSchema and AutoTypeColumnSchema now accept a NestedCommonFormatColumnFormatSpec as a new 'columnFormatSpec' property, which allows customizing how json and auto columns are compressed, how strings are encoded in dictionaries, etc, on a per column level. The nested column format spec has several properties: objectKeysEncoding, objectStorageEncoding, objectStorageCompression, stringDictionaryEncoding, dictionaryEncodedColumnCompression, longColumnEncoding, longColumnCompression, doubleColumnCompression NestedCommonFormatColumn blends in segment level config from IndexSpec to populate any values not explicitly specified with segment level.
• JSON field names can now be stored with front-coding with columnFormatSpec property objectKeysEncoding
• Adds 'druid.indexing.formats.nestedColumnFormatSpec' to define a default NestedCommonFormatColumn

Release note

todo

---

This PR has:

• [ ] been self-reviewed.
• [ ] added documentation for new or modified features or behaviors.
• [ ] a release note entry in the PR description.
• [ ] added Javadocs for most classes and all non-trivial methods. Linked related entities via Javadoc links.
• [ ] added or updated version, license, or notice information in licenses.yaml
• [ ] added comments explaining the "why" and the intent of the code wherever would not be obvious for an unfamiliar reader.
• [ ] added unit tests or modified existing tests to cover new code paths, ensuring the threshold for code coverage is met.
• [ ] added integration tests.
• [ ] been tested in a test Druid cluster.

[github-actions[bot]]

This pull request has been marked as stale due to 60 days of inactivity. It will be closed in 4 weeks if no further activity occurs. If you think that's incorrect or this pull request should instead be reviewed, please simply write any comment. Even if closed, you can still revive the PR at any time or discuss it on the [email protected] list. Thank you for your contributions.

[github-actions[bot]]

This pull request has been marked as stale due to 60 days of inactivity. It will be closed in 4 weeks if no further activity occurs. If you think that's incorrect or this pull request should instead be reviewed, please simply write any comment. Even if closed, you can still revive the PR at any time or discuss it on the [email protected] list. Thank you for your contributions.

[cecemei]

Hey this is a new feature, I drafted some release note:

Users can now specify a format specification for each JSON column individually, which will override the IndexSpec defined in the ingestion job. Additionally, a system-wide default IndexSpec can be set using the druid.indexing.formats.indexSpec property.

WDYT?