framework/resources/Functional/limit0/views/data/hive-parquet-join_DRILL-792.q

create or replace view `DRILL-792-limit0` as select cast(pageRank as int) pageRank, cast(pageURL as varchar(100)) pageURL, cast(avgDuration as integer) avgDuration from `dfs/parquet/rankings`;
select rankings.pageRank pagerank from `DRILL-792-limit0` rankings inner join hive.uservisits uservisits on rankings.pageURL = uservisits.destinationurl;
drop view `DRILL-792-limit0`;