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

[John Sichi (JIRA)]

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.