Hi <@UDT7GFEG6> <@UGRJA9TEH> <@UDQU92KBK>, Is ther...
# generalp
Pallavi Kumari
06/03/2023, 4:57 AMHi @Jackie @Xiang Fu @Mayank, Is there a way to remove consumer from a UPSERT table but want to keep the table. We are using Pinot version 11 released around December 2022,
m
Mayank
06/03/2023, 2:00 PM
Not sure if I follow what removing a consumer means, could you elaborate?
p
Pallavi Kumari
06/03/2023, 2:01 PMI meant I want to remove consumer from stream configs of table
Pallavi Kumari
06/03/2023, 2:02 PMand want to keep the table. Just do not want consumer to consume any messages anymore. Basically, I want to create a new table with same streamConfigs
m
Mayank
06/03/2023, 2:03 PM
Exactly which config?
Mayank
06/03/2023, 2:04 PM
And do you want to temporarily pause consumption or permanently?
p
Pallavi Kumari
06/03/2023, 2:04 PMpermanently pause consumption
m
Mayank
06/03/2023, 2:05 PM
p
Pallavi Kumari
06/03/2023, 2:05 PMthanks Mayank, let me try this.
m
Mark Needham
06/05/2023, 6:53 AM@Pallavi Kumari we have an example of using pause for another use case, but you can do the first bit to stop ingestion - https://dev.startree.ai/docs/pinot/recipes/pause-resume-consumption#the-pauseresume-workflow
p
Pallavi Kumari
06/06/2023, 3:18 PMThank you Mark.
Few more questions :
1. What are the possible ways to have data recovery from a backup store such as Azure Blob storage?
2. Can I drop a table and re create with same name in version 11? I can try this, just asking to save time, if its possible
@Mayank @Mark Needham
m
Mark Needham
06/07/2023, 9:49 AM2) Yes you can
Mark Needham
06/07/2023, 9:50 AM1. One of the responsibilities of the deep store is as backup