You are viewing a plain text version of this content. The canonical link for it is here.
Posted to github@arrow.apache.org by GitBox <gi...@apache.org> on 2022/10/12 08:33:00 UTC

[GitHub] [arrow-datafusion] Ted-Jiang opened a new issue, #3805: Run median expr on parquet file column got error

Ted-Jiang opened a new issue, #3805:
URL: https://github.com/apache/arrow-datafusion/issues/3805

   **Describe the bug**
   A clear and concise description of what the bug is.
   
   ```
       Finished dev [unoptimized + debuginfo] target(s) in 0.57s
        Running `target/debug/datafusion-cli`
   DataFusion CLI v13.0.0
   ❯ create external table test stored as parquet location '/Users/yangjiang/test-data/tpch-1g/orders';
   0 rows in set. Query took 0.015 seconds.
   ❯ select median(o_totalprice)  from test;
   ArrowError(InvalidArgumentError("number of columns(10) must match number of fields(1) in schema"))
   ❯ select max(o_totalprice)  from test;
   +------------------------+
   | MAX(test.o_totalprice) |
   +------------------------+
   | 555285.16              |
   +------------------------+
   1 row in set. Query took 0.181 seconds.
   ❯
   ````
   
   **To Reproduce**
   Steps to reproduce the behavior:
   
   **Expected behavior**
   A clear and concise description of what you expected to happen.
   
   **Additional context**
   Add any other context about the problem here.
   


-- 
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: github-unsubscribe@arrow.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [arrow-datafusion] alamb commented on issue #3805: Run median expr on parquet file column got error

Posted by GitBox <gi...@apache.org>.
alamb commented on issue #3805:
URL: https://github.com/apache/arrow-datafusion/issues/3805#issuecomment-1275970581

   Likely related to expression renaming. Thanks for the report @Ted-Jiang 


-- 
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: github-unsubscribe@arrow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [arrow-datafusion] Ted-Jiang closed issue #3805: Run median expr on parquet file column got error

Posted by "Ted-Jiang (via GitHub)" <gi...@apache.org>.
Ted-Jiang closed issue #3805: Run median expr on parquet file column got error
URL: https://github.com/apache/arrow-datafusion/issues/3805


-- 
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: github-unsubscribe@arrow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [arrow-datafusion] askoa commented on issue #3805: Run median expr on parquet file column got error

Posted by "askoa (via GitHub)" <gi...@apache.org>.
askoa commented on issue #3805:
URL: https://github.com/apache/arrow-datafusion/issues/3805#issuecomment-1416161188

   Is this still an issue @Ted-Jiang? I am not able to reproduce the problem.
   
   ```
   DataFusion CLI v17.0.0
   ❯ create external table test stored as parquet location '/path/to/orders.parquet';
   0 rows in set. Query took 0.014 seconds.
   ❯ select median(o_totalprice)  from test;
   +---------------------------+
   | MEDIAN(test.o_totalprice) |
   +---------------------------+
   | 144409.03999999998        |
   +---------------------------+
   1 row in set. Query took 6.572 seconds.
   ❯
   ```


-- 
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: github-unsubscribe@arrow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org