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

• Type: Improvement
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 0.6.0
• Component/s: Query Processor
• Assignee: Unassigned
• Reporter: John Sichi
• Created: 09/Feb/10 23:17
• Updated: 09/Feb/10 23:18

Description

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);

Issue Links

• is related to: HIVE-972 Support views