hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From pxi...@apache.org
Subject [3/3] hive git commit: HIVE-15716: Add TPCDS query14.q to HivePerfCliDriver (Pengcheng Xiong)
Date Tue, 24 Jan 2017 21:51:48 GMT
HIVE-15716: Add TPCDS query14.q to HivePerfCliDriver (Pengcheng Xiong)


Project: http://git-wip-us.apache.org/repos/asf/hive/repo
Commit: http://git-wip-us.apache.org/repos/asf/hive/commit/3f8656fc
Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/3f8656fc
Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/3f8656fc

Branch: refs/heads/master
Commit: 3f8656fc646538985a6bf7b62018ad0b80a130c2
Parents: 1d7f4b7
Author: Pengcheng Xiong <pxiong@apache.org>
Authored: Tue Jan 24 13:51:16 2017 -0800
Committer: Pengcheng Xiong <pxiong@apache.org>
Committed: Tue Jan 24 13:51:16 2017 -0800

----------------------------------------------------------------------
 .../src/test/results/clientpositive/ctas.q.out  |    6 +
 .../insert_into_dynamic_partitions.q.out        |    4 +
 .../clientpositive/insert_into_table.q.out      |   11 +
 .../insert_overwrite_directory.q.out            |    4 +
 .../insert_overwrite_dynamic_partitions.q.out   |    4 +
 .../clientpositive/insert_overwrite_table.q.out |   11 +
 .../write_final_output_blobstore.q.out          |   14 +
 .../test/queries/clientpositive/perf/query14.q  |  104 ++
 .../clientpositive/llap/optimize_nullscan.q.out |   18 +-
 .../results/clientpositive/perf/query14.q.out   | 1568 ++++++++++++++++++
 .../results/clientpositive/spark/bucket5.q.out  |    8 +
 .../spark/list_bucket_dml_10.q.out              |    4 +
 .../spark/reduce_deduplicate.q.out              |    6 +
 13 files changed, 1753 insertions(+), 9 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/hive/blob/3f8656fc/itests/hive-blobstore/src/test/results/clientpositive/ctas.q.out
----------------------------------------------------------------------
diff --git a/itests/hive-blobstore/src/test/results/clientpositive/ctas.q.out b/itests/hive-blobstore/src/test/results/clientpositive/ctas.q.out
index 0c91fee..9ecd08f 100644
--- a/itests/hive-blobstore/src/test/results/clientpositive/ctas.q.out
+++ b/itests/hive-blobstore/src/test/results/clientpositive/ctas.q.out
@@ -99,6 +99,7 @@ STAGE PLANS:
             output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
             properties:
               bucket_count -1
+              column.name.delimiter ,
               columns col
               columns.comments 
               columns.types int
@@ -117,6 +118,7 @@ STAGE PLANS:
               output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
               properties:
                 bucket_count -1
+                column.name.delimiter ,
                 columns col
                 columns.comments 
                 columns.types int
@@ -362,6 +364,7 @@ STAGE PLANS:
             properties:
               COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}
               bucket_count -1
+              column.name.delimiter ,
               columns col
               columns.comments 
               columns.types int
@@ -382,6 +385,7 @@ STAGE PLANS:
               properties:
                 COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}
                 bucket_count -1
+                column.name.delimiter ,
                 columns col
                 columns.comments 
                 columns.types int
@@ -635,6 +639,7 @@ STAGE PLANS:
             output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
             properties:
               bucket_count -1
+              column.name.delimiter ,
               columns col
               columns.comments 
               columns.types int
@@ -653,6 +658,7 @@ STAGE PLANS:
               output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
               properties:
                 bucket_count -1
+                column.name.delimiter ,
                 columns col
                 columns.comments 
                 columns.types int

http://git-wip-us.apache.org/repos/asf/hive/blob/3f8656fc/itests/hive-blobstore/src/test/results/clientpositive/insert_into_dynamic_partitions.q.out
----------------------------------------------------------------------
diff --git a/itests/hive-blobstore/src/test/results/clientpositive/insert_into_dynamic_partitions.q.out
b/itests/hive-blobstore/src/test/results/clientpositive/insert_into_dynamic_partitions.q.out
index 6983d99..ce1ac16 100644
--- a/itests/hive-blobstore/src/test/results/clientpositive/insert_into_dynamic_partitions.q.out
+++ b/itests/hive-blobstore/src/test/results/clientpositive/insert_into_dynamic_partitions.q.out
@@ -110,6 +110,7 @@ STAGE PLANS:
             output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
             properties:
               bucket_count -1
