PageRenderTime 24ms CodeModel.GetById 18ms app.highlight 2ms RepoModel.GetById 1ms app.codeStats 0ms

/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
 1PREHOOK: query: drop table dest1
 2PREHOOK: type: DROPTABLE
 3PREHOOK: query: CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE
 4PREHOOK: type: CREATETABLE
 5PREHOOK: query: INSERT OVERWRITE TABLE dest1 
 6SELECT /*+ MAPJOIN(x) */ x.key, count(1) FROM src1 x JOIN src y ON (x.key = y.key) group by x.key
 7PREHOOK: type: QUERY
 8PREHOOK: Input: default@src
 9PREHOOK: Input: default@src1
10PREHOOK: Output: default@dest1
11[MapJoinCounter PostHook] CONVERTED_LOCAL_MAPJOIN: 0 CONVERTED_MAPJOIN: 0 LOCAL_MAPJOIN: 1 COMMON_JOIN: 0 BACKUP_COMMON_JOIN: 0
12PREHOOK: query: FROM src src1 JOIN src src2 ON (src1.key = src2.key) JOIN src src3 ON (src1.key = src3.key)
13INSERT OVERWRITE TABLE dest1 SELECT src1.key, src3.value
14PREHOOK: type: QUERY
15PREHOOK: Input: default@src
16PREHOOK: Output: default@dest1
17[MapJoinCounter PostHook] CONVERTED_LOCAL_MAPJOIN: 1 CONVERTED_MAPJOIN: 1 LOCAL_MAPJOIN: 0 COMMON_JOIN: 0 BACKUP_COMMON_JOIN: 0
18PREHOOK: query: FROM srcpart src1 JOIN src src2 ON (src1.key = src2.key)
19INSERT OVERWRITE TABLE dest1 SELECT src1.key, src2.value 
20where (src1.ds = '2008-04-08' or src1.ds = '2008-04-09' )and (src1.hr = '12' or src1.hr = '11')
21PREHOOK: type: QUERY
22PREHOOK: Input: default@src
23PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
24PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
25PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
26PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
27PREHOOK: Output: default@dest1
28FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.MapredLocalTask
29ATTEMPT: Execute BackupTask: org.apache.hadoop.hive.ql.exec.MapRedTask
30[MapJoinCounter PostHook] CONVERTED_LOCAL_MAPJOIN: 1 CONVERTED_MAPJOIN: 0 LOCAL_MAPJOIN: 0 COMMON_JOIN: 0 BACKUP_COMMON_JOIN: 1
31PREHOOK: query: FROM src src1 JOIN src src2 ON (src1.key = src2.key) JOIN src src3 ON (src1.key + src2.key = src3.key)
32INSERT OVERWRITE TABLE dest1 SELECT src1.key, src3.value
33PREHOOK: type: QUERY
34PREHOOK: Input: default@src
35PREHOOK: Output: default@dest1
36FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.MapredLocalTask
37ATTEMPT: Execute BackupTask: org.apache.hadoop.hive.ql.exec.MapRedTask
38FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.MapredLocalTask
39ATTEMPT: Execute BackupTask: org.apache.hadoop.hive.ql.exec.MapRedTask
40[MapJoinCounter PostHook] CONVERTED_LOCAL_MAPJOIN: 2 CONVERTED_MAPJOIN: 0 LOCAL_MAPJOIN: 0 COMMON_JOIN: 0 BACKUP_COMMON_JOIN: 2