yql/essentials/tests/sql/suites/blocks/guess_tuple_optional.yql


1
2
3
4
5
6
7
8
9

$tupleVariantType = Variant<Int32, String>;

$optionalData = [
    <|variantValue: Just(Variant(1,       "0", $tupleVariantType))|>,
    <|variantValue: Nothing(OptionalType($tupleVariantType))|>,
    <|variantValue: Just(Variant("hello", "1", $tupleVariantType))|>,
];

SELECT variantValue.0 AS intAlternative, variantValue.1 AS strAlternative FROM as_table($optionalData);