# debug_upsert
- k
Kishore G
03/12/2021, 5:23 PM@User @User - m
Matteo Satnero
03/12/2021, 5:26 PMimage.png - m
Matteo Satnero
03/12/2021, 5:26 PMimage.png - m
Matteo Satnero
03/12/2021, 5:26 PMimage.png - m
Matteo Satnero
03/12/2021, 5:26 PMimage.png - m
Matteo Satnero
03/12/2021, 5:26 PMCopy codeupsertConfig mode true in REALTIME pinot 0.6.0 presto 0.247 dbeaver 21.0.0.202103021012 - j
Jackie
03/12/2021, 6:58 PM@User For the same primary key, there should be only one server queried - j
Jackie
03/12/2021, 6:59 PMPlease check if the kafka stream is properly partitioned - j
Jackie
03/12/2021, 7:03 PMSorry, didn't notice the other thread that this is a hybrid table. As Yupeng mentioned, upsert does not work on hybrid table - k
Kishore G
03/12/2021, 7:04 PMRight.. do we have an eta on allowing batch updates to upsert enabled tables? - k
Kishore G
03/12/2021, 7:05 PMWe should flag this error somewhere - m
Matteo Satnero
03/13/2021, 8:22 AMHello, thank you very much to all of you for the infos. At the moment we bypassed the case by using a rank&rownum(in case of exact duplications) = 1 on presto, the strange thing is that on web interface was showing it in the desired way. Thank you very much again for all the infos and I paste here the Yupeng note so we can have all in same chat Yupeng Fu: “yes, upsert is only for realtime table now. there is an ongoing PR to address upsert table with longer retention” Design doc: https://github.com/apache/incubator-pinot/pull/6567 - d
Deepak Mishra
07/07/2021, 9:32 AMHello Everyone - k
Kishore G
07/07/2021, 1:35 PMCan you elaborate? - k
Kishore G
07/07/2021, 1:35 PMAlso, ask this in #C011C9JHN7R - d
Deepak Mishra
07/08/2021, 11:46 AMHello everyone , i would like to understand how can backfill offline data which contains multiple segment. - y
Yupeng Fu
07/08/2021, 4:20 PMupsert table takes real time data only - j
Jeff Moszuti
12/11/2021, 9:40 AM@User has left the channel