Will the long-term lie tear the relationship apart?

What is the consequence of withholding a big secret from the person you are supposed to have an honest, transparent relationship with? Secrets can lead to lies that lead to people feeling betrayed, causing pain when all of it could have probably been avoided in the first place.