Hi, I have a use case for REALTIME table with upda...
# troubleshootingn
Nisheet
08/05/2021, 6:05 AMHi, I have a use case for REALTIME table with updates with kafka as streaming source. At the same time, I have to pull in existing data from s3 to pinot as well for same use case so that the complete data can be queries under one table. Is there any way to achieve this?
k
Kishore G
08/05/2021, 6:07 AM
That’s exactly how hybrid tables work in Pinot. You point real-time table to Kafka and push to offline tables
Kishore G
08/05/2021, 6:08 AM
https://docs.pinot.apache.org/basics/components/table see hybrid table
n
Nisheet
08/05/2021, 6:12 AM@Kishore G Is upsert operation supported for hybrid table?
k
Kishore G
08/05/2021, 6:16 AM
No, that’s something In the works. @Yupeng Fu @Jackie can provide more info on when it will be ready