+              column.name.delimiter ,
               columns tmp_values_col1,tmp_values_col2
               columns.comments 
               columns.types string:string
@@ -124,6 +125,7 @@ STAGE PLANS:
               output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
               properties:
                 bucket_count -1
+                column.name.delimiter ,
                 columns tmp_values_col1,tmp_values_col2
                 columns.comments 
                 columns.types string:string
@@ -156,6 +158,7 @@ STAGE PLANS:
                 properties:
                   bucket_count 2
                   bucket_field_name id
+                  column.name.delimiter ,
                   columns id
                   columns.comments 
                   columns.types int
@@ -187,6 +190,7 @@ STAGE PLANS:
               properties:
                 bucket_count 2
                 bucket_field_name id
+                column.name.delimiter ,
                 columns id
                 columns.comments 
                 columns.types int

http://git-wip-us.apache.org/repos/asf/hive/blob/3f8656fc/itests/hive-blobstore/src/test/results/clientpositive/insert_into_table.q.out
----------------------------------------------------------------------
diff --git a/itests/hive-blobstore/src/test/results/clientpositive/insert_into_table.q.out
b/itests/hive-blobstore/src/test/results/clientpositive/insert_into_table.q.out
index 3f9ce91..4ed53e5 100644
--- a/itests/hive-blobstore/src/test/results/clientpositive/insert_into_table.q.out
+++ b/itests/hive-blobstore/src/test/results/clientpositive/insert_into_table.q.out
@@ -72,6 +72,7 @@ STAGE PLANS:
                     output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                     properties:
                       bucket_count -1
+                      column.name.delimiter ,
                       columns id
                       columns.comments 
                       columns.types int
@@ -99,6 +100,7 @@ STAGE PLANS:
             output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
             properties:
               bucket_count -1
+              column.name.delimiter ,
               columns tmp_values_col1
               columns.comments 
               columns.types string
@@ -113,6 +115,7 @@ STAGE PLANS:
               output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
               properties:
                 bucket_count -1
+                column.name.delimiter ,
                 columns tmp_values_col1
                 columns.comments 
                 columns.types string
@@ -140,6 +143,7 @@ STAGE PLANS:
               output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
               properties:
                 bucket_count -1
+                column.name.delimiter ,
                 columns id
                 columns.comments 
                 columns.types int
@@ -174,6 +178,7 @@ STAGE PLANS:
                   output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                   properties:
                     bucket_count -1
+                    column.name.delimiter ,
                     columns id
                     columns.comments 
                     columns.types int
@@ -201,6 +206,7 @@ STAGE PLANS:
             output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
             properties:
               bucket_count -1
+              column.name.delimiter ,
               columns id
               columns.comments 
               columns.types int
@@ -219,6 +225,7 @@ STAGE PLANS:
               output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
               properties:
                 bucket_count -1
+                column.name.delimiter ,
                 columns id
                 columns.comments 
                 columns.types int
@@ -247,6 +254,7 @@ STAGE PLANS:
               output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
               properties:
                 bucket_count -1
+                column.name.delimiter ,
                 columns id
                 columns.comments 
                 columns.types int
@@ -277,6 +285,7 @@ STAGE PLANS:
                   output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                   properties:
                     bucket_count -1
+                    column.name.delimiter ,
                     columns id
                     columns.comments 
                     columns.types int
@@ -304,6 +313,7 @@ STAGE PLANS:
             output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
             properties:
               bucket_count -1
+              column.name.delimiter ,
               columns id
               columns.comments 
               columns.types int
@@ -322,6 +332,7 @@ STAGE PLANS:
               output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
               properties:
                 bucket_count -1
+                column.name.delimiter ,
                 columns id
                 columns.comments 
                 columns.types int

http://git-wip-us.apache.org/repos/asf/hive/blob/3f8656fc/itests/hive-blobstore/src/test/results/clientpositive/insert_overwrite_directory.q.out
----------------------------------------------------------------------
diff --git a/itests/hive-blobstore/src/test/results/clientpositive/insert_overwrite_directory.q.out
b/itests/hive-blobstore/src/test/results/clientpositive/insert_overwrite_directory.q.out
index 7d8d6c8..6e95fd1 100644
--- a/itests/hive-blobstore/src/test/results/clientpositive/insert_overwrite_directory.q.out
+++ b/itests/hive-blobstore/src/test/results/clientpositive/insert_overwrite_directory.q.out
@@ -109,6 +109,7 @@ STAGE PLANS:
             properties:
               COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}
               bucket_count -1
