https://pinot.apache.org/ logo
#general
Title
# general
t

Trust Okoroego

07/24/2021, 11:01 AM
Hi group, I am trying to do a join of two realtime tables, but I get an error that my segment is empty
presto error: null value in entry: Server_172.23.0.5_8098=null.
when I check the realtime table I don't have segments already created. but when I query the same table without a join it returns a result
k

Kishore G

07/26/2021, 5:51 AM
Hi @User we’re you able to resolve this issue?
t

Trust Okoroego

07/26/2021, 7:05 AM
Yes. Basically this is related to how Presto executes the query in Pinot. If there are no aggregation in the query, Presto queries the segments directly without going through the broker, since my real-time time table is not yet committed, no segment exist thus the reason for the error. To solve it, basically I added a count(1) in the query just to trick Presto into seeing it as an aggregation query. Another solution is to change the presto connector setting
pinot.forbid-segment-queries
to true. This ensure all queries goes through the broker which I don't prefer since I will have offline tables and do not want overwhelm the brokers.
k

Kishore G

07/26/2021, 7:27 AM
That seems like a bug.. consuming segments should be included cc @User
t

Trust Okoroego

07/26/2021, 2:22 PM
@User I am not sure if it is a bug since this is documented in the Pinot connector in presto connectors documentation. https://prestodb.io/docs/current/connector/pinot.html
x

Xiang Fu

07/27/2021, 4:33 AM
Please refer to this issue: https://github.com/apache/pinot/issues/7183 @User is on this.
m

Maitraiyee Gautam

08/17/2021, 9:55 PM
@User @User