Simple LEFT call crashes the executors

I have a simple query and the LEFT call here is crashing the executor, I’m on release 13:

SELECT eh.wtask_id, eh.sztp_id, LEFT(cast(eh.sztp_id as VARCHAR(20)),1) as TEST

FROM zlo.“base_data_replicated”.“mtms_equipment_history_replicated” eh

WHERE eh.remover IS NULL AND eh.wtask_id IN(‘RFULLIN’,‘RMTIN’,‘RFULLOUT’,‘RMTOUT’,‘RDRAYIN’)

AND eh.posted>=‘2021-06-01 08:00:00’;

I have also uploaded the profile. Please let me know what you find.

dbbfb044-6d07-4219-9b61-e23bc9268fc0.zip (43.4 KB)

@wz2020 Try this, add support key exec.disabled.gandiva-functions and add value LEFT and click save, retry query

See attached screenshot too

Dremio says "No Setting “exec.disabled.gandiva-functions” What now?

Hi @wz2020 What version of Dremio are you on?

Release 13 as in my question. I see the key is only available in 14. Any alternative other than upgrade? What’s strange is this just started happening last week.

@wz2020 Upgrade would be the best solution here