Do you have the "friend" who no matter the occasion,finds a way to ruin everyones fun?

I’m asking because tonight I’m going to a Christmas party and this “friend” Carl will be there.He’s a nice guy until he gets some booze in his system.Then he turns into a loud obnoxious drunk who always ends up groping a woman and getting in trouble or getting into a fight. Hes a good friend of the host of the party and I do want to go but I know the night will end up in an uncomfortable situation.Do you all have anyone similar in your circle?