[HIVE-4204] Support ellipsis for selecting multiple columns

• Type: Improvement
• Status: Patch Available
• Priority: Trivial
• Resolution: Unresolved
• Component/s: Query Processor
• Assignee: Navis Ryu
• Reporter: Navis Ryu
• Created: 20/Mar/13 05:49
• Updated: 22/Aug/13 06:38

Description

Some UDF should take all columns starting from second or third one and in this case, star argument(HIVE-3490) cannot be used. It's not pleasant to specify all of them especially when the table has many of columns. For example,

select some_udtf(a2,a3,a4,a5,a6) as (a2,a3,a4,a5,a6) from table;

it can be simplified to

select some_udtf(a2...) as (a2,a3,a4,a5,a6) from table;

if HIVE-2608 would be committed, it can be simplified further

select some_udtf(a2...) from table;