When one partakes in the act of inhaling cocaine through the nostril. The "hoover" section of the saying comes from the vacuum brand, while schneef is a variation on the word sniff or to sniff. "Schneef" is slang for cocaine.
I'm so drunk, someone needs to rack up so I can hoover some schneef right now.
I'm surprised we're not hoovering some schneef right now!