[GitHub] [arrow-datafusion] jorgecarleitao commented on issue #959: SELECT ... ORDER BY query fails on data with int64 timestamp field

[GitBox <gi...@apache.org>]

jorgecarleitao commented on issue #959:
URL: https://github.com/apache/arrow-datafusion/issues/959#issuecomment-908758004


   This is due to a limitation in arrow-rs that does not support timestamps with timezones: every timestamp that enters arrow-rs and is transformed is outputted as a timestamp without timezone. Because `Timestamp(a,Some(b)) != Timestamp(a,None)`, the `RecordBatch` refuses to accept the transformed columns (as it expects one with timestamp).
   
   A solution in `DataFusion` is to apply an extra cast after every operator from arrow to the expected schema, thereby converting the array back to the expected logical type (until the next operator hits). This implies not using operators that return `RecordBatch` such as `batch_filter`, etc. (since afaik they also error in `arrow-rs`).


-- 
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: github-unsubscribe@arrow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org