+              column.name.delimiter ,
               columns id,key
               columns.comments 
               columns.types int:string
@@ -130,6 +131,7 @@ STAGE PLANS:
               properties:
                 COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}
                 bucket_count -1
+                column.name.delimiter ,
                 columns id,key
                 columns.comments 
                 columns.types int:string
@@ -358,6 +360,7 @@ STAGE PLANS:
             properties:
               COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}
               bucket_count -1
+              column.name.delimiter ,
               columns id,key
               columns.comments 
               columns.types int:string
@@ -379,6 +382,7 @@ STAGE PLANS:
               properties:
                 COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}
                 bucket_count -1
+                column.name.delimiter ,
                 columns id,key
                 columns.comments 
                 columns.types int:string

http://git-wip-us.apache.org/repos/asf/hive/blob/3f8656fc/itests/hive-blobstore/src/test/results/clientpositive/insert_overwrite_dynamic_partitions.q.out
----------------------------------------------------------------------
diff --git a/itests/hive-blobstore/src/test/results/clientpositive/insert_overwrite_dynamic_partitions.q.out
b/itests/hive-blobstore/src/test/results/clientpositive/insert_overwrite_dynamic_partitions.q.out
index 48adac0..1ca24bc 100644
--- a/itests/hive-blobstore/src/test/results/clientpositive/insert_overwrite_dynamic_partitions.q.out
+++ b/itests/hive-blobstore/src/test/results/clientpositive/insert_overwrite_dynamic_partitions.q.out
@@ -128,6 +128,7 @@ STAGE PLANS:
             output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
             properties:
               bucket_count -1
+              column.name.delimiter ,
               columns tmp_values_col1,tmp_values_col2
               columns.comments 
               columns.types string:string
@@ -142,6 +143,7 @@ STAGE PLANS:
               output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
               properties:
                 bucket_count -1
+                column.name.delimiter ,
                 columns tmp_values_col1,tmp_values_col2
                 columns.comments 
                 columns.types string:string
@@ -174,6 +176,7 @@ STAGE PLANS:
                 properties:
                   bucket_count 2
                   bucket_field_name id
+                  column.name.delimiter ,
                   columns id
                   columns.comments 
                   columns.types int
@@ -205,6 +208,7 @@ STAGE PLANS:
               properties:
                 bucket_count 2
                 bucket_field_name id
+                column.name.delimiter ,
                 columns id
                 columns.comments 
                 columns.types int

http://git-wip-us.apache.org/repos/asf/hive/blob/3f8656fc/itests/hive-blobstore/src/test/results/clientpositive/insert_overwrite_table.q.out
----------------------------------------------------------------------
diff --git a/itests/hive-blobstore/src/test/results/clientpositive/insert_overwrite_table.q.out
b/itests/hive-blobstore/src/test/results/clientpositive/insert_overwrite_table.q.out
index 5eff2af..8052fd8 100644
--- a/itests/hive-blobstore/src/test/results/clientpositive/insert_overwrite_table.q.out
+++ b/itests/hive-blobstore/src/test/results/clientpositive/insert_overwrite_table.q.out
@@ -81,6 +81,7 @@ STAGE PLANS:
                     properties:
                       COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}
                       bucket_count -1
+                      column.name.delimiter ,
                       columns id
                       columns.comments 
                       columns.types int
@@ -110,6 +111,7 @@ STAGE PLANS:
             output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
             properties:
               bucket_count -1
+              column.name.delimiter ,
               columns tmp_values_col1
               columns.comments 
               columns.types string
@@ -124,6 +126,7 @@ STAGE PLANS:
               output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
               properties:
                 bucket_count -1
+                column.name.delimiter ,
                 columns tmp_values_col1
                 columns.comments 
                 columns.types string
@@ -152,6 +155,7 @@ STAGE PLANS:
               properties:
                 COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}
                 bucket_count -1
+                column.name.delimiter ,
                 columns id
                 columns.comments 
                 columns.types int
@@ -189,6 +193,7 @@ STAGE PLANS:
                   properties:
                     COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}
                     bucket_count -1
+                    column.name.delimiter ,
                     columns id
                     columns.comments 
                     columns.types int
@@ -219,6 +224,7 @@ STAGE PLANS:
             properties:
               COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}
               bucket_count -1
