Using llvm-9 and clang-9 will encounter hanging issue when running q14a.sql on ubuntu cluster.

[haojinIntel]

For OAP-1.4 testing, we encounter hanging issue when running q14a.sql on our ubuntu cluster. When we set "spark.oap.sql.columnar.hashagg" equal to false, the query can pass.

[PHILO-HE]

I guess this issue is related to our recent patch that forcing to replace sort agg with hash agg.

[haojinIntel]

@zhouyuan @PHILO-HE The issue is caused by llvm-9 and clang-9. After I exchange the version from 9 to 7, the issue not occurred again.

[zhouyuan]

@haojinIntel thanks for the clarify! ideally LLVM9 should also work