TPCDS integration test on higher scale factors fail on Presto CPU

[karthikeyann]

TPCDS integration test on higher scale factors like 0.1, 1 fail.

For scale-factor=0.1, 81 failed, 18 passed
For scale-factor=1, All queries failed

Steps to reproduce:

cd velox-testing/presto/testing/integration_tests/scripts
./generate_test_files.sh -s 0.1 -c
cd velox-testing/presto/scripts
./run_integ_test.sh -b tpcds

cd velox-testing/presto/testing/integration_tests/scripts
./generate_test_files.sh -s 1 -c
cd velox-testing/presto/scripts
./run_integ_test.sh -b tpcds

Please test for scale-factor=10 after the fix.

[karthikeyann]

For Java worker too, scale-factor=0.1 and For scale-factor=1, some queries fail.
12 failed, 87 passed
Q16 Q32 Q58 Q67 Q70 Q72 Q75 Q83 Q86 Q92 Q94 Q95 failed. (1 has incorrect output values, some are query unsupported issues)
Q67 output values mismatch.

Note that, For java workers, TPCH passes for all scale factors (0.01, 0.1, 1)

Ideally we should have all of these scale factors working with integration test for CPU.
Java unsupported queries is still okay to miss. But correctness issues should be fixed. (or report the issue to Presto repo)

E           prestodb.exceptions.PrestoUserError: PrestoUserError(type=USER_ERROR, name=SYNTAX_ERROR, message="line 1:251: '=' cannot be applied to date, varchar(10)", query_id=20260203_173804_00389_p3fsk)
E           prestodb.exceptions.PrestoUserError: PrestoUserError(type=USER_ERROR, name=SYNTAX_ERROR, message="line 1:886: '+' cannot be applied to date, integer", query_id=20260203_173825_00403_p3fsk)
E           prestodb.exceptions.PrestoUserError: PrestoUserError(type=USER_ERROR, name=SYNTAX_ERROR, message="line 1:258: IN value and list items must be the same type: date", query_id=20260203_173839_00414_p3fsk)
E           prestodb.exceptions.PrestoUserError: PrestoUserError(type=USER_ERROR, name=SYNTAX_ERROR, message="Invalid reference to output of SELECT clause from grouping() expression in ORDER BY", query_id=20260203_174113_00420_p3fsk)
E           prestodb.exceptions.PrestoUserError: PrestoUserError(type=USER_ERROR, name=SYNTAX_ERROR, message="line 1:444: Cannot check if date is BETWEEN varchar(10) and date", query_id=20260203_174119_00429_p3fsk)