hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ashish Thusoo (JIRA)" <j...@apache.org>
Subject [jira] Created: (HIVE-611) Support variables for variables for composing data flows
Date Mon, 06 Jul 2009 22:21:14 GMT
Support variables for variables for composing data flows
--------------------------------------------------------

                 Key: HIVE-611
                 URL: https://issues.apache.org/jira/browse/HIVE-611
             Project: Hadoop Hive
          Issue Type: New Feature
          Components: Query Processor
            Reporter: Ashish Thusoo
            Assignee: Ashish Thusoo


This is similar to SCOPEs use of variables for composing data flows. With this capability
Hive should be able to support things like

X = select c1, c2 from T;
Y = select X.c1 as c1, T2.c1 as c2 from X join T2 on (T2.c2 = X.c2);
Z = select Y.c1, count(1) from Y group by Y.c1

This can be also achieved through views though one minor difference is that the data variables
X, Y and Z are local to the session whereas views are global is scope (though you can also
have session specific views).

Thoughts?

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message