wz2020
June 27, 2021, 6:24pm
1
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
June 27, 2021, 6:25pm
2
@wz2020 Try this, add support key exec.disabled.gandiva-functions
and add value LEFT
and click save, retry query
See attached screenshot too
wz2020
June 29, 2021, 4:09pm
4
Dremio says "No Setting “exec.disabled.gandiva-functions” What now?
Hi @wz2020 What version of Dremio are you on?
wz2020
June 29, 2021, 9:45pm
6
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