If you drill the holes without caution, it can weaken the joists. However, if you keep precise calculations, the joist will not drain.