Someone who pretends to be knowledgeable on some subject.
Someone who is frequently drunk (pissed).
Someone who frequently ridicules others (takes the piss).