blob: 03e34f5002a4d90348562fa56497a94e34339a45 [file] [log] [blame]
SELECT MAX(lead_col1) FROM (SELECT col1, LEAD(col1) OVER(PARTITION BY col7 ORDER BY col1) lead_col1 , col7 FROM `allTypsUniq.parquet`) sub_query WHERE col1 NOT IN (-1,0,1,-65535,10000000) AND col7 NOT IN (false);