Sign in
apache
/
drill-test-framework
/
refs/heads/main
/
.
/
framework
/
resources
/
Functional
/
views
/
query12.q
blob: 8c021439a5bffd81b47a10a5006cfb998cc91113 [
file
]
create
or
replace view v12
as
select
*
from
`dfs/parquet/rankings`
;
create
or
replace view v12_2
as
select
*
from
`dfs/parquet/uservisits`
;
select
*
from
v12 inner join v12_2 on v12
.
pageURL
=
v12_2
.
destinationURL
;
drop view v12
;
drop view v12_2
;