Hello Here, I am new in Pinot and Presto, so maybe my question has an obvious explenation I am not seeing. I ve a table split in OFFLINE and REALTIME, with a defined key and time. From pinot interface I am getting 1 record (the OFFLINE one) while from Presto by DBeaver client I am getting 2 records (one for each table) Is there something I am missing in thew configuration for this?

upsertConfig mode true in REALTIME
pinot 0.6.0
presto 0.247
dbeaver 21.0.0.202103021012

Thanks you very much in advance

have you turned on upsert?

i supposed that the

upsertConfig mode true

mean yes but probably is not enough

I dont think upsert can support hybrid table's as of today.. @Yupeng Fu ^^

I don’t know if is something i forgot on the link between the 2 systems

yes, upsert is only for realtime table now. there is an ongoing PR to address upsert table with longer retention https://github.com/apache/incubator-pinot/pull/6567