framework/resources/Functional/views/query22.q

create or replace view v22 as select rankings.pageRank, rankings.pageURL, rankings.avgDuration, uservisits.sourceIP, uservisits.destinationURL, uservisits.visitDate, uservisits.adRevenue, uservisits.userAgent, uservisits.countryCode, uservisits.languageCode, uservisits.searchWord, uservisits.duration from `dfs/parquet/rankings` rankings inner join `dfs/parquet/uservisits` uservisits on rankings.pageURL = uservisits.destinationURL;
select searchWord from v22;
drop view v22;