[HIVE-2165] variable to be assigned with an atomic value from a query

• Type: Sub-task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: Query Processor
• Assignee: Unassigned Assign to me
• Reporter: Ning Zhang
• Created: 14/May/11 00:35
• Updated: 14/May/11 01:54

Description

Currently variable can only be assigned by a constant. There are cases where a query generate a single value that should be used by the second query. It would be nice to assign this value to a variable and pass it to the second query. For exmaple:

hive> set x_avg = `select avg(x) from T`;
hive> select my_udf(${hiveconf:x_avg}, y) from T2;