Hi,
We are trying to upsert into table using pinot, but as our table needs data to be ingested from multiple Kafka source (basically combination of multiple source tables from MySQL databases)
Also as these pinot does not support reading from multiple Kafka for a same table
we are trying if we can push all data as json to a single Kafka topic (having data of different source tables as different messages/events)
So can do a partial upsert but using condition like if some specific value is there at source then only update it and update specific columns in pinot based on these different condition
if we don't have any such support in pinot do we have a workaround where i don't require a join but using this multiple events can update rows of table parallel