blob: 4a5dcc0e5588b4215f22dc0dad9188731bbb5f20 [file] [log] [blame]
create or replace view v3_limit0_plan as select cast(pageRank as int) pageRank, cast(pageURL as varchar(100)) pageURL, cast(avgDuration as integer) avgDuration from `dfs/parquet/rankings`;
explain plan for select * from (select pageRank, pageURL, avgDuration from v3_limit0_plan) t limit 0;
drop view v3_limit0_plan;