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

/tags/release-0.0.0-rc0/hive/external/hbase-handler/src/test/results/hbase_stats.q.out

#
text | 246 lines | 228 code | 18 blank | 0 comment | 0 complexity | e3664e2e1a85e7e27f34e8e1eb92e532 MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0 
    

  1. PREHOOK: query: create table stats_src like src
    2. 

  2. PREHOOK: type: CREATETABLE
    3. 

  3. POSTHOOK: query: create table stats_src like src
    4. 

  4. POSTHOOK: type: CREATETABLE
    5. 

  5. POSTHOOK: Output: default@stats_src
    6. 

  6. PREHOOK: query: insert overwrite table stats_src select * from src
    7. 

  7. PREHOOK: type: QUERY
    8. 

  8. PREHOOK: Input: default@src
    9. 

  9. PREHOOK: Output: default@stats_src
    10. 

  10. POSTHOOK: query: insert overwrite table stats_src select * from src
    11. 

  11. POSTHOOK: type: QUERY
    12. 

  12. POSTHOOK: Input: default@src
    13. 

  13. POSTHOOK: Output: default@stats_src
    14. 

  14. POSTHOOK: Lineage: stats_src.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    15. 

  15. POSTHOOK: Lineage: stats_src.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    16. 

  16. PREHOOK: query: analyze table stats_src compute statistics
    17. 

  17. PREHOOK: type: QUERY
    18. 

  18. PREHOOK: Input: default@stats_src
    19. 

  19. PREHOOK: Output: default@stats_src
    20. 

  20. POSTHOOK: query: analyze table stats_src compute statistics
    21. 

  21. POSTHOOK: type: QUERY
    22. 

  22. POSTHOOK: Input: default@stats_src
    23. 

  23. POSTHOOK: Output: default@stats_src
    24. 

  24. POSTHOOK: Lineage: stats_src.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    25. 

  25. POSTHOOK: Lineage: stats_src.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    26. 

  26. PREHOOK: query: desc formatted stats_src
    27. 

  27. PREHOOK: type: DESCTABLE
    28. 

  28. POSTHOOK: query: desc formatted stats_src
    29. 

  29. POSTHOOK: type: DESCTABLE
    30. 

  30. POSTHOOK: Lineage: stats_src.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    31. 

  31. POSTHOOK: Lineage: stats_src.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    32. 

  32. # col_name            	data_type           	comment             
    33. 

  33. 	 	 
    34. 

  34. key                 	string              	default             
    35. 

  35. value               	string              	default             
    36. 

  36. 	 	 
    37. 

  37. # Detailed Table Information	 	 
    38. 

  38. Database:           	default             	 
    39. 

  39. Owner:              	null                	 
    40. 

  40. CreateTime:         	Tue Jan 25 14:48:20 PST 2011	 
    41. 

  41. LastAccessTime:     	UNKNOWN             	 
    42. 

  42. Protect Mode:       	None                	 
    43. 

  43. Retention:          	0                   	 
    44. 

  44. Location:           	pfile:/data/users/jsichi/open/hive-trunk/build/hbase-handler/test/data/warehouse/stats_src	 
    45. 

  45. Table Type:         	MANAGED_TABLE       	 
    46. 

  46. Table Parameters:	 	 
    47. 

  47. 	transient_lastDdlTime	1295995714          
    48. 

  48. 	 	 
    49. 

  49. # Storage Information	 	 
    50. 

  50. SerDe Library:      	org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe	 
    51. 

  51. InputFormat:        	org.apache.hadoop.mapred.TextInputFormat	 
    52. 

  52. OutputFormat:       	org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat	 
    53. 

  53. Compressed:         	No                  	 
    54. 

  54. Num Buckets:        	-1                  	 
    55. 

  55. Bucket Columns:     	[]                  	 
    56. 

  56. Sort Columns:       	[]                  	 
    57. 

  57. Storage Desc Params:	 	 
    58. 

  58. 	serialization.format	1                   
    59. 

  59. PREHOOK: query: create table hbase_part like srcpart
    60. 

  60. PREHOOK: type: CREATETABLE
    61. 

  61. POSTHOOK: query: create table hbase_part like srcpart
    62. 

  62. POSTHOOK: type: CREATETABLE
    63. 

  63. POSTHOOK: Output: default@hbase_part
    64. 

  64. POSTHOOK: Lineage: stats_src.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    65. 

  65. POSTHOOK: Lineage: stats_src.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    66. 

  66. PREHOOK: query: insert overwrite table hbase_part partition (ds='2010-04-08', hr = '11') select key, value from src
    67. 

  67. PREHOOK: type: QUERY
    68. 

  68. PREHOOK: Input: default@src
    69. 

  69. PREHOOK: Output: default@hbase_part@ds=2010-04-08/hr=11
    70. 

  70. POSTHOOK: query: insert overwrite table hbase_part partition (ds='2010-04-08', hr = '11') select key, value from src
    71. 

  71. POSTHOOK: type: QUERY
    72. 

  72. POSTHOOK: Input: default@src
    73. 

  73. POSTHOOK: Output: default@hbase_part@ds=2010-04-08/hr=11
    74. 

  74. POSTHOOK: Lineage: hbase_part PARTITION(ds=2010-04-08,hr=11).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    75. 

  75. POSTHOOK: Lineage: hbase_part PARTITION(ds=2010-04-08,hr=11).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    76. 

  76. POSTHOOK: Lineage: stats_src.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    77. 

  77. POSTHOOK: Lineage: stats_src.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    78. 

  78. PREHOOK: query: insert overwrite table hbase_part partition (ds='2010-04-08', hr = '12') select key, value from src
    79. 

  79. PREHOOK: type: QUERY
    80. 

  80. PREHOOK: Input: default@src
    81. 

  81. PREHOOK: Output: default@hbase_part@ds=2010-04-08/hr=12
    82. 

  82. POSTHOOK: query: insert overwrite table hbase_part partition (ds='2010-04-08', hr = '12') select key, value from src
    83. 

  83. POSTHOOK: type: QUERY
    84. 

  84. POSTHOOK: Input: default@src
    85. 

  85. POSTHOOK: Output: default@hbase_part@ds=2010-04-08/hr=12
    86. 

  86. POSTHOOK: Lineage: hbase_part PARTITION(ds=2010-04-08,hr=11).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    87. 

  87. POSTHOOK: Lineage: hbase_part PARTITION(ds=2010-04-08,hr=11).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    88. 

  88. POSTHOOK: Lineage: hbase_part PARTITION(ds=2010-04-08,hr=12).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    89. 

  89. POSTHOOK: Lineage: hbase_part PARTITION(ds=2010-04-08,hr=12).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    90. 

  90. POSTHOOK: Lineage: stats_src.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    91. 

  91. POSTHOOK: Lineage: stats_src.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    92. 

  92. PREHOOK: query: analyze table hbase_part partition(ds='2008-04-08', hr=11) compute statistics
    93. 

  93. PREHOOK: type: QUERY
    94. 

  94. PREHOOK: Input: default@hbase_part@ds=2008-04-08/hr=11
    95. 

  95. PREHOOK: Output: default@hbase_part
    96. 

  96. POSTHOOK: query: analyze table hbase_part partition(ds='2008-04-08', hr=11) compute statistics
    97. 

  97. POSTHOOK: type: QUERY
    98. 

  98. POSTHOOK: Input: default@hbase_part@ds=2008-04-08/hr=11
    99. 

  99. POSTHOOK: Output: default@hbase_part
    100. 

  100. POSTHOOK: Lineage: hbase_part PARTITION(ds=2010-04-08,hr=11).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    101. 

  101. POSTHOOK: Lineage: hbase_part PARTITION(ds=2010-04-08,hr=11).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    102. 

  102. POSTHOOK: Lineage: hbase_part PARTITION(ds=2010-04-08,hr=12).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    103. 

  103. POSTHOOK: Lineage: hbase_part PARTITION(ds=2010-04-08,hr=12).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    104. 

  104. POSTHOOK: Lineage: stats_src.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    105. 

  105. POSTHOOK: Lineage: stats_src.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    106. 

  106. PREHOOK: query: analyze table hbase_part partition(ds='2008-04-08', hr=12) compute statistics
    107. 

  107. PREHOOK: type: QUERY
    108. 

  108. PREHOOK: Input: default@hbase_part@ds=2008-04-08/hr=12
    109. 

  109. PREHOOK: Output: default@hbase_part
    110. 

  110. POSTHOOK: query: analyze table hbase_part partition(ds='2008-04-08', hr=12) compute statistics
    111. 

  111. POSTHOOK: type: QUERY
    112. 

  112. POSTHOOK: Input: default@hbase_part@ds=2008-04-08/hr=12
    113. 

  113. POSTHOOK: Output: default@hbase_part
    114. 

  114. POSTHOOK: Lineage: hbase_part PARTITION(ds=2010-04-08,hr=11).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    115. 

  115. POSTHOOK: Lineage: hbase_part PARTITION(ds=2010-04-08,hr=11).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    116. 

  116. POSTHOOK: Lineage: hbase_part PARTITION(ds=2010-04-08,hr=12).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    117. 

  117. POSTHOOK: Lineage: hbase_part PARTITION(ds=2010-04-08,hr=12).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    118. 

  118. POSTHOOK: Lineage: stats_src.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    119. 

  119. POSTHOOK: Lineage: stats_src.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    120. 

  120. PREHOOK: query: desc formatted hbase_part
    121. 

  121. PREHOOK: type: DESCTABLE
    122. 

  122. POSTHOOK: query: desc formatted hbase_part
    123. 

  123. POSTHOOK: type: DESCTABLE
    124. 

  124. POSTHOOK: Lineage: hbase_part PARTITION(ds=2010-04-08,hr=11).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    125. 

  125. POSTHOOK: Lineage: hbase_part PARTITION(ds=2010-04-08,hr=11).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    126. 

  126. POSTHOOK: Lineage: hbase_part PARTITION(ds=2010-04-08,hr=12).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    127. 

  127. POSTHOOK: Lineage: hbase_part PARTITION(ds=2010-04-08,hr=12).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    128. 

  128. POSTHOOK: Lineage: stats_src.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    129. 

  129. POSTHOOK: Lineage: stats_src.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    130. 

  130. # col_name            	data_type           	comment             
    131. 

  131. 	 	 
    132. 

  132. key                 	string              	default             
    133. 

  133. value               	string              	default             
    134. 

  134. 	 	 
    135. 

  135. # Partition Information	 	 
    136. 

  136. # col_name            	data_type           	comment             
    137. 

  137. 	 	 
    138. 

  138. ds                  	string              	None                
    139. 

  139. hr                  	string              	None                
    140. 

  140. 	 	 
    141. 

  141. # Detailed Table Information	 	 
    142. 

  142. Database:           	default             	 
    143. 

  143. Owner:              	null                	 
    144. 

  144. CreateTime:         	Tue Jan 25 14:49:11 PST 2011	 
    145. 

  145. LastAccessTime:     	UNKNOWN             	 
    146. 

  146. Protect Mode:       	None                	 
    147. 

  147. Retention:          	0                   	 
    148. 

  148. Location:           	pfile:/data/users/jsichi/open/hive-trunk/build/hbase-handler/test/data/warehouse/hbase_part	 
    149. 

  149. Table Type:         	MANAGED_TABLE       	 
    150. 

  150. Table Parameters:	 	 
    151. 

  151. 	transient_lastDdlTime	1295995751          
    152. 

  152. 	 	 
    153. 

  153. # Storage Information	 	 
    154. 

  154. SerDe Library:      	org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe	 
    155. 

  155. InputFormat:        	org.apache.hadoop.mapred.TextInputFormat	 
    156. 

  156. OutputFormat:       	org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat	 
    157. 

  157. Compressed:         	No                  	 
    158. 

  158. Num Buckets:        	-1                  	 
    159. 

  159. Bucket Columns:     	[]                  	 
    160. 

  160. Sort Columns:       	[]                  	 
    161. 

  161. Storage Desc Params:	 	 
    162. 

  162. 	serialization.format	1                   
    163. 

  163. PREHOOK: query: desc formatted hbase_part partition (ds='2010-04-08', hr = '11')
    164. 

  164. PREHOOK: type: DESCTABLE
    165. 

  165. POSTHOOK: query: desc formatted hbase_part partition (ds='2010-04-08', hr = '11')
    166. 

  166. POSTHOOK: type: DESCTABLE
    167. 

  167. POSTHOOK: Lineage: hbase_part PARTITION(ds=2010-04-08,hr=11).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    168. 

  168. POSTHOOK: Lineage: hbase_part PARTITION(ds=2010-04-08,hr=11).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    169. 

  169. POSTHOOK: Lineage: hbase_part PARTITION(ds=2010-04-08,hr=12).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    170. 

  170. POSTHOOK: Lineage: hbase_part PARTITION(ds=2010-04-08,hr=12).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    171. 

  171. POSTHOOK: Lineage: stats_src.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    172. 

  172. POSTHOOK: Lineage: stats_src.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    173. 

  173. # col_name            	data_type           	comment             
    174. 

  174. 	 	 
    175. 

  175. key                 	string              	default             
    176. 

  176. value               	string              	default             
    177. 

  177. 	 	 
    178. 

  178. # Partition Information	 	 
    179. 

  179. # col_name            	data_type           	comment             
    180. 

  180. 	 	 
    181. 

  181. ds                  	string              	None                
    182. 

  182. hr                  	string              	None                
    183. 

  183. 	 	 
    184. 

  184. # Detailed Partition Information	 	 
    185. 

  185. Partition Value:    	[2010-04-08, 11]    	 
    186. 

  186. Database:           	default             	 
    187. 

  187. Table:              	hbase_part          	 
    188. 

  188. CreateTime:         	Tue Jan 25 14:49:26 PST 2011	 
    189. 

  189. LastAccessTime:     	UNKNOWN             	 
    190. 

  190. Protect Mode:       	None                	 
    191. 

  191. Location:           	pfile:/data/users/jsichi/open/hive-trunk/build/hbase-handler/test/data/warehouse/hbase_part/ds=2010-04-08/hr=11	 
    192. 

  192. Partition Parameters:	 	 
    193. 

  193. 	transient_lastDdlTime	1295995766          
    194. 

  194. 	 	 
    195. 

  195. # Storage Information	 	 
    196. 

  196. SerDe Library:      	org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe	 
    197. 

  197. InputFormat:        	org.apache.hadoop.mapred.TextInputFormat	 
    198. 

  198. OutputFormat:       	org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat	 
    199. 

  199. Compressed:         	No                  	 
    200. 

  200. Num Buckets:        	-1                  	 
    201. 

  201. Bucket Columns:     	[]                  	 
    202. 

  202. Sort Columns:       	[]                  	 
    203. 

  203. Storage Desc Params:	 	 
    204. 

  204. 	serialization.format	1                   
    205. 

  205. PREHOOK: query: desc formatted hbase_part partition (ds='2010-04-08', hr = '12')
    206. 

  206. PREHOOK: type: DESCTABLE
    207. 

  207. POSTHOOK: query: desc formatted hbase_part partition (ds='2010-04-08', hr = '12')
    208. 

  208. POSTHOOK: type: DESCTABLE
    209. 

  209. POSTHOOK: Lineage: hbase_part PARTITION(ds=2010-04-08,hr=11).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    210. 

  210. POSTHOOK: Lineage: hbase_part PARTITION(ds=2010-04-08,hr=11).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    211. 

  211. POSTHOOK: Lineage: hbase_part PARTITION(ds=2010-04-08,hr=12).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    212. 

  212. POSTHOOK: Lineage: hbase_part PARTITION(ds=2010-04-08,hr=12).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    213. 

  213. POSTHOOK: Lineage: stats_src.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    214. 

  214. POSTHOOK: Lineage: stats_src.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    215. 

  215. # col_name            	data_type           	comment             
    216. 

  216. 	 	 
    217. 

  217. key                 	string              	default             
    218. 

  218. value               	string              	default             
    219. 

  219. 	 	 
    220. 

  220. # Partition Information	 	 
    221. 

  221. # col_name            	data_type           	comment             
    222. 

  222. 	 	 
    223. 

  223. ds                  	string              	None                
    224. 

  224. hr                  	string              	None                
    225. 

  225. 	 	 
    226. 

  226. # Detailed Partition Information	 	 
    227. 

  227. Partition Value:    	[2010-04-08, 12]    	 
    228. 

  228. Database:           	default             	 
    229. 

  229. Table:              	hbase_part          	 
    230. 

  230. CreateTime:         	Tue Jan 25 14:49:52 PST 2011	 
    231. 

  231. LastAccessTime:     	UNKNOWN             	 
    232. 

  232. Protect Mode:       	None                	 
    233. 

  233. Location:           	pfile:/data/users/jsichi/open/hive-trunk/build/hbase-handler/test/data/warehouse/hbase_part/ds=2010-04-08/hr=12	 
    234. 

  234. Partition Parameters:	 	 
    235. 

  235. 	transient_lastDdlTime	1295995792          
    236. 

  236. 	 	 
    237. 

  237. # Storage Information	 	 
    238. 

  238. SerDe Library:      	org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe	 
    239. 

  239. InputFormat:        	org.apache.hadoop.mapred.TextInputFormat	 
    240. 

  240. OutputFormat:       	org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat	 
    241. 

  241. Compressed:         	No                  	 
    242. 

  242. Num Buckets:        	-1                  	 
    243. 

  243. Bucket Columns:     	[]                  	 
    244. 

  244. Sort Columns:       	[]                  	 
    245. 

  245. Storage Desc Params:	 	 
    246. 

  246. 	serialization.format	1                   
    247. 

  247.