[
https://issues.apache.org/jira/browse/HIVE-29310?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Denys Kuzmenko updated HIVE-29310:
----------------------------------
Description:
{code:java}
SELECT
try_variant_get(data, '$.name') AS name,
try_variant_get(data, '$.age') AS age,
try_variant_get(data, '$.address.city') AS city
FROM variant_ice01
WHERE try_variant_get(data, '$.age', 'int') >= 28; {code}
> Filtering on Variant columns
> ----------------------------
>
> Key: HIVE-29310
> URL: https://issues.apache.org/jira/browse/HIVE-29310
> Project: Hive
> Issue Type: Sub-task
> Reporter: Denys Kuzmenko
> Assignee: Denys Kuzmenko
> Priority: Major
>
> {code:java}
> SELECT
> try_variant_get(data, '$.name') AS name,
> try_variant_get(data, '$.age') AS age,
> try_variant_get(data, '$.address.city') AS city
> FROM variant_ice01
> WHERE try_variant_get(data, '$.age', 'int') >= 28; {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
