[BUG] Spark-4.0: Tests failures in GpuLoreSuite

[nartal1]

Describe the bug
Below unit tests(scala tests) are failing in GpuLoreSuite
Total test failures : 6

Pasting the error message which have different reasons for the failure.

1. - Aggregate *** FAILED ***
  java.lang.IllegalArgumentException: Part of the plan is not columnar class org.apache.spark.sql.execution.aggregate.HashAggregateExec
HashAggregate(keys=[key#1L], functions=[sum(value#2L)], output=[key#1L, total#3L])
+- Exchange hashpartitioning(key#1L, 200), ENSURE_REQUIREMENTS, [plan_id=43]
   +- HashAggregate(keys=[key#1L], functions=[partial_sum(value#2L)], output=[key#1L, sum#8L])

2. - AQE broadcast *** FAILED ***
  java.lang.IllegalArgumentException: Part of the plan is not columnar class org.apache.spark.sql.execution.exchange.ShuffleExchangeExec
Exchange hashpartitioning(key#91L, 200), ENSURE_REQUIREMENTS, [plan_id=796]
+- HashAggregate(keys=[key#91L], functions=[partial_sum(value#92L)], output=[key#91L, sum#105L])
   +- GpuColumnarToRow false
      +- GpuProject [(id#90L % 10) AS key#91L, (id#90L % 100) AS value#92L], [loreId=29]
         +- GpuCoalesceBatches targetsize(1073741824)
            +- GpuFilter gpuisnotnull((id#90L % 10)), [loreId=28]
               +- GpuRange (0, 1000, step=1, splits=10)

Steps/Code to reproduce bug

$ mvn package -f scala2.13/pom.xml -pl tests -am -Dbuildver=400 -Dsuffixes=".*GpuLoreSuite"

Expected behavior
Tests must either pass or skip with valid reason in the test suite.

[nartal1]

We will have to skip these tests for Spark-4.0. i.e disable ANSI mode for these failing tests.
We need to enable the tests once #5114 if fixed. Mention the issue number to track.