You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by px...@apache.org on 2017/01/24 21:51:48 UTC
[3/3] hive git commit: HIVE-15716: Add TPCDS query14.q to
HivePerfCliDriver (Pengcheng Xiong)
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 <px...@apache.org>
Authored: Tue Jan 24 13:51:16 2017 -0800
Committer: Pengcheng Xiong <px...@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