Does Datafusion support type coercion between Arrow Timestamp and unix timestamp in query?

[niebayes]

For example, can I execute select * from test where ts > 1725186000 directly on Datafusion?

[jonahgao]

I believe it can't, but you can use the from_unixtime function.

> create table t(a timestamp);
0 row(s) fetched.
Elapsed 0.013 seconds.

> select * from t where a > 1725186000;
type_coercion
caused by
Error during planning: Cannot infer common argument type for comparison operation Timestamp(Nanosecond, None) > Int64

> select * from t where a > from_unixtime(1725186000);
+---+
| a |
+---+
+---+
0 row(s) fetched.
Elapsed 0.007 seconds.

[niebayes]

@jonahgao Thanks. I've also tried myself and found the same error. I've filed a issue #12891 and maybe Datafusion could support the type coercion between timestamp and unixtime.