| create or replace view v29_limit0 as select cast(rankings.pageRank as int) pageRank, cast(rankings.pageURL as varchar(100)) pageURL, cast(uservisits.destinationURL as character varying(100)) destinationURL from `dfs/parquet/rankings` rankings inner join `dfs/parquet/uservisits` uservisits on rankings.pageURL = uservisits.destinationURL; | |
| select v29_limit0.pageRank, pages.url, pages.description from v29_limit0 inner join hive.pages pages on v29_limit0.pageURL = pages.url; | |
| drop view v29_limit0; |