Sign in
apache
/
drill-test-framework
/
0c85b4fdd97d4bceb9f295eb434983b210bff100
/
.
/
framework
/
resources
/
Functional
/
views
/
query12.q
blob: 8c021439a5bffd81b47a10a5006cfb998cc91113 [
file
] [
log
] [
blame
]
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
;