Limit List field exceeded the maximum number of elements 128


I’ve encountered since I am on Community Edition v14.0 the error
List field exceeded the maximum number of elements 128, as some of my parquet files have list with more than 128 items.

I did not have this error message in the past (with v4.9)
Do you confirm it’s a new limit ? I do not see it in documentation about limits : Dremio
Is there any way to change this limit ?


Here is the error log :

2021-03-29 09:50:56,145 [grpc-default-executor-16139] INFO - User Error Occurred [ErrorId: 1e156f0f-2185-4028-b241-1e8b016b8327]
com.dremio.common.exceptions.UserException: List field ‘data_cart_items’ exceeded the maximum number of elements 128
at com.dremio.common.exceptions.UserException$
at org.apache.arrow.flight.FlightService.doGetCustom(
at org.apache.arrow.flight.FlightBindingService$DoGetMethod.invoke(
at org.apache.arrow.flight.FlightBindingService$DoGetMethod.invoke(
at io.grpc.stub.ServerCalls$UnaryServerCallHandler$UnaryServerCallListener.onHalfClose(
at io.grpc.PartialForwardingServerCallListener.onHalfClose(
at io.grpc.ForwardingServerCallListener.onHalfClose(
at io.grpc.ForwardingServerCallListener$SimpleForwardingServerCallListener.onHalfClose(
at io.grpc.util.TransmitStatusRuntimeExceptionInterceptor$1.onHalfClose(
at io.grpc.internal.ServerCallImpl$ServerStreamListenerImpl.halfClosed(
at io.grpc.internal.ServerImpl$JumpToApplicationThreadServerStreamListener$1HalfClosed.runInContext(
at java.util.concurrent.ThreadPoolExecutor.runWorker(
at java.util.concurrent.ThreadPoolExecutor$


Dremio did not support complex type resolution during planning in v4.9 and were treating the datatype is a mixed type. In the current version, the planner detects the right data type as ARRAY and hit the maximum elements per LIST limit

How many such datasets are affected?


I think only one dataset is affected, but not the least important unfortunately.
More than 128 cart items is frequent in FMCG baskets.

If there is no way to use this dataset anymore, I will need to process all the data beforehand by flattening it.

@dfleckinger Here you go “store.parquet.list_items.threshold”

Thanks @balaji.ramaswamy , works great ! That fixed my issue