[jira] [Created] (HIVE-27823) select returns struct unfilled fields with nulls, some way to suppress this?

[Alexander Petrossian (PAF) (Jira)]

Alexander Petrossian (PAF) created HIVE-27823:
-------------------------------------------------

             Summary: select returns struct unfilled fields with nulls, some 
way to suppress this?
                 Key: HIVE-27823
                 URL: https://issues.apache.org/jira/browse/HIVE-27823
             Project: Hive
          Issue Type: Wish
    Affects Versions: 3.1.0
            Reporter: Alexander Petrossian (PAF)


One of fields has struct type
{code:sql}
struct<
  BoolValue:struct<value:boolean>,
  IntValue:struct<value:int>,
  Ipv4Value:struct<value:string>,
  StringValue:struct<value:string>,
  ZonedTimeValue:struct<value:struct<timestampUTC:int>>
>
{code}

Of which only one at a time is used.

As result of select we get all fields, others filled with nulls:
{code:json}
{
  "BoolValue": null,
  "IntValue": null,
  "Ipv4Value": null,
  "StringValue": {
    "value": "ipv4:10.31.94.28:31003"
  },
  "ZonedTimeValue": null
},
{code}

This is truth, but an unreadable one.

Any ideas on how to get this output for this field:
{code:json}
{
  "StringValue": {
    "value": "ipv4:10.31.94.28:31003"
  }
},
{code}
??

Thanks!



--
This message was sent by Atlassian Jira
(v8.20.10#820010)