+              column.name.delimiter ,
               columns id
               columns.comments 
               columns.types int
@@ -240,6 +246,7 @@ STAGE PLANS:
               properties:
                 COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}
                 bucket_count -1
+                column.name.delimiter ,
                 columns id
                 columns.comments 
                 columns.types int
@@ -271,6 +278,7 @@ STAGE PLANS:
               properties:
                 COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}
                 bucket_count -1
+                column.name.delimiter ,
                 columns id
                 columns.comments 
                 columns.types int
@@ -304,6 +312,7 @@ STAGE PLANS:
                   properties:
                     COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}
                     bucket_count -1
+                    column.name.delimiter ,
                     columns id
                     columns.comments 
                     columns.types int
@@ -334,6 +343,7 @@ STAGE PLANS:
             properties:
               COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}
               bucket_count -1
+              column.name.delimiter ,
               columns id
               columns.comments 
               columns.types int
@@ -355,6 +365,7 @@ STAGE PLANS:
               properties:
                 COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}
                 bucket_count -1
+                column.name.delimiter ,
                 columns id
                 columns.comments 
                 columns.types int

http://git-wip-us.apache.org/repos/asf/hive/blob/3f8656fc/itests/hive-blobstore/src/test/results/clientpositive/write_final_output_blobstore.q.out
----------------------------------------------------------------------
diff --git a/itests/hive-blobstore/src/test/results/clientpositive/write_final_output_blobstore.q.out
b/itests/hive-blobstore/src/test/results/clientpositive/write_final_output_blobstore.q.out
index e48647f..8a90a9e 100644
--- a/itests/hive-blobstore/src/test/results/clientpositive/write_final_output_blobstore.q.out
+++ b/itests/hive-blobstore/src/test/results/clientpositive/write_final_output_blobstore.q.out
@@ -70,6 +70,7 @@ STAGE PLANS:
             properties:
               COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}
               bucket_count -1
+              column.name.delimiter ,
               columns key
               columns.comments 
               columns.types int
@@ -90,6 +91,7 @@ STAGE PLANS:
               properties:
                 COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}
                 bucket_count -1
+                column.name.delimiter ,
                 columns key
                 columns.comments 
                 columns.types int
@@ -124,6 +126,7 @@ STAGE PLANS:
                 input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                 output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
                 properties:
+                  column.name.delimiter ,
                   columns _col0
                   columns.types int
                   escape.delim \
@@ -154,6 +157,7 @@ STAGE PLANS:
             input format: org.apache.hadoop.mapred.SequenceFileInputFormat
             output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
             properties:
+              column.name.delimiter ,
               columns _col0
               columns.types int
               escape.delim \
@@ -163,6 +167,7 @@ STAGE PLANS:
               input format: org.apache.hadoop.mapred.SequenceFileInputFormat
               output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
               properties:
+                column.name.delimiter ,
                 columns _col0
                 columns.types int
                 escape.delim \
@@ -188,6 +193,7 @@ STAGE PLANS:
                 output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                 properties:
                   bucket_count -1
+                  column.name.delimiter ,
                   columns key
                   columns.comments 
                   columns.types int
@@ -214,6 +220,7 @@ STAGE PLANS:
               output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
               properties:
                 bucket_count -1
+                column.name.delimiter ,
                 columns key
                 columns.comments 
                 columns.types int
@@ -277,6 +284,7 @@ STAGE PLANS:
             properties:
               COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}
               bucket_count -1
+              column.name.delimiter ,
               columns key
               columns.comments 
               columns.types int
@@ -297,6 +305,7 @@ STAGE PLANS:
               properties:
                 COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}
                 bucket_count -1
+                column.name.delimiter ,
                 columns key
                 columns.comments 
                 columns.types int
@@ -331,6 +340,7 @@ STAGE PLANS:
                 input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                 output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
                 properties:
+                  column.name.delimiter ,
                   columns _col0
                   columns.types int
                   escape.delim \
@@ -361,6 +371,7 @@ STAGE PLANS:
             input format: org.apache.hadoop.mapred.SequenceFileInputFormat
             output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
             properties:
+              column.name.delimiter ,
               columns _col0
               columns.types int
               escape.delim \
@@ -370,6 +381,7 @@ STAGE PLANS:
               input format: org.apache.hadoop.mapred.SequenceFileInputFormat
               output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
               properties:
+                column.name.delimiter ,
                 columns _col0
                 columns.types int
                 escape.delim \
