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

Matteo Satnero

03/12/2021, 11:42 AM
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?
Copy code
upsertConfig mode true in REALTIME
pinot 0.6.0
presto 0.247
dbeaver 21.0.0.202103021012
Thanks you very much in advance
k

Kishore G

03/12/2021, 3:01 PM
have you turned on upsert?
m

Matteo Satnero

03/12/2021, 3:04 PM
i supposed that the
upsertConfig mode true
mean yes but probably is not enough
strange is that the pinot web interface seems is using the upsert setitng while presto not
k

Kishore G

03/12/2021, 3:07 PM
I dont think upsert can support hybrid table's as of today.. @Yupeng Fu ^^
m

Matteo Satnero

03/12/2021, 3:07 PM
I don’t know if is something i forgot on the link between the 2 systems
y

Yupeng Fu

03/12/2021, 6:04 PM
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