Repository: hive Updated Branches: refs/heads/master 894efdb02 -> 6924b9cd4
http://git-wip-us.apache.org/repos/asf/hive/blob/6924b9cd/ql/src/test/results/clientpositive/pointlookup3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/pointlookup3.q.out b/ql/src/test/results/clientpositive/pointlookup3.q.out index 0057d1d..3085693 100644 --- a/ql/src/test/results/clientpositive/pointlookup3.q.out +++ b/ql/src/test/results/clientpositive/pointlookup3.q.out @@ -66,6 +66,1347 @@ STAGE PLANS: GatherStats: false Filter Operator isSamplingPred: false + predicate: (((ds1 = '2000-04-08') and (key = 1)) or ((ds1 = '2000-04-09') and (key = 2))) (type: boolean) + Statistics: Num rows: 40 Data size: 320 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: key (type: int), value (type: string), ds1 (type: string), ds2 (type: string) + outputColumnNames: _col0, _col1, _col2, _col3 + Statistics: Num rows: 40 Data size: 320 Basic stats: COMPLETE Column stats: NONE + Reduce Output Operator + key expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string), _col3 (type: string) + null sort order: aaaa + sort order: ++++ + Statistics: Num rows: 40 Data size: 320 Basic stats: COMPLETE Column stats: NONE + tag: -1 + auto parallelism: false + Path -> Alias: +#### A masked pattern was here #### + Path -> Partition: +#### A masked pattern was here #### + Partition + base file name: ds2=2001-04-08 + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + partition values: + ds1 2000-04-08 + ds2 2001-04-08 + properties: + COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}} + bucket_count -1 + column.name.delimiter , + columns key,value + columns.comments + columns.types int:string +#### A masked pattern was here #### + name default.pcr_t1 + numFiles 1 + numRows 20 + partition_columns ds1/ds2 + partition_columns.types string:string + rawDataSize 160 + serialization.ddl struct pcr_t1 { i32 key, string value} + serialization.format 1 + serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + totalSize 180 +#### A masked pattern was here #### + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + properties: + bucket_count -1 + column.name.delimiter , + columns key,value + columns.comments + columns.types int:string +#### A masked pattern was here #### + name default.pcr_t1 + partition_columns ds1/ds2 + partition_columns.types string:string + serialization.ddl struct pcr_t1 { i32 key, string value} + serialization.format 1 + serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe +#### A masked pattern was here #### + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + name: default.pcr_t1 + name: default.pcr_t1 +#### A masked pattern was here #### + Partition + base file name: ds2=2001-04-09 + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + partition values: + ds1 2000-04-09 + ds2 2001-04-09 + properties: + COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}} + bucket_count -1 + column.name.delimiter , + columns key,value + columns.comments + columns.types int:string +#### A masked pattern was here #### + name default.pcr_t1 + numFiles 1 + numRows 20 + partition_columns ds1/ds2 + partition_columns.types string:string + rawDataSize 160 + serialization.ddl struct pcr_t1 { i32 key, string value} + serialization.format 1 + serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + totalSize 180 +#### A masked pattern was here #### + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + properties: + bucket_count -1 + column.name.delimiter , + columns key,value + columns.comments + columns.types int:string +#### A masked pattern was here #### + name default.pcr_t1 + partition_columns ds1/ds2 + partition_columns.types string:string + serialization.ddl struct pcr_t1 { i32 key, string value} + serialization.format 1 + serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe +#### A masked pattern was here #### + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + name: default.pcr_t1 + name: default.pcr_t1 + Truncated Path -> Alias: + /pcr_t1/ds1=2000-04-08/ds2=2001-04-08 [pcr_t1] + /pcr_t1/ds1=2000-04-09/ds2=2001-04-09 [pcr_t1] + Needs Tagging: false + Reduce Operator Tree: + Select Operator + expressions: KEY.reducesinkkey0 (type: int), KEY.reducesinkkey1 (type: string), KEY.reducesinkkey2 (type: string), KEY.reducesinkkey3 (type: string) + outputColumnNames: _col0, _col1, _col2, _col3 + Statistics: Num rows: 40 Data size: 320 Basic stats: COMPLETE Column stats: NONE + File Output Operator + compressed: false + GlobalTableId: 0 +#### A masked pattern was here #### + NumFilesPerFileSink: 1 + Statistics: Num rows: 40 Data size: 320 Basic stats: COMPLETE Column stats: NONE +#### A masked pattern was here #### + table: + input format: org.apache.hadoop.mapred.SequenceFileInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat + properties: + columns _col0,_col1,_col2,_col3 + columns.types int:string:string:string + escape.delim \ + hive.serialization.extend.additional.nesting.levels true + serialization.escape.crlf true + serialization.format 1 + serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + TotalFiles: 1 + GatherStats: false + MultiFileSpray: false + + Stage: Stage-0 + Fetch Operator + limit: -1 + Processor Tree: + ListSink + +PREHOOK: query: explain extended +select key, value, ds1, ds2 +from pcr_t1 +where (ds1='2000-04-08' and ds2='2001-04-08' and key=1) or (ds1='2000-04-09' and ds2='2001-04-08' and key=2) +order by key, value, ds1, ds2 +PREHOOK: type: QUERY +POSTHOOK: query: explain extended +select key, value, ds1, ds2 +from pcr_t1 +where (ds1='2000-04-08' and ds2='2001-04-08' and key=1) or (ds1='2000-04-09' and ds2='2001-04-08' and key=2) +order by key, value, ds1, ds2 +POSTHOOK: type: QUERY +STAGE DEPENDENCIES: + Stage-1 is a root stage + Stage-0 depends on stages: Stage-1 + +STAGE PLANS: + Stage: Stage-1 + Map Reduce + Map Operator Tree: + TableScan + alias: pcr_t1 + Statistics: Num rows: 20 Data size: 160 Basic stats: COMPLETE Column stats: NONE + GatherStats: false + Filter Operator + isSamplingPred: false + predicate: (key = 1) (type: boolean) + Statistics: Num rows: 10 Data size: 80 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: key (type: int), value (type: string), ds1 (type: string) + outputColumnNames: _col0, _col1, _col2 + Statistics: Num rows: 10 Data size: 80 Basic stats: COMPLETE Column stats: NONE + Reduce Output Operator + key expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string) + null sort order: aaa + sort order: +++ + Statistics: Num rows: 10 Data size: 80 Basic stats: COMPLETE Column stats: NONE + tag: -1 + auto parallelism: false + Path -> Alias: +#### A masked pattern was here #### + Path -> Partition: +#### A masked pattern was here #### + Partition + base file name: ds2=2001-04-08 + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + partition values: + ds1 2000-04-08 + ds2 2001-04-08 + properties: + COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}} + bucket_count -1 + column.name.delimiter , + columns key,value + columns.comments + columns.types int:string +#### A masked pattern was here #### + name default.pcr_t1 + numFiles 1 + numRows 20 + partition_columns ds1/ds2 + partition_columns.types string:string + rawDataSize 160 + serialization.ddl struct pcr_t1 { i32 key, string value} + serialization.format 1 + serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + totalSize 180 +#### A masked pattern was here #### + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + properties: + bucket_count -1 + column.name.delimiter , + columns key,value + columns.comments + columns.types int:string +#### A masked pattern was here #### + name default.pcr_t1 + partition_columns ds1/ds2 + partition_columns.types string:string + serialization.ddl struct pcr_t1 { i32 key, string value} + serialization.format 1 + serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe +#### A masked pattern was here #### + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + name: default.pcr_t1 + name: default.pcr_t1 + Truncated Path -> Alias: + /pcr_t1/ds1=2000-04-08/ds2=2001-04-08 [$hdt$_0:pcr_t1] + Needs Tagging: false + Reduce Operator Tree: + Select Operator + expressions: KEY.reducesinkkey0 (type: int), KEY.reducesinkkey1 (type: string), KEY.reducesinkkey2 (type: string), '2001-04-08' (type: string) + outputColumnNames: _col0, _col1, _col2, _col3 + Statistics: Num rows: 10 Data size: 80 Basic stats: COMPLETE Column stats: NONE + File Output Operator + compressed: false + GlobalTableId: 0 +#### A masked pattern was here #### + NumFilesPerFileSink: 1 + Statistics: Num rows: 10 Data size: 80 Basic stats: COMPLETE Column stats: NONE +#### A masked pattern was here #### + table: + input format: org.apache.hadoop.mapred.SequenceFileInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat + properties: + columns _col0,_col1,_col2,_col3 + columns.types int:string:string:string + escape.delim \ + hive.serialization.extend.additional.nesting.levels true + serialization.escape.crlf true + serialization.format 1 + serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + TotalFiles: 1 + GatherStats: false + MultiFileSpray: false + + Stage: Stage-0 + Fetch Operator + limit: -1 + Processor Tree: + ListSink + +PREHOOK: query: explain extended +select * +from pcr_t1 t1 join pcr_t1 t2 +on t1.key=t2.key and t1.ds1='2000-04-08' and t2.ds2='2001-04-08' +order by t2.key, t2.value, t1.ds1 +PREHOOK: type: QUERY +POSTHOOK: query: explain extended +select * +from pcr_t1 t1 join pcr_t1 t2 +on t1.key=t2.key and t1.ds1='2000-04-08' and t2.ds2='2001-04-08' +order by t2.key, t2.value, t1.ds1 +POSTHOOK: type: QUERY +STAGE DEPENDENCIES: + Stage-1 is a root stage + Stage-2 depends on stages: Stage-1 + Stage-0 depends on stages: Stage-2 + +STAGE PLANS: + Stage: Stage-1 + Map Reduce + Map Operator Tree: + TableScan + alias: t1 + Statistics: Num rows: 20 Data size: 160 Basic stats: COMPLETE Column stats: NONE + GatherStats: false + Filter Operator + isSamplingPred: false + predicate: key is not null (type: boolean) + Statistics: Num rows: 20 Data size: 160 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: key (type: int), value (type: string), ds2 (type: string) + outputColumnNames: _col0, _col1, _col3 + Statistics: Num rows: 20 Data size: 160 Basic stats: COMPLETE Column stats: NONE + Reduce Output Operator + key expressions: _col0 (type: int) + null sort order: a + sort order: + + Map-reduce partition columns: _col0 (type: int) + Statistics: Num rows: 20 Data size: 160 Basic stats: COMPLETE Column stats: NONE + tag: 0 + value expressions: _col1 (type: string), _col3 (type: string) + auto parallelism: false + TableScan + alias: t2 + Statistics: Num rows: 20 Data size: 160 Basic stats: COMPLETE Column stats: NONE + GatherStats: false + Filter Operator + isSamplingPred: false + predicate: key is not null (type: boolean) + Statistics: Num rows: 20 Data size: 160 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: key (type: int), value (type: string), ds1 (type: string) + outputColumnNames: _col0, _col1, _col2 + Statistics: Num rows: 20 Data size: 160 Basic stats: COMPLETE Column stats: NONE + Reduce Output Operator + key expressions: _col0 (type: int) + null sort order: a + sort order: + + Map-reduce partition columns: _col0 (type: int) + Statistics: Num rows: 20 Data size: 160 Basic stats: COMPLETE Column stats: NONE + tag: 1 + value expressions: _col1 (type: string), _col2 (type: string) + auto parallelism: false + Path -> Alias: +#### A masked pattern was here #### + Path -> Partition: +#### A masked pattern was here #### + Partition + base file name: ds2=2001-04-08 + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + partition values: + ds1 2000-04-08 + ds2 2001-04-08 + properties: + COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}} + bucket_count -1 + column.name.delimiter , + columns key,value + columns.comments + columns.types int:string +#### A masked pattern was here #### + name default.pcr_t1 + numFiles 1 + numRows 20 + partition_columns ds1/ds2 + partition_columns.types string:string + rawDataSize 160 + serialization.ddl struct pcr_t1 { i32 key, string value} + serialization.format 1 + serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + totalSize 180 +#### A masked pattern was here #### + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + properties: + bucket_count -1 + column.name.delimiter , + columns key,value + columns.comments + columns.types int:string +#### A masked pattern was here #### + name default.pcr_t1 + partition_columns ds1/ds2 + partition_columns.types string:string + serialization.ddl struct pcr_t1 { i32 key, string value} + serialization.format 1 + serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe +#### A masked pattern was here #### + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + name: default.pcr_t1 + name: default.pcr_t1 + Truncated Path -> Alias: + /pcr_t1/ds1=2000-04-08/ds2=2001-04-08 [$hdt$_0:$hdt$_0:t1, $hdt$_0:$hdt$_1:t2] + Needs Tagging: true + Reduce Operator Tree: + Join Operator + condition map: + Inner Join 0 to 1 + keys: + 0 _col0 (type: int) + 1 _col0 (type: int) + outputColumnNames: _col0, _col1, _col3, _col4, _col5, _col6 + Statistics: Num rows: 22 Data size: 176 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: _col0 (type: int), _col1 (type: string), _col3 (type: string), _col4 (type: int), _col5 (type: string), _col6 (type: string) + outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 + Statistics: Num rows: 22 Data size: 176 Basic stats: COMPLETE Column stats: NONE + File Output Operator + compressed: false + GlobalTableId: 0 +#### A masked pattern was here #### + NumFilesPerFileSink: 1 + table: + input format: org.apache.hadoop.mapred.SequenceFileInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat + properties: + column.name.delimiter , + columns _col0,_col1,_col2,_col3,_col4,_col5 + columns.types int,string,string,int,string,string + escape.delim \ + serialization.lib org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe + serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe + TotalFiles: 1 + GatherStats: false + MultiFileSpray: false + + Stage: Stage-2 + Map Reduce + Map Operator Tree: + TableScan + GatherStats: false + Reduce Output Operator + key expressions: _col3 (type: int), _col4 (type: string) + null sort order: aa + sort order: ++ + Statistics: Num rows: 22 Data size: 176 Basic stats: COMPLETE Column stats: NONE + tag: -1 + value expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string), _col5 (type: string) + auto parallelism: false + Path -> Alias: +#### A masked pattern was here #### + Path -> Partition: +#### A masked pattern was here #### + Partition + base file name: -mr-10004 + input format: org.apache.hadoop.mapred.SequenceFileInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat + properties: + column.name.delimiter , + columns _col0,_col1,_col2,_col3,_col4,_col5 + columns.types int,string,string,int,string,string + escape.delim \ + serialization.lib org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe + serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe + + input format: org.apache.hadoop.mapred.SequenceFileInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat + properties: + column.name.delimiter , + columns _col0,_col1,_col2,_col3,_col4,_col5 + columns.types int,string,string,int,string,string + escape.delim \ + serialization.lib org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe + serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe + Truncated Path -> Alias: +#### A masked pattern was here #### + Needs Tagging: false + Reduce Operator Tree: + Select Operator + expressions: VALUE._col0 (type: int), VALUE._col1 (type: string), '2000-04-08' (type: string), VALUE._col2 (type: string), KEY.reducesinkkey0 (type: int), KEY.reducesinkkey1 (type: string), VALUE._col3 (type: string), '2001-04-08' (type: string) + outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7 + Statistics: Num rows: 22 Data size: 176 Basic stats: COMPLETE Column stats: NONE + File Output Operator + compressed: false + GlobalTableId: 0 +#### A masked pattern was here #### + NumFilesPerFileSink: 1 + Statistics: Num rows: 22 Data size: 176 Basic stats: COMPLETE Column stats: NONE +#### A masked pattern was here #### + table: + input format: org.apache.hadoop.mapred.SequenceFileInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat + properties: + columns _col0,_col1,_col2,_col3,_col4,_col5,_col6,_col7 + columns.types int:string:string:string:int:string:string:string + escape.delim \ + hive.serialization.extend.additional.nesting.levels true + serialization.escape.crlf true + serialization.format 1 + serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + TotalFiles: 1 + GatherStats: false + MultiFileSpray: false + + Stage: Stage-0 + Fetch Operator + limit: -1 + Processor Tree: + ListSink + +PREHOOK: query: explain extended +select * +from pcr_t1 t1 join pcr_t1 t2 +on t1.key=t2.key and t1.ds1='2000-04-08' and t2.ds1='2000-04-09' +order by t2.key, t2.value, t1.ds1 +PREHOOK: type: QUERY +POSTHOOK: query: explain extended +select * +from pcr_t1 t1 join pcr_t1 t2 +on t1.key=t2.key and t1.ds1='2000-04-08' and t2.ds1='2000-04-09' +order by t2.key, t2.value, t1.ds1 +POSTHOOK: type: QUERY +STAGE DEPENDENCIES: + Stage-1 is a root stage + Stage-2 depends on stages: Stage-1 + Stage-0 depends on stages: Stage-2 + +STAGE PLANS: + Stage: Stage-1 + Map Reduce + Map Operator Tree: + TableScan + alias: t1 + Statistics: Num rows: 20 Data size: 160 Basic stats: COMPLETE Column stats: NONE + GatherStats: false + Filter Operator + isSamplingPred: false + predicate: key is not null (type: boolean) + Statistics: Num rows: 20 Data size: 160 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: key (type: int), value (type: string), ds2 (type: string) + outputColumnNames: _col0, _col1, _col3 + Statistics: Num rows: 20 Data size: 160 Basic stats: COMPLETE Column stats: NONE + Reduce Output Operator + key expressions: _col0 (type: int) + null sort order: a + sort order: + + Map-reduce partition columns: _col0 (type: int) + Statistics: Num rows: 20 Data size: 160 Basic stats: COMPLETE Column stats: NONE + tag: 0 + value expressions: _col1 (type: string), _col3 (type: string) + auto parallelism: false + TableScan + alias: t2 + Statistics: Num rows: 20 Data size: 160 Basic stats: COMPLETE Column stats: NONE + GatherStats: false + Filter Operator + isSamplingPred: false + predicate: key is not null (type: boolean) + Statistics: Num rows: 20 Data size: 160 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: key (type: int), value (type: string), ds2 (type: string) + outputColumnNames: _col0, _col1, _col3 + Statistics: Num rows: 20 Data size: 160 Basic stats: COMPLETE Column stats: NONE + Reduce Output Operator + key expressions: _col0 (type: int) + null sort order: a + sort order: + + Map-reduce partition columns: _col0 (type: int) + Statistics: Num rows: 20 Data size: 160 Basic stats: COMPLETE Column stats: NONE + tag: 1 + value expressions: _col1 (type: string), _col3 (type: string) + auto parallelism: false + Path -> Alias: +#### A masked pattern was here #### + Path -> Partition: +#### A masked pattern was here #### + Partition + base file name: ds2=2001-04-08 + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + partition values: + ds1 2000-04-08 + ds2 2001-04-08 + properties: + COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}} + bucket_count -1 + column.name.delimiter , + columns key,value + columns.comments + columns.types int:string +#### A masked pattern was here #### + name default.pcr_t1 + numFiles 1 + numRows 20 + partition_columns ds1/ds2 + partition_columns.types string:string + rawDataSize 160 + serialization.ddl struct pcr_t1 { i32 key, string value} + serialization.format 1 + serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + totalSize 180 +#### A masked pattern was here #### + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + properties: + bucket_count -1 + column.name.delimiter , + columns key,value + columns.comments + columns.types int:string +#### A masked pattern was here #### + name default.pcr_t1 + partition_columns ds1/ds2 + partition_columns.types string:string + serialization.ddl struct pcr_t1 { i32 key, string value} + serialization.format 1 + serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe +#### A masked pattern was here #### + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + name: default.pcr_t1 + name: default.pcr_t1 +#### A masked pattern was here #### + Partition + base file name: ds2=2001-04-09 + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + partition values: + ds1 2000-04-09 + ds2 2001-04-09 + properties: + COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}} + bucket_count -1 + column.name.delimiter , + columns key,value + columns.comments + columns.types int:string +#### A masked pattern was here #### + name default.pcr_t1 + numFiles 1 + numRows 20 + partition_columns ds1/ds2 + partition_columns.types string:string + rawDataSize 160 + serialization.ddl struct pcr_t1 { i32 key, string value} + serialization.format 1 + serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + totalSize 180 +#### A masked pattern was here #### + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + properties: + bucket_count -1 + column.name.delimiter , + columns key,value + columns.comments + columns.types int:string +#### A masked pattern was here #### + name default.pcr_t1 + partition_columns ds1/ds2 + partition_columns.types string:string + serialization.ddl struct pcr_t1 { i32 key, string value} + serialization.format 1 + serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe +#### A masked pattern was here #### + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + name: default.pcr_t1 + name: default.pcr_t1 + Truncated Path -> Alias: + /pcr_t1/ds1=2000-04-08/ds2=2001-04-08 [$hdt$_0:$hdt$_0:t1] + /pcr_t1/ds1=2000-04-09/ds2=2001-04-09 [$hdt$_0:$hdt$_1:t2] + Needs Tagging: true + Reduce Operator Tree: + Join Operator + condition map: + Inner Join 0 to 1 + keys: + 0 _col0 (type: int) + 1 _col0 (type: int) + outputColumnNames: _col0, _col1, _col3, _col4, _col5, _col7 + Statistics: Num rows: 22 Data size: 176 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: _col0 (type: int), _col1 (type: string), _col3 (type: string), _col4 (type: int), _col5 (type: string), _col7 (type: string) + outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 + Statistics: Num rows: 22 Data size: 176 Basic stats: COMPLETE Column stats: NONE + File Output Operator + compressed: false + GlobalTableId: 0 +#### A masked pattern was here #### + NumFilesPerFileSink: 1 + table: + input format: org.apache.hadoop.mapred.SequenceFileInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat + properties: + column.name.delimiter , + columns _col0,_col1,_col2,_col3,_col4,_col5 + columns.types int,string,string,int,string,string + escape.delim \ + serialization.lib org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe + serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe + TotalFiles: 1 + GatherStats: false + MultiFileSpray: false + + Stage: Stage-2 + Map Reduce + Map Operator Tree: + TableScan + GatherStats: false + Reduce Output Operator + key expressions: _col3 (type: int), _col4 (type: string) + null sort order: aa + sort order: ++ + Statistics: Num rows: 22 Data size: 176 Basic stats: COMPLETE Column stats: NONE + tag: -1 + value expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string), _col5 (type: string) + auto parallelism: false + Path -> Alias: +#### A masked pattern was here #### + Path -> Partition: +#### A masked pattern was here #### + Partition + base file name: -mr-10004 + input format: org.apache.hadoop.mapred.SequenceFileInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat + properties: + column.name.delimiter , + columns _col0,_col1,_col2,_col3,_col4,_col5 + columns.types int,string,string,int,string,string + escape.delim \ + serialization.lib org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe + serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe + + input format: org.apache.hadoop.mapred.SequenceFileInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat + properties: + column.name.delimiter , + columns _col0,_col1,_col2,_col3,_col4,_col5 + columns.types int,string,string,int,string,string + escape.delim \ + serialization.lib org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe + serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe + Truncated Path -> Alias: +#### A masked pattern was here #### + Needs Tagging: false + Reduce Operator Tree: + Select Operator + expressions: VALUE._col0 (type: int), VALUE._col1 (type: string), '2000-04-08' (type: string), VALUE._col2 (type: string), KEY.reducesinkkey0 (type: int), KEY.reducesinkkey1 (type: string), '2000-04-09' (type: string), VALUE._col3 (type: string) + outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7 + Statistics: Num rows: 22 Data size: 176 Basic stats: COMPLETE Column stats: NONE + File Output Operator + compressed: false + GlobalTableId: 0 +#### A masked pattern was here #### + NumFilesPerFileSink: 1 + Statistics: Num rows: 22 Data size: 176 Basic stats: COMPLETE Column stats: NONE +#### A masked pattern was here #### + table: + input format: org.apache.hadoop.mapred.SequenceFileInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat + properties: + columns _col0,_col1,_col2,_col3,_col4,_col5,_col6,_col7 + columns.types int:string:string:string:int:string:string:string + escape.delim \ + hive.serialization.extend.additional.nesting.levels true + serialization.escape.crlf true + serialization.format 1 + serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + TotalFiles: 1 + GatherStats: false + MultiFileSpray: false + + Stage: Stage-0 + Fetch Operator + limit: -1 + Processor Tree: + ListSink + +Warning: Shuffle Join JOIN[8][tables = [$hdt$_0, $hdt$_1]] in Stage 'Stage-1:MAPRED' is a cross product +PREHOOK: query: explain extended +select * +from pcr_t1 t1 join pcr_t1 t2 +where (t1.ds1='2000-04-08' and t2.key=1) or (t1.ds1='2000-04-09' and t2.key=2) +order by t2.key, t2.value, t1.ds1 +PREHOOK: type: QUERY +POSTHOOK: query: explain extended +select * +from pcr_t1 t1 join pcr_t1 t2 +where (t1.ds1='2000-04-08' and t2.key=1) or (t1.ds1='2000-04-09' and t2.key=2) +order by t2.key, t2.value, t1.ds1 +POSTHOOK: type: QUERY +STAGE DEPENDENCIES: + Stage-1 is a root stage + Stage-2 depends on stages: Stage-1 + Stage-0 depends on stages: Stage-2 + +STAGE PLANS: + Stage: Stage-1 + Map Reduce + Map Operator Tree: + TableScan + alias: t1 + Statistics: Num rows: 40 Data size: 320 Basic stats: COMPLETE Column stats: NONE + GatherStats: false + Select Operator + expressions: key (type: int), value (type: string), ds1 (type: string), ds2 (type: string) + outputColumnNames: _col0, _col1, _col2, _col3 + Statistics: Num rows: 40 Data size: 320 Basic stats: COMPLETE Column stats: NONE + Reduce Output Operator + null sort order: + sort order: + Statistics: Num rows: 40 Data size: 320 Basic stats: COMPLETE Column stats: NONE + tag: 0 + value expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string), _col3 (type: string) + auto parallelism: false + TableScan + alias: t2 + Statistics: Num rows: 60 Data size: 480 Basic stats: COMPLETE Column stats: NONE + GatherStats: false + Filter Operator + isSamplingPred: false + predicate: ((key = 1) or (key = 2)) (type: boolean) + Statistics: Num rows: 60 Data size: 480 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: key (type: int), value (type: string), ds1 (type: string), ds2 (type: string) + outputColumnNames: _col0, _col1, _col2, _col3 + Statistics: Num rows: 60 Data size: 480 Basic stats: COMPLETE Column stats: NONE + Reduce Output Operator + null sort order: + sort order: + Statistics: Num rows: 60 Data size: 480 Basic stats: COMPLETE Column stats: NONE + tag: 1 + value expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string), _col3 (type: string) + auto parallelism: false + Path -> Alias: +#### A masked pattern was here #### + Path -> Partition: +#### A masked pattern was here #### + Partition + base file name: ds2=2001-04-08 + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + partition values: + ds1 2000-04-08 + ds2 2001-04-08 + properties: + COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}} + bucket_count -1 + column.name.delimiter , + columns key,value + columns.comments + columns.types int:string +#### A masked pattern was here #### + name default.pcr_t1 + numFiles 1 + numRows 20 + partition_columns ds1/ds2 + partition_columns.types string:string + rawDataSize 160 + serialization.ddl struct pcr_t1 { i32 key, string value} + serialization.format 1 + serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + totalSize 180 +#### A masked pattern was here #### + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + properties: + bucket_count -1 + column.name.delimiter , + columns key,value + columns.comments + columns.types int:string +#### A masked pattern was here #### + name default.pcr_t1 + partition_columns ds1/ds2 + partition_columns.types string:string + serialization.ddl struct pcr_t1 { i32 key, string value} + serialization.format 1 + serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe +#### A masked pattern was here #### + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + name: default.pcr_t1 + name: default.pcr_t1 +#### A masked pattern was here #### + Partition + base file name: ds2=2001-04-09 + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + partition values: + ds1 2000-04-09 + ds2 2001-04-09 + properties: + COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}} + bucket_count -1 + column.name.delimiter , + columns key,value + columns.comments + columns.types int:string +#### A masked pattern was here #### + name default.pcr_t1 + numFiles 1 + numRows 20 + partition_columns ds1/ds2 + partition_columns.types string:string + rawDataSize 160 + serialization.ddl struct pcr_t1 { i32 key, string value} + serialization.format 1 + serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + totalSize 180 +#### A masked pattern was here #### + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + properties: + bucket_count -1 + column.name.delimiter , + columns key,value + columns.comments + columns.types int:string +#### A masked pattern was here #### + name default.pcr_t1 + partition_columns ds1/ds2 + partition_columns.types string:string + serialization.ddl struct pcr_t1 { i32 key, string value} + serialization.format 1 + serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe +#### A masked pattern was here #### + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + name: default.pcr_t1 + name: default.pcr_t1 +#### A masked pattern was here #### + Partition + base file name: ds2=2001-04-10 + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + partition values: + ds1 2000-04-10 + ds2 2001-04-10 + properties: + COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}} + bucket_count -1 + column.name.delimiter , + columns key,value + columns.comments + columns.types int:string +#### A masked pattern was here #### + name default.pcr_t1 + numFiles 1 + numRows 20 + partition_columns ds1/ds2 + partition_columns.types string:string + rawDataSize 160 + serialization.ddl struct pcr_t1 { i32 key, string value} + serialization.format 1 + serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + totalSize 180 +#### A masked pattern was here #### + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + properties: + bucket_count -1 + column.name.delimiter , + columns key,value + columns.comments + columns.types int:string +#### A masked pattern was here #### + name default.pcr_t1 + partition_columns ds1/ds2 + partition_columns.types string:string + serialization.ddl struct pcr_t1 { i32 key, string value} + serialization.format 1 + serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe +#### A masked pattern was here #### + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + name: default.pcr_t1 + name: default.pcr_t1 + Truncated Path -> Alias: + /pcr_t1/ds1=2000-04-08/ds2=2001-04-08 [$hdt$_0:t1, $hdt$_1:t2] + /pcr_t1/ds1=2000-04-09/ds2=2001-04-09 [$hdt$_0:t1, $hdt$_1:t2] + /pcr_t1/ds1=2000-04-10/ds2=2001-04-10 [$hdt$_1:t2] + Needs Tagging: true + Reduce Operator Tree: + Join Operator + condition map: + Inner Join 0 to 1 + keys: + 0 + 1 + outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7 + Statistics: Num rows: 2400 Data size: 40800 Basic stats: COMPLETE Column stats: NONE + Filter Operator + isSamplingPred: false + predicate: (((_col2 = '2000-04-08') and (_col4 = 1)) or ((_col2 = '2000-04-09') and (_col4 = 2))) (type: boolean) + Statistics: Num rows: 1200 Data size: 20400 Basic stats: COMPLETE Column stats: NONE + File Output Operator + compressed: false + GlobalTableId: 0 +#### A masked pattern was here #### + NumFilesPerFileSink: 1 + table: + input format: org.apache.hadoop.mapred.SequenceFileInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat + properties: + column.name.delimiter , + columns _col0,_col1,_col2,_col3,_col4,_col5,_col6,_col7 + columns.types int,string,string,string,int,string,string,string + escape.delim \ + serialization.lib org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe + serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe + TotalFiles: 1 + GatherStats: false + MultiFileSpray: false + + Stage: Stage-2 + Map Reduce + Map Operator Tree: + TableScan + GatherStats: false + Reduce Output Operator + key expressions: _col4 (type: int), _col5 (type: string), _col2 (type: string) + null sort order: aaa + sort order: +++ + Statistics: Num rows: 1200 Data size: 20400 Basic stats: COMPLETE Column stats: NONE + tag: -1 + value expressions: _col0 (type: int), _col1 (type: string), _col3 (type: string), _col6 (type: string), _col7 (type: string) + auto parallelism: false + Path -> Alias: +#### A masked pattern was here #### + Path -> Partition: +#### A masked pattern was here #### + Partition + base file name: -mr-10004 + input format: org.apache.hadoop.mapred.SequenceFileInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat + properties: + column.name.delimiter , + columns _col0,_col1,_col2,_col3,_col4,_col5,_col6,_col7 + columns.types int,string,string,string,int,string,string,string + escape.delim \ + serialization.lib org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe + serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe + + input format: org.apache.hadoop.mapred.SequenceFileInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat + properties: + column.name.delimiter , + columns _col0,_col1,_col2,_col3,_col4,_col5,_col6,_col7 + columns.types int,string,string,string,int,string,string,string + escape.delim \ + serialization.lib org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe + serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe + Truncated Path -> Alias: +#### A masked pattern was here #### + Needs Tagging: false + Reduce Operator Tree: + Select Operator + expressions: VALUE._col0 (type: int), VALUE._col1 (type: string), KEY.reducesinkkey2 (type: string), VALUE._col2 (type: string), KEY.reducesinkkey0 (type: int), KEY.reducesinkkey1 (type: string), VALUE._col3 (type: string), VALUE._col4 (type: string) + outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7 + Statistics: Num rows: 1200 Data size: 20400 Basic stats: COMPLETE Column stats: NONE + File Output Operator + compressed: false + GlobalTableId: 0 +#### A masked pattern was here #### + NumFilesPerFileSink: 1 + Statistics: Num rows: 1200 Data size: 20400 Basic stats: COMPLETE Column stats: NONE +#### A masked pattern was here #### + table: + input format: org.apache.hadoop.mapred.SequenceFileInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat + properties: + columns _col0,_col1,_col2,_col3,_col4,_col5,_col6,_col7 + columns.types int:string:string:string:int:string:string:string + escape.delim \ + hive.serialization.extend.additional.nesting.levels true + serialization.escape.crlf true + serialization.format 1 + serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + TotalFiles: 1 + GatherStats: false + MultiFileSpray: false + + Stage: Stage-0 + Fetch Operator + limit: -1 + Processor Tree: + ListSink + +PREHOOK: query: select key, value, ds1, ds2 +from pcr_t1 +where (ds1='2000-04-08' and key=1) or (ds1='2000-04-09' and key=2) +order by key, value, ds1, ds2 +PREHOOK: type: QUERY +PREHOOK: Input: default@pcr_t1 +PREHOOK: Input: default@pcr_t1@ds1=2000-04-08/ds2=2001-04-08 +PREHOOK: Input: default@pcr_t1@ds1=2000-04-09/ds2=2001-04-09 +#### A masked pattern was here #### +POSTHOOK: query: select key, value, ds1, ds2 +from pcr_t1 +where (ds1='2000-04-08' and key=1) or (ds1='2000-04-09' and key=2) +order by key, value, ds1, ds2 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@pcr_t1 +POSTHOOK: Input: default@pcr_t1@ds1=2000-04-08/ds2=2001-04-08 +POSTHOOK: Input: default@pcr_t1@ds1=2000-04-09/ds2=2001-04-09 +#### A masked pattern was here #### +2 val_2 2000-04-09 2001-04-09 +PREHOOK: query: select key, value, ds1, ds2 +from pcr_t1 +where (ds1='2000-04-08' and ds2='2001-04-08' and key=1) or (ds1='2000-04-09' and ds2='2001-04-08' and key=2) +order by key, value, ds1, ds2 +PREHOOK: type: QUERY +PREHOOK: Input: default@pcr_t1 +PREHOOK: Input: default@pcr_t1@ds1=2000-04-08/ds2=2001-04-08 +#### A masked pattern was here #### +POSTHOOK: query: select key, value, ds1, ds2 +from pcr_t1 +where (ds1='2000-04-08' and ds2='2001-04-08' and key=1) or (ds1='2000-04-09' and ds2='2001-04-08' and key=2) +order by key, value, ds1, ds2 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@pcr_t1 +POSTHOOK: Input: default@pcr_t1@ds1=2000-04-08/ds2=2001-04-08 +#### A masked pattern was here #### +PREHOOK: query: select * +from pcr_t1 t1 join pcr_t1 t2 +on t1.key=t2.key and t1.ds1='2000-04-08' and t2.ds2='2001-04-08' +order by t2.key, t2.value, t1.ds1 +PREHOOK: type: QUERY +PREHOOK: Input: default@pcr_t1 +PREHOOK: Input: default@pcr_t1@ds1=2000-04-08/ds2=2001-04-08 +#### A masked pattern was here #### +POSTHOOK: query: select * +from pcr_t1 t1 join pcr_t1 t2 +on t1.key=t2.key and t1.ds1='2000-04-08' and t2.ds2='2001-04-08' +order by t2.key, t2.value, t1.ds1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@pcr_t1 +POSTHOOK: Input: default@pcr_t1@ds1=2000-04-08/ds2=2001-04-08 +#### A masked pattern was here #### +0 val_0 2000-04-08 2001-04-08 0 val_0 2000-04-08 2001-04-08 +0 val_0 2000-04-08 2001-04-08 0 val_0 2000-04-08 2001-04-08 +0 val_0 2000-04-08 2001-04-08 0 val_0 2000-04-08 2001-04-08 +0 val_0 2000-04-08 2001-04-08 0 val_0 2000-04-08 2001-04-08 +0 val_0 2000-04-08 2001-04-08 0 val_0 2000-04-08 2001-04-08 +0 val_0 2000-04-08 2001-04-08 0 val_0 2000-04-08 2001-04-08 +0 val_0 2000-04-08 2001-04-08 0 val_0 2000-04-08 2001-04-08 +0 val_0 2000-04-08 2001-04-08 0 val_0 2000-04-08 2001-04-08 +0 val_0 2000-04-08 2001-04-08 0 val_0 2000-04-08 2001-04-08 +2 val_2 2000-04-08 2001-04-08 2 val_2 2000-04-08 2001-04-08 +4 val_4 2000-04-08 2001-04-08 4 val_4 2000-04-08 2001-04-08 +5 val_5 2000-04-08 2001-04-08 5 val_5 2000-04-08 2001-04-08 +5 val_5 2000-04-08 2001-04-08 5 val_5 2000-04-08 2001-04-08 +5 val_5 2000-04-08 2001-04-08 5 val_5 2000-04-08 2001-04-08 +5 val_5 2000-04-08 2001-04-08 5 val_5 2000-04-08 2001-04-08 +5 val_5 2000-04-08 2001-04-08 5 val_5 2000-04-08 2001-04-08 +5 val_5 2000-04-08 2001-04-08 5 val_5 2000-04-08 2001-04-08 +5 val_5 2000-04-08 2001-04-08 5 val_5 2000-04-08 2001-04-08 +5 val_5 2000-04-08 2001-04-08 5 val_5 2000-04-08 2001-04-08 +5 val_5 2000-04-08 2001-04-08 5 val_5 2000-04-08 2001-04-08 +8 val_8 2000-04-08 2001-04-08 8 val_8 2000-04-08 2001-04-08 +9 val_9 2000-04-08 2001-04-08 9 val_9 2000-04-08 2001-04-08 +10 val_10 2000-04-08 2001-04-08 10 val_10 2000-04-08 2001-04-08 +11 val_11 2000-04-08 2001-04-08 11 val_11 2000-04-08 2001-04-08 +12 val_12 2000-04-08 2001-04-08 12 val_12 2000-04-08 2001-04-08 +12 val_12 2000-04-08 2001-04-08 12 val_12 2000-04-08 2001-04-08 +12 val_12 2000-04-08 2001-04-08 12 val_12 2000-04-08 2001-04-08 +12 val_12 2000-04-08 2001-04-08 12 val_12 2000-04-08 2001-04-08 +15 val_15 2000-04-08 2001-04-08 15 val_15 2000-04-08 2001-04-08 +15 val_15 2000-04-08 2001-04-08 15 val_15 2000-04-08 2001-04-08 +15 val_15 2000-04-08 2001-04-08 15 val_15 2000-04-08 2001-04-08 +15 val_15 2000-04-08 2001-04-08 15 val_15 2000-04-08 2001-04-08 +17 val_17 2000-04-08 2001-04-08 17 val_17 2000-04-08 2001-04-08 +18 val_18 2000-04-08 2001-04-08 18 val_18 2000-04-08 2001-04-08 +18 val_18 2000-04-08 2001-04-08 18 val_18 2000-04-08 2001-04-08 +18 val_18 2000-04-08 2001-04-08 18 val_18 2000-04-08 2001-04-08 +18 val_18 2000-04-08 2001-04-08 18 val_18 2000-04-08 2001-04-08 +19 val_19 2000-04-08 2001-04-08 19 val_19 2000-04-08 2001-04-08 +PREHOOK: query: select * +from pcr_t1 t1 join pcr_t1 t2 +on t1.key=t2.key and t1.ds1='2000-04-08' and t2.ds1='2000-04-09' +order by t2.key, t2.value, t1.ds1 +PREHOOK: type: QUERY +PREHOOK: Input: default@pcr_t1 +PREHOOK: Input: default@pcr_t1@ds1=2000-04-08/ds2=2001-04-08 +PREHOOK: Input: default@pcr_t1@ds1=2000-04-09/ds2=2001-04-09 +#### A masked pattern was here #### +POSTHOOK: query: select * +from pcr_t1 t1 join pcr_t1 t2 +on t1.key=t2.key and t1.ds1='2000-04-08' and t2.ds1='2000-04-09' +order by t2.key, t2.value, t1.ds1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@pcr_t1 +POSTHOOK: Input: default@pcr_t1@ds1=2000-04-08/ds2=2001-04-08 +POSTHOOK: Input: default@pcr_t1@ds1=2000-04-09/ds2=2001-04-09 +#### A masked pattern was here #### +0 val_0 2000-04-08 2001-04-08 0 val_0 2000-04-09 2001-04-09 +0 val_0 2000-04-08 2001-04-08 0 val_0 2000-04-09 2001-04-09 +0 val_0 2000-04-08 2001-04-08 0 val_0 2000-04-09 2001-04-09 +0 val_0 2000-04-08 2001-04-08 0 val_0 2000-04-09 2001-04-09 +0 val_0 2000-04-08 2001-04-08 0 val_0 2000-04-09 2001-04-09 +0 val_0 2000-04-08 2001-04-08 0 val_0 2000-04-09 2001-04-09 +0 val_0 2000-04-08 2001-04-08 0 val_0 2000-04-09 2001-04-09 +0 val_0 2000-04-08 2001-04-08 0 val_0 2000-04-09 2001-04-09 +0 val_0 2000-04-08 2001-04-08 0 val_0 2000-04-09 2001-04-09 +2 val_2 2000-04-08 2001-04-08 2 val_2 2000-04-09 2001-04-09 +4 val_4 2000-04-08 2001-04-08 4 val_4 2000-04-09 2001-04-09 +5 val_5 2000-04-08 2001-04-08 5 val_5 2000-04-09 2001-04-09 +5 val_5 2000-04-08 2001-04-08 5 val_5 2000-04-09 2001-04-09 +5 val_5 2000-04-08 2001-04-08 5 val_5 2000-04-09 2001-04-09 +5 val_5 2000-04-08 2001-04-08 5 val_5 2000-04-09 2001-04-09 +5 val_5 2000-04-08 2001-04-08 5 val_5 2000-04-09 2001-04-09 +5 val_5 2000-04-08 2001-04-08 5 val_5 2000-04-09 2001-04-09 +5 val_5 2000-04-08 2001-04-08 5 val_5 2000-04-09 2001-04-09 +5 val_5 2000-04-08 2001-04-08 5 val_5 2000-04-09 2001-04-09 +5 val_5 2000-04-08 2001-04-08 5 val_5 2000-04-09 2001-04-09 +8 val_8 2000-04-08 2001-04-08 8 val_8 2000-04-09 2001-04-09 +9 val_9 2000-04-08 2001-04-08 9 val_9 2000-04-09 2001-04-09 +10 val_10 2000-04-08 2001-04-08 10 val_10 2000-04-09 2001-04-09 +11 val_11 2000-04-08 2001-04-08 11 val_11 2000-04-09 2001-04-09 +12 val_12 2000-04-08 2001-04-08 12 val_12 2000-04-09 2001-04-09 +12 val_12 2000-04-08 2001-04-08 12 val_12 2000-04-09 2001-04-09 +12 val_12 2000-04-08 2001-04-08 12 val_12 2000-04-09 2001-04-09 +12 val_12 2000-04-08 2001-04-08 12 val_12 2000-04-09 2001-04-09 +15 val_15 2000-04-08 2001-04-08 15 val_15 2000-04-09 2001-04-09 +15 val_15 2000-04-08 2001-04-08 15 val_15 2000-04-09 2001-04-09 +15 val_15 2000-04-08 2001-04-08 15 val_15 2000-04-09 2001-04-09 +15 val_15 2000-04-08 2001-04-08 15 val_15 2000-04-09 2001-04-09 +17 val_17 2000-04-08 2001-04-08 17 val_17 2000-04-09 2001-04-09 +18 val_18 2000-04-08 2001-04-08 18 val_18 2000-04-09 2001-04-09 +18 val_18 2000-04-08 2001-04-08 18 val_18 2000-04-09 2001-04-09 +18 val_18 2000-04-08 2001-04-08 18 val_18 2000-04-09 2001-04-09 +18 val_18 2000-04-08 2001-04-08 18 val_18 2000-04-09 2001-04-09 +19 val_19 2000-04-08 2001-04-08 19 val_19 2000-04-09 2001-04-09 +Warning: Shuffle Join JOIN[8][tables = [$hdt$_0, $hdt$_1]] in Stage 'Stage-1:MAPRED' is a cross product +PREHOOK: query: select * +from pcr_t1 t1 join pcr_t1 t2 +where (t1.ds1='2000-04-08' and t2.key=1) or (t1.ds1='2000-04-09' and t2.key=2) +order by t2.key, t2.value, t1.ds1 +PREHOOK: type: QUERY +PREHOOK: Input: default@pcr_t1 +PREHOOK: Input: default@pcr_t1@ds1=2000-04-08/ds2=2001-04-08 +PREHOOK: Input: default@pcr_t1@ds1=2000-04-09/ds2=2001-04-09 +PREHOOK: Input: default@pcr_t1@ds1=2000-04-10/ds2=2001-04-10 +#### A masked pattern was here #### +POSTHOOK: query: select * +from pcr_t1 t1 join pcr_t1 t2 +where (t1.ds1='2000-04-08' and t2.key=1) or (t1.ds1='2000-04-09' and t2.key=2) +order by t2.key, t2.value, t1.ds1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@pcr_t1 +POSTHOOK: Input: default@pcr_t1@ds1=2000-04-08/ds2=2001-04-08 +POSTHOOK: Input: default@pcr_t1@ds1=2000-04-09/ds2=2001-04-09 +POSTHOOK: Input: default@pcr_t1@ds1=2000-04-10/ds2=2001-04-10 +#### A masked pattern was here #### +0 val_0 2000-04-09 2001-04-09 2 val_2 2000-04-10 2001-04-10 +0 val_0 2000-04-09 2001-04-09 2 val_2 2000-04-08 2001-04-08 +0 val_0 2000-04-09 2001-04-09 2 val_2 2000-04-09 2001-04-09 +0 val_0 2000-04-09 2001-04-09 2 val_2 2000-04-10 2001-04-10 +0 val_0 2000-04-09 2001-04-09 2 val_2 2000-04-08 2001-04-08 +0 val_0 2000-04-09 2001-04-09 2 val_2 2000-04-09 2001-04-09 +0 val_0 2000-04-09 2001-04-09 2 val_2 2000-04-10 2001-04-10 +0 val_0 2000-04-09 2001-04-09 2 val_2 2000-04-08 2001-04-08 +0 val_0 2000-04-09 2001-04-09 2 val_2 2000-04-09 2001-04-09 +10 val_10 2000-04-09 2001-04-09 2 val_2 2000-04-10 2001-04-10 +10 val_10 2000-04-09 2001-04-09 2 val_2 2000-04-08 2001-04-08 +10 val_10 2000-04-09 2001-04-09 2 val_2 2000-04-09 2001-04-09 +11 val_11 2000-04-09 2001-04-09 2 val_2 2000-04-10 2001-04-10 +11 val_11 2000-04-09 2001-04-09 2 val_2 2000-04-08 2001-04-08 +11 val_11 2000-04-09 2001-04-09 2 val_2 2000-04-09 2001-04-09 +12 val_12 2000-04-09 2001-04-09 2 val_2 2000-04-10 2001-04-10 +12 val_12 2000-04-09 2001-04-09 2 val_2 2000-04-08 2001-04-08 +12 val_12 2000-04-09 2001-04-09 2 val_2 2000-04-09 2001-04-09 +12 val_12 2000-04-09 2001-04-09 2 val_2 2000-04-10 2001-04-10 +12 val_12 2000-04-09 2001-04-09 2 val_2 2000-04-08 2001-04-08 +12 val_12 2000-04-09 2001-04-09 2 val_2 2000-04-09 2001-04-09 +15 val_15 2000-04-09 2001-04-09 2 val_2 2000-04-10 2001-04-10 +15 val_15 2000-04-09 2001-04-09 2 val_2 2000-04-08 2001-04-08 +15 val_15 2000-04-09 2001-04-09 2 val_2 2000-04-09 2001-04-09 +15 val_15 2000-04-09 2001-04-09 2 val_2 2000-04-10 2001-04-10 +15 val_15 2000-04-09 2001-04-09 2 val_2 2000-04-08 2001-04-08 +15 val_15 2000-04-09 2001-04-09 2 val_2 2000-04-09 2001-04-09 +17 val_17 2000-04-09 2001-04-09 2 val_2 2000-04-10 2001-04-10 +17 val_17 2000-04-09 2001-04-09 2 val_2 2000-04-08 2001-04-08 +17 val_17 2000-04-09 2001-04-09 2 val_2 2000-04-09 2001-04-09 +18 val_18 2000-04-09 2001-04-09 2 val_2 2000-04-10 2001-04-10 +18 val_18 2000-04-09 2001-04-09 2 val_2 2000-04-08 2001-04-08 +18 val_18 2000-04-09 2001-04-09 2 val_2 2000-04-09 2001-04-09 +18 val_18 2000-04-09 2001-04-09 2 val_2 2000-04-10 2001-04-10 +18 val_18 2000-04-09 2001-04-09 2 val_2 2000-04-08 2001-04-08 +18 val_18 2000-04-09 2001-04-09 2 val_2 2000-04-09 2001-04-09 +19 val_19 2000-04-09 2001-04-09 2 val_2 2000-04-10 2001-04-10 +19 val_19 2000-04-09 2001-04-09 2 val_2 2000-04-08 2001-04-08 +19 val_19 2000-04-09 2001-04-09 2 val_2 2000-04-09 2001-04-09 +2 val_2 2000-04-09 2001-04-09 2 val_2 2000-04-10 2001-04-10 +2 val_2 2000-04-09 2001-04-09 2 val_2 2000-04-08 2001-04-08 +2 val_2 2000-04-09 2001-04-09 2 val_2 2000-04-09 2001-04-09 +4 val_4 2000-04-09 2001-04-09 2 val_2 2000-04-10 2001-04-10 +4 val_4 2000-04-09 2001-04-09 2 val_2 2000-04-08 2001-04-08 +4 val_4 2000-04-09 2001-04-09 2 val_2 2000-04-09 2001-04-09 +5 val_5 2000-04-09 2001-04-09 2 val_2 2000-04-10 2001-04-10 +5 val_5 2000-04-09 2001-04-09 2 val_2 2000-04-08 2001-04-08 +5 val_5 2000-04-09 2001-04-09 2 val_2 2000-04-09 2001-04-09 +5 val_5 2000-04-09 2001-04-09 2 val_2 2000-04-10 2001-04-10 +5 val_5 2000-04-09 2001-04-09 2 val_2 2000-04-08 2001-04-08 +5 val_5 2000-04-09 2001-04-09 2 val_2 2000-04-09 2001-04-09 +5 val_5 2000-04-09 2001-04-09 2 val_2 2000-04-10 2001-04-10 +5 val_5 2000-04-09 2001-04-09 2 val_2 2000-04-08 2001-04-08 +5 val_5 2000-04-09 2001-04-09 2 val_2 2000-04-09 2001-04-09 +8 val_8 2000-04-09 2001-04-09 2 val_2 2000-04-10 2001-04-10 +8 val_8 2000-04-09 2001-04-09 2 val_2 2000-04-08 2001-04-08 +8 val_8 2000-04-09 2001-04-09 2 val_2 2000-04-09 2001-04-09 +9 val_9 2000-04-09 2001-04-09 2 val_2 2000-04-10 2001-04-10 +9 val_9 2000-04-09 2001-04-09 2 val_2 2000-04-08 2001-04-08 +9 val_9 2000-04-09 2001-04-09 2 val_2 2000-04-09 2001-04-09 +PREHOOK: query: explain extended +select key, value, ds1, ds2 +from pcr_t1 +where (ds1='2000-04-08' and key=1) or (ds1='2000-04-09' and key=2) +order by key, value, ds1, ds2 +PREHOOK: type: QUERY +POSTHOOK: query: explain extended +select key, value, ds1, ds2 +from pcr_t1 +where (ds1='2000-04-08' and key=1) or (ds1='2000-04-09' and key=2) +order by key, value, ds1, ds2 +POSTHOOK: type: QUERY +STAGE DEPENDENCIES: + Stage-1 is a root stage + Stage-0 depends on stages: Stage-1 + +STAGE PLANS: + Stage: Stage-1 + Map Reduce + Map Operator Tree: + TableScan + alias: pcr_t1 + Statistics: Num rows: 40 Data size: 320 Basic stats: COMPLETE Column stats: NONE + GatherStats: false + Filter Operator + isSamplingPred: false predicate: (struct(key,ds1)) IN (const struct(1,'2000-04-08'), const struct(2,'2000-04-09')) (type: boolean) Statistics: Num rows: 20 Data size: 160 Basic stats: COMPLETE Column stats: NONE Select Operator @@ -347,13 +1688,13 @@ PREHOOK: query: explain extended select * from pcr_t1 t1 join pcr_t1 t2 on t1.key=t2.key and t1.ds1='2000-04-08' and t2.ds2='2001-04-08' -order by t1.key +order by t2.key, t2.value, t1.ds1 PREHOOK: type: QUERY POSTHOOK: query: explain extended select * from pcr_t1 t1 join pcr_t1 t2 on t1.key=t2.key and t1.ds1='2000-04-08' and t2.ds2='2001-04-08' -order by t1.key +order by t2.key, t2.value, t1.ds1 POSTHOOK: type: QUERY STAGE DEPENDENCIES: Stage-1 is a root stage @@ -498,12 +1839,12 @@ STAGE PLANS: TableScan GatherStats: false Reduce Output Operator - key expressions: _col0 (type: int) - null sort order: a - sort order: + + key expressions: _col3 (type: int), _col4 (type: string) + null sort order: aa + sort order: ++ Statistics: Num rows: 22 Data size: 176 Basic stats: COMPLETE Column stats: NONE tag: -1 - value expressions: _col1 (type: string), _col2 (type: string), _col3 (type: int), _col4 (type: string), _col5 (type: string) + value expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string), _col5 (type: string) auto parallelism: false Path -> Alias: #### A masked pattern was here #### @@ -535,7 +1876,7 @@ STAGE PLANS: Needs Tagging: false Reduce Operator Tree: Select Operator - expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: string), '2000-04-08' (type: string), VALUE._col1 (type: string), VALUE._col2 (type: int), VALUE._col3 (type: string), VALUE._col4 (type: string), '2001-04-08' (type: string) + expressions: VALUE._col0 (type: int), VALUE._col1 (type: string), '2000-04-08' (type: string), VALUE._col2 (type: string), KEY.reducesinkkey0 (type: int), KEY.reducesinkkey1 (type: string), VALUE._col3 (type: string), '2001-04-08' (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7 Statistics: Num rows: 22 Data size: 176 Basic stats: COMPLETE Column stats: NONE File Output Operator @@ -571,13 +1912,13 @@ PREHOOK: query: explain extended select * from pcr_t1 t1 join pcr_t1 t2 on t1.key=t2.key and t1.ds1='2000-04-08' and t2.ds1='2000-04-09' -order by t1.key +order by t2.key, t2.value, t1.ds1 PREHOOK: type: QUERY POSTHOOK: query: explain extended select * from pcr_t1 t1 join pcr_t1 t2 on t1.key=t2.key and t1.ds1='2000-04-08' and t2.ds1='2000-04-09' -order by t1.key +order by t2.key, t2.value, t1.ds1 POSTHOOK: type: QUERY STAGE DEPENDENCIES: Stage-1 is a root stage @@ -771,12 +2112,12 @@ STAGE PLANS: TableScan GatherStats: false Reduce Output Operator - key expressions: _col0 (type: int) - null sort order: a - sort order: + + key expressions: _col3 (type: int), _col4 (type: string) + null sort order: aa + sort order: ++ Statistics: Num rows: 22 Data size: 176 Basic stats: COMPLETE Column stats: NONE tag: -1 - value expressions: _col1 (type: string), _col2 (type: string), _col3 (type: int), _col4 (type: string), _col5 (type: string) + value expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string), _col5 (type: string) auto parallelism: false Path -> Alias: #### A masked pattern was here #### @@ -808,7 +2149,7 @@ STAGE PLANS: Needs Tagging: false Reduce Operator Tree: Select Operator - expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: string), '2000-04-08' (type: string), VALUE._col1 (type: string), VALUE._col2 (type: int), VALUE._col3 (type: string), '2000-04-09' (type: string), VALUE._col4 (type: string) + expressions: VALUE._col0 (type: int), VALUE._col1 (type: string), '2000-04-08' (type: string), VALUE._col2 (type: string), KEY.reducesinkkey0 (type: int), KEY.reducesinkkey1 (type: string), '2000-04-09' (type: string), VALUE._col3 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7 Statistics: Num rows: 22 Data size: 176 Basic stats: COMPLETE Column stats: NONE File Output Operator @@ -1155,6 +2496,232 @@ STAGE PLANS: Processor Tree: ListSink +PREHOOK: query: select key, value, ds1, ds2 +from pcr_t1 +where (ds1='2000-04-08' and key=1) or (ds1='2000-04-09' and key=2) +order by key, value, ds1, ds2 +PREHOOK: type: QUERY +PREHOOK: Input: default@pcr_t1 +PREHOOK: Input: default@pcr_t1@ds1=2000-04-08/ds2=2001-04-08 +PREHOOK: Input: default@pcr_t1@ds1=2000-04-09/ds2=2001-04-09 +#### A masked pattern was here #### +POSTHOOK: query: select key, value, ds1, ds2 +from pcr_t1 +where (ds1='2000-04-08' and key=1) or (ds1='2000-04-09' and key=2) +order by key, value, ds1, ds2 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@pcr_t1 +POSTHOOK: Input: default@pcr_t1@ds1=2000-04-08/ds2=2001-04-08 +POSTHOOK: Input: default@pcr_t1@ds1=2000-04-09/ds2=2001-04-09 +#### A masked pattern was here #### +2 val_2 2000-04-09 2001-04-09 +PREHOOK: query: select key, value, ds1, ds2 +from pcr_t1 +where (ds1='2000-04-08' and ds2='2001-04-08' and key=1) or (ds1='2000-04-09' and ds2='2001-04-08' and key=2) +order by key, value, ds1, ds2 +PREHOOK: type: QUERY +PREHOOK: Input: default@pcr_t1 +PREHOOK: Input: default@pcr_t1@ds1=2000-04-08/ds2=2001-04-08 +#### A masked pattern was here #### +POSTHOOK: query: select key, value, ds1, ds2 +from pcr_t1 +where (ds1='2000-04-08' and ds2='2001-04-08' and key=1) or (ds1='2000-04-09' and ds2='2001-04-08' and key=2) +order by key, value, ds1, ds2 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@pcr_t1 +POSTHOOK: Input: default@pcr_t1@ds1=2000-04-08/ds2=2001-04-08 +#### A masked pattern was here #### +PREHOOK: query: select * +from pcr_t1 t1 join pcr_t1 t2 +on t1.key=t2.key and t1.ds1='2000-04-08' and t2.ds2='2001-04-08' +order by t2.key, t2.value, t1.ds1 +PREHOOK: type: QUERY +PREHOOK: Input: default@pcr_t1 +PREHOOK: Input: default@pcr_t1@ds1=2000-04-08/ds2=2001-04-08 +#### A masked pattern was here #### +POSTHOOK: query: select * +from pcr_t1 t1 join pcr_t1 t2 +on t1.key=t2.key and t1.ds1='2000-04-08' and t2.ds2='2001-04-08' +order by t2.key, t2.value, t1.ds1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@pcr_t1 +POSTHOOK: Input: default@pcr_t1@ds1=2000-04-08/ds2=2001-04-08 +#### A masked pattern was here #### +0 val_0 2000-04-08 2001-04-08 0 val_0 2000-04-08 2001-04-08 +0 val_0 2000-04-08 2001-04-08 0 val_0 2000-04-08 2001-04-08 +0 val_0 2000-04-08 2001-04-08 0 val_0 2000-04-08 2001-04-08 +0 val_0 2000-04-08 2001-04-08 0 val_0 2000-04-08 2001-04-08 +0 val_0 2000-04-08 2001-04-08 0 val_0 2000-04-08 2001-04-08 +0 val_0 2000-04-08 2001-04-08 0 val_0 2000-04-08 2001-04-08 +0 val_0 2000-04-08 2001-04-08 0 val_0 2000-04-08 2001-04-08 +0 val_0 2000-04-08 2001-04-08 0 val_0 2000-04-08 2001-04-08 +0 val_0 2000-04-08 2001-04-08 0 val_0 2000-04-08 2001-04-08 +2 val_2 2000-04-08 2001-04-08 2 val_2 2000-04-08 2001-04-08 +4 val_4 2000-04-08 2001-04-08 4 val_4 2000-04-08 2001-04-08 +5 val_5 2000-04-08 2001-04-08 5 val_5 2000-04-08 2001-04-08 +5 val_5 2000-04-08 2001-04-08 5 val_5 2000-04-08 2001-04-08 +5 val_5 2000-04-08 2001-04-08 5 val_5 2000-04-08 2001-04-08 +5 val_5 2000-04-08 2001-04-08 5 val_5 2000-04-08 2001-04-08 +5 val_5 2000-04-08 2001-04-08 5 val_5 2000-04-08 2001-04-08 +5 val_5 2000-04-08 2001-04-08 5 val_5 2000-04-08 2001-04-08 +5 val_5 2000-04-08 2001-04-08 5 val_5 2000-04-08 2001-04-08 +5 val_5 2000-04-08 2001-04-08 5 val_5 2000-04-08 2001-04-08 +5 val_5 2000-04-08 2001-04-08 5 val_5 2000-04-08 2001-04-08 +8 val_8 2000-04-08 2001-04-08 8 val_8 2000-04-08 2001-04-08 +9 val_9 2000-04-08 2001-04-08 9 val_9 2000-04-08 2001-04-08 +10 val_10 2000-04-08 2001-04-08 10 val_10 2000-04-08 2001-04-08 +11 val_11 2000-04-08 2001-04-08 11 val_11 2000-04-08 2001-04-08 +12 val_12 2000-04-08 2001-04-08 12 val_12 2000-04-08 2001-04-08 +12 val_12 2000-04-08 2001-04-08 12 val_12 2000-04-08 2001-04-08 +12 val_12 2000-04-08 2001-04-08 12 val_12 2000-04-08 2001-04-08 +12 val_12 2000-04-08 2001-04-08 12 val_12 2000-04-08 2001-04-08 +15 val_15 2000-04-08 2001-04-08 15 val_15 2000-04-08 2001-04-08 +15 val_15 2000-04-08 2001-04-08 15 val_15 2000-04-08 2001-04-08 +15 val_15 2000-04-08 2001-04-08 15 val_15 2000-04-08 2001-04-08 +15 val_15 2000-04-08 2001-04-08 15 val_15 2000-04-08 2001-04-08 +17 val_17 2000-04-08 2001-04-08 17 val_17 2000-04-08 2001-04-08 +18 val_18 2000-04-08 2001-04-08 18 val_18 2000-04-08 2001-04-08 +18 val_18 2000-04-08 2001-04-08 18 val_18 2000-04-08 2001-04-08 +18 val_18 2000-04-08 2001-04-08 18 val_18 2000-04-08 2001-04-08 +18 val_18 2000-04-08 2001-04-08 18 val_18 2000-04-08 2001-04-08 +19 val_19 2000-04-08 2001-04-08 19 val_19 2000-04-08 2001-04-08 +PREHOOK: query: select * +from pcr_t1 t1 join pcr_t1 t2 +on t1.key=t2.key and t1.ds1='2000-04-08' and t2.ds1='2000-04-09' +order by t2.key, t2.value, t1.ds1 +PREHOOK: type: QUERY +PREHOOK: Input: default@pcr_t1 +PREHOOK: Input: default@pcr_t1@ds1=2000-04-08/ds2=2001-04-08 +PREHOOK: Input: default@pcr_t1@ds1=2000-04-09/ds2=2001-04-09 +#### A masked pattern was here #### +POSTHOOK: query: select * +from pcr_t1 t1 join pcr_t1 t2 +on t1.key=t2.key and t1.ds1='2000-04-08' and t2.ds1='2000-04-09' +order by t2.key, t2.value, t1.ds1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@pcr_t1 +POSTHOOK: Input: default@pcr_t1@ds1=2000-04-08/ds2=2001-04-08 +POSTHOOK: Input: default@pcr_t1@ds1=2000-04-09/ds2=2001-04-09 +#### A masked pattern was here #### +0 val_0 2000-04-08 2001-04-08 0 val_0 2000-04-09 2001-04-09 +0 val_0 2000-04-08 2001-04-08 0 val_0 2000-04-09 2001-04-09 +0 val_0 2000-04-08 2001-04-08 0 val_0 2000-04-09 2001-04-09 +0 val_0 2000-04-08 2001-04-08 0 val_0 2000-04-09 2001-04-09 +0 val_0 2000-04-08 2001-04-08 0 val_0 2000-04-09 2001-04-09 +0 val_0 2000-04-08 2001-04-08 0 val_0 2000-04-09 2001-04-09 +0 val_0 2000-04-08 2001-04-08 0 val_0 2000-04-09 2001-04-09 +0 val_0 2000-04-08 2001-04-08 0 val_0 2000-04-09 2001-04-09 +0 val_0 2000-04-08 2001-04-08 0 val_0 2000-04-09 2001-04-09 +2 val_2 2000-04-08 2001-04-08 2 val_2 2000-04-09 2001-04-09 +4 val_4 2000-04-08 2001-04-08 4 val_4 2000-04-09 2001-04-09 +5 val_5 2000-04-08 2001-04-08 5 val_5 2000-04-09 2001-04-09 +5 val_5 2000-04-08 2001-04-08 5 val_5 2000-04-09 2001-04-09 +5 val_5 2000-04-08 2001-04-08 5 val_5 2000-04-09 2001-04-09 +5 val_5 2000-04-08 2001-04-08 5 val_5 2000-04-09 2001-04-09 +5 val_5 2000-04-08 2001-04-08 5 val_5 2000-04-09 2001-04-09 +5 val_5 2000-04-08 2001-04-08 5 val_5 2000-04-09 2001-04-09 +5 val_5 2000-04-08 2001-04-08 5 val_5 2000-04-09 2001-04-09 +5 val_5 2000-04-08 2001-04-08 5 val_5 2000-04-09 2001-04-09 +5 val_5 2000-04-08 2001-04-08 5 val_5 2000-04-09 2001-04-09 +8 val_8 2000-04-08 2001-04-08 8 val_8 2000-04-09 2001-04-09 +9 val_9 2000-04-08 2001-04-08 9 val_9 2000-04-09 2001-04-09 +10 val_10 2000-04-08 2001-04-08 10 val_10 2000-04-09 2001-04-09 +11 val_11 2000-04-08 2001-04-08 11 val_11 2000-04-09 2001-04-09 +12 val_12 2000-04-08 2001-04-08 12 val_12 2000-04-09 2001-04-09 +12 val_12 2000-04-08 2001-04-08 12 val_12 2000-04-09 2001-04-09 +12 val_12 2000-04-08 2001-04-08 12 val_12 2000-04-09 2001-04-09 +12 val_12 2000-04-08 2001-04-08 12 val_12 2000-04-09 2001-04-09 +15 val_15 2000-04-08 2001-04-08 15 val_15 2000-04-09 2001-04-09 +15 val_15 2000-04-08 2001-04-08 15 val_15 2000-04-09 2001-04-09 +15 val_15 2000-04-08 2001-04-08 15 val_15 2000-04-09 2001-04-09 +15 val_15 2000-04-08 2001-04-08 15 val_15 2000-04-09 2001-04-09 +17 val_17 2000-04-08 2001-04-08 17 val_17 2000-04-09 2001-04-09 +18 val_18 2000-04-08 2001-04-08 18 val_18 2000-04-09 2001-04-09 +18 val_18 2000-04-08 2001-04-08 18 val_18 2000-04-09 2001-04-09 +18 val_18 2000-04-08 2001-04-08 18 val_18 2000-04-09 2001-04-09 +18 val_18 2000-04-08 2001-04-08 18 val_18 2000-04-09 2001-04-09 +19 val_19 2000-04-08 2001-04-08 19 val_19 2000-04-09 2001-04-09 +Warning: Shuffle Join JOIN[8][tables = [$hdt$_0, $hdt$_1]] in Stage 'Stage-1:MAPRED' is a cross product +PREHOOK: query: select * +from pcr_t1 t1 join pcr_t1 t2 +where (t1.ds1='2000-04-08' and t2.key=1) or (t1.ds1='2000-04-09' and t2.key=2) +order by t2.key, t2.value, t1.ds1 +PREHOOK: type: QUERY +PREHOOK: Input: default@pcr_t1 +PREHOOK: Input: default@pcr_t1@ds1=2000-04-08/ds2=2001-04-08 +PREHOOK: Input: default@pcr_t1@ds1=2000-04-09/ds2=2001-04-09 +PREHOOK: Input: default@pcr_t1@ds1=2000-04-10/ds2=2001-04-10 +#### A masked pattern was here #### +POSTHOOK: query: select * +from pcr_t1 t1 join pcr_t1 t2 +where (t1.ds1='2000-04-08' and t2.key=1) or (t1.ds1='2000-04-09' and t2.key=2) +order by t2.key, t2.value, t1.ds1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@pcr_t1 +POSTHOOK: Input: default@pcr_t1@ds1=2000-04-08/ds2=2001-04-08 +POSTHOOK: Input: default@pcr_t1@ds1=2000-04-09/ds2=2001-04-09 +POSTHOOK: Input: default@pcr_t1@ds1=2000-04-10/ds2=2001-04-10 +#### A masked pattern was here #### +0 val_0 2000-04-09 2001-04-09 2 val_2 2000-04-10 2001-04-10 +0 val_0 2000-04-09 2001-04-09 2 val_2 2000-04-08 2001-04-08 +0 val_0 2000-04-09 2001-04-09 2 val_2 2000-04-09 2001-04-09 +0 val_0 2000-04-09 2001-04-09 2 val_2 2000-04-10 2001-04-10 +0 val_0 2000-04-09 2001-04-09 2 val_2 2000-04-08 2001-04-08 +0 val_0 2000-04-09 2001-04-09 2 val_2 2000-04-09 2001-04-09 +0 val_0 2000-04-09 2001-04-09 2 val_2 2000-04-10 2001-04-10 +0 val_0 2000-04-09 2001-04-09 2 val_2 2000-04-08 2001-04-08 +0 val_0 2000-04-09 2001-04-09 2 val_2 2000-04-09 2001-04-09 +10 val_10 2000-04-09 2001-04-09 2 val_2 2000-04-10 2001-04-10 +10 val_10 2000-04-09 2001-04-09 2 val_2 2000-04-08 2001-04-08 +10 val_10 2000-04-09 2001-04-09 2 val_2 2000-04-09 2001-04-09 +11 val_11 2000-04-09 2001-04-09 2 val_2 2000-04-10 2001-04-10 +11 val_11 2000-04-09 2001-04-09 2 val_2 2000-04-08 2001-04-08 +11 val_11 2000-04-09 2001-04-09 2 val_2 2000-04-09 2001-04-09 +12 val_12 2000-04-09 2001-04-09 2 val_2 2000-04-10 2001-04-10 +12 val_12 2000-04-09 2001-04-09 2 val_2 2000-04-08 2001-04-08 +12 val_12 2000-04-09 2001-04-09 2 val_2 2000-04-09 2001-04-09 +12 val_12 2000-04-09 2001-04-09 2 val_2 2000-04-10 2001-04-10 +12 val_12 2000-04-09 2001-04-09 2 val_2 2000-04-08 2001-04-08 +12 val_12 2000-04-09 2001-04-09 2 val_2 2000-04-09 2001-04-09 +15 val_15 2000-04-09 2001-04-09 2 val_2 2000-04-10 2001-04-10 +15 val_15 2000-04-09 2001-04-09 2 val_2 2000-04-08 2001-04-08 +15 val_15 2000-04-09 2001-04-09 2 val_2 2000-04-09 2001-04-09 +15 val_15 2000-04-09 2001-04-09 2 val_2 2000-04-10 2001-04-10 +15 val_15 2000-04-09 2001-04-09 2 val_2 2000-04-08 2001-04-08 +15 val_15 2000-04-09 2001-04-09 2 val_2 2000-04-09 2001-04-09 +17 val_17 2000-04-09 2001-04-09 2 val_2 2000-04-10 2001-04-10 +17 val_17 2000-04-09 2001-04-09 2 val_2 2000-04-08 2001-04-08 +17 val_17 2000-04-09 2001-04-09 2 val_2 2000-04-09 2001-04-09 +18 val_18 2000-04-09 2001-04-09 2 val_2 2000-04-10 2001-04-10 +18 val_18 2000-04-09 2001-04-09 2 val_2 2000-04-08 2001-04-08 +18 val_18 2000-04-09 2001-04-09 2 val_2 2000-04-09 2001-04-09 +18 val_18 2000-04-09 2001-04-09 2 val_2 2000-04-10 2001-04-10 +18 val_18 2000-04-09 2001-04-09 2 val_2 2000-04-08 2001-04-08 +18 val_18 2000-04-09 2001-04-09 2 val_2 2000-04-09 2001-04-09 +19 val_19 2000-04-09 2001-04-09 2 val_2 2000-04-10 2001-04-10 +19 val_19 2000-04-09 2001-04-09 2 val_2 2000-04-08 2001-04-08 +19 val_19 2000-04-09 2001-04-09 2 val_2 2000-04-09 2001-04-09 +2 val_2 2000-04-09 2001-04-09 2 val_2 2000-04-10 2001-04-10 +2 val_2 2000-04-09 2001-04-09 2 val_2 2000-04-08 2001-04-08 +2 val_2 2000-04-09 2001-04-09 2 val_2 2000-04-09 2001-04-09 +4 val_4 2000-04-09 2001-04-09 2 val_2 2000-04-10 2001-04-10 +4 val_4 2000-04-09 2001-04-09 2 val_2 2000-04-08 2001-04-08 +4 val_4 2000-04-09 2001-04-09 2 val_2 2000-04-09 2001-04-09 +5 val_5 2000-04-09 2001-04-09 2 val_2 2000-04-10 2001-04-10 +5 val_5 2000-04-09 2001-04-09 2 val_2 2000-04-08 2001-04-08 +5 val_5 2000-04-09 2001-04-09 2 val_2 2000-04-09 2001-04-09 +5 val_5 2000-04-09 2001-04-09 2 val_2 2000-04-10 2001-04-10 +5 val_5 2000-04-09 2001-04-09 2 val_2 2000-04-08 2001-04-08 +5 val_5 2000-04-09 2001-04-09 2 val_2 2000-04-09 2001-04-09 +5 val_5 2000-04-09 2001-04-09 2 val_2 2000-04-10 2001-04-10 +5 val_5 2000-04-09 2001-04-09 2 val_2 2000-04-08 2001-04-08 +5 val_5 2000-04-09 2001-04-09 2 val_2 2000-04-09 2001-04-09 +8 val_8 2000-04-09 2001-04-09 2 val_2 2000-04-10 2001-04-10 +8 val_8 2000-04-09 2001-04-09 2 val_2 2000-04-08 2001-04-08 +8 val_8 2000-04-09 2001-04-09 2 val_2 2000-04-09 2001-04-09 +9 val_9 2000-04-09 2001-04-09 2 val_2 2000-04-10 2001-04-10 +9 val_9 2000-04-09 2001-04-09 2 val_2 2000-04-08 2001-04-08 +9 val_9 2000-04-09 2001-04-09 2 val_2 2000-04-09 2001-04-09 PREHOOK: query: drop table pcr_t1 PREHOOK: type: DROPTABLE PREHOOK: Input: default@pcr_t1 http://git-wip-us.apache.org/repos/asf/hive/blob/6924b9cd/ql/src/test/results/clientpositive/pointlookup4.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/pointlookup4.q.out b/ql/src/test/results/clientpositive/pointlookup4.q.out index 3c9cc60..a9eb713 100644 --- a/ql/src/test/results/clientpositive/pointlookup4.q.out +++ b/ql/src/test/results/clientpositive/pointlookup4.q.out @@ -216,6 +216,25 @@ STAGE PLANS: Processor Tree: ListSink +PREHOOK: query: select key, value, ds1, ds2 +from pcr_t1 +where (ds1='2000-04-08' and ds2='2001-04-08' and key=1) or (ds1='2000-04-09' and ds2='2001-04-09' and key=2) +order by key, value, ds1, ds2 +PREHOOK: type: QUERY +PREHOOK: Input: default@pcr_t1 +PREHOOK: Input: default@pcr_t1@ds1=2000-04-08/ds2=2001-04-08 +PREHOOK: Input: default@pcr_t1@ds1=2000-04-09/ds2=2001-04-09 +#### A masked pattern was here #### +POSTHOOK: query: select key, value, ds1, ds2 +from pcr_t1 +where (ds1='2000-04-08' and ds2='2001-04-08' and key=1) or (ds1='2000-04-09' and ds2='2001-04-09' and key=2) +order by key, value, ds1, ds2 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@pcr_t1 +POSTHOOK: Input: default@pcr_t1@ds1=2000-04-08/ds2=2001-04-08 +POSTHOOK: Input: default@pcr_t1@ds1=2000-04-09/ds2=2001-04-09 +#### A masked pattern was here #### +2 val_2 2000-04-09 2001-04-09 PREHOOK: query: explain extended select key, value, ds1, ds2 from pcr_t1 @@ -392,6 +411,25 @@ STAGE PLANS: Processor Tree: ListSink +PREHOOK: query: select key, value, ds1, ds2 +from pcr_t1 +where (ds1='2000-04-08' and ds2='2001-04-08' and key=1) or (ds1='2000-04-09' and ds2='2001-04-09' and key=2) +order by key, value, ds1, ds2 +PREHOOK: type: QUERY +PREHOOK: Input: default@pcr_t1 +PREHOOK: Input: default@pcr_t1@ds1=2000-04-08/ds2=2001-04-08 +PREHOOK: Input: default@pcr_t1@ds1=2000-04-09/ds2=2001-04-09 +#### A masked pattern was here #### +POSTHOOK: query: select key, value, ds1, ds2 +from pcr_t1 +where (ds1='2000-04-08' and ds2='2001-04-08' and key=1) or (ds1='2000-04-09' and ds2='2001-04-09' and key=2) +order by key, value, ds1, ds2 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@pcr_t1 +POSTHOOK: Input: default@pcr_t1@ds1=2000-04-08/ds2=2001-04-08 +POSTHOOK: Input: default@pcr_t1@ds1=2000-04-09/ds2=2001-04-09 +#### A masked pattern was here #### +2 val_2 2000-04-09 2001-04-09 PREHOOK: query: drop table pcr_t1 PREHOOK: type: DROPTABLE PREHOOK: Input: default@pcr_t1
