PageRenderTime 54ms CodeModel.GetById 17ms RepoModel.GetById 0ms app.codeStats 0ms

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

#
text | 578 lines | 558 code | 20 blank | 0 comment | 0 complexity | e4c18b94fe7a0fdf73e050a48b434b74 MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0 
    

  1. PREHOOK: query: create table abcd (a int, b int, c int, d int)
    2. 

  2. PREHOOK: type: CREATETABLE
    3. 

  3. POSTHOOK: query: create table abcd (a int, b int, c int, d int)
    4. 

  4. POSTHOOK: type: CREATETABLE
    5. 

  5. POSTHOOK: Output: default@abcd
    6. 

  6. PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/in4.txt' INTO TABLE abcd
    7. 

  7. PREHOOK: type: LOAD
    8. 

  8. PREHOOK: Output: default@abcd
    9. 

  9. POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/in4.txt' INTO TABLE abcd
    10. 

  10. POSTHOOK: type: LOAD
    11. 

  11. POSTHOOK: Output: default@abcd
    12. 

  12. PREHOOK: query: select * from abcd
    13. 

  13. PREHOOK: type: QUERY
    14. 

  14. PREHOOK: Input: default@abcd
    15. 

  15. PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-46-53_458_612862284528268304/-mr-10000
    16. 

  16. POSTHOOK: query: select * from abcd
    17. 

  17. POSTHOOK: type: QUERY
    18. 

  18. POSTHOOK: Input: default@abcd
    19. 

  19. POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-46-53_458_612862284528268304/-mr-10000
    20. 

  20. NULL	35	23	6
    21. 

  21. 10	1000	50	1
    22. 

  22. 100	100	10	3
    23. 

  23. 12	NULL	80	2
    24. 

  24. 10	100	NULL	5
    25. 

  25. 10	100	45	4
    26. 

  26. 12	100	75	7
    27. 

  27. PREHOOK: query: explain select a, count(distinct b), count(distinct c), sum(d) from abcd group by a
    28. 

  28. PREHOOK: type: QUERY
    29. 

  29. POSTHOOK: query: explain select a, count(distinct b), count(distinct c), sum(d) from abcd group by a
    30. 

  30. POSTHOOK: type: QUERY
    31. 

  31. ABSTRACT SYNTAX TREE:
    32. 

  32.   (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME abcd))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL a)) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL b))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL c))) (TOK_SELEXPR (TOK_FUNCTION sum (TOK_TABLE_OR_COL d)))) (TOK_GROUPBY (TOK_TABLE_OR_COL a))))
    33. 

  33. 

  34. STAGE DEPENDENCIES:
    35. 

  35.   Stage-1 is a root stage
    36. 

  36.   Stage-0 is a root stage
    37. 

  37. 

  38. STAGE PLANS:
    39. 

  39.   Stage: Stage-1
    40. 

  40.     Map Reduce
    41. 

  41.       Alias -> Map Operator Tree:
    42. 

  42.         abcd 
    43. 

  43.           TableScan
    44. 

  44.             alias: abcd
    45. 

  45.             Select Operator
    46. 

  46.               expressions:
    47. 

  47.                     expr: a
    48. 

  48.                     type: int
    49. 

  49.                     expr: b
    50. 

  50.                     type: int
    51. 

  51.                     expr: c
    52. 

  52.                     type: int
    53. 

  53.                     expr: d
    54. 

  54.                     type: int
    55. 

  55.               outputColumnNames: a, b, c, d
    56. 

  56.               Group By Operator
    57. 

  57.                 aggregations:
    58. 

  58.                       expr: count(DISTINCT b)
    59. 

  59.                       expr: count(DISTINCT c)
    60. 

  60.                       expr: sum(d)
    61. 

  61.                 bucketGroup: false
    62. 

  62.                 keys:
    63. 

  63.                       expr: a
    64. 

  64.                       type: int
    65. 

  65.                       expr: b
    66. 

  66.                       type: int
    67. 

  67.                       expr: c
    68. 

  68.                       type: int
    69. 

  69.                 mode: hash
    70. 

  70.                 outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
    71. 

  71.                 Reduce Output Operator
    72. 

  72.                   key expressions:
    73. 

  73.                         expr: _col0
    74. 

  74.                         type: int
    75. 

  75.                         expr: _col1
    76. 

  76.                         type: int
    77. 

  77.                         expr: _col2
    78. 

  78.                         type: int
    79. 

  79.                   sort order: +++
    80. 

  80.                   Map-reduce partition columns:
    81. 

  81.                         expr: _col0
    82. 

  82.                         type: int
    83. 

  83.                   tag: -1
    84. 

  84.                   value expressions:
    85. 

  85.                         expr: _col3
    86. 

  86.                         type: bigint
    87. 

  87.                         expr: _col4
    88. 

  88.                         type: bigint
    89. 

  89.                         expr: _col5
    90. 

  90.                         type: bigint
    91. 

  91.       Reduce Operator Tree:
    92. 

  92.         Group By Operator
    93. 

  93.           aggregations:
    94. 

  94.                 expr: count(DISTINCT KEY._col1:0._col0)
    95. 

  95.                 expr: count(DISTINCT KEY._col1:1._col0)
    96. 

  96.                 expr: sum(VALUE._col2)
    97. 

  97.           bucketGroup: false
    98. 

  98.           keys:
    99. 

  99.                 expr: KEY._col0
    100. 

  100.                 type: int
    101. 

  101.           mode: mergepartial
    102. 

  102.           outputColumnNames: _col0, _col1, _col2, _col3
    103. 

  103.           Select Operator
    104. 

  104.             expressions:
    105. 

  105.                   expr: _col0
    106. 

  106.                   type: int
    107. 

  107.                   expr: _col1
    108. 

  108.                   type: bigint
    109. 

  109.                   expr: _col2
    110. 

  110.                   type: bigint
    111. 

  111.                   expr: _col3
    112. 

  112.                   type: bigint
    113. 

  113.             outputColumnNames: _col0, _col1, _col2, _col3
    114. 

  114.             File Output Operator
    115. 

  115.               compressed: false
    116. 

  116.               GlobalTableId: 0
    117. 

  117.               table:
    118. 

  118.                   input format: org.apache.hadoop.mapred.TextInputFormat
    119. 

  119.                   output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
    120. 

  120. 

  121.   Stage: Stage-0
    122. 

  122.     Fetch Operator
    123. 

  123.       limit: -1
    124. 

  124. 

  125. 

  126. PREHOOK: query: select a, count(distinct b), count(distinct c), sum(d) from abcd group by a
    127. 

  127. PREHOOK: type: QUERY
    128. 

  128. PREHOOK: Input: default@abcd
    129. 

  129. PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-46-54_530_5497111678274590113/-mr-10000
    130. 

  130. POSTHOOK: query: select a, count(distinct b), count(distinct c), sum(d) from abcd group by a
    131. 

  131. POSTHOOK: type: QUERY
    132. 

  132. POSTHOOK: Input: default@abcd
    133. 

  133. POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-46-54_530_5497111678274590113/-mr-10000
    134. 

  134. NULL	1	1	6
    135. 

  135. 10	2	2	10
    136. 

  136. 12	1	2	9
    137. 

  137. 100	1	1	3
    138. 

  138. PREHOOK: query: explain select count(1), count(*), count(a), count(b), count(c), count(d), count(distinct a), count(distinct b), count(distinct c), count(distinct d), count(distinct a,b), count(distinct b,c), count(distinct c,d), count(distinct a,d), count(distinct a,c), count(distinct b,d), count(distinct a,b,c), count(distinct b,c,d), count(distinct a,c,d), count(distinct a,b,d), count(distinct a,b,c,d) from abcd
    139. 

  139. PREHOOK: type: QUERY
    140. 

  140. POSTHOOK: query: explain select count(1), count(*), count(a), count(b), count(c), count(d), count(distinct a), count(distinct b), count(distinct c), count(distinct d), count(distinct a,b), count(distinct b,c), count(distinct c,d), count(distinct a,d), count(distinct a,c), count(distinct b,d), count(distinct a,b,c), count(distinct b,c,d), count(distinct a,c,d), count(distinct a,b,d), count(distinct a,b,c,d) from abcd
    141. 

  141. POSTHOOK: type: QUERY
    142. 

  142. ABSTRACT SYNTAX TREE:
    143. 

  143.   (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME abcd))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION count 1)) (TOK_SELEXPR (TOK_FUNCTIONSTAR count)) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL a))) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL b))) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL c))) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL d))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL a))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL b))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL c))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL d))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL a) (TOK_TABLE_OR_COL b))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL b) (TOK_TABLE_OR_COL c))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL c) (TOK_TABLE_OR_COL d))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL a) (TOK_TABLE_OR_COL d))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL a) (TOK_TABLE_OR_COL c))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL b) (TOK_TABLE_OR_COL d))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL a) (TOK_TABLE_OR_COL b) (TOK_TABLE_OR_COL c))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL b) (TOK_TABLE_OR_COL c) (TOK_TABLE_OR_COL d))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL a) (TOK_TABLE_OR_COL c) (TOK_TABLE_OR_COL d))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL a) (TOK_TABLE_OR_COL b) (TOK_TABLE_OR_COL d))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL a) (TOK_TABLE_OR_COL b) (TOK_TABLE_OR_COL c) (TOK_TABLE_OR_COL d))))))
    144. 

  144. 

  145. STAGE DEPENDENCIES:
    146. 

  146.   Stage-1 is a root stage
    147. 

  147.   Stage-0 is a root stage
    148. 

  148. 

  149. STAGE PLANS:
    150. 

  150.   Stage: Stage-1
    151. 

  151.     Map Reduce
    152. 

  152.       Alias -> Map Operator Tree:
    153. 

  153.         abcd 
    154. 

  154.           TableScan
    155. 

  155.             alias: abcd
    156. 

  156.             Select Operator
    157. 

  157.               expressions:
    158. 

  158.                     expr: a
    159. 

  159.                     type: int
    160. 

  160.                     expr: b
    161. 

  161.                     type: int
    162. 

  162.                     expr: c
    163. 

  163.                     type: int
    164. 

  164.                     expr: d
    165. 

  165.                     type: int
    166. 

  166.               outputColumnNames: a, b, c, d
    167. 

  167.               Group By Operator
    168. 

  168.                 aggregations:
    169. 

  169.                       expr: count(1)
    170. 

  170.                       expr: count()
    171. 

  171.                       expr: count(a)
    172. 

  172.                       expr: count(b)
    173. 

  173.                       expr: count(c)
    174. 

  174.                       expr: count(d)
    175. 

  175.                       expr: count(DISTINCT a)
    176. 

  176.                       expr: count(DISTINCT b)
    177. 

  177.                       expr: count(DISTINCT c)
    178. 

  178.                       expr: count(DISTINCT d)
    179. 

  179.                       expr: count(DISTINCT a, b)
    180. 

  180.                       expr: count(DISTINCT b, c)
    181. 

  181.                       expr: count(DISTINCT c, d)
    182. 

  182.                       expr: count(DISTINCT a, d)
    183. 

  183.                       expr: count(DISTINCT a, c)
    184. 

  184.                       expr: count(DISTINCT b, d)
    185. 

  185.                       expr: count(DISTINCT a, b, c)
    186. 

  186.                       expr: count(DISTINCT b, c, d)
    187. 

  187.                       expr: count(DISTINCT a, c, d)
    188. 

  188.                       expr: count(DISTINCT a, b, d)
    189. 

  189.                       expr: count(DISTINCT a, b, c, d)
    190. 

  190.                 bucketGroup: false
    191. 

  191.                 keys:
    192. 

  192.                       expr: a
    193. 

  193.                       type: int
    194. 

  194.                       expr: b
    195. 

  195.                       type: int
    196. 

  196.                       expr: c
    197. 

  197.                       type: int
    198. 

  198.                       expr: d
    199. 

  199.                       type: int
    200. 

  200.                 mode: hash
    201. 

  201.                 outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col20, _col21, _col22, _col23, _col24
    202. 

  202.                 Reduce Output Operator
    203. 

  203.                   key expressions:
    204. 

  204.                         expr: _col0
    205. 

  205.                         type: int
    206. 

  206.                         expr: _col1
    207. 

  207.                         type: int
    208. 

  208.                         expr: _col2
    209. 

  209.                         type: int
    210. 

  210.                         expr: _col3
    211. 

  211.                         type: int
    212. 

  212.                   sort order: ++++
    213. 

  213.                   tag: -1
    214. 

  214.                   value expressions:
    215. 

  215.                         expr: _col4
    216. 

  216.                         type: bigint
    217. 

  217.                         expr: _col5
    218. 

  218.                         type: bigint
    219. 

  219.                         expr: _col6
    220. 

  220.                         type: bigint
    221. 

  221.                         expr: _col7
    222. 

  222.                         type: bigint
    223. 

  223.                         expr: _col8
    224. 

  224.                         type: bigint
    225. 

  225.                         expr: _col9
    226. 

  226.                         type: bigint
    227. 

  227.                         expr: _col10
    228. 

  228.                         type: bigint
    229. 

  229.                         expr: _col11
    230. 

  230.                         type: bigint
    231. 

  231.                         expr: _col12
    232. 

  232.                         type: bigint
    233. 

  233.                         expr: _col13
    234. 

  234.                         type: bigint
    235. 

  235.                         expr: _col14
    236. 

  236.                         type: bigint
    237. 

  237.                         expr: _col15
    238. 

  238.                         type: bigint
    239. 

  239.                         expr: _col16
    240. 

  240.                         type: bigint
    241. 

  241.                         expr: _col17
    242. 

  242.                         type: bigint
    243. 

  243.                         expr: _col18
    244. 

  244.                         type: bigint
    245. 

  245.                         expr: _col19
    246. 

  246.                         type: bigint
    247. 

  247.                         expr: _col20
    248. 

  248.                         type: bigint
    249. 

  249.                         expr: _col21
    250. 

  250.                         type: bigint
    251. 

  251.                         expr: _col22
    252. 

  252.                         type: bigint
    253. 

  253.                         expr: _col23
    254. 

  254.                         type: bigint
    255. 

  255.                         expr: _col24
    256. 

  256.                         type: bigint
    257. 

  257.       Reduce Operator Tree:
    258. 

  258.         Group By Operator
    259. 

  259.           aggregations:
    260. 

  260.                 expr: count(VALUE._col0)
    261. 

  261.                 expr: count(VALUE._col1)
    262. 

  262.                 expr: count(VALUE._col2)
    263. 

  263.                 expr: count(VALUE._col3)
    264. 

  264.                 expr: count(VALUE._col4)
    265. 

  265.                 expr: count(VALUE._col5)
    266. 

  266.                 expr: count(DISTINCT KEY._col0:0._col0)
    267. 

  267.                 expr: count(DISTINCT KEY._col0:1._col0)
    268. 

  268.                 expr: count(DISTINCT KEY._col0:2._col0)
    269. 

  269.                 expr: count(DISTINCT KEY._col0:3._col0)
    270. 

  270.                 expr: count(DISTINCT KEY._col0:4._col0, KEY._col0:4._col1)
    271. 

  271.                 expr: count(DISTINCT KEY._col0:5._col0, KEY._col0:5._col1)
    272. 

  272.                 expr: count(DISTINCT KEY._col0:6._col0, KEY._col0:6._col1)
    273. 

  273.                 expr: count(DISTINCT KEY._col0:7._col0, KEY._col0:7._col1)
    274. 

  274.                 expr: count(DISTINCT KEY._col0:8._col0, KEY._col0:8._col1)
    275. 

  275.                 expr: count(DISTINCT KEY._col0:9._col0, KEY._col0:9._col1)
    276. 

  276.                 expr: count(DISTINCT KEY._col0:10._col0, KEY._col0:10._col1, KEY._col0:10._col2)
    277. 

  277.                 expr: count(DISTINCT KEY._col0:11._col0, KEY._col0:11._col1, KEY._col0:11._col2)
    278. 

  278.                 expr: count(DISTINCT KEY._col0:12._col0, KEY._col0:12._col1, KEY._col0:12._col2)
    279. 

  279.                 expr: count(DISTINCT KEY._col0:13._col0, KEY._col0:13._col1, KEY._col0:13._col2)
    280. 

  280.                 expr: count(DISTINCT KEY._col0:14._col0, KEY._col0:14._col1, KEY._col0:14._col2, KEY._col0:14._col3)
    281. 

  281.           bucketGroup: false
    282. 

  282.           mode: mergepartial
    283. 

  283.           outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col20
    284. 

  284.           Select Operator
    285. 

  285.             expressions:
    286. 

  286.                   expr: _col0
    287. 

  287.                   type: bigint
    288. 

  288.                   expr: _col1
    289. 

  289.                   type: bigint
    290. 

  290.                   expr: _col2
    291. 

  291.                   type: bigint
    292. 

  292.                   expr: _col3
    293. 

  293.                   type: bigint
    294. 

  294.                   expr: _col4
    295. 

  295.                   type: bigint
    296. 

  296.                   expr: _col5
    297. 

  297.                   type: bigint
    298. 

  298.                   expr: _col6
    299. 

  299.                   type: bigint
    300. 

  300.                   expr: _col7
    301. 

  301.                   type: bigint
    302. 

  302.                   expr: _col8
    303. 

  303.                   type: bigint
    304. 

  304.                   expr: _col9
    305. 

  305.                   type: bigint
    306. 

  306.                   expr: _col10
    307. 

  307.                   type: bigint
    308. 

  308.                   expr: _col11
    309. 

  309.                   type: bigint
    310. 

  310.                   expr: _col12
    311. 

  311.                   type: bigint
    312. 

  312.                   expr: _col13
    313. 

  313.                   type: bigint
    314. 

  314.                   expr: _col14
    315. 

  315.                   type: bigint
    316. 

  316.                   expr: _col15
    317. 

  317.                   type: bigint
    318. 

  318.                   expr: _col16
    319. 

  319.                   type: bigint
    320. 

  320.                   expr: _col17
    321. 

  321.                   type: bigint
    322. 

  322.                   expr: _col18
    323. 

  323.                   type: bigint
    324. 

  324.                   expr: _col19
    325. 

  325.                   type: bigint
    326. 

  326.                   expr: _col20
    327. 

  327.                   type: bigint
    328. 

  328.             outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col20
    329. 

  329.             File Output Operator
    330. 

  330.               compressed: false
    331. 

  331.               GlobalTableId: 0
    332. 

  332.               table:
    333. 

  333.                   input format: org.apache.hadoop.mapred.TextInputFormat
    334. 

  334.                   output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
    335. 

  335. 

  336.   Stage: Stage-0
    337. 

  337.     Fetch Operator
    338. 

  338.       limit: -1
    339. 

  339. 

  340. 

  341. PREHOOK: query: select count(1), count(*), count(a), count(b), count(c), count(d), count(distinct a), count(distinct b), count(distinct c), count(distinct d), count(distinct a,b), count(distinct b,c), count(distinct c,d), count(distinct a,d), count(distinct a,c), count(distinct b,d), count(distinct a,b,c), count(distinct b,c,d), count(distinct a,c,d), count(distinct a,b,d), count(distinct a,b,c,d) from abcd
    342. 

  342. PREHOOK: type: QUERY
    343. 

  343. PREHOOK: Input: default@abcd
    344. 

  344. PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-47-01_430_3407527654800696294/-mr-10000
    345. 

  345. POSTHOOK: query: select count(1), count(*), count(a), count(b), count(c), count(d), count(distinct a), count(distinct b), count(distinct c), count(distinct d), count(distinct a,b), count(distinct b,c), count(distinct c,d), count(distinct a,d), count(distinct a,c), count(distinct b,d), count(distinct a,b,c), count(distinct b,c,d), count(distinct a,c,d), count(distinct a,b,d), count(distinct a,b,c,d) from abcd
    346. 

  346. POSTHOOK: type: QUERY
    347. 

  347. POSTHOOK: Input: default@abcd
    348. 

  348. POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-47-01_430_3407527654800696294/-mr-10000
    349. 

  349. 7	7	6	6	6	7	3	3	6	7	4	5	6	6	5	6	4	5	5	5	4
    350. 

  350. PREHOOK: query: explain select a, count(distinct b), count(distinct c), sum(d) from abcd group by a
    351. 

  351. PREHOOK: type: QUERY
    352. 

  352. POSTHOOK: query: explain select a, count(distinct b), count(distinct c), sum(d) from abcd group by a
    353. 

  353. POSTHOOK: type: QUERY
    354. 

  354. ABSTRACT SYNTAX TREE:
    355. 

  355.   (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME abcd))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL a)) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL b))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL c))) (TOK_SELEXPR (TOK_FUNCTION sum (TOK_TABLE_OR_COL d)))) (TOK_GROUPBY (TOK_TABLE_OR_COL a))))
    356. 

  356. 

  357. STAGE DEPENDENCIES:
    358. 

  358.   Stage-1 is a root stage
    359. 

  359.   Stage-0 is a root stage
    360. 

  360. 

  361. STAGE PLANS:
    362. 

  362.   Stage: Stage-1
    363. 

  363.     Map Reduce
    364. 

  364.       Alias -> Map Operator Tree:
    365. 

  365.         abcd 
    366. 

  366.           TableScan
    367. 

  367.             alias: abcd
    368. 

  368.             Select Operator
    369. 

  369.               expressions:
    370. 

  370.                     expr: a
    371. 

  371.                     type: int
    372. 

  372.                     expr: b
    373. 

  373.                     type: int
    374. 

  374.                     expr: c
    375. 

  375.                     type: int
    376. 

  376.                     expr: d
    377. 

  377.                     type: int
    378. 

  378.               outputColumnNames: a, b, c, d
    379. 

  379.               Reduce Output Operator
    380. 

  380.                 key expressions:
    381. 

  381.                       expr: a
    382. 

  382.                       type: int
    383. 

  383.                       expr: b
    384. 

  384.                       type: int
    385. 

  385.                       expr: c
    386. 

  386.                       type: int
    387. 

  387.                 sort order: +++
    388. 

  388.                 Map-reduce partition columns:
    389. 

  389.                       expr: a
    390. 

  390.                       type: int
    391. 

  391.                 tag: -1
    392. 

  392.                 value expressions:
    393. 

  393.                       expr: d
    394. 

  394.                       type: int
    395. 

  395.       Reduce Operator Tree:
    396. 

  396.         Group By Operator
    397. 

  397.           aggregations:
    398. 

  398.                 expr: count(DISTINCT KEY._col1:0._col0)
    399. 

  399.                 expr: count(DISTINCT KEY._col1:1._col0)
    400. 

  400.                 expr: sum(VALUE._col0)
    401. 

  401.           bucketGroup: false
    402. 

  402.           keys:
    403. 

  403.                 expr: KEY._col0
    404. 

  404.                 type: int
    405. 

  405.           mode: complete
    406. 

  406.           outputColumnNames: _col0, _col1, _col2, _col3
    407. 

  407.           Select Operator
    408. 

  408.             expressions:
    409. 

  409.                   expr: _col0
    410. 

  410.                   type: int
    411. 

  411.                   expr: _col1
    412. 

  412.                   type: bigint
    413. 

  413.                   expr: _col2
    414. 

  414.                   type: bigint
    415. 

  415.                   expr: _col3
    416. 

  416.                   type: bigint
    417. 

  417.             outputColumnNames: _col0, _col1, _col2, _col3
    418. 

  418.             File Output Operator
    419. 

  419.               compressed: false
    420. 

  420.               GlobalTableId: 0
    421. 

  421.               table:
    422. 

  422.                   input format: org.apache.hadoop.mapred.TextInputFormat
    423. 

  423.                   output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
    424. 

  424. 

  425.   Stage: Stage-0
    426. 

  426.     Fetch Operator
    427. 

  427.       limit: -1
    428. 

  428. 

  429. 

  430. PREHOOK: query: select a, count(distinct b), count(distinct c), sum(d) from abcd group by a
    431. 

  431. PREHOOK: type: QUERY
    432. 

  432. PREHOOK: Input: default@abcd
    433. 

  433. PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-47-10_928_4191678549398242821/-mr-10000
    434. 

  434. POSTHOOK: query: select a, count(distinct b), count(distinct c), sum(d) from abcd group by a
    435. 

  435. POSTHOOK: type: QUERY
    436. 

  436. POSTHOOK: Input: default@abcd
    437. 

  437. POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-47-10_928_4191678549398242821/-mr-10000
    438. 

  438. NULL	1	1	6
    439. 

  439. 10	2	2	10
    440. 

  440. 12	1	2	9
    441. 

  441. 100	1	1	3
    442. 

  442. PREHOOK: query: explain select count(1), count(*), count(a), count(b), count(c), count(d), count(distinct a), count(distinct b), count(distinct c), count(distinct d), count(distinct a,b), count(distinct b,c), count(distinct c,d), count(distinct a,d), count(distinct a,c), count(distinct b,d), count(distinct a,b,c), count(distinct b,c,d), count(distinct a,c,d), count(distinct a,b,d), count(distinct a,b,c,d) from abcd
    443. 

  443. PREHOOK: type: QUERY
    444. 

  444. POSTHOOK: query: explain select count(1), count(*), count(a), count(b), count(c), count(d), count(distinct a), count(distinct b), count(distinct c), count(distinct d), count(distinct a,b), count(distinct b,c), count(distinct c,d), count(distinct a,d), count(distinct a,c), count(distinct b,d), count(distinct a,b,c), count(distinct b,c,d), count(distinct a,c,d), count(distinct a,b,d), count(distinct a,b,c,d) from abcd
    445. 

  445. POSTHOOK: type: QUERY
    446. 

  446. ABSTRACT SYNTAX TREE:
    447. 

  447.   (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME abcd))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION count 1)) (TOK_SELEXPR (TOK_FUNCTIONSTAR count)) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL a))) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL b))) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL c))) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL d))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL a))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL b))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL c))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL d))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL a) (TOK_TABLE_OR_COL b))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL b) (TOK_TABLE_OR_COL c))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL c) (TOK_TABLE_OR_COL d))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL a) (TOK_TABLE_OR_COL d))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL a) (TOK_TABLE_OR_COL c))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL b) (TOK_TABLE_OR_COL d))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL a) (TOK_TABLE_OR_COL b) (TOK_TABLE_OR_COL c))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL b) (TOK_TABLE_OR_COL c) (TOK_TABLE_OR_COL d))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL a) (TOK_TABLE_OR_COL c) (TOK_TABLE_OR_COL d))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL a) (TOK_TABLE_OR_COL b) (TOK_TABLE_OR_COL d))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL a) (TOK_TABLE_OR_COL b) (TOK_TABLE_OR_COL c) (TOK_TABLE_OR_COL d))))))
    448. 

  448. 

  449. STAGE DEPENDENCIES:
    450. 

  450.   Stage-1 is a root stage
    451. 

  451.   Stage-0 is a root stage
    452. 

  452. 

  453. STAGE PLANS:
    454. 

  454.   Stage: Stage-1
    455. 

  455.     Map Reduce
    456. 

  456.       Alias -> Map Operator Tree:
    457. 

  457.         abcd 
    458. 

  458.           TableScan
    459. 

  459.             alias: abcd
    460. 

  460.             Select Operator
    461. 

  461.               expressions:
    462. 

  462.                     expr: a
    463. 

  463.                     type: int
    464. 

  464.                     expr: b
    465. 

  465.                     type: int
    466. 

  466.                     expr: c
    467. 

  467.                     type: int
    468. 

  468.                     expr: d
    469. 

  469.                     type: int
    470. 

  470.               outputColumnNames: a, b, c, d
    471. 

  471.               Reduce Output Operator
    472. 

  472.                 key expressions:
    473. 

  473.                       expr: a
    474. 

  474.                       type: int
    475. 

  475.                       expr: b
    476. 

  476.                       type: int
    477. 

  477.                       expr: c
    478. 

  478.                       type: int
    479. 

  479.                       expr: d
    480. 

  480.                       type: int
    481. 

  481.                 sort order: ++++
    482. 

  482.                 tag: -1
    483. 

  483.                 value expressions:
    484. 

  484.                       expr: 1
    485. 

  485.                       type: int
    486. 

  486.       Reduce Operator Tree:
    487. 

  487.         Group By Operator
    488. 

  488.           aggregations:
    489. 

  489.                 expr: count(VALUE._col0)
    490. 

  490.                 expr: count()
    491. 

  491.                 expr: count(KEY._col0:14._col0)
    492. 

  492.                 expr: count(KEY._col0:14._col1)
    493. 

  493.                 expr: count(KEY._col0:14._col2)
    494. 

  494.                 expr: count(KEY._col0:14._col3)
    495. 

  495.                 expr: count(DISTINCT KEY._col0:0._col0)
    496. 

  496.                 expr: count(DISTINCT KEY._col0:1._col0)
    497. 

  497.                 expr: count(DISTINCT KEY._col0:2._col0)
    498. 

  498.                 expr: count(DISTINCT KEY._col0:3._col0)
    499. 

  499.                 expr: count(DISTINCT KEY._col0:4._col0, KEY._col0:4._col1)
    500. 

  500.                 expr: count(DISTINCT KEY._col0:5._col0, KEY._col0:5._col1)
    501. 

  501.                 expr: count(DISTINCT KEY._col0:6._col0, KEY._col0:6._col1)
    502. 

  502.                 expr: count(DISTINCT KEY._col0:7._col0, KEY._col0:7._col1)
    503. 

  503.                 expr: count(DISTINCT KEY._col0:8._col0, KEY._col0:8._col1)
    504. 

  504.                 expr: count(DISTINCT KEY._col0:9._col0, KEY._col0:9._col1)
    505. 

  505.                 expr: count(DISTINCT KEY._col0:10._col0, KEY._col0:10._col1, KEY._col0:10._col2)
    506. 

  506.                 expr: count(DISTINCT KEY._col0:11._col0, KEY._col0:11._col1, KEY._col0:11._col2)
    507. 

  507.                 expr: count(DISTINCT KEY._col0:12._col0, KEY._col0:12._col1, KEY._col0:12._col2)
    508. 

  508.                 expr: count(DISTINCT KEY._col0:13._col0, KEY._col0:13._col1, KEY._col0:13._col2)
    509. 

  509.                 expr: count(DISTINCT KEY._col0:14._col0, KEY._col0:14._col1, KEY._col0:14._col2, KEY._col0:14._col3)
    510. 

  510.           bucketGroup: false
    511. 

  511.           mode: complete
    512. 

  512.           outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col20
    513. 

  513.           Select Operator
    514. 

  514.             expressions:
    515. 

  515.                   expr: _col0
    516. 

  516.                   type: bigint
    517. 

  517.                   expr: _col1
    518. 

  518.                   type: bigint
    519. 

  519.                   expr: _col2
    520. 

  520.                   type: bigint
    521. 

  521.                   expr: _col3
    522. 

  522.                   type: bigint
    523. 

  523.                   expr: _col4
    524. 

  524.                   type: bigint
    525. 

  525.                   expr: _col5
    526. 

  526.                   type: bigint
    527. 

  527.                   expr: _col6
    528. 

  528.                   type: bigint
    529. 

  529.                   expr: _col7
    530. 

  530.                   type: bigint
    531. 

  531.                   expr: _col8
    532. 

  532.                   type: bigint
    533. 

  533.                   expr: _col9
    534. 

  534.                   type: bigint
    535. 

  535.                   expr: _col10
    536. 

  536.                   type: bigint
    537. 

  537.                   expr: _col11
    538. 

  538.                   type: bigint
    539. 

  539.                   expr: _col12
    540. 

  540.                   type: bigint
    541. 

  541.                   expr: _col13
    542. 

  542.                   type: bigint
    543. 

  543.                   expr: _col14
    544. 

  544.                   type: bigint
    545. 

  545.                   expr: _col15
    546. 

  546.                   type: bigint
    547. 

  547.                   expr: _col16
    548. 

  548.                   type: bigint
    549. 

  549.                   expr: _col17
    550. 

  550.                   type: bigint
    551. 

  551.                   expr: _col18
    552. 

  552.                   type: bigint
    553. 

  553.                   expr: _col19
    554. 

  554.                   type: bigint
    555. 

  555.                   expr: _col20
    556. 

  556.                   type: bigint
    557. 

  557.             outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col20
    558. 

  558.             File Output Operator
    559. 

  559.               compressed: false
    560. 

  560.               GlobalTableId: 0
    561. 

  561.               table:
    562. 

  562.                   input format: org.apache.hadoop.mapred.TextInputFormat
    563. 

  563.                   output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
    564. 

  564. 

  565.   Stage: Stage-0
    566. 

  566.     Fetch Operator
    567. 

  567.       limit: -1
    568. 

  568. 

  569. 

  570. PREHOOK: query: select count(1), count(*), count(a), count(b), count(c), count(d), count(distinct a), count(distinct b), count(distinct c), count(distinct d), count(distinct a,b), count(distinct b,c), count(distinct c,d), count(distinct a,d), count(distinct a,c), count(distinct b,d), count(distinct a,b,c), count(distinct b,c,d), count(distinct a,c,d), count(distinct a,b,d), count(distinct a,b,c,d) from abcd
    571. 

  571. PREHOOK: type: QUERY
    572. 

  572. PREHOOK: Input: default@abcd
    573. 

  573. PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-47-23_137_2355783462946349645/-mr-10000
    574. 

  574. POSTHOOK: query: select count(1), count(*), count(a), count(b), count(c), count(d), count(distinct a), count(distinct b), count(distinct c), count(distinct d), count(distinct a,b), count(distinct b,c), count(distinct c,d), count(distinct a,d), count(distinct a,c), count(distinct b,d), count(distinct a,b,c), count(distinct b,c,d), count(distinct a,c,d), count(distinct a,b,d), count(distinct a,b,c,d) from abcd
    575. 

  575. POSTHOOK: type: QUERY
    576. 

  576. POSTHOOK: Input: default@abcd
    577. 

  577. POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-47-23_137_2355783462946349645/-mr-10000
    578. 

  578. 7	7	6	6	6	7	3	3	6	7	4	5	6	6	5	6	4	5	5	5	4
    579. 

  579.