bvarghese1 commented on code in PR #29285:
URL: https://github.com/apache/flink/pull/29285#discussion_r4221182102
##########
flink-table/flink-table-planner/src/test/java/org/apache/flink/table/planner/plan/optimize/program/FlinkRuntimeFilterProgramTest.java:
##########
@@ -152,7 +152,11 @@ void testNestedLoopJoin() throws Exception {
// runtime filter will not succeed
setupTableRowCount("dim", 1L);
setupTableRowCount("fact", SUITABLE_FACT_ROW_COUNT);
- String query = "select * from fact, dim where fact.amount = dim.amount
and dim.price < 500";
+ // force nested loop join explicitly using a hint
+ // with an equi-condition, the CBO now prefers a hash join over nested
loop join
+ String query =
+ "select /*+ NEST_LOOP(dim) */ * from fact, dim"
+ + " where fact.amount = dim.amount and dim.price <
500";
Review Comment:
Fixed
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
