Also, seems the table is not partitioned as well. ...
# troubleshootingj
Jackie
12/28/2020, 7:16 PMAlso, 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 PMI have 1 topic kafka 1 partition ... on pinot I repli it as 4 tables on 4 server nodes
lâm nguyễn hoàng
12/28/2020, 7:21 PMproblem 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 PMYou need to enable partition routing for upsert to work
Jackie
12/28/2020, 7:24 PMIf 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 PMIf there is only 1 Kafka partition, the query have to hit only 1 server ---> yes
lâm nguyễn hoàng
12/28/2020, 7:25 PMbut 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 PMHmm.. this is unexpected
Jackie
12/28/2020, 7:27 PMCan 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 PMCan 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 PMCan you try distinct count on the primary key column?
Jackie
12/28/2020, 7:36 PMAlso check if there is ERROR logged on the servers