Uploaded image for project: 'Apache Arrow'
  1. Apache Arrow
  2. ARROW-12277

[Rust][DataFusion] Min/Max are not supported for timestamp types

    XMLWordPrintableJSON

Details

    Description

      If you try and aggregate (via MIN, 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:

      > 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.")
      

      Attachments

        Issue Links

          Activity

            People

              alamb Andrew Lamb
              alamb Andrew Lamb
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 4h 10m
                  4h 10m