alamb commented on issue #7604:
URL:
https://github.com/apache/arrow-datafusion/issues/7604#issuecomment-1729299085
Thank you @ACking-you
Is it possible to post a reproducer for your issue?
I tried this:
```
❯ create table t(a timestamp, b int) as values ('2023-01-01', 5),
('2023-01-02', 6);
0 rows in set. Query took 0.003 seconds.
❯ create table t2 as select arrow_cast(a, 'Timestamp(Microsecond,
Some("UTC"))') as a, b from t;
0 rows in set. Query took 0.002 seconds.
❯ select min(a),b from t2 group by b;
+----------------------+---+
| MIN(t2.a) | b |
+----------------------+---+
| 2023-01-01T00:00:00Z | 5 |
| 2023-01-02T00:00:00Z | 6 |
+----------------------+---+
2 rows in set. Query took 0.003 seconds.
❯ select arrow_typeof(a), arrow_typeof(b) from t2;
+-------------------------------------+--------------------+
| arrow_typeof(t2.a) | arrow_typeof(t2.b) |
+-------------------------------------+--------------------+
| Timestamp(Microsecond, Some("UTC")) | Int32 |
| Timestamp(Microsecond, Some("UTC")) | Int32 |
+-------------------------------------+--------------------+
2 rows in set. Query took 0.004 seconds.
```
However, I could not get a timezone of `"+8:00"` to work for some reason (I
will file a follow on ticket)
```
❯ select arrow_cast('2022-01-01', 'Timestamp(Microsecond, Some("+8:00"))');
Optimizer rule 'simplify_expressions' failed
caused by
Arrow error: Parser error: Invalid timezone "+8:00": '+8:00' is not a valid
timezone
❯
```
--
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]
