/tags/release-0.2.0-rc0/hive/external/ql/src/test/results/clientpositive/mapjoin_hook.q.out
text | 40 lines | 40 code | 0 blank | 0 comment | 0 complexity | 5885b9bd153c1e772a9409113e70b7e9 MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0
- PREHOOK: query: drop table dest1
- PREHOOK: type: DROPTABLE
- PREHOOK: query: CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE
- PREHOOK: type: CREATETABLE
- PREHOOK: query: INSERT OVERWRITE TABLE dest1
- SELECT /*+ MAPJOIN(x) */ x.key, count(1) FROM src1 x JOIN src y ON (x.key = y.key) group by x.key
- PREHOOK: type: QUERY
- PREHOOK: Input: default@src
- PREHOOK: Input: default@src1
- PREHOOK: Output: default@dest1
- [MapJoinCounter PostHook] CONVERTED_LOCAL_MAPJOIN: 0 CONVERTED_MAPJOIN: 0 LOCAL_MAPJOIN: 1 COMMON_JOIN: 0 BACKUP_COMMON_JOIN: 0
- PREHOOK: query: FROM src src1 JOIN src src2 ON (src1.key = src2.key) JOIN src src3 ON (src1.key = src3.key)
- INSERT OVERWRITE TABLE dest1 SELECT src1.key, src3.value
- PREHOOK: type: QUERY
- PREHOOK: Input: default@src
- PREHOOK: Output: default@dest1
- [MapJoinCounter PostHook] CONVERTED_LOCAL_MAPJOIN: 1 CONVERTED_MAPJOIN: 1 LOCAL_MAPJOIN: 0 COMMON_JOIN: 0 BACKUP_COMMON_JOIN: 0
- PREHOOK: query: FROM srcpart src1 JOIN src src2 ON (src1.key = src2.key)
- INSERT OVERWRITE TABLE dest1 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@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
- FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.MapredLocalTask
- ATTEMPT: Execute BackupTask: org.apache.hadoop.hive.ql.exec.MapRedTask
- [MapJoinCounter PostHook] CONVERTED_LOCAL_MAPJOIN: 1 CONVERTED_MAPJOIN: 0 LOCAL_MAPJOIN: 0 COMMON_JOIN: 0 BACKUP_COMMON_JOIN: 1
- 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 dest1 SELECT src1.key, src3.value
- PREHOOK: type: QUERY
- PREHOOK: Input: default@src
- PREHOOK: Output: default@dest1
- FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.MapredLocalTask
- ATTEMPT: Execute BackupTask: org.apache.hadoop.hive.ql.exec.MapRedTask
- FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.MapredLocalTask
- ATTEMPT: Execute BackupTask: org.apache.hadoop.hive.ql.exec.MapRedTask
- [MapJoinCounter PostHook] CONVERTED_LOCAL_MAPJOIN: 2 CONVERTED_MAPJOIN: 0 LOCAL_MAPJOIN: 0 COMMON_JOIN: 0 BACKUP_COMMON_JOIN: 2