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


1
2
3
4
5
6
7
8
9

$structVariantType = Variant<a: Int32, b: String>;

$optionalVariantData = [
    <|variantValue: Just(Variant(1,       "a", $structVariantType))|>,
    <|variantValue: Nothing(OptionalType($structVariantType))|>,
    <|variantValue: Just(Variant("hello", "b", $structVariantType))|>,
];

SELECT variantValue.a AS aAlternative, variantValue.b AS bAlternative FROM as_table($optionalVariantData);