You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Ayush Saxena (Jira)" <ji...@apache.org> on 2026/03/23 10:03:00 UTC
[jira] [Commented] (HIVE-29342) Iceberg: [V3] Display initial and write defaults in describe formatted column output
[ https://issues.apache.org/jira/browse/HIVE-29342?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18067594#comment-18067594 ]
Ayush Saxena commented on HIVE-29342:
-------------------------------------
Currently {{initial-default}} is present in the {{DESCRIBE TABLE FORMATTED}} output already as part of the current schema
{noformat}
current-schema {\"type\":\"struct\",\"schema-id\":1,\"fields\":[{\"id\":1,\"name\":\"id\",\"required\":false,\"type\":\"int\"},{\"id\":2,\"name\":\"point\",\"required\":false,\"type\":{\"type\":\"struct\",\"fields\":[{\"id\":3,\"name\":\"x\",\"required\":false,\"type\":\"int\",\"write-default\":100},{\"id\":4,\"name\":\"y\",\"required\":false,\"type\":\"int\",\"write-default\":99}]}},{\"id\":5,\"name\":\"name\",\"required\":false,\"type\":\"string\",\"initial-default\":\"unknown\",\"write-default\":\"unknown\"},{\"id\":6,\"name\":\"age\",\"required\":false,\"type\":\"int\",\"initial-default\":25,\"write-default\":25}]}{noformat}
So, we have the info already.
The {{describe formatted column }} doesn't even print the normal SQL defaults for any other table as well, the Native SQL defaults.
Those defaults are present in {{DESCRIBE TABLE FORMATTED}}, under the {{Default Constraints}} sub heading
{noformat}
# Default Constraints
Table: default.ice_parq
Constraint Name: #### A masked pattern was here ####
Column Name:age Default Value:25
{noformat}
I think we should add the Initial Default here only with the other default value
> Iceberg: [V3] Display initial and write defaults in describe formatted column output
> ------------------------------------------------------------------------------------
>
> Key: HIVE-29342
> URL: https://issues.apache.org/jira/browse/HIVE-29342
> Project: Hive
> Issue Type: Improvement
> Components: Iceberg integration
> Reporter: Denys Kuzmenko
> Assignee: tanishqchugh
> Priority: Major
> Labels: pull-request-available
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)