Soumya Dey07/04/2021, 7:29 PM
1. Ingestion in Pinot has traditionally been via offline and realtime stream. Could you elaborate your usecase that requires insert of rows via Presto?
2. Upsert in Pinot is a newer feature and requires a primary key to identify a row to be updated. While we may definitely explore update via Presto, it might still be primary key based (as opposed to any generic condition).
3. If you don't want to use Kafka ingestion, you can push the data via offline pipeline.
4. Schema changes have to be backward compatible, which your example isn't.
5. Offline and realtime tables are internal to Pinot. Client side only sees a single hybrid table, and Pinot answers query including the offline and realtime data.
Soumya Dey07/05/2021, 4:06 AM
Soumya Dey07/05/2021, 5:26 AM
Soumya Dey07/05/2021, 6:06 AM