Thousands of fans have streamed into Great American Ball Park in Cincinnati despite steady rain to pay respects to Pete Rose.