If I am doing select from any other tables .i.e. h...
# troubleshootingr
RK
06/08/2021, 6:39 AMIf 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
x
Xiang Fu
06/08/2021, 6:44 AM
check pinot catalog config :
Copy code
pinot.limit-large-for-segment=2147483647Xiang Fu
06/08/2021, 7:10 AM
wait, are you using prestodb or trino?
Xiang Fu
06/08/2021, 7:23 AM
for trino,set
Copy code
pinot.max-rows-per-split-for-segment-queries=2147483647r
RK
06/08/2021, 7:25 AMIt's prestrodb @Xiang Fu version 350
x
Xiang Fu
06/08/2021, 7:26 AM
if 350, then it’s trino
r
RK
06/08/2021, 7:28 AMOhh 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
RK
06/08/2021, 9:47 AM@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.
RK
06/08/2021, 9:48 AMIn case of max value of integer , it was showing this issue
x
Xiang Fu
06/08/2021, 10:09 AM
ok
Xiang Fu
06/08/2021, 10:09 AM
then you can make it a bit smaller I think
Xiang Fu
06/08/2021, 10:10 AM
I think 2Billion is fine as well
Xiang Fu
06/08/2021, 10:10 AM
As long as it’s bigger than your max docs of one single segment
r
RK
06/08/2021, 10:23 AMOk @Xiang Fu