If I am doing select from any other tables .i.e. hive or druid I am able to select data .but in case of pinot in throwing this error. Some problem with this prestro-pinot connector.kindly suggest if is there any why to select data directly from pinot without prestro connector or any way to increase this limit. @Xiang Fu@Jackie
Ohh ok in logs everywhere I am getting prestrosql so I thought it's prestrodb.
Ok let me try with trino property then. Thanks alot @Xiang Fu
@Xiang Fu thanks alot it worked. One update had to decrease the max row limit from Int max size value i.e. 2147483647 otherwise it was taking the minimum value of Int i.e. -2147483648 and again showing limit error.
In case of max value of integer , it was showing this issue
x
Xiang Fu
06/08/2021, 10:09 AM
ok
then you can make it a bit smaller I think
I think 2Billion is fine as well
As long as it’s bigger than your max docs of one single segment