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