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; |