[
https://issues.apache.org/jira/browse/HIVE-28936?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
ASF GitHub Bot updated HIVE-28936:
----------------------------------
Labels: pull-request-available (was: )
> Redundant fields/nullable attributes in CBOPlan returned by EXPLAIN FORMATTED
> -----------------------------------------------------------------------------
>
> Key: HIVE-28936
> URL: https://issues.apache.org/jira/browse/HIVE-28936
> Project: Hive
> Issue Type: Improvement
> Components: CBO
> Reporter: Stamatis Zampetakis
> Assignee: Stamatis Zampetakis
> Priority: Major
> Labels: pull-request-available
>
> EXPLAIN FORMATTED contains some redundant fields and nullable attributes in
> the JSON serialization of the CBOPlan. The redundant appears in the
> serialization of the rowType of the {{ROW__ID}} field that is of type STRUCT
> thus it affects all tables.
> Consider for instance the following test:
> [ql/src/test/results/clientpositive/llap/concat_op.q.out|https://github.com/apache/hive/blob/208488089df71e8a0dafd95b2812e5e4864baed9/ql/src/test/results/clientpositive/llap/concat_op.q.out]
> {code:json}
> "rowType": {
> "fields": [
> {
> "type": "VARCHAR",
> "nullable": true,
> "precision": 2147483647,
> "name": "key"
> },
> …
> {
> "fields": { <-- REDUNDANT
> "fields": [
> {
> "type": "BIGINT",
> "nullable": true,
> "name": "writeid"
> },
> {
> "type": "INTEGER",
> "nullable": true,
> "name": "bucketid"
> },
> {
> "type": "BIGINT",
> "nullable": true,
> "name": "rowid"
> }
> ],
> "nullable": true
> },
> "nullable": true, <-- REDUNDANT
> "name": "ROW__ID"
> },
> {
> "type": "BOOLEAN",
> "nullable": true,
> "name": "ROW__IS__DELETED"
> }
> ],
> "nullable": false
> }
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
