Reading bz2-compressed tables from URL fails with c-engine in Python 2
In https://github.com/pandas-dev/pandas/pull/14576, we consolidated compression code and introduced support for compressed URLs beyond just gzip. However, as described in https://github.com/pandas-dev/pandas/pull/14576#issuecomment-264963575, the c-engine cannot read bz2-compressed URLs in python 2. This error is coming from [`parser.pyx#L615-L621`](https://github.com/pandas-dev/pandas/blob/b3dd9bafbfcbac1a2b6ab756e588d6e167f90439/pandas/parser.pyx#L615-L621). There may be potential to entirely bypass this offending code as it appears to duplicate the functionality of `_get_handle`.