aboutsummaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql/suites/join/cbo_4tables_a.txt.attr
blob: 295e5a3d06b87e4ae362f5eb7a82a4f06db41904 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
{
    "_yql_row_spec"={
        "Type"=["StructType";[
            ["Key1";["DataType";"Int32"]];
            ["Key2";["DataType";"String"]];
            ["Fk1";["OptionalType";["DataType";"String"]]];
            ["Value";["OptionalType";["DataType";"String"]]]]
        ];
        "SortDirections"=[1;1];
        "SortedBy"=["Key1";"Key2"];
        "SortedByTypes"=[["DataType";"Int32";];["DataType";"String"]];
        "SortMembers"=["Key1";"Key2"];
    };
    "schema" = <"strict" = %true; "unique_keys" = %false>
    [
        {
            "name" = "Key1";
            "sort_order" = "ascending";
            "type" = "int64";
            "type_v3" = {"type_name" = "optional"; item = "int64"}
        };
        {
            "name" = "Key2";
            "sort_order" = "ascending";
            "type" = "string";
            "type_v3" = {"type_name" = "optional"; item = "string"}
        };
        {
            "name" = "Fk1";
            "type" = "string";
            "type_v3" = {"type_name" = "optional"; item = "string"}
        };
        {
            "name" = "Value";
            "type" = "string";
            "type_v3" = {"type_name" = "optional"; item = "string"}
        };
    ];
    "extended_stats" = [
        {
            "column_name" = "Key1";
            "data_weight" = 56;
            "num_unique_vals" = 11;
        };
        {
            "column_name" = "Key2";
            "data_weight" = 66;
            "num_unique_vals" = 5;
        };
        {
            "column_name" = "Fk1";
            "data_weight" = 70;
            "num_unique_vals" = 5;
        };
        {
            "column_name" = "Value";
            "data_weight" = 98;
            "num_unique_vals" = 6;
        }
    ]
}