blob: edcd8f791f6c07c2e4172d5f1267fd2e5000e96b [file] [log] [blame]
-- create or replace view with the same case as in files
create or replace view v1 as select * from ( select * from `customer.json` ) where CUSTOMERID >= 100 order by customerid;
select * from v1;
drop view v1;