PageRenderTime 41ms CodeModel.GetById 16ms RepoModel.GetById 0ms app.codeStats 0ms

/tags/release-0.0.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 
    

  1. PREHOOK: query: drop table dest1
    2. 

  2. PREHOOK: type: DROPTABLE
    3. 

  3. PREHOOK: query: CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE
    4. 

  4. PREHOOK: type: CREATETABLE
    5. 

  5. PREHOOK: query: INSERT OVERWRITE TABLE dest1 
    6. 

  6. SELECT /*+ MAPJOIN(x) */ x.key, count(1) FROM src1 x JOIN src y ON (x.key = y.key) group by x.key
    7. 

  7. PREHOOK: type: QUERY
    8. 

  8. PREHOOK: Input: default@src
    9. 

  9. PREHOOK: Input: default@src1
    10. 

  10. PREHOOK: Output: default@dest1
    11. 

  11. [MapJoinCounter PostHook] CONVERTED_LOCAL_MAPJOIN: 0 CONVERTED_MAPJOIN: 0 LOCAL_MAPJOIN: 1 COMMON_JOIN: 0 BACKUP_COMMON_JOIN: 0
    12. 

  12. PREHOOK: query: FROM src src1 JOIN src src2 ON (src1.key = src2.key) JOIN src src3 ON (src1.key = src3.key)
    13. 

  13. INSERT OVERWRITE TABLE dest1 SELECT src1.key, src3.value
    14. 

  14. PREHOOK: type: QUERY
    15. 

  15. PREHOOK: Input: default@src
    16. 

  16. PREHOOK: Output: default@dest1
    17. 

  17. [MapJoinCounter PostHook] CONVERTED_LOCAL_MAPJOIN: 1 CONVERTED_MAPJOIN: 1 LOCAL_MAPJOIN: 0 COMMON_JOIN: 0 BACKUP_COMMON_JOIN: 0
    18. 

  18. PREHOOK: query: FROM srcpart src1 JOIN src src2 ON (src1.key = src2.key)
    19. 

  19. INSERT OVERWRITE TABLE dest1 SELECT src1.key, src2.value 
    20. 

  20. where (src1.ds = '2008-04-08' or src1.ds = '2008-04-09' )and (src1.hr = '12' or src1.hr = '11')
    21. 

  21. PREHOOK: type: QUERY
    22. 

  22. PREHOOK: Input: default@src
    23. 

  23. PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
    24. 

  24. PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
    25. 

  25. PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
    26. 

  26. PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
    27. 

  27. PREHOOK: Output: default@dest1
    28. 

  28. FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.MapredLocalTask
    29. 

  29. ATTEMPT: Execute BackupTask: org.apache.hadoop.hive.ql.exec.MapRedTask
    30. 

  30. [MapJoinCounter PostHook] CONVERTED_LOCAL_MAPJOIN: 1 CONVERTED_MAPJOIN: 0 LOCAL_MAPJOIN: 0 COMMON_JOIN: 0 BACKUP_COMMON_JOIN: 1
    31. 

  31. PREHOOK: query: FROM src src1 JOIN src src2 ON (src1.key = src2.key) JOIN src src3 ON (src1.key + src2.key = src3.key)
    32. 

  32. INSERT OVERWRITE TABLE dest1 SELECT src1.key, src3.value
    33. 

  33. PREHOOK: type: QUERY
    34. 

  34. PREHOOK: Input: default@src
    35. 

  35. PREHOOK: Output: default@dest1
    36. 

  36. FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.MapredLocalTask
    37. 

  37. ATTEMPT: Execute BackupTask: org.apache.hadoop.hive.ql.exec.MapRedTask
    38. 

  38. FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.MapredLocalTask
    39. 

  39. ATTEMPT: Execute BackupTask: org.apache.hadoop.hive.ql.exec.MapRedTask
    40. 

  40. [MapJoinCounter PostHook] CONVERTED_LOCAL_MAPJOIN: 2 CONVERTED_MAPJOIN: 0 LOCAL_MAPJOIN: 0 COMMON_JOIN: 0 BACKUP_COMMON_JOIN: 2
    41. 

  41.