Stamatis Zampetakis created HIVE-28936:
------------------------------------------
Summary: 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
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)
