Why does clear nail polish come off with hot water?

The reason is not that the nail polish is clear, it's just that the nail polish is cheap or crappy. Try getting nail polish from a different company, because some nail polishes just do that.