This program implements a modified version of the TPC-H query 10.
The original query can be found at
http://www.tpc.org/tpch/spec/tpch2.16.0.pdf (page 45).
This program implements the following SQL equivalent:
SELECT
Compared to the original TPC-H query this version does not print
c_phone and c_comment, only filters by years greater than 1990 instead of
a period of 3 months, and does not sort the result by revenue.
Input files are plain text CSV files using the pipe character ('|') as field separator
as generated by the TPC-H data generator which is available at http://www.tpc.org/tpch/.
Usage: TPCHQuery10 --customer <path> --orders <path> --lineitem<path> --nation <path> --output <path>
This example shows how to use:
- tuple data types
- inline-defined functions
- projection and join projection
- built-in aggregation functions