[SPARK-29604][SQL][FOLLOWUP][test-hadoop3.2] Let SparkSQLEnvSuite to be run in dedicated JVM
[SPARK-29604][SQL][FOLLOWUP][test-hadoop3.2] Let SparkSQLEnvSuite to be run in dedicated JVM

### What changes were proposed in this pull request?

This patch addresses CI build issue on sbt Hadoop-3.2 Jenkins job: SparkSQLEnvSuite are failing. Looks like the reason of test failure is the test checks registered listeners from active SparkSession which could be interfered with other test suites running concurrently. If we isolate test suite the problem should be gone.

### Why are the changes needed?

CI builds for "spark-master-test-sbt-hadoop-3.2" are failing.

### Does this PR introduce any user-facing change?

No.

### How was this patch tested?

I've run the single test suite with below command and it passed 3 times sequentially:

```
build/sbt "hive-thriftserver/testOnly *.SparkSQLEnvSuite" -Phadoop-3.2 -Phive-thriftserver
```

so we expect the test suite will pass if we isolate the test suite.

Closes #26342 from HeartSaVioR/SPARK-29604-FOLLOWUP.

Authored-by: Jungtaek Lim (HeartSaVioR) <6dfb5872701d21af1c4dd7add991df02fba61fbf@gmail.com>
Signed-off-by: Dongjoon Hyun <9b02cb7e37158797a8e22c559f7c5f5ecd28ea57@apple.com>

