PageRenderTime 44ms CodeModel.GetById 18ms RepoModel.GetById 0ms app.codeStats 0ms

/tags/release-0.2.0-rc0/hive/external/ql/src/test/results/clientpositive/input39.q.out

#
text | 189 lines | 183 code | 6 blank | 0 comment | 0 complexity | be4ef3b5c655169c46b93b15f6a206a8 MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0 
    

  1. PREHOOK: query: create table t1(key string, value string) partitioned by (ds string)
    2. 

  2. PREHOOK: type: CREATETABLE
    3. 

  3. POSTHOOK: query: create table t1(key string, value string) partitioned by (ds string)
    4. 

  4. POSTHOOK: type: CREATETABLE
    5. 

  5. POSTHOOK: Output: default@t1
    6. 

  6. PREHOOK: query: create table t2(key string, value string) partitioned by (ds string)
    7. 

  7. PREHOOK: type: CREATETABLE
    8. 

  8. POSTHOOK: query: create table t2(key string, value string) partitioned by (ds string)
    9. 

  9. POSTHOOK: type: CREATETABLE
    10. 

  10. POSTHOOK: Output: default@t2
    11. 

  11. PREHOOK: query: insert overwrite table t1 partition (ds='1')
    12. 

  12. select key, value from src
    13. 

  13. PREHOOK: type: QUERY
    14. 

  14. PREHOOK: Input: default@src
    15. 

  15. PREHOOK: Output: default@t1@ds=1
    16. 

  16. POSTHOOK: query: insert overwrite table t1 partition (ds='1')
    17. 

  17. select key, value from src
    18. 

  18. POSTHOOK: type: QUERY
    19. 

  19. POSTHOOK: Input: default@src
    20. 

  20. POSTHOOK: Output: default@t1@ds=1
    21. 

  21. POSTHOOK: Lineage: t1 PARTITION(ds=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    22. 

  22. POSTHOOK: Lineage: t1 PARTITION(ds=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    23. 

  23. PREHOOK: query: insert overwrite table t1 partition (ds='2')
    24. 

  24. select key, value from src
    25. 

  25. PREHOOK: type: QUERY
    26. 

  26. PREHOOK: Input: default@src
    27. 

  27. PREHOOK: Output: default@t1@ds=2
    28. 

  28. POSTHOOK: query: insert overwrite table t1 partition (ds='2')
    29. 

  29. select key, value from src
    30. 

  30. POSTHOOK: type: QUERY
    31. 

  31. POSTHOOK: Input: default@src
    32. 

  32. POSTHOOK: Output: default@t1@ds=2
    33. 

  33. POSTHOOK: Lineage: t1 PARTITION(ds=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    34. 

  34. POSTHOOK: Lineage: t1 PARTITION(ds=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    35. 

  35. POSTHOOK: Lineage: t1 PARTITION(ds=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    36. 

  36. POSTHOOK: Lineage: t1 PARTITION(ds=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    37. 

  37. PREHOOK: query: insert overwrite table t2 partition (ds='1')
    38. 

  38. select key, value from src
    39. 

  39. PREHOOK: type: QUERY
    40. 

  40. PREHOOK: Input: default@src
    41. 

  41. PREHOOK: Output: default@t2@ds=1
    42. 

  42. POSTHOOK: query: insert overwrite table t2 partition (ds='1')
    43. 

  43. select key, value from src
    44. 

  44. POSTHOOK: type: QUERY
    45. 

  45. POSTHOOK: Input: default@src
    46. 

  46. POSTHOOK: Output: default@t2@ds=1
    47. 

  47. POSTHOOK: Lineage: t1 PARTITION(ds=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    48. 

  48. POSTHOOK: Lineage: t1 PARTITION(ds=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    49. 

  49. POSTHOOK: Lineage: t1 PARTITION(ds=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    50. 

  50. POSTHOOK: Lineage: t1 PARTITION(ds=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    51. 

  51. POSTHOOK: Lineage: t2 PARTITION(ds=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    52. 

  52. POSTHOOK: Lineage: t2 PARTITION(ds=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    53. 

  53. PREHOOK: query: explain
    54. 

  54. select count(1) from t1 join t2 on t1.key=t2.key where t1.ds='1' and t2.ds='1'
    55. 

  55. PREHOOK: type: QUERY
    56. 

  56. POSTHOOK: query: explain
    57. 

  57. select count(1) from t1 join t2 on t1.key=t2.key where t1.ds='1' and t2.ds='1'
    58. 

  58. POSTHOOK: type: QUERY
    59. 

  59. POSTHOOK: Lineage: t1 PARTITION(ds=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    60. 

  60. POSTHOOK: Lineage: t1 PARTITION(ds=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    61. 

  61. POSTHOOK: Lineage: t1 PARTITION(ds=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    62. 

  62. POSTHOOK: Lineage: t1 PARTITION(ds=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    63. 

  63. POSTHOOK: Lineage: t2 PARTITION(ds=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    64. 

  64. POSTHOOK: Lineage: t2 PARTITION(ds=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    65. 

  65. ABSTRACT SYNTAX TREE:
    66. 

  66.   (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_TABREF (TOK_TABNAME t1)) (TOK_TABREF (TOK_TABNAME t2)) (= (. (TOK_TABLE_OR_COL t1) key) (. (TOK_TABLE_OR_COL t2) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION count 1))) (TOK_WHERE (and (= (. (TOK_TABLE_OR_COL t1) ds) '1') (= (. (TOK_TABLE_OR_COL t2) ds) '1')))))
    67. 

  67. 

  68. STAGE DEPENDENCIES:
    69. 

  69.   Stage-1 is a root stage
    70. 

  70.   Stage-2 depends on stages: Stage-1
    71. 

  71.   Stage-0 is a root stage
    72. 

  72. 

  73. STAGE PLANS:
    74. 

  74.   Stage: Stage-1
    75. 

  75.     Map Reduce
    76. 

  76.       Alias -> Map Operator Tree:
    77. 

  77.         t1 
    78. 

  78.           TableScan
    79. 

  79.             alias: t1
    80. 

  80.             Filter Operator
    81. 

  81.               predicate:
    82. 

  82.                   expr: (((hash(rand(460476415)) & 2147483647) % 32) = 0)
    83. 

  83.                   type: boolean
    84. 

  84.               Reduce Output Operator
    85. 

  85.                 key expressions:
    86. 

  86.                       expr: key
    87. 

  87.                       type: string
    88. 

  88.                 sort order: +
    89. 

  89.                 Map-reduce partition columns:
    90. 

  90.                       expr: key
    91. 

  91.                       type: string
    92. 

  92.                 tag: 0
    93. 

  93.                 value expressions:
    94. 

  94.                       expr: ds
    95. 

  95.                       type: string
    96. 

  96.         t2 
    97. 

  97.           TableScan
    98. 

  98.             alias: t2
    99. 

  99.             Filter Operator
    100. 

  100.               predicate:
    101. 

  101.                   expr: (((hash(rand(460476415)) & 2147483647) % 32) = 0)
    102. 

  102.                   type: boolean
    103. 

  103.               Reduce Output Operator
    104. 

  104.                 key expressions:
    105. 

  105.                       expr: key
    106. 

  106.                       type: string
    107. 

  107.                 sort order: +
    108. 

  108.                 Map-reduce partition columns:
    109. 

  109.                       expr: key
    110. 

  110.                       type: string
    111. 

  111.                 tag: 1
    112. 

  112.                 value expressions:
    113. 

  113.                       expr: ds
    114. 

  114.                       type: string
    115. 

  115.       Reduce Operator Tree:
    116. 

  116.         Join Operator
    117. 

  117.           condition map:
    118. 

  118.                Inner Join 0 to 1
    119. 

  119.           condition expressions:
    120. 

  120.             0 {VALUE._col2}
    121. 

  121.             1 {VALUE._col2}
    122. 

  122.           handleSkewJoin: false
    123. 

  123.           outputColumnNames: _col2, _col7
    124. 

  124.           Select Operator
    125. 

  125.             Group By Operator
    126. 

  126.               aggregations:
    127. 

  127.                     expr: count(1)
    128. 

  128.               bucketGroup: false
    129. 

  129.               mode: hash
    130. 

  130.               outputColumnNames: _col0
    131. 

  131.               File Output Operator
    132. 

  132.                 compressed: false
    133. 

  133.                 GlobalTableId: 0
    134. 

  134.                 table:
    135. 

  135.                     input format: org.apache.hadoop.mapred.SequenceFileInputFormat
    136. 

  136.                     output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
    137. 

  137. 

  138.   Stage: Stage-2
    139. 

  139.     Map Reduce
    140. 

  140.       Alias -> Map Operator Tree:
    141. 

  141.         file:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_15-56-17_686_3261350439842445445/-mr-10002 
    142. 

  142.             Reduce Output Operator
    143. 

  143.               sort order: 
    144. 

  144.               tag: -1
    145. 

  145.               value expressions:
    146. 

  146.                     expr: _col0
    147. 

  147.                     type: bigint
    148. 

  148.       Reduce Operator Tree:
    149. 

  149.         Group By Operator
    150. 

  150.           aggregations:
    151. 

  151.                 expr: count(VALUE._col0)
    152. 

  152.           bucketGroup: false
    153. 

  153.           mode: mergepartial
    154. 

  154.           outputColumnNames: _col0
    155. 

  155.           Select Operator
    156. 

  156.             expressions:
    157. 

  157.                   expr: _col0
    158. 

  158.                   type: bigint
    159. 

  159.             outputColumnNames: _col0
    160. 

  160.             File Output Operator
    161. 

  161.               compressed: false
    162. 

  162.               GlobalTableId: 0
    163. 

  163.               table:
    164. 

  164.                   input format: org.apache.hadoop.mapred.TextInputFormat
    165. 

  165.                   output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
    166. 

  166. 

  167.   Stage: Stage-0
    168. 

  168.     Fetch Operator
    169. 

  169.       limit: -1
    170. 

  170. 

  171. 

  172. PREHOOK: query: select count(1) from t1 join t2 on t1.key=t2.key where t1.ds='1' and t2.ds='1'
    173. 

  173. PREHOOK: type: QUERY
    174. 

  174. PREHOOK: Input: default@t1@ds=1
    175. 

  175. PREHOOK: Input: default@t2@ds=1
    176. 

  176. PREHOOK: Output: file:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_15-56-17_843_8594138521492763524/-mr-10000
    177. 

  177. POSTHOOK: query: select count(1) from t1 join t2 on t1.key=t2.key where t1.ds='1' and t2.ds='1'
    178. 

  178. POSTHOOK: type: QUERY
    179. 

  179. POSTHOOK: Input: default@t1@ds=1
    180. 

  180. POSTHOOK: Input: default@t2@ds=1
    181. 

  181. POSTHOOK: Output: file:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_15-56-17_843_8594138521492763524/-mr-10000
    182. 

  182. POSTHOOK: Lineage: t1 PARTITION(ds=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    183. 

  183. POSTHOOK: Lineage: t1 PARTITION(ds=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    184. 

  184. POSTHOOK: Lineage: t1 PARTITION(ds=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    185. 

  185. POSTHOOK: Lineage: t1 PARTITION(ds=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    186. 

  186. POSTHOOK: Lineage: t2 PARTITION(ds=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    187. 

  187. POSTHOOK: Lineage: t2 PARTITION(ds=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    188. 

  188. 18
    189. 

  189. mapred.job.tracker=does.notexist.com:666
    190. 

  190.