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.
@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