ql/src/test/results/clientpositive/llap/auto_join25.q.out

PREHOOK: query: CREATE TABLE dest1_n62(key INT, value STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@dest1_n62
POSTHOOK: query: CREATE TABLE dest1_n62(key INT, value STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1_n62
RUN: Stage-0:DDL
PREHOOK: query: FROM srcpart src1 JOIN src src2 ON (src1.key = src2.key)
INSERT OVERWRITE TABLE dest1_n62 SELECT src1.key, src2.value
where (src1.ds = '2008-04-08' or src1.ds = '2008-04-09' )and (src1.hr = '12' or src1.hr = '11')
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Input: default@srcpart
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
PREHOOK: Output: default@dest1_n62
POSTHOOK: query: FROM srcpart src1 JOIN src src2 ON (src1.key = src2.key)
INSERT OVERWRITE TABLE dest1_n62 SELECT src1.key, src2.value
where (src1.ds = '2008-04-08' or src1.ds = '2008-04-09' )and (src1.hr = '12' or src1.hr = '11')
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Input: default@srcpart
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
POSTHOOK: Output: default@dest1_n62
POSTHOOK: Lineage: dest1_n62.key EXPRESSION [(srcpart)src1.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: dest1_n62.value SIMPLE [(src)src2.FieldSchema(name:value, type:string, comment:default), ]
RUN: Stage-1:MAPRED
RUN: Stage-2:DEPENDENCY_COLLECTION
RUN: Stage-0:MOVE
RUN: Stage-3:STATS
PREHOOK: query: SELECT sum(hash(dest1_n62.key,dest1_n62.value)) FROM dest1_n62
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1_n62
#### A masked pattern was here ####
POSTHOOK: query: SELECT sum(hash(dest1_n62.key,dest1_n62.value)) FROM dest1_n62
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1_n62
#### A masked pattern was here ####
RUN: Stage-1:MAPRED
407444119660
PREHOOK: query: CREATE TABLE dest_j2_n0(key INT, value STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@dest_j2_n0
POSTHOOK: query: CREATE TABLE dest_j2_n0(key INT, value STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest_j2_n0
RUN: Stage-0:DDL
PREHOOK: query: FROM src src1 JOIN src src2 ON (src1.key = src2.key) JOIN src src3 ON (src1.key + src2.key = src3.key)
INSERT OVERWRITE TABLE dest_j2_n0 SELECT src1.key, src3.value
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@dest_j2_n0
POSTHOOK: query: FROM src src1 JOIN src src2 ON (src1.key = src2.key) JOIN src src3 ON (src1.key + src2.key = src3.key)
INSERT OVERWRITE TABLE dest_j2_n0 SELECT src1.key, src3.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@dest_j2_n0
POSTHOOK: Lineage: dest_j2_n0.key EXPRESSION [(src)src1.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: dest_j2_n0.value SIMPLE [(src)src3.FieldSchema(name:value, type:string, comment:default), ]
RUN: Stage-1:MAPRED
RUN: Stage-2:DEPENDENCY_COLLECTION
RUN: Stage-0:MOVE
RUN: Stage-3:STATS
PREHOOK: query: SELECT sum(hash(dest_j2_n0.key,dest_j2_n0.value)) FROM dest_j2_n0
PREHOOK: type: QUERY
PREHOOK: Input: default@dest_j2_n0
#### A masked pattern was here ####
POSTHOOK: query: SELECT sum(hash(dest_j2_n0.key,dest_j2_n0.value)) FROM dest_j2_n0
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest_j2_n0
#### A masked pattern was here ####
RUN: Stage-1:MAPRED
33815990627
PREHOOK: query: CREATE TABLE dest_j1_n5(key INT, value STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@dest_j1_n5
POSTHOOK: query: CREATE TABLE dest_j1_n5(key INT, value STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest_j1_n5
RUN: Stage-0:DDL
PREHOOK: query: FROM src src1 JOIN src src2 ON (src1.key = src2.key)
INSERT OVERWRITE TABLE dest_j1_n5 SELECT src1.key, src2.value
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@dest_j1_n5
POSTHOOK: query: FROM src src1 JOIN src src2 ON (src1.key = src2.key)
INSERT OVERWRITE TABLE dest_j1_n5 SELECT src1.key, src2.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@dest_j1_n5
POSTHOOK: Lineage: dest_j1_n5.key EXPRESSION [(src)src1.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: dest_j1_n5.value SIMPLE [(src)src2.FieldSchema(name:value, type:string, comment:default), ]
RUN: Stage-1:MAPRED
RUN: Stage-2:DEPENDENCY_COLLECTION
RUN: Stage-0:MOVE
RUN: Stage-3:STATS
PREHOOK: query: SELECT sum(hash(dest_j1_n5.key,dest_j1_n5.value)) FROM dest_j1_n5
PREHOOK: type: QUERY
PREHOOK: Input: default@dest_j1_n5
#### A masked pattern was here ####
POSTHOOK: query: SELECT sum(hash(dest_j1_n5.key,dest_j1_n5.value)) FROM dest_j1_n5
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest_j1_n5
#### A masked pattern was here ####
RUN: Stage-1:MAPRED
101861029915