impala-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From tarmstr...@apache.org
Subject [1/5] incubator-impala git commit: Renamed conjunct_ordering.test to primitive_conjunct_ordering.test in targeted-perf
Date Sat, 14 May 2016 08:30:07 GMT
Repository: incubator-impala
Updated Branches:
  refs/heads/master ff0cd823c -> 4c9c74dd3


Renamed conjunct_ordering.test to primitive_conjunct_ordering.test in targeted-perf

This is needed because the workload runner required a prefix of query names to run.

Change-Id: Ica8db68141ef653b0b01a7cfa7773302717a35a2
Reviewed-on: http://gerrit.cloudera.org:8080/3021
Tested-by: Internal Jenkins
Reviewed-by: Thomas Tauber-Marshall <tmarshall@cloudera.com>


Project: http://git-wip-us.apache.org/repos/asf/incubator-impala/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-impala/commit/11ea79c5
Tree: http://git-wip-us.apache.org/repos/asf/incubator-impala/tree/11ea79c5
Diff: http://git-wip-us.apache.org/repos/asf/incubator-impala/diff/11ea79c5

Branch: refs/heads/master
Commit: 11ea79c5251a15d7a6902084f8a537fdab649cfc
Parents: ff0cd82
Author: Thomas Tauber-Marshall <tmarshall@cloudera.com>
Authored: Tue May 10 16:25:00 2016 -0700
Committer: Tim Armstrong <tarmstrong@cloudera.com>
Committed: Sat May 14 01:30:00 2016 -0700

----------------------------------------------------------------------
 .../queries/conjunct_ordering.test              | 73 --------------------
 .../queries/primitive_conjunct_ordering.test    | 73 ++++++++++++++++++++
 2 files changed, 73 insertions(+), 73 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/11ea79c5/testdata/workloads/targeted-perf/queries/conjunct_ordering.test
----------------------------------------------------------------------
diff --git a/testdata/workloads/targeted-perf/queries/conjunct_ordering.test b/testdata/workloads/targeted-perf/queries/conjunct_ordering.test
deleted file mode 100644
index 155aebe..0000000
--- a/testdata/workloads/targeted-perf/queries/conjunct_ordering.test
+++ /dev/null
@@ -1,73 +0,0 @@
-====
----- QUERY: conjunct_ordering_1
--- Description : A simple select with one expensive conjunct and one cheap conjunct.
-SELECT *
-FROM lineitem
-WHERE (l_shipdate < current_timestamp() - interval 1 day) AND l_orderkey = -1;
-====
----- QUERY: conjunct_ordering_2
--- Description: Based on TPCH-Q19
-SELECT sum(l_extendedprice * (1 - l_discount)) AS revenue
-FROM lineitem, part
-WHERE p_partkey = l_partkey
-  AND ((p_brand = 'Brand#12'
-      AND p_container IN ('SM CASE', 'SM BOX', 'SM PACK', 'SM PKG')
-      AND l_quantity >= 1 AND l_quantity <= 11
-      AND p_size BETWEEN 1 AND 5
-      AND l_shipmode IN ('AIR', 'AIR REG')
-      AND l_shipinstruct = 'DELIVER IN PERSON')
-    OR (p_brand = 'Brand#23'
-      AND p_container IN ('MED BAG', 'MED BOX', 'MED PKG', 'MED PACK')
-      AND l_quantity >= 10 AND l_quantity <= 20
-      AND p_size BETWEEN 1 AND 10
-      AND l_shipmode IN ('AIR', 'AIR REG')
-      AND l_shipinstruct = 'DELIVER IN PERSON')
-    OR (p_brand = 'Brand#34'
-      AND p_container IN ('LG CASE', 'LG BOX', 'LG PACK', 'LG PKG')
-      AND l_quantity >= 20 AND l_quantity <= 30
-      AND p_size BETWEEN 1 AND 15
-      AND l_shipmode IN ('AIR', 'AIR REG')
-      AND l_shipinstruct = 'DELIVER IN PERSON'))
-  AND (p_partkey = 0 OR l_partkey = 0)
-====
----- QUERY: conjunct_ordering_3
--- Description: Based on TPCDS-Q28
-SELECT avg(l_extendedprice), count(l_extendedprice), count(distinct l_extendedprice)
-FROM lineitem
-WHERE
-  (l_discount BETWEEN 0.2 AND 0.3
-    OR l_discount BETWEEN 0.4 AND 0.5
-    OR l_tax BETWEEN 0.1 AND 0.2
-    OR l_tax BETWEEN 0 AND 0.09)
-  AND l_extendedprice BETWEEN 100 AND 500
-====
----- QUERY: conjunct_ordering_4
--- Description: Based on TPCDS-Q41
-SELECT p_mfgr, count(*) as item_cnt
-FROM part
-WHERE ((p_type LIKE '%STEEL%'
-      AND p_size BETWEEN 10 AND 40
-      AND p_container IN ('LG BOX', 'LG BAG', 'LG CASE'))
-    OR (p_type LIKE '%COPPER%'
-      AND p_size BETWEEN 20 AND 50
-      AND p_container IN ('JUMBO BOX', 'JUMBO BAG', 'JUMBO CASE'))
-    OR (p_type LIKE '%TIN%'
-      AND p_size BETWEEN 0 AND 30
-      AND p_container IN ('MED BOX', 'MED BAG', 'MED CASE'))
-    OR (p_type LIKE '%BRASS%'
-      AND p_size BETWEEN 0 AND 20
-      AND p_container IN ('SMALL BOX', 'SMALL BAG', 'SMALL CASE')))
-  AND p_partkey = -1
-GROUP BY p_mfgr
-====
----- QUERY: conjunct_ordering_5
--- Description: Based on TPCDS-Q48
-SELECT sum(l_quantity)
-FROM orders, lineitem,
-  (SELECT * FROM customer WHERE c_comment LIKE c_comment AND c_nationkey IN (5, 20)) as v1
-WHERE l_orderkey = o_orderkey
-  AND (v1.c_custkey = o_custkey
-    AND (o_totalprice BETWEEN 1000 AND 2000
-      OR o_totalprice BETWEEN 3000 AND 4000
-      OR o_totalprice BETWEEN 5000 AND 6000))
-====

