yql/essentials/tests/sql/suites/optimizers/length_over_merge.sql


1
2
3
4
5
6
7
8
9
10
11
12

/* postgres can not */
use plato;

$input = (select key, key || subkey as subkey, value from Input);

$total_count = (select count(1) from $input);

$filtered = (select * from $input where key in ("023", "037", "075"));

$filtered_cnt = (select count(1) from $filtered);

select $filtered_cnt / cast($total_count as Double) as cnt;