blob: 8b9be3c15ed0b73c1469269e328b65e01f8be099 [file] [log] [blame]
create or replace view v18 as select pageRank, pageURL, avgDuration from `dfs/parquet/rankings`;
create or replace view v18_2 as select sourceIP, destinationURL, visitDate, adRevenue, userAgent, countryCode, languageCode,
searchWord, duration from `dfs/parquet/uservisits`;
select * from v18 inner join v18_2 on v18.pageURL = v18_2.destinationURL;
drop view v18;
drop view v18_2;