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


1
2
3
4
5
6
7
8

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

$data = [
    <|variantValue: Variant(1,       "a", $structVariantType)|>,
    <|variantValue: Variant("world", "b", $structVariantType)|>,
];

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