Support missing values in Boolean columns about pyathena HOT 5 CLOSED

I don't usually use Pandas. I don't know what solution is best.

[1] Either we follow pandas and convert to object the column involved in the issue (I'm not sure we can detect the faulty column, so we could convert all columns with dtypes that are not Na compatible.)

[2] Convert booleans (I understand from the PR above that int is already na safe ) to int and warn the user.

Which method do you think is better?

from pyathena.

Related: #100

from pyathena.

Hi, thanks for the prompt answer ! I did a PR that respects Pandas Type Promotion so bool will be casted to object dtypes and let the user decide what they want to do with it.

from pyathena.

Thank you for your PR. I understood what kind of implementation should be done.
I'm thinking of refactoring the Converter class to use it with PandasCursor.
https://github.com/laughingman7743/PyAthena/blob/master/pyathena/converter.py
I plan to try it on a weekend.

from pyathena.

I implemented it so that dtype and converter can be customized freely in the following branches.
Please make sure. 🙏
#104

from pyathena.