infra: run tests for windows

[kevinjqliu]

Feature Request / Improvement

We only run in ubuntu env today,

iceberg-python/.github/workflows/python-ci.yml

Line 47 in a9897de

runs-on: ubuntu-22.04

Would be helpful to run in Windows

I suspect there will be some compatibility issues. I'll run the test suite locally with a Windows laptop

Previous related issue: #1005

[kevinjqliu]

dealing with path in windows

• https://stackoverflow.com/questions/43911052/urlparse-on-a-windows-file-scheme-uri-leaves-extra-slash-at-start
• Path.as_uri()
• urllib.request.url2pathname(url)
• https://github.com/pypa/pip/blob/81b3c05137d54f2a16b460694de10fb7f808517f/src/pip/_internal/utils/urls.py#L9-L55

[kevinjqliu]

Ran make test in CI with Windows OS and these are the errors

ValueError: Unrecognized filesystem type in URI: c
    tests/test_avro_sanitization.py::test_comprehensive_avro_compatibility
No preferred file implementation for scheme: c
    tests/catalog/test_base.py::test_create_table
puresasl.SASLError: kerberos module not installed, GSSAPI unavailable
    tests/catalog/test_hive.py::test_create_hive_client_with_kerberos
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file
    tests/catalog/test_sql.py::test_creation_with_echo_parameter
pyarrow.lib.ArrowInvalid: File URI cannot be relative
    tests/io/test_pyarrow.py::test_projection_add_column

from kevinjqliu#27

[github-actions]

This issue has been automatically marked as stale because it has been open for 180 days with no activity. It will be closed in next 14 days if no further activity occurs. To permanently prevent this issue from being considered stale, add the label 'not-stale', but commenting on the issue is preferred when possible.