Presto TPCDS Runtime errors due to unsupported features

[karthikeyann]

When running with Presto GPU run with fallback, no runtime errors should be thrown for expression coverage, and aggregation coverage.
A few of TPCDS queries still thrown runtime errors. These should be caught early during CPU fallback, or expression evaluator should be fixed to use both functions and AST.

Here are the runtime errors for TPCDS Scale factor 1.

=== short test summary info ===
[Q4] - prestodb.exceptions.PrestoQueryError: PrestoQueryError(type=INTERNAL_ERROR, name=GENERIC_INTERNAL_ERROR, message=" Unsupported expression: switch", query_id=20251215_120624_00008_usfhy)
[Q11] - prestodb.exceptions.PrestoQueryError: PrestoQueryError(type=INTERNAL_ERROR, name=GENERIC_INTERNAL_ERROR, message=" Unsupported expression: switch", query_id=20251215_120629_00015_usfhy)
[Q15] - prestodb.exceptions.PrestoQueryError: PrestoQueryError(type=INTERNAL_ERROR, name=GENERIC_INTERNAL_ERROR, message=" Unsupported expression: substring", query_id=20251215_120633_00019_usfhy)
[Q17] - prestodb.exceptions.PrestoQueryError: PrestoQueryError(type=INTERNAL_ERROR, name=GENERIC_INTERNAL_ERROR, message=" Aggregation not yet supported, kind: presto.default.stddev_samp", query_id=20251215_120633_00021_usfhy)
[Q19] - prestodb.exceptions.PrestoQueryError: PrestoQueryError(type=INTERNAL_ERROR, name=GENERIC_INTERNAL_ERROR, message=" Unsupported expression: substring", query_id=20251215_120634_00023_usfhy)
[Q24] - prestodb.exceptions.PrestoQueryError: PrestoQueryError(type=INTERNAL_ERROR, name=GENERIC_INTERNAL_ERROR, message=" Unsupported expression: upper", query_id=20251215_120637_00028_usfhy)
[Q31] - prestodb.exceptions.PrestoQueryError: PrestoQueryError(type=INTERNAL_ERROR, name=GENERIC_INTERNAL_ERROR, message=" Unsupported expression: switch", query_id=20251215_120641_00035_usfhy)
[Q34] - prestodb.exceptions.PrestoQueryError: PrestoQueryError(type=INTERNAL_ERROR, name=GENERIC_INTERNAL_ERROR, message=" Decimal not supported", query_id=20251215_120643_00038_usfhy)
[Q39] - prestodb.exceptions.PrestoQueryError: PrestoQueryError(type=INTERNAL_ERROR, name=GENERIC_INTERNAL_ERROR, message=" Aggregation not yet supported, kind: presto.default.stddev_samp", query_id=20251215_120645_00043_usfhy)
[Q49] - prestodb.exceptions.PrestoQueryError: PrestoQueryError(type=INTERNAL_ERROR, name=GENERIC_INTERNAL_ERROR, message=" Operator::getOutput failed for [operator: CudfFilterProject, plan node ID: 11]: CUDF failure at:/presto_native_...
[Q72] - prestodb.exceptions.PrestoQueryError: PrestoQueryError(type=INTERNAL_ERROR, name=GENERIC_INTERNAL_ERROR, message=" Operator::getOutput failed for [operator: CudfHashJoinProbe, plan node ID: 3111]: CUDF failure at:/presto_nativ...
[Q73] - prestodb.exceptions.PrestoQueryError: PrestoQueryError(type=INTERNAL_ERROR, name=GENERIC_INTERNAL_ERROR, message=" Decimal not supported", query_id=20251215_120711_00076_usfhy)
[Q74] - prestodb.exceptions.PrestoQueryError: PrestoQueryError(type=INTERNAL_ERROR, name=GENERIC_INTERNAL_ERROR, message=" Unsupported expression: switch", query_id=20251215_120711_00077_usfhy)
[Q75] - prestodb.exceptions.PrestoQueryError: PrestoQueryError(type=INTERNAL_ERROR, name=GENERIC_INTERNAL_ERROR, message=" Decimal not supported", query_id=20251215_120712_00078_usfhy)
[Q90] - prestodb.exceptions.PrestoQueryError: PrestoQueryError(type=INTERNAL_ERROR, name=GENERIC_INTERNAL_ERROR, message=" Decimal not supported", query_id=20251215_120721_00092_usfhy)
15 failed, 82 passed in 62.03s (0:01:02)

Q18 and Q70 crashes, so replaced with a stub run in this log (Tracked in issue #148 )

Attached tpcds_benchmark_presto_gpu_runtime_errors.log