framework/resources/Functional/views/query29.q

create or replace view v29 as select rankings.pageRank pageRank, rankings.pageURL pageURL, uservisits.destinationURL destinationURL from `dfs/parquet/rankings` rankings inner join `dfs/parquet/uservisits` uservisits on rankings.pageURL = uservisits.destinationURL;
select v29.pageRank, pages.url, pages.description from v29 inner join hive.pages pages on v29.pageURL = pages.url;
drop view v29;