blob: 5ae8b1a73fe21586732d3223015c82cae063accf [file] [log] [blame]
PREHOOK: query: CREATE EXTERNAL TABLE hbase_pushdown(key int, value string)
STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,cf:string",
"hbase.scan.cache" = "500", "hbase.scan.cacheblocks" = "true", "hbase.scan.batch" = "1")
TBLPROPERTIES ("external.table.purge" = "true")
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@hbase_pushdown
POSTHOOK: query: CREATE EXTERNAL TABLE hbase_pushdown(key int, value string)
STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,cf:string",
"hbase.scan.cache" = "500", "hbase.scan.cacheblocks" = "true", "hbase.scan.batch" = "1")
TBLPROPERTIES ("external.table.purge" = "true")
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@hbase_pushdown
PREHOOK: query: INSERT OVERWRITE TABLE hbase_pushdown SELECT * FROM src
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@hbase_pushdown
POSTHOOK: query: INSERT OVERWRITE TABLE hbase_pushdown SELECT * FROM src
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@hbase_pushdown
PREHOOK: query: select * from hbase_pushdown
PREHOOK: type: QUERY
PREHOOK: Input: default@hbase_pushdown
#### A masked pattern was here ####
POSTHOOK: query: select * from hbase_pushdown
POSTHOOK: type: QUERY
POSTHOOK: Input: default@hbase_pushdown
#### A masked pattern was here ####
0 val_0
10 val_10
100 val_100
103 val_103
104 val_104
105 val_105
11 val_11
111 val_111
113 val_113
114 val_114
116 val_116
118 val_118
119 val_119
12 val_12
120 val_120
125 val_125
126 val_126
128 val_128
129 val_129
131 val_131
133 val_133
134 val_134
136 val_136
137 val_137
138 val_138
143 val_143
145 val_145
146 val_146
149 val_149
15 val_15
150 val_150
152 val_152
153 val_153
155 val_155
156 val_156
157 val_157
158 val_158
160 val_160
162 val_162
163 val_163
164 val_164
165 val_165
166 val_166
167 val_167
168 val_168
169 val_169
17 val_17
170 val_170
172 val_172
174 val_174
175 val_175
176 val_176
177 val_177
178 val_178
179 val_179
18 val_18
180 val_180
181 val_181
183 val_183
186 val_186
187 val_187
189 val_189
19 val_19
190 val_190
191 val_191
192 val_192
193 val_193
194 val_194
195 val_195
196 val_196
197 val_197
199 val_199
2 val_2
20 val_20
200 val_200
201 val_201
202 val_202
203 val_203
205 val_205
207 val_207
208 val_208
209 val_209
213 val_213
214 val_214
216 val_216
217 val_217
218 val_218
219 val_219
221 val_221
222 val_222
223 val_223
224 val_224
226 val_226
228 val_228
229 val_229
230 val_230
233 val_233
235 val_235
237 val_237
238 val_238
239 val_239
24 val_24
241 val_241
242 val_242
244 val_244
247 val_247
248 val_248
249 val_249
252 val_252
255 val_255
256 val_256
257 val_257
258 val_258
26 val_26
260 val_260
262 val_262
263 val_263
265 val_265
266 val_266
27 val_27
272 val_272
273 val_273
274 val_274
275 val_275
277 val_277
278 val_278
28 val_28
280 val_280
281 val_281
282 val_282
283 val_283
284 val_284
285 val_285
286 val_286
287 val_287
288 val_288
289 val_289
291 val_291
292 val_292
296 val_296
298 val_298
30 val_30
302 val_302
305 val_305
306 val_306
307 val_307
308 val_308
309 val_309
310 val_310
311 val_311
315 val_315
316 val_316
317 val_317
318 val_318
321 val_321
322 val_322
323 val_323
325 val_325
327 val_327
33 val_33
331 val_331
332 val_332
333 val_333
335 val_335
336 val_336
338 val_338
339 val_339
34 val_34
341 val_341
342 val_342
344 val_344
345 val_345
348 val_348
35 val_35
351 val_351
353 val_353
356 val_356
360 val_360
362 val_362
364 val_364
365 val_365
366 val_366
367 val_367
368 val_368
369 val_369
37 val_37
373 val_373
374 val_374
375 val_375
377 val_377
378 val_378
379 val_379
382 val_382
384 val_384
386 val_386
389 val_389
392 val_392
393 val_393
394 val_394
395 val_395
396 val_396
397 val_397
399 val_399
4 val_4
400 val_400
401 val_401
402 val_402
403 val_403
404 val_404
406 val_406
407 val_407
409 val_409
41 val_41
411 val_411
413 val_413
414 val_414
417 val_417
418 val_418
419 val_419
42 val_42
421 val_421
424 val_424
427 val_427
429 val_429
43 val_43
430 val_430
431 val_431
432 val_432
435 val_435
436 val_436
437 val_437
438 val_438
439 val_439
44 val_44
443 val_443
444 val_444
446 val_446
448 val_448
449 val_449
452 val_452
453 val_453
454 val_454
455 val_455
457 val_457
458 val_458
459 val_459
460 val_460
462 val_462
463 val_463
466 val_466
467 val_467
468 val_468
469 val_469
47 val_47
470 val_470
472 val_472
475 val_475
477 val_477
478 val_478
479 val_479
480 val_480
481 val_481
482 val_482
483 val_483
484 val_484
485 val_485
487 val_487
489 val_489
490 val_490
491 val_491
492 val_492
493 val_493
494 val_494
495 val_495
496 val_496
497 val_497
498 val_498
5 val_5
51 val_51
53 val_53
54 val_54
57 val_57
58 val_58
64 val_64
65 val_65
66 val_66
67 val_67
69 val_69
70 val_70
72 val_72
74 val_74
76 val_76
77 val_77
78 val_78
8 val_8
80 val_80
82 val_82
83 val_83
84 val_84
85 val_85
86 val_86
87 val_87
9 val_9
90 val_90
92 val_92
95 val_95
96 val_96
97 val_97
98 val_98