ZuoTiJia commented on issue #4947: URL: https://github.com/apache/arrow-datafusion/issues/4947#issuecomment-1386346995
> @ZuoTiJia It looks like None returns because the real error is supressed, if I run it without CSV format > > ``` > DataFusion CLI v16.0.0 > ❯ select to_timestamp_millis(1926632005177685347); > +-----------------------------------------------+ > | totimestampmillis(Int64(1926632005177685347)) | > +-----------------------------------------------+ > | ERROR CONVERTING DATE | > +-----------------------------------------------+ > ``` Mixing correct and incorrect results is not good, it would be nice to be able to throw an error. ``` DataFusion CLI v16.0.0 ❯ CREATE TABLE test(time BIGINT) AS VALUES (1), (1926632005177685347); 0 rows in set. Query took 0.006 seconds. ❯ select * from test; +---------------------+ | time | +---------------------+ | 1 | | 1926632005177685347 | +---------------------+ 2 rows in set. Query took 0.003 seconds. ❯ select to_timestamp_millis(time) from test; +------------------------------+ | totimestampmillis(test.time) | +------------------------------+ | 1970-01-01T00:00:00.001 | | ERROR CONVERTING DATE | +------------------------------+ 2 rows in set. Query took 0.003 seconds. ❯ ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
