What is the idiom in Frank was in hot water when he arrived late?

If you think about it for a minute you can figure this out yourself. Which part of that sentence doesn't make any sense if you take it literally? Do you think Frank was actually down in the water? "In hot water" is an idiom because you have to know what it means before it makes any sense.