CI TPCDS test q14b frequently fails intermittently (flaky failure) on Spark 3.0/3.1/3.2 versions, while it runs stably on higher Spark versions. ( Example failure job: link)
Reproduction
The failure is reproducible locally on Spark 3.1.
Failure Details
Failure occurs at stage 158, related to the final subquery and join in the q14b SQL:
Failure is in stage 158, related to the final subquery and join in the SQL:
Suspected Root Cause
Compatibility issues of the q14b final share HAVING filter subquery and join with Spark 3.0/3.1.