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

   ```
   time duckdb -c "select l_returnflag,l_linestatus, count(*) as count_order 
from 'lineitem.parquet' group by l_returnflag, l_linestatus;"
   100% ▕██████████████████████████████████████▏ (00:00:09.37 elapsed)     
   ┌──────────────┬──────────────┬─────────────┐
   │ l_returnflag │ l_linestatus │ count_order │
   │   varchar    │   varchar    │    int64    │
   ├──────────────┼──────────────┼─────────────┤
   │ R            │ F            │  1480675200 │
   │ N            │ F            │    38657144 │
   │ A            │ F            │  1480681438 │
   │ N            │ O            │  2999975927 │
   └──────────────┴──────────────┴─────────────┘
   
   real 0m10.657s
   user 1m38.246s
   sys  0m16.266s
   ```
   ```
   time datafusion-cli -c "select l_returnflag,l_linestatus, count(*) as 
count_order from 'lineitem.parquet' group by l_returnflag, l_linestatus;"
   DataFusion CLI v50.3.0
   +--------------+--------------+-------------+
   | l_returnflag | l_linestatus | count_order |
   +--------------+--------------+-------------+
   | N            | O            | 2999975927  |
   | A            | F            | 1480681438  |
   | R            | F            | 1480675200  |
   | N            | F            | 38657144    |
   +--------------+--------------+-------------+
   4 row(s) fetched. 
   Elapsed 15.924 seconds.
   
   
   real 0m16.128s
   user 5m19.545s
   sys  0m17.042s
   ```
   


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