milliman/spark,zzcclp/spark,holdenk/spark,milliman/spark,taroplus/spark,hvanhovell/spark,WeichenXu123/spark,taroplus/spark,hvanhovell/spark,kevinyu98/spark,ptkool/spark,zero323/spark,vinodkc/spark,zzcclp/spark,JoshRosen/spark,jiangxb1987/spark,darionyaphet/spark,dbtsai/spark,ConeyLiu/spark,dbtsai/spark,chuckchen/spark,dbtsai/spark,shaneknapp/spark,witgo/spark,xuanyuanking/spark,zuotingbing/spark,cloud-fan/spark,milliman/spark,nchammas/spark,gengliangwang/spark,ptkool/spark,jiangxb1987/spark,vinodkc/spark,kevinyu98/spark,HyukjinKwon/spark,cloud-fan/spark,zuotingbing/spark,spark-test/spark,hvanhovell/spark,shaneknapp/spark,rednaxelafx/apache-spark,nchammas/spark,zzcclp/spark,mahak/spark,dongjoon-hyun/spark,zzcclp/spark,ueshin/apache-spark,holdenk/spark,xuanyuanking/spark,wzhfy/spark,dongjoon-hyun/spark,wangyum/spark,ConeyLiu/spark,JoshRosen/spark,gengliangwang/spark,spark-test/spark,vinodkc/spark,apache/spark,wangyum/spark,dongjoon-hyun/spark,ConeyLiu/spark,wangmiao1981/spark,zzcclp/spark,nchammas/spark,BryanCutler/spark,milliman/spark,srowen/spark,mahak/spark,ptkool/spark,HyukjinKwon/spark,skonto/spark,wangyum/spark,cloud-fan/spark,HyukjinKwon/spark,wangmiao1981/spark,dongjoon-hyun/spark,spark-test/spark,wzhfy/spark,skonto/spark,darionyaphet/spark,milliman/spark,hvanhovell/spark,apache/spark,shuangshuangwang/spark,goldmedal/spark,holdenk/spark,srowen/spark,srowen/spark,taroplus/spark,ueshin/apache-spark,xuanyuanking/spark,BryanCutler/spark,caneGuy/spark,zuotingbing/spark,mahak/spark,ueshin/apache-spark,ueshin/apache-spark,vinodkc/spark,jiangxb1987/spark,wangmiao1981/spark,vinodkc/spark,vinodkc/spark,taroplus/spark,caneGuy/spark,shaneknapp/spark,caneGuy/spark,dongjoon-hyun/spark,HyukjinKwon/spark,nchammas/spark,chuckchen/spark,witgo/spark,wzhfy/spark,shuangshuangwang/spark,vinodkc/spark,maropu/spark,cloud-fan/spark,mahak/spark,BryanCutler/spark,ptkool/spark,maropu/spark,WeichenXu123/spark,shuangshuangwang/spark,mahak/spark,shuangshuangwang/spark,goldmedal/spark,skonto/spark,milliman/spark,rednaxelafx/apache-spark,rednaxelafx/apache-spark,apache/spark,zero323/spark,apache/spark,shuangshuangwang/spark,WeichenXu123/spark,JoshRosen/spark,goldmedal/spark,shaneknapp/spark,cloud-fan/spark,wangmiao1981/spark,caneGuy/spark,taroplus/spark,dongjoon-hyun/spark,BryanCutler/spark,wangyum/spark,xuanyuanking/spark,goldmedal/spark,JoshRosen/spark,BryanCutler/spark,spark-test/spark,maropu/spark,gengliangwang/spark,BryanCutler/spark,holdenk/spark,dbtsai/spark,zuotingbing/spark,nchammas/spark,holdenk/spark,taroplus/spark,wangmiao1981/spark,kevinyu98/spark,goldmedal/spark,spark-test/spark,jiangxb1987/spark,chuckchen/spark,wzhfy/spark,chuckchen/spark,wzhfy/spark,jkbradley/spark,dbtsai/spark,maropu/spark,ConeyLiu/spark,kevinyu98/spark,kevinyu98/spark,ptkool/spark,shaneknapp/spark,srowen/spark,ptkool/spark,caneGuy/spark,darionyaphet/spark,JoshRosen/spark,goldmedal/spark,cloud-fan/spark,apache/spark,spark-test/spark,mahak/spark,chuckchen/spark,HyukjinKwon/spark,zero323/spark,nchammas/spark,srowen/spark,witgo/spark,witgo/spark,HyukjinKwon/spark,WeichenXu123/spark,gengliangwang/spark,holdenk/spark,wzhfy/spark,darionyaphet/spark,chuckchen/spark,zuotingbing/spark,jkbradley/spark,wzhfy/spark,witgo/spark,ConeyLiu/spark,rednaxelafx/apache-spark,skonto/spark,srowen/spark,xuanyuanking/spark,caneGuy/spark,HyukjinKwon/spark,jkbradley/spark,wangyum/spark,shuangshuangwang/spark,shaneknapp/spark,zzcclp/spark,ueshin/apache-spark,zzcclp/spark,goldmedal/spark,ueshin/apache-spark,xuanyuanking/spark,zero323/spark,srowen/spark,ConeyLiu/spark,jiangxb1987/spark,zero323/spark,apache/spark,xuanyuanking/spark,gengliangwang/spark,JoshRosen/spark,hvanhovell/spark,matthewfranglen/spark,ueshin/apache-spark,milliman/spark,darionyaphet/spark,wangyum/spark,dongjoon-hyun/spark,dbtsai/spark,ConeyLiu/spark,rednaxelafx/apache-spark,BryanCutler/spark,maropu/spark,wangyum/spark,zero323/spark,mahak/spark,gengliangwang/spark,WeichenXu123/spark,zuotingbing/spark,maropu/spark,skonto/spark,zuotingbing/spark,cloud-fan/spark,jkbradley/spark,gengliangwang/spark,maropu/spark,zero323/spark,spark-test/spark,kevinyu98/spark,jkbradley/spark,nchammas/spark,taroplus/spark,rednaxelafx/apache-spark,jkbradley/spark,holdenk/spark,darionyaphet/spark,skonto/spark,skonto/spark,shaneknapp/spark,WeichenXu123/spark,WeichenXu123/spark,wangmiao1981/spark,hvanhovell/spark,JoshRosen/spark,witgo/spark,witgo/spark,apache/spark,ptkool/spark,hvanhovell/spark,darionyaphet/spark,shuangshuangwang/spark,kevinyu98/spark,caneGuy/spark,rednaxelafx/apache-spark,jiangxb1987/spark,jkbradley/spark,dbtsai/spark,chuckchen/spark,wangmiao1981/spark,jiangxb1987/spark