You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jira@arrow.apache.org by "Andrew Lamb (Jira)" <ji...@apache.org> on 2021/04/07 18:24:00 UTC

[jira] [Created] (ARROW-12277) [Rust][DataFusion] Aggregates are not supported for timestamp types

Andrew Lamb created ARROW-12277:
-----------------------------------

             Summary: [Rust][DataFusion] Aggregates are not supported for timestamp types
                 Key: ARROW-12277
                 URL: https://issues.apache.org/jira/browse/ARROW-12277
             Project: Apache Arrow
          Issue Type: Improvement
            Reporter: Andrew Lamb
            Assignee: Andrew Lamb


If you try and aggregate (via SUM, for example) a column of a timestamp type, it generates an error:
```
Coercion from [Timestamp(Nanosecond, None)] to the signature Uniform(1, [Int8, Int16, Int32, Int64, UInt8, UInt16, UInt32, UInt64, Float32, Float64]) failed.
```

For example:

{code}
> show columns from t;
+---------------+--------------+------------+-------------+-----------------------------+-------------+
| table_catalog | table_schema | table_name | column_name | data_type                   | is_nullable |
+---------------+--------------+------------+-------------+-----------------------------+-------------+
| datafusion    | public       | t          | a           | Utf8                        | NO          |
| datafusion    | public       | t          | b           | Timestamp(Nanosecond, None) | NO          |
+---------------+--------------+------------+-------------+-----------------------------+-------------+
2 row in set. Query took 0 seconds.
> select sum(b) from t;
Plan("Coercion from [Timestamp(Nanosecond, None)] to the signature Uniform(1, [Int8, Int16, Int32, Int64, UInt8, UInt16, UInt32, UInt64, Float32, Float64]) failed.")
{code}




--
This message was sent by Atlassian Jira
(v8.3.4#803005)