we can play with zookeeper metadata as well if thats what needs to be done

Yeah, let's try hybrid table or changing kafka offset (not sure if that is supported) first, and keep this as last resort.