[
https://issues.apache.org/jira/browse/HIVE-29474?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
ASF GitHub Bot updated HIVE-29474:
----------------------------------
Labels: pull-request-available (was: )
> DESCRIBE FORMATTED for columns produces wrong output when the column datatype
> is STRUCT
> ---------------------------------------------------------------------------------------
>
> Key: HIVE-29474
> URL: https://issues.apache.org/jira/browse/HIVE-29474
> Project: Hive
> Issue Type: Bug
> Reporter: tanishqchugh
> Assignee: tanishqchugh
> Priority: Major
> Labels: pull-request-available
>
> When we have a table that contains STRUCT type columns, the output of
> DESCRIBE FORMATTED on the STRUCT type column produces wrong output.
> For Exm:
> {code:java}
> CREATE TABLE tbl_t (id int, point STRUCT<x:INT, y:INT>);
> DESCRIBE FORMATTED tbl_t point;{code}
>
> gives the following output:
> {code:java}
> +------------------------+----------------------------------------------------+
> | column_property | value
> |
> +------------------------+----------------------------------------------------+
> | col_name | x
> |
> | data_type | int
> |
> | min |
> |
> | max |
> |
> | num_nulls |
> |
> | distinct_count |
> |
> | avg_col_len |
> |
> | max_col_len |
> |
> | num_trues |
> |
> | num_falses |
> |
> | bit_vector |
> |
> | comment | from deserializer
> |
> | COLUMN_STATS_ACCURATE |
> {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"id\":\"true\"}} |
> +------------------------+----------------------------------------------------+
> {code}
> We can see that the col_name & data_type contain the wrong values.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
