Add the date expressions in the tpch queries
Project: http://git-wip-us.apache.org/repos/asf/incubator-drill/repo Commit: http://git-wip-us.apache.org/repos/asf/incubator-drill/commit/02b20681 Tree: http://git-wip-us.apache.org/repos/asf/incubator-drill/tree/02b20681 Diff: http://git-wip-us.apache.org/repos/asf/incubator-drill/diff/02b20681 Branch: refs/heads/master Commit: 02b206819f0c3c8b390ee81858315ea9d44fb9ea Parents: 029c5b8 Author: Mehant Baid <[email protected]> Authored: Mon Mar 31 16:38:47 2014 -0700 Committer: Jacques Nadeau <[email protected]> Committed: Sat Apr 19 18:07:09 2014 -0700 ---------------------------------------------------------------------- exec/java-exec/src/test/resources/queries/tpch/03.sql | 4 ++-- exec/java-exec/src/test/resources/queries/tpch/05.sql | 4 ++-- exec/java-exec/src/test/resources/queries/tpch/07.sql | 2 +- exec/java-exec/src/test/resources/queries/tpch/12.sql | 4 ++-- 4 files changed, 7 insertions(+), 7 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/incubator-drill/blob/02b20681/exec/java-exec/src/test/resources/queries/tpch/03.sql ---------------------------------------------------------------------- diff --git a/exec/java-exec/src/test/resources/queries/tpch/03.sql b/exec/java-exec/src/test/resources/queries/tpch/03.sql index f856e64..91fa846 100644 --- a/exec/java-exec/src/test/resources/queries/tpch/03.sql +++ b/exec/java-exec/src/test/resources/queries/tpch/03.sql @@ -14,8 +14,8 @@ where c.c_mktsegment = 'HOUSEHOLD' and c.c_custkey = o.o_custkey and l.l_orderkey = o.o_orderkey --- and o.o_orderdate < date '1995-03-25' --- and l.l_shipdate > date '1995-03-25' + and o.o_orderdate < date '1995-03-25' + and l.l_shipdate > date '1995-03-25' group by l.l_orderkey, http://git-wip-us.apache.org/repos/asf/incubator-drill/blob/02b20681/exec/java-exec/src/test/resources/queries/tpch/05.sql ---------------------------------------------------------------------- diff --git a/exec/java-exec/src/test/resources/queries/tpch/05.sql b/exec/java-exec/src/test/resources/queries/tpch/05.sql index ae82d39..11e413f 100644 --- a/exec/java-exec/src/test/resources/queries/tpch/05.sql +++ b/exec/java-exec/src/test/resources/queries/tpch/05.sql @@ -19,8 +19,8 @@ where and s.s_nationkey = n.n_nationkey and n.n_regionkey = r.r_regionkey and r.r_name = 'EUROPE' --- and o.o_orderdate >= date '1997-01-01' --- and o.o_orderdate < date '1997-01-01' + interval '1' year + and o.o_orderdate >= date '1997-01-01' + and o.o_orderdate < date '1997-01-01' + interval '1' year group by n.n_name http://git-wip-us.apache.org/repos/asf/incubator-drill/blob/02b20681/exec/java-exec/src/test/resources/queries/tpch/07.sql ---------------------------------------------------------------------- diff --git a/exec/java-exec/src/test/resources/queries/tpch/07.sql b/exec/java-exec/src/test/resources/queries/tpch/07.sql index 94bd51c..85eaece 100644 --- a/exec/java-exec/src/test/resources/queries/tpch/07.sql +++ b/exec/java-exec/src/test/resources/queries/tpch/07.sql @@ -28,7 +28,7 @@ from (n1.n_name = 'EGYPT' and n2.n_name = 'UNITED STATES') or (n1.n_name = 'UNITED STATES' and n2.n_name = 'EGYPT') ) --- and l.l_shipdate between date '1995-01-01' and date '1996-12-31' + and l.l_shipdate between date '1995-01-01' and date '1996-12-31' ) as shipping group by supp_nation, http://git-wip-us.apache.org/repos/asf/incubator-drill/blob/02b20681/exec/java-exec/src/test/resources/queries/tpch/12.sql ---------------------------------------------------------------------- diff --git a/exec/java-exec/src/test/resources/queries/tpch/12.sql b/exec/java-exec/src/test/resources/queries/tpch/12.sql index 41bc5dd..65d2c6d 100644 --- a/exec/java-exec/src/test/resources/queries/tpch/12.sql +++ b/exec/java-exec/src/test/resources/queries/tpch/12.sql @@ -21,8 +21,8 @@ where and l.l_shipmode in ('TRUCK', 'REG AIR') and l.l_commitdate < l.l_receiptdate and l.l_shipdate < l.l_commitdate --- and l.l_receiptdate >= date '1994-01-01' --- and l.l_receiptdate < date '1994-01-01' + interval '1' year + and l.l_receiptdate >= date '1994-01-01' + and l.l_receiptdate < date '1994-01-01' + interval '1' year group by l.l_shipmode order by
