Docker crashes when Using the Random() function in a SQL query

1

Hello,

The dremio docker container crashes, and requires to be started again after running one of the following queries:

  • SELECT RANDOM()
  • SELECT RAND()
  • A Query that uses one of the RANDOM(), or RAND() functions.

Notice that if the seed value is provided in the query, everything is fine. However, according to the dremio documentation it should also work without providing the seed value:

My dremio version: 24.3.0-202312220021110714-f19d865e

Thanks,
Babak

2

@babak Just to narrow down the issue, can you try adding the support key exec.disabled.gandiva-functions and then enter RANDOM in the field and save. Then try to use SELECT RANDOM() and see if the docker does not crash