@@ -395,6 +407,7 @@ STAGE PLANS:
                 output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                 properties:
                   bucket_count -1
+                  column.name.delimiter ,
                   columns key
                   columns.comments 
                   columns.types int
@@ -421,6 +434,7 @@ STAGE PLANS:
               output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
               properties:
                 bucket_count -1
+                column.name.delimiter ,
                 columns key
                 columns.comments 
                 columns.types int

http://git-wip-us.apache.org/repos/asf/hive/blob/3f8656fc/ql/src/test/queries/clientpositive/perf/query14.q
----------------------------------------------------------------------
diff --git a/ql/src/test/queries/clientpositive/perf/query14.q b/ql/src/test/queries/clientpositive/perf/query14.q
new file mode 100644
index 0000000..a036802
--- /dev/null
+++ b/ql/src/test/queries/clientpositive/perf/query14.q
@@ -0,0 +1,104 @@
+set hive.strict.checks.cartesian.product=false;
+
+explain
+with  cross_items as
+ (select i_item_sk ss_item_sk
+ from item,
+ (select iss.i_brand_id brand_id
+     ,iss.i_class_id class_id
+     ,iss.i_category_id category_id
+ from store_sales
+     ,item iss
+     ,date_dim d1
+ where ss_item_sk = iss.i_item_sk
+   and ss_sold_date_sk = d1.d_date_sk
+   and d1.d_year between 1999 AND 1999 + 2
+ intersect 
+ select ics.i_brand_id
+     ,ics.i_class_id
+     ,ics.i_category_id
+ from catalog_sales
+     ,item ics
+     ,date_dim d2
+ where cs_item_sk = ics.i_item_sk
+   and cs_sold_date_sk = d2.d_date_sk
+   and d2.d_year between 1999 AND 1999 + 2
+ intersect
+ select iws.i_brand_id
+     ,iws.i_class_id
+     ,iws.i_category_id
+ from web_sales
+     ,item iws
+     ,date_dim d3
+ where ws_item_sk = iws.i_item_sk
+   and ws_sold_date_sk = d3.d_date_sk
+   and d3.d_year between 1999 AND 1999 + 2) x
+ where i_brand_id = brand_id
+      and i_class_id = class_id
+      and i_category_id = category_id
+),
+ avg_sales as
+ (select avg(quantity*list_price) average_sales
+  from (select ss_quantity quantity
+             ,ss_list_price list_price
+       from store_sales
+           ,date_dim
+       where ss_sold_date_sk = d_date_sk
+         and d_year between 1999 and 2001 
+       union all 
+       select cs_quantity quantity 
+             ,cs_list_price list_price
+       from catalog_sales
+           ,date_dim
+       where cs_sold_date_sk = d_date_sk
+         and d_year between 1998 and 1998 + 2 
+       union all
+       select ws_quantity quantity
+             ,ws_list_price list_price
+       from web_sales
+           ,date_dim
+       where ws_sold_date_sk = d_date_sk
+         and d_year between 1998 and 1998 + 2) x)
+  select  channel, i_brand_id,i_class_id,i_category_id,sum(sales), sum(number_sales)
+ from(
+       select 'store' channel, i_brand_id,i_class_id
+             ,i_category_id,sum(ss_quantity*ss_list_price) sales
+             , count(*) number_sales
+       from store_sales
+           ,item
+           ,date_dim
+       where ss_item_sk in (select ss_item_sk from cross_items)
+         and ss_item_sk = i_item_sk
+         and ss_sold_date_sk = d_date_sk
+         and d_year = 1998+2 
+         and d_moy = 11
+       group by i_brand_id,i_class_id,i_category_id
+       having sum(ss_quantity*ss_list_price) > (select average_sales from avg_sales)
+       union all
+       select 'catalog' channel, i_brand_id,i_class_id,i_category_id, sum(cs_quantity*cs_list_price)
sales, count(*) number_sales
+       from catalog_sales
+           ,item
+           ,date_dim
+       where cs_item_sk in (select ss_item_sk from cross_items)
+         and cs_item_sk = i_item_sk
+         and cs_sold_date_sk = d_date_sk
+         and d_year = 1998+2 
+         and d_moy = 11
+       group by i_brand_id,i_class_id,i_category_id
+       having sum(cs_quantity*cs_list_price) > (select average_sales from avg_sales)
+       union all
+       select 'web' channel, i_brand_id,i_class_id,i_category_id, sum(ws_quantity*ws_list_price)
sales , count(*) number_sales
+       from web_sales
+           ,item
+           ,date_dim
+       where ws_item_sk in (select ss_item_sk from cross_items)
+         and ws_item_sk = i_item_sk
+         and ws_sold_date_sk = d_date_sk
+         and d_year = 1998+2
+         and d_moy = 11
+       group by i_brand_id,i_class_id,i_category_id
+       having sum(ws_quantity*ws_list_price) > (select average_sales from avg_sales)
+ ) y
+ group by rollup (channel, i_brand_id,i_class_id,i_category_id)
+ order by channel,i_brand_id,i_class_id,i_category_id
+ limit 100;

