IllegalArgumentException: the requested size must be non-negative

1

When executing a reflection with a selected field set to partition on 3.0, the reflection failed with the following message:

IllegalArgumentException: the requested size must be non-negative

However, when running the same data set on 2.0.5, it works.

Any idea what the issue may be?

2

Hi @trang, could you download the profile of the reflection job that fails and share it here? note you’ll need to check the “accelerator” checkbox on the jobs tab to see the failed reflection job: image

3

Hi @trang

Can you please try to set the below parameter under Admin-Support-Support Key,

Enter planner.op.sort.limit click show and enter 1 GB in bytes (1073741824) and try to run the query?

For experimenting you can bump it up which will make it faster but might hit the above error

Thanks
@balaji.ramaswamy