http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/11ea79c5/testdata/workloads/targeted-perf/queries/primitive_conjunct_ordering.test
----------------------------------------------------------------------
diff --git a/testdata/workloads/targeted-perf/queries/primitive_conjunct_ordering.test b/testdata/workloads/targeted-perf/queries/primitive_conjunct_ordering.test
new file mode 100644
index 0000000..71be122
--- /dev/null
+++ b/testdata/workloads/targeted-perf/queries/primitive_conjunct_ordering.test
@@ -0,0 +1,73 @@
+====
+---- QUERY: primitive_conjunct_ordering_1
+-- Description : A simple select with one expensive conjunct and one cheap conjunct.
+SELECT *
+FROM lineitem
+WHERE (l_shipdate < current_timestamp() - interval 1 day) AND l_orderkey = -1;
+====
+---- QUERY: primitive_conjunct_ordering_2
+-- Description: Based on TPCH-Q19
+SELECT sum(l_extendedprice * (1 - l_discount)) AS revenue
+FROM lineitem, part
+WHERE p_partkey = l_partkey
+  AND ((p_brand = 'Brand#12'
+      AND p_container IN ('SM CASE', 'SM BOX', 'SM PACK', 'SM PKG')
+      AND l_quantity >= 1 AND l_quantity <= 11
+      AND p_size BETWEEN 1 AND 5
+      AND l_shipmode IN ('AIR', 'AIR REG')
+      AND l_shipinstruct = 'DELIVER IN PERSON')
+    OR (p_brand = 'Brand#23'
+      AND p_container IN ('MED BAG', 'MED BOX', 'MED PKG', 'MED PACK')
+      AND l_quantity >= 10 AND l_quantity <= 20
+      AND p_size BETWEEN 1 AND 10
+      AND l_shipmode IN ('AIR', 'AIR REG')
+      AND l_shipinstruct = 'DELIVER IN PERSON')
+    OR (p_brand = 'Brand#34'
+      AND p_container IN ('LG CASE', 'LG BOX', 'LG PACK', 'LG PKG')
+      AND l_quantity >= 20 AND l_quantity <= 30
+      AND p_size BETWEEN 1 AND 15
+      AND l_shipmode IN ('AIR', 'AIR REG')
+      AND l_shipinstruct = 'DELIVER IN PERSON'))
+  AND (p_partkey = 0 OR l_partkey = 0)
+====
+---- QUERY: primitive_conjunct_ordering_3
+-- Description: Based on TPCDS-Q28
+SELECT avg(l_extendedprice), count(l_extendedprice), count(distinct l_extendedprice)
+FROM lineitem
+WHERE
+  (l_discount BETWEEN 0.2 AND 0.3
+    OR l_discount BETWEEN 0.4 AND 0.5
+    OR l_tax BETWEEN 0.1 AND 0.2
+    OR l_tax BETWEEN 0 AND 0.09)
+  AND l_extendedprice BETWEEN 100 AND 500
+====
+---- QUERY: primitive_conjunct_ordering_4
+-- Description: Based on TPCDS-Q41
+SELECT p_mfgr, count(*) as item_cnt
+FROM part
+WHERE ((p_type LIKE '%STEEL%'
+      AND p_size BETWEEN 10 AND 40
+      AND p_container IN ('LG BOX', 'LG BAG', 'LG CASE'))
+    OR (p_type LIKE '%COPPER%'
+      AND p_size BETWEEN 20 AND 50
+      AND p_container IN ('JUMBO BOX', 'JUMBO BAG', 'JUMBO CASE'))
+    OR (p_type LIKE '%TIN%'
+      AND p_size BETWEEN 0 AND 30
+      AND p_container IN ('MED BOX', 'MED BAG', 'MED CASE'))
+    OR (p_type LIKE '%BRASS%'
+      AND p_size BETWEEN 0 AND 20
+      AND p_container IN ('SMALL BOX', 'SMALL BAG', 'SMALL CASE')))
+  AND p_partkey = -1
+GROUP BY p_mfgr
+====
+---- QUERY: primitive_conjunct_ordering_5
+-- Description: Based on TPCDS-Q48
+SELECT sum(l_quantity)
+FROM orders, lineitem,
+  (SELECT * FROM customer WHERE c_comment LIKE c_comment AND c_nationkey IN (5, 20)) as v1
+WHERE l_orderkey = o_orderkey
+  AND (v1.c_custkey = o_custkey
+    AND (o_totalprice BETWEEN 1000 AND 2000
+      OR o_totalprice BETWEEN 3000 AND 4000
+      OR o_totalprice BETWEEN 5000 AND 6000))
+====


Mime
View raw message