You are viewing a plain text version of this content. The canonical link for it is here.
Posted to github@datafusion.apache.org by "alamb (via GitHub)" <gi...@apache.org> on 2026/03/10 12:52:09 UTC

Re: [I] Make it easier to run TPCH queries with datafusion-cli [datafusion]

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

   i think with the current state of `tpchgen-cli` this is now pretty easy to run tpch queries with datafusion-cli so I am going to claim this is closed
   
   ```shell
   tpchgen-cli --format=parquet --parts=10
   ```
   
   Then you can just run the queries like this:
   
   ```shell
   andrewlamb@Andrews-MacBook-Pro-3:~/Downloads$ datafusion-cli
   DataFusion CLI v52.1.0
   > select
       l_returnflag,
       l_linestatus,
       sum(l_quantity) as sum_qty,
       sum(l_extendedprice) as sum_base_price,
       sum(l_extendedprice * (1 - l_discount)) as sum_disc_price,
       sum(l_extendedprice * (1 - l_discount) * (1 + l_tax)) as sum_charge,
       avg(l_quantity) as avg_qty,
       avg(l_extendedprice) as avg_price,
       avg(l_discount) as avg_disc,
       count(*) as count_order
   from
       lineitem
   where
           l_shipdate <= date '1998-09-02'
   group by
       l_returnflag,
       l_linestatus
   order by
       l_returnflag,
       l_linestatus;
   +--------------+--------------+-------------+-----------------+-------------------+---------------------+-----------+--------------+----------+-------------+
   | l_returnflag | l_linestatus | sum_qty     | sum_base_price  | sum_disc_price    | sum_charge          | avg_qty   | avg_price    | avg_disc | count_order |
   +--------------+--------------+-------------+-----------------+-------------------+---------------------+-----------+--------------+----------+-------------+
   | A            | F            | 37734107.00 | 56586554400.73  | 53758257134.8700  | 55909065222.827692  | 25.522005 | 38273.129734 | 0.049985 | 1478493     |
   | N            | F            | 991417.00   | 1487504710.38   | 1413082168.0541   | 1469649223.194375   | 25.516471 | 38284.467760 | 0.050093 | 38854       |
   | N            | O            | 74476040.00 | 111701729697.74 | 106118230307.6056 | 110367043872.497010 | 25.502226 | 38249.117988 | 0.049996 | 2920374     |
   | R            | F            | 37719753.00 | 56568041380.90  | 53741292684.6040  | 55889619119.831932  | 25.505793 | 38250.854626 | 0.050009 | 1478870     |
   +--------------+--------------+-------------+-----------------+-------------------+---------------------+-----------+--------------+----------+-------------+
   4 row(s) fetched.
   Elapsed 0.109 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@datafusion.apache.org

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


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org