hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ning Zhang (JIRA)" <>
Subject [jira] [Commented] (HIVE-2165) variable to be assigned with an atomic value from a query
Date Fri, 13 May 2011 21:54:47 GMT


Ning Zhang commented on HIVE-2165:

Yeah, I think we should draw a line between a necessary feature and a whole SP language. This
small feature can solve some cases that prevent hive from being a data flow processing language
itself, but I don't think a lot of features in SP language is necessary because they can be
implemented by Hive's UDFs (transform etc.). And UDFs have the benefits of pushing down computation
close to data. So I think implementing a full-blown SP's control flow is an overkill and unnecessary,
but some small feature like this has its value. 

> variable to be assigned with an atomic value from a query
> ---------------------------------------------------------
>                 Key: HIVE-2165
>                 URL:
>             Project: Hive
>          Issue Type: Sub-task
>          Components: Query Processor
>            Reporter: Ning Zhang
> 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:
> {code}
> hive> set x_avg = `select avg(x) from T`;
> hive> select my_udf(${hiveconf:x_avg}, y) from T2;
> {code}

This message is automatically generated by JIRA.
For more information on JIRA, see:

View raw message