https://pinot.apache.org/ logo
j

Jackie

12/28/2020, 7:16 PM
Also, seems the table is not partitioned as well. @Yupeng Fu I remember there is a check on the table config to enforce the partitioning?
l

lâm nguyễn hoàng

12/28/2020, 7:20 PM
I have 1 topic kafka 1 partition ... on pinot I repli it as 4 tables on 4 server nodes
problem 1 I query on this table the number of rows is missing ... even though I configured replicasPerPartition to be 4 @Jackie
j

Jackie

12/28/2020, 7:23 PM
You need to enable partition routing for upsert to work
If there is only 1 Kafka partition, the query have to hit only 1 server
l

lâm nguyễn hoàng

12/28/2020, 7:25 PM
If there is only 1 Kafka partition, the query have to hit only 1 server ---> yes
but on 4 server nodes instead of returning the same number of rows ... but here the number of rows is not the same on 4 nodes
j

Jackie

12/28/2020, 7:27 PM
Hmm.. this is unexpected
Can you try disabling the upsert with query options and see if the results are the same?
l

lâm nguyễn hoàng

12/28/2020, 7:31 PM
Can you try disabling the upsert with query options and see if the results are the same? --> yes result same when off upsert
j

Jackie

12/28/2020, 7:36 PM
Can you try distinct count on the primary key column?
Also check if there is ERROR logged on the servers