In hot water means in trouble. We use it when someone may be scolded or punished for a mistake.

Examples: Arif was in hot water for losing his library book. The team got in hot water for being late.