[HIVE-2608] Do not require AS a,b,c part in LATERAL VIEW

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 0.12.0
• Component/s: Query Processor, UDF
• Release Note: Committed. Thanks Navis.
• Assignee: Navis Ryu
• Reporter: Igor Kabiljo
• Created: 24/Nov/11 04:38
• Updated: 15/Oct/13 23:30
• Resolved: 20/Aug/13 05:29

Description

Currently, it is required to state column names when LATERAL VIEW is used.
That shouldn't be necessary, since UDTF returns struct which contains column names - and they should be used by default.

For example, it would be great if this was possible:

SELECT t.*, t.key1 + t.key4
FROM some_table
LATERAL VIEW JSON_TUPLE(json, 'key1', 'key2', 'key3', 'key3') t;

Issue Links

• is related to: HIVE-5116 HIVE-2608 didn't removed udtf_not_supported2.q test