gistfile1.txt

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 - Output[rows] => [rows:bigint]
     - TableCommit[hive:HiveTransactionHandle{uuid=455b2996-33e3-48a4-bad3-9e3490bf4b40}:default.nation] => [rows:bigint]
             Collected statistics:
                 aggregations =>
                     NUMBER_OF_NULLS[nationkey] => [number_of_nulls-nationkey := "count"("count")]
                     MIN[nationkey] => [min-nationkey := "min"("min")]
                     MAX[nationkey] => [max-nationkey := "max"("max")]
                     NUMBER_OF_DISTINCT_VALUES[nationkey] => [number_of_distinct_values-nationkey := "approx_distinct"("approx_distinct")]
                     NUMBER_OF_NULLS[name] => [number_of_nulls-name := "count"("count_19")]
                     NUMBER_OF_DISTINCT_VALUES[name] => [number_of_distinct_values-name := "approx_distinct"("approx_distinct_20")]
                     MAX_VALUE_SIZE_IN_BYTES[name] => [max_value_size_in_bytes-name := "max"("max_21")]
                     AVERAGE_VALUE_SIZE_IN_BYTES[name] => [average_value_size_in_bytes-name := "avg"("avg")]
                     NUMBER_OF_NULLS[regionkey] => [number_of_nulls-regionkey := "count"("count_22")]
                     MIN[regionkey] => [min-regionkey := "min"("min_23")]
                     MAX[regionkey] => [max-regionkey := "max"("max_24")]
                     NUMBER_OF_DISTINCT_VALUES[regionkey] => [number_of_distinct_values-regionkey := "approx_distinct"("approx_distinct_25")]
                 grouped by => [comment := comment]
         - LocalExchange[SINGLE] () => partialrows:bigint, fragment:varbinary, comment:varchar(152), count:bigint, min:bigint, max:bigint, approx_distinct:HyperLogLog, count_19:bigint, approx_distinct_20:HyperLogLog, max_21:bigint, avg:row(double, bi
             - RemoteExchange[GATHER] => partialrows:bigint, fragment:varbinary, comment:varchar(152), count:bigint, min:bigint, max:bigint, approx_distinct:HyperLogLog, count_19:bigint, approx_distinct_20:HyperLogLog, max_21:bigint, avg:row(double,
                 - TableWriter => [partialrows:bigint, fragment:varbinary, comment:varchar(152), count:bigint, min:bigint, max:bigint, approx_distinct:HyperLogLog, count_19:bigint, approx_distinct_20:HyperLogLog, max_21:bigint, avg:row(double, bigint
                         nationkey := nationkey
                         name := name
                         regionkey := regionkey
                         comment := comment
                         Collected statistics:
                             aggregations =>
                                 NUMBER_OF_NULLS[nationkey] => [count := "count"("expr_15")]
                                 MIN[nationkey] => [min := "min"("nationkey")]
                                 MAX[nationkey] => [max := "max"("nationkey")]
                                 NUMBER_OF_DISTINCT_VALUES[nationkey] => [approx_distinct := "approx_distinct"("nationkey")]
                                 NUMBER_OF_NULLS[name] => [count_19 := "count"("expr_16")]
                                 NUMBER_OF_DISTINCT_VALUES[name] => [approx_distinct_20 := "approx_distinct"("name")]
                                 MAX_VALUE_SIZE_IN_BYTES[name] => [max_21 := "max"("length")]
                                 AVERAGE_VALUE_SIZE_IN_BYTES[name] => [avg := "avg"("length")]
                                 NUMBER_OF_NULLS[regionkey] => [count_22 := "count"("expr_18")]
                                 MIN[regionkey] => [min_23 := "min"("regionkey")]
                                 MAX[regionkey] => [max_24 := "max"("regionkey")]
                                 NUMBER_OF_DISTINCT_VALUES[regionkey] => [approx_distinct_25 := "approx_distinct"("regionkey")]
                             grouped by => [comment := comment]
                     - LocalExchange[SINGLE] () => nationkey:bigint, name:varchar(25), regionkey:bigint, comment:varchar(152), expr_15:bigint, expr_16:bigint, length:bigint, expr_18:bigint
                             Cost: {rows: 25 (1.95kB), cpu: 3000.00, memory: 0.00, network: 0.00}
                         - ScanProject[table = tpch:tpch:nation:sf0.01, originalConstraint = true] => [nationkey:bigint, name:varchar(25), regionkey:bigint, comment:varchar(152), expr_15:bigint, expr_16:bigint, length:bigint, expr_18:bigint]
                                 Cost: {rows: 25 (1000B), cpu: 1000.00, memory: 0.00, network: 0.00}/{rows: 25 (1.95kB), cpu: 3000.00, memory: 0.00, network: 0.00}
                                 expr_15 := (CASE WHEN ("nationkey" IS NULL) THEN BIGINT '1' END)
                                 expr_16 := (CASE WHEN ("name" IS NULL) THEN BIGINT '1' END)
                                 length := "length"(CAST("name" AS varbinary))
                                 expr_18 := (CASE WHEN ("regionkey" IS NULL) THEN BIGINT '1' END)
                                 nationkey := tpch:nationkey
                                 regionkey := tpch:regionkey
                                 name := tpch:name
                                 comment := tpch:comment

(1 row)