I am doing performance testing on Apache Derby (10.14.2). I am using TPCH benchmarking for the same. I have completed the dbgen part of the TPCH and populated the database. There are 22 queries in the TPCH benchmarking queries. I am not able to convert the 1st query to suit the syntax of the Apache Derby. In the make file, I gave the DB as DB2. Since there is no Apache Derby option present there.
Query is as follows:
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 <= '1998-12-01' - interval ':1' day (3)
group by
l_returnflag,
l_linestatus
order by
l_returnflag,
l_linestatus;
Error from the ij tool:
ERROR 42X01: Syntax error: Encountered "\':1\'" at line 15, column 47.
Issue the 'help' command for general information on IJ command syntax.
Any unrecognized commands are treated as potential SQL commands and executed directly.
Consult your DBMS server reference documentation for details of the SQL syntax supported by your server.
Is there a way to generate the queries for Apache Derby in TPCH. Or tool which can covert the queries to Apache Derby.
Thanks in advance.