englefly commented on code in PR #17637:
URL: https://github.com/apache/doris/pull/17637#discussion_r1132266948


##########
fe/fe-core/src/main/java/org/apache/doris/nereids/stats/ExpressionEstimation.java:
##########
@@ -118,13 +164,13 @@ public ColumnStatistic 
visitBinaryArithmetic(BinaryArithmetic binaryArithmetic,
         double leftNullCount = leftColStats.numNulls;
         double rightNullCount = rightColStats.numNulls;
         double rowCount = context.getRowCount();
-        double numNulls = context.getRowCount()
-                * (1 - (1 - (leftNullCount / rowCount) * (1 - rightNullCount / 
rowCount)));
+        double numNulls = Math.max(leftNullCount, rightNullCount);

Review Comment:
   why change the formula?



##########
fe/fe-core/src/main/java/org/apache/doris/nereids/cost/CostModelV1.java:
##########
@@ -221,12 +221,7 @@ public Cost visitPhysicalHashJoin(
         pattern2: (L join1 Agg1) join2 agg2
         in pattern2, join1 and join2 takes more time, but Agg1 and agg2 can be 
processed in parallel.
         */
-        double penalty = HEAVY_OPERATOR_PUNISH_FACTOR
-                * Math.min(probeStats.getPenalty(), buildStats.getPenalty());
-        if (buildStats.getWidth() >= 2) {
-            //penalty for right deep tree
-            penalty += rightRowCount;
-        }
+        double penalty = HEAVY_OPERATOR_PUNISH_FACTOR;

Review Comment:
   penalty is not a constant. Do we need line224-229?



-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org

Reply via email to