Hello Here, I am new in Pinot and Presto, so maybe...
# troubleshootingm
Matteo Satnero
03/12/2021, 11:42 AMHello 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.202103021012k
Kishore G
03/12/2021, 3:01 PM
have you turned on upsert?
m
Matteo Satnero
03/12/2021, 3:04 PMi supposed that the
upsertConfig mode trueMatteo Satnero
03/12/2021, 3:04 PMstrange 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 PMI don’t know if is something i forgot on the link between the 2 systems
y
Yupeng Fu
03/12/2021, 6:04 PMyes, 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