alamb commented on issue #18411:
URL: https://github.com/apache/datafusion/issues/18411#issuecomment-3661074237

   With the various tricks in https://github.com/apache/datafusion/pull/19344
   DataFusion now goes 8.473s -- not quite as fast as DuckDB but pretty close 
(0m7.220s)
   
   ```
   time ~/Software/datafusion2/target/profiling/datafusion-cli  -c "select 
l_returnflag,l_linestatus, count(*) as count_order from 'lineitem.parquet' 
group by l_returnflag, l_linestatus;"
   DataFusion CLI v51.0.0
   +--------------+--------------+-------------+
   | l_returnflag | l_linestatus | count_order |
   +--------------+--------------+-------------+
   | R            | F            | 1480675200  |
   | A            | F            | 1480681438  |
   | N            | F            | 38657144    |
   | N            | O            | 2999975927  |
   +--------------+--------------+-------------+
   4 row(s) fetched.
   Elapsed 8.194 seconds.
   
   
   real 0m8.473s
   user 1m40.730s
   sys  0m6.544s
   ```
   
   


-- 
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]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to