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

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

#
text | 243 lines | 239 code | 4 blank | 0 comment | 0 complexity | b8bc2568fcb98598632d2dfddc023c66 MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0 
    

  1. PREHOOK: query: create table src_rc_concatenate_test(key int, value string) stored as rcfile
    2. 

  2. PREHOOK: type: CREATETABLE
    3. 

  3. POSTHOOK: query: create table src_rc_concatenate_test(key int, value string) stored as rcfile
    4. 

  4. POSTHOOK: type: CREATETABLE
    5. 

  5. POSTHOOK: Output: default@src_rc_concatenate_test
    6. 

  6. PREHOOK: query: load data local inpath '../data/files/smbbucket_1.rc' into table src_rc_concatenate_test
    7. 

  7. PREHOOK: type: LOAD
    8. 

  8. PREHOOK: Output: default@src_rc_concatenate_test
    9. 

  9. POSTHOOK: query: load data local inpath '../data/files/smbbucket_1.rc' into table src_rc_concatenate_test
    10. 

  10. POSTHOOK: type: LOAD
    11. 

  11. POSTHOOK: Output: default@src_rc_concatenate_test
    12. 

  12. PREHOOK: query: load data local inpath '../data/files/smbbucket_2.rc' into table src_rc_concatenate_test
    13. 

  13. PREHOOK: type: LOAD
    14. 

  14. PREHOOK: Output: default@src_rc_concatenate_test
    15. 

  15. POSTHOOK: query: load data local inpath '../data/files/smbbucket_2.rc' into table src_rc_concatenate_test
    16. 

  16. POSTHOOK: type: LOAD
    17. 

  17. POSTHOOK: Output: default@src_rc_concatenate_test
    18. 

  18. PREHOOK: query: load data local inpath '../data/files/smbbucket_3.rc' into table src_rc_concatenate_test
    19. 

  19. PREHOOK: type: LOAD
    20. 

  20. PREHOOK: Output: default@src_rc_concatenate_test
    21. 

  21. POSTHOOK: query: load data local inpath '../data/files/smbbucket_3.rc' into table src_rc_concatenate_test
    22. 

  22. POSTHOOK: type: LOAD
    23. 

  23. POSTHOOK: Output: default@src_rc_concatenate_test
    24. 

  24. PREHOOK: query: show table extended like `src_rc_concatenate_test`
    25. 

  25. PREHOOK: type: SHOW_TABLESTATUS
    26. 

  26. POSTHOOK: query: show table extended like `src_rc_concatenate_test`
    27. 

  27. POSTHOOK: type: SHOW_TABLESTATUS
    28. 

  28. tableName:src_rc_concatenate_test
    29. 

  29. owner:heyongqiang
    30. 

  30. location:pfile:/Users/heyongqiang/Documents/workspace/Hive-3/build/ql/test/data/warehouse/src_rc_concatenate_test
    31. 

  31. inputformat:org.apache.hadoop.hive.ql.io.RCFileInputFormat
    32. 

  32. outputformat:org.apache.hadoop.hive.ql.io.RCFileOutputFormat
    33. 

  33. columns:struct columns { i32 key, string value}
    34. 

  34. partitioned:false
    35. 

  35. partitionColumns:
    36. 

  36. totalNumberFiles:3
    37. 

  37. totalFileSize:636
    38. 

  38. maxFileSize:222
    39. 

  39. minFileSize:206
    40. 

  40. lastAccessTime:0
    41. 

  41. lastUpdateTime:1303856093000
    42. 

  42. 

  43. PREHOOK: query: select count(1) from src_rc_concatenate_test
    44. 

  44. PREHOOK: type: QUERY
    45. 

  45. PREHOOK: Input: default@src_rc_concatenate_test
    46. 

  46. PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-04-26_15-14-54_116_5056538740056177435/-mr-10000
    47. 

  47. POSTHOOK: query: select count(1) from src_rc_concatenate_test
    48. 

  48. POSTHOOK: type: QUERY
    49. 

  49. POSTHOOK: Input: default@src_rc_concatenate_test
    50. 

  50. POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-04-26_15-14-54_116_5056538740056177435/-mr-10000
    51. 

  51. 15
    52. 

  52. PREHOOK: query: select sum(hash(key)), sum(hash(value)) from src_rc_concatenate_test
    53. 

  53. PREHOOK: type: QUERY
    54. 

  54. PREHOOK: Input: default@src_rc_concatenate_test
    55. 

  55. PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-04-26_15-15-01_971_2647514620376325946/-mr-10000
    56. 

  56. POSTHOOK: query: select sum(hash(key)), sum(hash(value)) from src_rc_concatenate_test
    57. 

  57. POSTHOOK: type: QUERY
    58. 

  58. POSTHOOK: Input: default@src_rc_concatenate_test
    59. 

  59. POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-04-26_15-15-01_971_2647514620376325946/-mr-10000
    60. 

  60. 214	-7678496319
    61. 

  61. PREHOOK: query: create index src_rc_concatenate_test_index on table src_rc_concatenate_test(key) as 'compact' WITH DEFERRED REBUILD IDXPROPERTIES ("prop1"="val1", "prop2"="val2")
    62. 

  62. PREHOOK: type: CREATEINDEX
    63. 

  63. POSTHOOK: query: create index src_rc_concatenate_test_index on table src_rc_concatenate_test(key) as 'compact' WITH DEFERRED REBUILD IDXPROPERTIES ("prop1"="val1", "prop2"="val2")
    64. 

  64. POSTHOOK: type: CREATEINDEX
    65. 

  65. PREHOOK: query: show indexes on src_rc_concatenate_test
    66. 

  66. PREHOOK: type: SHOWINDEXES
    67. 

  67. POSTHOOK: query: show indexes on src_rc_concatenate_test
    68. 

  68. POSTHOOK: type: SHOWINDEXES
    69. 

  69. src_rc_concatenate_test_index	src_rc_concatenate_test	key                 	default__src_rc_concatenate_test_src_rc_concatenate_test_index__	compact             	
    70. 

  70. PREHOOK: query: alter table src_rc_concatenate_test concatenate
    71. 

  71. PREHOOK: type: ALTER_TABLE_MERGE
    72. 

  72. PREHOOK: Input: default@src_rc_concatenate_test
    73. 

  73. PREHOOK: Output: default@src_rc_concatenate_test
    74. 

  74. POSTHOOK: query: alter table src_rc_concatenate_test concatenate
    75. 

  75. POSTHOOK: type: ALTER_TABLE_MERGE
    76. 

  76. POSTHOOK: Input: default@src_rc_concatenate_test
    77. 

  77. POSTHOOK: Output: default@src_rc_concatenate_test
    78. 

  78. PREHOOK: query: show table extended like `src_rc_concatenate_test`
    79. 

  79. PREHOOK: type: SHOW_TABLESTATUS
    80. 

  80. POSTHOOK: query: show table extended like `src_rc_concatenate_test`
    81. 

  81. POSTHOOK: type: SHOW_TABLESTATUS
    82. 

  82. tableName:src_rc_concatenate_test
    83. 

  83. owner:heyongqiang
    84. 

  84. location:pfile:/Users/heyongqiang/Documents/workspace/Hive-3/build/ql/test/data/warehouse/src_rc_concatenate_test
    85. 

  85. inputformat:org.apache.hadoop.hive.ql.io.RCFileInputFormat
    86. 

  86. outputformat:org.apache.hadoop.hive.ql.io.RCFileOutputFormat
    87. 

  87. columns:struct columns { i32 key, string value}
    88. 

  88. partitioned:false
    89. 

  89. partitionColumns:
    90. 

  90. totalNumberFiles:1
    91. 

  91. totalFileSize:334
    92. 

  92. maxFileSize:334
    93. 

  93. minFileSize:334
    94. 

  94. lastAccessTime:0
    95. 

  95. lastUpdateTime:1303856111000
    96. 

  96. 

  97. PREHOOK: query: select count(1) from src_rc_concatenate_test
    98. 

  98. PREHOOK: type: QUERY
    99. 

  99. PREHOOK: Input: default@src_rc_concatenate_test
    100. 

  100. PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-04-26_15-15-12_232_1765943327509437357/-mr-10000
    101. 

  101. POSTHOOK: query: select count(1) from src_rc_concatenate_test
    102. 

  102. POSTHOOK: type: QUERY
    103. 

  103. POSTHOOK: Input: default@src_rc_concatenate_test
    104. 

  104. POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-04-26_15-15-12_232_1765943327509437357/-mr-10000
    105. 

  105. 15
    106. 

  106. PREHOOK: query: select sum(hash(key)), sum(hash(value)) from src_rc_concatenate_test
    107. 

  107. PREHOOK: type: QUERY
    108. 

  108. PREHOOK: Input: default@src_rc_concatenate_test
    109. 

  109. PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-04-26_15-15-18_738_6289595467011155110/-mr-10000
    110. 

  110. POSTHOOK: query: select sum(hash(key)), sum(hash(value)) from src_rc_concatenate_test
    111. 

  111. POSTHOOK: type: QUERY
    112. 

  112. POSTHOOK: Input: default@src_rc_concatenate_test
    113. 

  113. POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-04-26_15-15-18_738_6289595467011155110/-mr-10000
    114. 

  114. 214	-7678496319
    115. 

  115. PREHOOK: query: drop index src_rc_concatenate_test_index on src_rc_concatenate_test
    116. 

  116. PREHOOK: type: DROPINDEX
    117. 

  117. POSTHOOK: query: drop index src_rc_concatenate_test_index on src_rc_concatenate_test
    118. 

  118. POSTHOOK: type: DROPINDEX
    119. 

  119. PREHOOK: query: create table src_rc_concatenate_test_part(key int, value string) partitioned by (ds string) stored as rcfile
    120. 

  120. PREHOOK: type: CREATETABLE
    121. 

  121. POSTHOOK: query: create table src_rc_concatenate_test_part(key int, value string) partitioned by (ds string) stored as rcfile
    122. 

  122. POSTHOOK: type: CREATETABLE
    123. 

  123. POSTHOOK: Output: default@src_rc_concatenate_test_part
    124. 

  124. PREHOOK: query: alter table src_rc_concatenate_test_part add partition (ds='2011')
    125. 

  125. PREHOOK: type: ALTERTABLE_ADDPARTS
    126. 

  126. PREHOOK: Input: default@src_rc_concatenate_test_part
    127. 

  127. POSTHOOK: query: alter table src_rc_concatenate_test_part add partition (ds='2011')
    128. 

  128. POSTHOOK: type: ALTERTABLE_ADDPARTS
    129. 

  129. POSTHOOK: Input: default@src_rc_concatenate_test_part
    130. 

  130. POSTHOOK: Output: default@src_rc_concatenate_test_part@ds=2011
    131. 

  131. PREHOOK: query: load data local inpath '../data/files/smbbucket_1.rc' into table src_rc_concatenate_test_part partition (ds='2011')
    132. 

  132. PREHOOK: type: LOAD
    133. 

  133. PREHOOK: Output: default@src_rc_concatenate_test_part@ds=2011
    134. 

  134. POSTHOOK: query: load data local inpath '../data/files/smbbucket_1.rc' into table src_rc_concatenate_test_part partition (ds='2011')
    135. 

  135. POSTHOOK: type: LOAD
    136. 

  136. POSTHOOK: Output: default@src_rc_concatenate_test_part@ds=2011
    137. 

  137. PREHOOK: query: load data local inpath '../data/files/smbbucket_2.rc' into table src_rc_concatenate_test_part partition (ds='2011')
    138. 

  138. PREHOOK: type: LOAD
    139. 

  139. PREHOOK: Output: default@src_rc_concatenate_test_part@ds=2011
    140. 

  140. POSTHOOK: query: load data local inpath '../data/files/smbbucket_2.rc' into table src_rc_concatenate_test_part partition (ds='2011')
    141. 

  141. POSTHOOK: type: LOAD
    142. 

  142. POSTHOOK: Output: default@src_rc_concatenate_test_part@ds=2011
    143. 

  143. PREHOOK: query: load data local inpath '../data/files/smbbucket_3.rc' into table src_rc_concatenate_test_part partition (ds='2011')
    144. 

  144. PREHOOK: type: LOAD
    145. 

  145. PREHOOK: Output: default@src_rc_concatenate_test_part@ds=2011
    146. 

  146. POSTHOOK: query: load data local inpath '../data/files/smbbucket_3.rc' into table src_rc_concatenate_test_part partition (ds='2011')
    147. 

  147. POSTHOOK: type: LOAD
    148. 

  148. POSTHOOK: Output: default@src_rc_concatenate_test_part@ds=2011
    149. 

  149. PREHOOK: query: show table extended like `src_rc_concatenate_test_part` partition (ds='2011')
    150. 

  150. PREHOOK: type: SHOW_TABLESTATUS
    151. 

  151. POSTHOOK: query: show table extended like `src_rc_concatenate_test_part` partition (ds='2011')
    152. 

  152. POSTHOOK: type: SHOW_TABLESTATUS
    153. 

  153. tableName:src_rc_concatenate_test_part
    154. 

  154. owner:heyongqiang
    155. 

  155. location:pfile:/Users/heyongqiang/Documents/workspace/Hive-3/build/ql/test/data/warehouse/src_rc_concatenate_test_part/ds=2011
    156. 

  156. inputformat:org.apache.hadoop.hive.ql.io.RCFileInputFormat
    157. 

  157. outputformat:org.apache.hadoop.hive.ql.io.RCFileOutputFormat
    158. 

  158. columns:struct columns { i32 key, string value}
    159. 

  159. partitioned:true
    160. 

  160. partitionColumns:struct partition_columns { string ds}
    161. 

  161. totalNumberFiles:3
    162. 

  162. totalFileSize:636
    163. 

  163. maxFileSize:222
    164. 

  164. minFileSize:206
    165. 

  165. lastAccessTime:0
    166. 

  166. lastUpdateTime:1303856128000
    167. 

  167. 

  168. PREHOOK: query: select count(1) from src_rc_concatenate_test_part
    169. 

  169. PREHOOK: type: QUERY
    170. 

  170. PREHOOK: Input: default@src_rc_concatenate_test_part@ds=2011
    171. 

  171. PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-04-26_15-15-28_709_6508379632697292274/-mr-10000
    172. 

  172. POSTHOOK: query: select count(1) from src_rc_concatenate_test_part
    173. 

  173. POSTHOOK: type: QUERY
    174. 

  174. POSTHOOK: Input: default@src_rc_concatenate_test_part@ds=2011
    175. 

  175. POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-04-26_15-15-28_709_6508379632697292274/-mr-10000
    176. 

  176. 15
    177. 

  177. PREHOOK: query: select sum(hash(key)), sum(hash(value)) from src_rc_concatenate_test_part
    178. 

  178. PREHOOK: type: QUERY
    179. 

  179. PREHOOK: Input: default@src_rc_concatenate_test_part@ds=2011
    180. 

  180. PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-04-26_15-15-35_496_4356530739014843487/-mr-10000
    181. 

  181. POSTHOOK: query: select sum(hash(key)), sum(hash(value)) from src_rc_concatenate_test_part
    182. 

  182. POSTHOOK: type: QUERY
    183. 

  183. POSTHOOK: Input: default@src_rc_concatenate_test_part@ds=2011
    184. 

  184. POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-04-26_15-15-35_496_4356530739014843487/-mr-10000
    185. 

  185. 214	-7678496319
    186. 

  186. PREHOOK: query: create index src_rc_concatenate_test_part_index on table src_rc_concatenate_test_part(key) as 'compact' WITH DEFERRED REBUILD IDXPROPERTIES ("prop1"="val1", "prop2"="val2")
    187. 

  187. PREHOOK: type: CREATEINDEX
    188. 

  188. POSTHOOK: query: create index src_rc_concatenate_test_part_index on table src_rc_concatenate_test_part(key) as 'compact' WITH DEFERRED REBUILD IDXPROPERTIES ("prop1"="val1", "prop2"="val2")
    189. 

  189. POSTHOOK: type: CREATEINDEX
    190. 

  190. PREHOOK: query: show indexes on src_rc_concatenate_test_part
    191. 

  191. PREHOOK: type: SHOWINDEXES
    192. 

  192. POSTHOOK: query: show indexes on src_rc_concatenate_test_part
    193. 

  193. POSTHOOK: type: SHOWINDEXES
    194. 

  194. src_rc_concatenate_test_part_index	src_rc_concatenate_test_part	key                 	default__src_rc_concatenate_test_part_src_rc_concatenate_test_part_index__	compact             	
    195. 

  195. PREHOOK: query: alter table src_rc_concatenate_test_part partition (ds='2011') concatenate
    196. 

  196. PREHOOK: type: ALTER_PARTITION_MERGE
    197. 

  197. PREHOOK: Input: default@src_rc_concatenate_test_part
    198. 

  198. PREHOOK: Output: default@src_rc_concatenate_test_part@ds=2011
    199. 

  199. POSTHOOK: query: alter table src_rc_concatenate_test_part partition (ds='2011') concatenate
    200. 

  200. POSTHOOK: type: ALTER_PARTITION_MERGE
    201. 

  201. POSTHOOK: Input: default@src_rc_concatenate_test_part
    202. 

  202. POSTHOOK: Output: default@src_rc_concatenate_test_part@ds=2011
    203. 

  203. PREHOOK: query: show table extended like `src_rc_concatenate_test_part` partition (ds='2011')
    204. 

  204. PREHOOK: type: SHOW_TABLESTATUS
    205. 

  205. POSTHOOK: query: show table extended like `src_rc_concatenate_test_part` partition (ds='2011')
    206. 

  206. POSTHOOK: type: SHOW_TABLESTATUS
    207. 

  207. tableName:src_rc_concatenate_test_part
    208. 

  208. owner:heyongqiang
    209. 

  209. location:pfile:/Users/heyongqiang/Documents/workspace/Hive-3/build/ql/test/data/warehouse/src_rc_concatenate_test_part/ds=2011
    210. 

  210. inputformat:org.apache.hadoop.hive.ql.io.RCFileInputFormat
    211. 

  211. outputformat:org.apache.hadoop.hive.ql.io.RCFileOutputFormat
    212. 

  212. columns:struct columns { i32 key, string value}
    213. 

  213. partitioned:true
    214. 

  214. partitionColumns:struct partition_columns { string ds}
    215. 

  215. totalNumberFiles:1
    216. 

  216. totalFileSize:334
    217. 

  217. maxFileSize:334
    218. 

  218. minFileSize:334
    219. 

  219. lastAccessTime:0
    220. 

  220. lastUpdateTime:1303856144000
    221. 

  221. 

  222. PREHOOK: query: select count(1) from src_rc_concatenate_test_part
    223. 

  223. PREHOOK: type: QUERY
    224. 

  224. PREHOOK: Input: default@src_rc_concatenate_test_part@ds=2011
    225. 

  225. PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-04-26_15-15-45_308_2380163877365308340/-mr-10000
    226. 

  226. POSTHOOK: query: select count(1) from src_rc_concatenate_test_part
    227. 

  227. POSTHOOK: type: QUERY
    228. 

  228. POSTHOOK: Input: default@src_rc_concatenate_test_part@ds=2011
    229. 

  229. POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-04-26_15-15-45_308_2380163877365308340/-mr-10000
    230. 

  230. 15
    231. 

  231. PREHOOK: query: select sum(hash(key)), sum(hash(value)) from src_rc_concatenate_test_part
    232. 

  232. PREHOOK: type: QUERY
    233. 

  233. PREHOOK: Input: default@src_rc_concatenate_test_part@ds=2011
    234. 

  234. PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-04-26_15-15-51_822_7148108227690658912/-mr-10000
    235. 

  235. POSTHOOK: query: select sum(hash(key)), sum(hash(value)) from src_rc_concatenate_test_part
    236. 

  236. POSTHOOK: type: QUERY
    237. 

  237. POSTHOOK: Input: default@src_rc_concatenate_test_part@ds=2011
    238. 

  238. POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-04-26_15-15-51_822_7148108227690658912/-mr-10000
    239. 

  239. 214	-7678496319
    240. 

  240. PREHOOK: query: drop index src_rc_concatenate_test_part_index on src_rc_concatenate_test_part
    241. 

  241. PREHOOK: type: DROPINDEX
    242. 

  242. POSTHOOK: query: drop index src_rc_concatenate_test_part_index on src_rc_concatenate_test_part
    243. 

  243. POSTHOOK: type: DROPINDEX
    244. 

  244.