[IMPALA-4827] Equivalent to Hive's named_struct() in Impala

• Type: New Feature
• Status: Open
• Priority: Trivial
• Resolution: Unresolved
• Affects Version/s: Impala 2.5.0
• Component/s: Frontend
• Epic Link: UDF support for complex types
• Assignee: Unassigned
• Reporter: Thomas Scott
• Created: 26/Jan/17 12:47
• Updated: 17/Mar/20 11:41

Description

Hive's named_struct function is useful for projections of the type:

select min(named_struct(
'col1', `sometable`.`col1`,
'col2', `sometable`.`col2`,
'col3', `sometable`.`col3`
)) `named_struct`
FROM
`event`.`sometable` where dt='2010-01-01'

Can we have an equivalent in Impala

Issue Links

• relates to: IMPALA-4515 INSERT support for nested / complex types for Parquet