If I am doing select from any other tables i e hive or druid

Question

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>

Xiang Fu · Answer

check pinot catalog config ```pinot limit large for segment=2147483647```

Xiang Fu · Answer

wait are you using prestodb or trino

Xiang Fu · Answer

for trino set ```pinot max rows per split for segment queries=2147483647```

RK · Answer

It s prestrodb < Xiang Fu> version 350

Xiang Fu · Answer

if 350 then it s trino

RK · Answer

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>

RK · Answer

< 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 · Answer

In case of max value of integer it was showing this issue

Xiang Fu · Answer

ok

Xiang Fu · Answer

then you can make it a bit smaller I think

Xiang Fu · Answer

I think 2Billion is fine as well

Xiang Fu · Answer

As long as it s bigger than your max docs of one single segment

RK · Answer

Ok < Xiang Fu>