[sql-lab]Pyarrow to pandas fails when timestamp is out of bounds

[cabo40]

When querying from a database with a timestamp column with [us] granularity and missing data as zero dates the query cannot be completed

Expected results

The query result with full precision of dates

Actual results

pyarrow.lib.ArrowInvalid: Casting from timestamp[us] to timestamp[ns] would result in out of bounds timestamp

How to reproduce the bug

Tested with a DB2 database, select a timestamp from 1900-01-01 in sql-lab

Environment

(please complete the following information):

• superset version: 0.38.0
• python version: 3.7.9
• node.js version: 16.14.0

[cabo40]

Hi @junlincc . I am very very sorry for not answering sooner.

I tested with a fresh installation and could reproduce by querying in sql lab on the examples database:

SELECT TIMESTAMP '01-01-1000';

result:

[junlincc]

Thanks for the additional details and contributing a fix PR, we will get it reviewed asap!
@cabo40 🙏

[cabo40]

Thanks to you for reviewing and contributing this great tool!

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. For admin, please label this issue .pinned to prevent stale bot from closing the issue.