yql/essentials/tests/sql/suites/select/dict_lookup.sql


1
2
3
4
5
6
7
8
9
10

/* syntax version 1 */
/* postgres can not */
use plato;
$dictList = (select
    AsDict(AsTuple(value, CAST(subkey AS Int32))) as `dict`,
    AsDict(AsTuple("z", "a"), AsTuple("y", "b")) AS d,
    subkey, value
from Input);

select d["z"] as static, input.`dict`[input.value] as dynamic, input.`dict` as `dict` from $dictList as input;