--! qt:dataset:src

EXPLAIN CBO
SELECT *
FROM src src1
  JOIN src src2 ON (src1.key = src2.key)
  JOIN src src3 ON (src1.key = src3.key)
WHERE src1.key > 10 and src1.key < 20;

set hive.cbo.rule.exclusion.regex=HiveJoinPushTransitivePredicatesRule;

EXPLAIN CBO
SELECT *
FROM src src1
  JOIN src src2 ON (src1.key = src2.key)
  JOIN src src3 ON (src1.key = src3.key)
WHERE src1.key > 10 and src1.key < 20;

set hive.cbo.rule.exclusion.regex=HiveJoinPushTransitivePredicatesRule|HiveJoinAddNotNullRule;

EXPLAIN CBO
SELECT *
FROM src src1
  JOIN src src2 ON (src1.key = src2.key)
  JOIN src src3 ON (src1.key = src3.key)
WHERE src1.key > 10 and src1.key < 20;

set hive.cbo.rule.exclusion.regex=HiveJoin.*Rule;

EXPLAIN CBO
SELECT *
FROM src src1
  JOIN src src2 ON (src1.key = src2.key)
  JOIN src src3 ON (src1.key = src3.key)
WHERE src1.key > 10 and src1.key < 20;

set hive.cbo.rule.exclusion.regex=.*;

EXPLAIN CBO
SELECT *
FROM src src1
  JOIN src src2 ON (src1.key = src2.key)
  JOIN src src3 ON (src1.key = src3.key)
WHERE src1.key > 10 and src1.key < 20;