You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by ha...@apache.org on 2013/06/14 00:55:53 UTC
svn commit: r1492893 - in /hive/trunk/ql/src/test/results/clientpositive:
auto_join14.q.out input12.q.out input39.q.out recursive_dir.q.out
sample_islocalmode_hook.q.out
Author: hashutosh
Date: Thu Jun 13 22:55:52 2013
New Revision: 1492893
URL: http://svn.apache.org/r1492893
Log:
HIVE-4715 : Fix TestCliDriver.{recursive_dir.q,sample_islocalmode_hook.q,input12.q,input39.q,auto_join14.q} on 0.23 (Brock Noland via Ashutosh Chauhan)
Modified:
hive/trunk/ql/src/test/results/clientpositive/auto_join14.q.out
hive/trunk/ql/src/test/results/clientpositive/input12.q.out
hive/trunk/ql/src/test/results/clientpositive/input39.q.out
hive/trunk/ql/src/test/results/clientpositive/recursive_dir.q.out
hive/trunk/ql/src/test/results/clientpositive/sample_islocalmode_hook.q.out
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_join14.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join14.q.out?rev=1492893&r1=1492892&r2=1492893&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join14.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join14.q.out Thu Jun 13 22:55:52 2013
@@ -19,29 +19,22 @@ ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_TABREF (TOK_TABNAME src)) (TOK_TABREF (TOK_TABNAME srcpart)) (and (AND (= (. (TOK_TABLE_OR_COL src) key) (. (TOK_TABLE_OR_COL srcpart) key)) (= (. (TOK_TABLE_OR_COL srcpart) ds) '2008-04-08')) (> (. (TOK_TABLE_OR_COL src) key) 100)))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME dest1))) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL src) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL srcpart) value)))))
STAGE DEPENDENCIES:
- Stage-6 is a root stage , consists of Stage-7, Stage-8, Stage-1
- Stage-7 has a backup stage: Stage-1
- Stage-4 depends on stages: Stage-7
- Stage-0 depends on stages: Stage-1, Stage-4, Stage-5
+ Stage-5 is a root stage
+ Stage-4 depends on stages: Stage-5
+ Stage-0 depends on stages: Stage-4
Stage-2 depends on stages: Stage-0
- Stage-8 has a backup stage: Stage-1
- Stage-5 depends on stages: Stage-8
- Stage-1
STAGE PLANS:
- Stage: Stage-6
- Conditional Operator
-
- Stage: Stage-7
+ Stage: Stage-5
Map Reduce Local Work
Alias -> Map Local Tables:
- srcpart
+ src
Fetch Operator
limit: -1
Alias -> Map Local Operator Tree:
- srcpart
+ src
TableScan
- alias: srcpart
+ alias: src
Filter Operator
predicate:
expr: (key > 100.0)
@@ -54,14 +47,14 @@ STAGE PLANS:
keys:
0 [Column[key]]
1 [Column[key]]
- Position of Big Table: 0
+ Position of Big Table: 1
Stage: Stage-4
Map Reduce
Alias -> Map Operator Tree:
- src
+ srcpart
TableScan
- alias: src
+ alias: srcpart
Filter Operator
predicate:
expr: (key > 100.0)
@@ -77,7 +70,7 @@ STAGE PLANS:
0 [Column[key]]
1 [Column[key]]
outputColumnNames: _col0, _col5
- Position of Big Table: 0
+ Position of Big Table: 1
Select Operator
expressions:
expr: UDFToInteger(_col0)
@@ -109,136 +102,6 @@ STAGE PLANS:
Stage: Stage-2
Stats-Aggr Operator
- Stage: Stage-8
- Map Reduce Local Work
- Alias -> Map Local Tables:
- src
- Fetch Operator
- limit: -1
- Alias -> Map Local Operator Tree:
- src
- TableScan
- alias: src
- Filter Operator
- predicate:
- expr: (key > 100.0)
- type: boolean
- HashTable Sink Operator
- condition expressions:
- 0 {key}
- 1 {value}
- handleSkewJoin: false
- keys:
- 0 [Column[key]]
- 1 [Column[key]]
- Position of Big Table: 1
-
- Stage: Stage-5
- Map Reduce
- Alias -> Map Operator Tree:
- srcpart
- TableScan
- alias: srcpart
- Filter Operator
- predicate:
- expr: (key > 100.0)
- type: boolean
- Map Join Operator
- condition map:
- Inner Join 0 to 1
- condition expressions:
- 0 {key}
- 1 {value}
- handleSkewJoin: false
- keys:
- 0 [Column[key]]
- 1 [Column[key]]
- outputColumnNames: _col0, _col5
- Position of Big Table: 1
- Select Operator
- expressions:
- expr: UDFToInteger(_col0)
- type: int
- expr: _col5
- type: string
- outputColumnNames: _col0, _col1
- File Output Operator
- compressed: false
- GlobalTableId: 1
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: default.dest1
- Local Work:
- Map Reduce Local Work
-
- Stage: Stage-1
- Map Reduce
- Alias -> Map Operator Tree:
- src
- TableScan
- alias: src
- Filter Operator
- predicate:
- expr: (key > 100.0)
- type: boolean
- Reduce Output Operator
- key expressions:
- expr: key
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: key
- type: string
- tag: 0
- value expressions:
- expr: key
- type: string
- srcpart
- TableScan
- alias: srcpart
- Filter Operator
- predicate:
- expr: (key > 100.0)
- type: boolean
- Reduce Output Operator
- key expressions:
- expr: key
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: key
- type: string
- tag: 1
- value expressions:
- expr: value
- type: string
- Reduce Operator Tree:
- Join Operator
- condition map:
- Inner Join 0 to 1
- condition expressions:
- 0 {VALUE._col0}
- 1 {VALUE._col1}
- handleSkewJoin: false
- outputColumnNames: _col0, _col5
- Select Operator
- expressions:
- expr: UDFToInteger(_col0)
- type: int
- expr: _col5
- type: string
- outputColumnNames: _col0, _col1
- File Output Operator
- compressed: false
- GlobalTableId: 1
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: default.dest1
-
PREHOOK: query: FROM src JOIN srcpart ON src.key = srcpart.key AND srcpart.ds = '2008-04-08' and src.key > 100
INSERT OVERWRITE TABLE dest1 SELECT src.key, srcpart.value
Modified: hive/trunk/ql/src/test/results/clientpositive/input12.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input12.q.out?rev=1492893&r1=1492892&r2=1492893&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/input12.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/input12.q.out Thu Jun 13 22:55:52 2013
@@ -525,10 +525,12 @@ POSTHOOK: Lineage: dest3 PARTITION(ds=20
169 val_169
PREHOOK: query: SELECT dest3.* FROM dest3
PREHOOK: type: QUERY
+PREHOOK: Input: default@dest3
PREHOOK: Input: default@dest3@ds=2008-04-08/hr=12
#### A masked pattern was here ####
POSTHOOK: query: SELECT dest3.* FROM dest3
POSTHOOK: type: QUERY
+POSTHOOK: Input: default@dest3
POSTHOOK: Input: default@dest3@ds=2008-04-08/hr=12
#### A masked pattern was here ####
POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
Modified: hive/trunk/ql/src/test/results/clientpositive/input39.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input39.q.out?rev=1492893&r1=1492892&r2=1492893&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/input39.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/input39.q.out Thu Jun 13 22:55:52 2013
@@ -96,9 +96,6 @@ STAGE PLANS:
expr: key
type: string
tag: 0
- value expressions:
- expr: ds
- type: string
t2
TableScan
alias: t2
@@ -115,18 +112,14 @@ STAGE PLANS:
expr: key
type: string
tag: 1
- value expressions:
- expr: ds
- type: string
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col2}
- 1 {VALUE._col2}
+ 0
+ 1
handleSkewJoin: false
- outputColumnNames: _col2, _col7
Select Operator
Group By Operator
aggregations:
@@ -177,12 +170,16 @@ STAGE PLANS:
PREHOOK: query: select count(1) from t1 join t2 on t1.key=t2.key where t1.ds='1' and t2.ds='1'
PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
PREHOOK: Input: default@t1@ds=1
+PREHOOK: Input: default@t2
PREHOOK: Input: default@t2@ds=1
#### A masked pattern was here ####
POSTHOOK: query: select count(1) from t1 join t2 on t1.key=t2.key where t1.ds='1' and t2.ds='1'
POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t1@ds=1
+POSTHOOK: Input: default@t2
POSTHOOK: Input: default@t2@ds=1
#### A masked pattern was here ####
POSTHOOK: Lineage: t1 PARTITION(ds=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
Modified: hive/trunk/ql/src/test/results/clientpositive/recursive_dir.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/recursive_dir.q.out?rev=1492893&r1=1492892&r2=1492893&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/recursive_dir.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/recursive_dir.q.out Thu Jun 13 22:55:52 2013
@@ -46,10 +46,12 @@ POSTHOOK: Output: default@fact_daily@ds=
POSTHOOK: Lineage: fact_tz PARTITION(ds=1,hr=1).x EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
PREHOOK: query: SELECT * FROM fact_daily WHERE ds='1'
PREHOOK: type: QUERY
+PREHOOK: Input: default@fact_daily
PREHOOK: Input: default@fact_daily@ds=1
#### A masked pattern was here ####
POSTHOOK: query: SELECT * FROM fact_daily WHERE ds='1'
POSTHOOK: type: QUERY
+POSTHOOK: Input: default@fact_daily
POSTHOOK: Input: default@fact_daily@ds=1
#### A masked pattern was here ####
POSTHOOK: Lineage: fact_tz PARTITION(ds=1,hr=1).x EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
Modified: hive/trunk/ql/src/test/results/clientpositive/sample_islocalmode_hook.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/sample_islocalmode_hook.q.out?rev=1492893&r1=1492892&r2=1492893&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/sample_islocalmode_hook.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/sample_islocalmode_hook.q.out Thu Jun 13 22:55:52 2013
@@ -47,11 +47,13 @@ POSTHOOK: Lineage: sih_i_part PARTITION(
POSTHOOK: Lineage: sih_i_part PARTITION(p=3).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
PREHOOK: query: create table sih_src as select key, value from sih_i_part order by key, value
PREHOOK: type: CREATETABLE_AS_SELECT
+PREHOOK: Input: default@sih_i_part
PREHOOK: Input: default@sih_i_part@p=1
PREHOOK: Input: default@sih_i_part@p=2
PREHOOK: Input: default@sih_i_part@p=3
POSTHOOK: query: create table sih_src as select key, value from sih_i_part order by key, value
POSTHOOK: type: CREATETABLE_AS_SELECT
+POSTHOOK: Input: default@sih_i_part
POSTHOOK: Input: default@sih_i_part@p=1
POSTHOOK: Input: default@sih_i_part@p=2
POSTHOOK: Input: default@sih_i_part@p=3