The hydraulic resistance paradox in rapid narrow pipe waterflow