You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "John Sichi (JIRA)" <ji...@apache.org> on 2010/02/10 00:19:29 UTC

[jira] Created: (HIVE-1146) CREATE VIEW followup: add utility for recursively expanding view references

CREATE VIEW followup:  add utility for recursively expanding view references
----------------------------------------------------------------------------

                 Key: HIVE-1146
                 URL: https://issues.apache.org/jira/browse/HIVE-1146
             Project: Hadoop Hive
          Issue Type: Improvement
          Components: Query Processor
    Affects Versions: 0.6.0
            Reporter: John Sichi
            Priority: Minor


Something like

CREATE VIEW v1 AS SELECT c from t1;
CREATE VIEW v2 AS SELECT c from t2;
EXPLAIN VIEW select * from v1 union all select * from v2;

to produce

select c from (select c from t1) union all select c from (select c from t2);


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