Wei-Ting Kuo

Datafusion [https://github.com/apache/arrow-datafusion](https://github.com/apache/arrow-datafusion) is the subproject of apache arrow I can do `ta.from_arrow(pa.Table.from_batches( datafusion_dataframe.collect())` for now to 1. convert datafusion's dataframe to arrow batch record 2. convert arrow batch record to...

[EPIC] Proposal for Date/Time enhancement

1

# !!! Please correct me if i'm wrong !!! # Intro - This changes breaks some original behaviors. - UTC+8 is the local time zone in my examples. - As...

to_timestamp timeunit to be consistent with postgresql's

9

**Is your feature request related to a problem or challenge? Please describe what you are trying to do.** Current [to_timestamp](https://arrow.apache.org/datafusion/user-guide/sql/datafusion-functions.html#to-timestamp) assume the input number is nanoseconds from 1970 ```bash ❯...

Cannot GROUP BY Binary

4

**Describe the bug** A clear and concise description of what the bug is. This is part of #3048 I was doing the benchmark for [clickbench](https://benchmark.clickhouse.com/). One of it's column is...

`date_part` does't work for `now()`

1

**Describe the bug** A clear and concise description of what the bug is. **To Reproduce** Steps to reproduce the behavior: ```bash ❯ select date_part('hour', now()); Plan("Coercion from [Utf8, Timestamp(Nanosecond, Some(\"UTC\"))]...

**Is your feature request related to a problem or challenge? Please describe what you are trying to do.** A clear and concise description of what the problem is. Ex. I'm...

Incorrect type coercion rule for date + interval

1

**Describe the bug** A clear and concise description of what the bug is. coercion rule for date + interval('1 day' ) works but fails for hours/min/sec **To Reproduce** Steps to...

Cast string to timestamp crash while we input time before 1970 with floating number second

2

**Describe the bug** A clear and concise description of what the bug is. **To Reproduce** Steps to reproduce the behavior: ```bash DataFusion CLI v10.0.0 ❯ select cast('1969-01-01T00:00:00.1' as timestamp); thread...

Should `Cast(UTF-8 AS Timestamp)` apply local time zone?

1

**Is your feature request related to a problem or challenge? Please describe what you are trying to do.** dataufusion v10.0.0's applies local time zone (i'm in UTC+8) ```bash ❯ select...

**Describe the bug** A clear and concise description of what the bug is. **To Reproduce** Steps to reproduce the behavior: ```bash DataFusion CLI v10.0.0 ❯ select * from (select 1...