cbo_4tables_a.txt.attr 1.7 KB

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