With the hot water heater in use, the cold water inlet, and attached pipe is literally scalding to the touch.

The hot water outlet is cool...