http://git-wip-us.apache.org/repos/asf/hive/blob/3f8656fc/ql/src/test/results/clientpositive/llap/optimize_nullscan.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/optimize_nullscan.q.out b/ql/src/test/results/clientpositive/llap/optimize_nullscan.q.out
index 65c6cc1..4c08ee1 100644
--- a/ql/src/test/results/clientpositive/llap/optimize_nullscan.q.out
+++ b/ql/src/test/results/clientpositive/llap/optimize_nullscan.q.out
@@ -1025,19 +1025,19 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: srcpart
-                  Statistics: Num rows: 2000 Data size: 182000 Basic stats: COMPLETE Column
stats: PARTIAL
+                  Statistics: Num rows: 2000 Data size: 182000 Basic stats: COMPLETE Column
stats: COMPLETE
                   GatherStats: false
                   Select Operator
                     expressions: value (type: string)
                     outputColumnNames: _col0
-                    Statistics: Num rows: 2000 Data size: 182000 Basic stats: COMPLETE Column
stats: PARTIAL
+                    Statistics: Num rows: 2000 Data size: 182000 Basic stats: COMPLETE Column
stats: COMPLETE
                     Limit
                       Number of rows: 0
-                      Statistics: Num rows: 1 Data size: 91 Basic stats: COMPLETE Column
stats: PARTIAL
+                      Statistics: Num rows: 1 Data size: 91 Basic stats: COMPLETE Column
stats: COMPLETE
                       Reduce Output Operator
                         null sort order: 
                         sort order: 
-                        Statistics: Num rows: 1 Data size: 91 Basic stats: COMPLETE Column
stats: PARTIAL
+                        Statistics: Num rows: 1 Data size: 91 Basic stats: COMPLETE Column
stats: COMPLETE
                         tag: -1
                         value expressions: _col0 (type: string)
                         auto parallelism: false
@@ -1254,13 +1254,13 @@ STAGE PLANS:
                   1 
                 outputColumnNames: _col0, _col1
                 Position of Big Table: 0
-                Statistics: Num rows: 1 Data size: 178 Basic stats: COMPLETE Column stats:
PARTIAL
+                Statistics: Num rows: 1 Data size: 178 Basic stats: COMPLETE Column stats:
COMPLETE
                 File Output Operator
                   compressed: false
                   GlobalTableId: 0
 #### A masked pattern was here ####
                   NumFilesPerFileSink: 1
-                  Statistics: Num rows: 1 Data size: 178 Basic stats: COMPLETE Column stats:
PARTIAL
+                  Statistics: Num rows: 1 Data size: 178 Basic stats: COMPLETE Column stats:
COMPLETE
 #### A masked pattern was here ####
                   table:
                       input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -1284,14 +1284,14 @@ STAGE PLANS:
               Select Operator
                 expressions: VALUE._col0 (type: string)
                 outputColumnNames: _col0
-                Statistics: Num rows: 1 Data size: 91 Basic stats: COMPLETE Column stats:
PARTIAL
+                Statistics: Num rows: 1 Data size: 91 Basic stats: COMPLETE Column stats:
COMPLETE
                 Limit
                   Number of rows: 0
-                  Statistics: Num rows: 1 Data size: 91 Basic stats: COMPLETE Column stats:
PARTIAL
+                  Statistics: Num rows: 1 Data size: 91 Basic stats: COMPLETE Column stats:
COMPLETE
                   Reduce Output Operator
                     null sort order: 
                     sort order: 
-                    Statistics: Num rows: 1 Data size: 91 Basic stats: COMPLETE Column stats:
PARTIAL
+                    Statistics: Num rows: 1 Data size: 91 Basic stats: COMPLETE Column stats:
COMPLETE
                     tag: 1
                     value expressions: _col0 (type: string)
                     auto parallelism: false


Mime
View raw message