yql/essentials/tests/sql/suites/optimizers/yql-8041-fuse_with_desc_map.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17

/* postgres can not */
USE plato;

$i = (
    SELECT
        cast(key as Double) as key,
        value
    FROM Input
    WHERE key < "100"
    ORDER BY key DESC
    LIMIT 1000
);

select distinct key
from $i
where value != ""
order by key;