summaryrefslogtreecommitdiffstats
path: root/src/arrow/cpp/submodules/parquet-testing/data/delta_binary_packed.md
blob: 27a6df490a34ab7f357316b412ec1e3db8f006e3 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
<!--
  ~ Licensed to the Apache Software Foundation (ASF) under one
  ~ or more contributor license agreements.  See the NOTICE file
  ~ distributed with this work for additional information
  ~ regarding copyright ownership.  The ASF licenses this file
  ~ to you under the Apache License, Version 2.0 (the
  ~ "License"); you may not use this file except in compliance
  ~ with the License.  You may obtain a copy of the License at
  ~
  ~   http://www.apache.org/licenses/LICENSE-2.0
  ~
  ~ Unless required by applicable law or agreed to in writing,
  ~ software distributed under the License is distributed on an
  ~ "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
  ~ KIND, either express or implied.  See the License for the
  ~ specific language governing permissions and limitations
  ~ under the License.
  -->

`delta_binary_packed.parquet` is generated with parquet-mr version 1.10.0.
The expected file contents are in `delta_binary_packed_expect.csv`.

Each column is DELTA_BINARY_PACKED-encoded, with a different delta bitwidth
for each column.

Each column has 200 rows including 1 first value and 2 blocks.  The first block
has 4 miniblocks, the second block has 3.  Each miniblock contains 32 values,
except the last one which only contains 7 values (1 + 6 \* 32 + 7 == 200).

Here is the file structure:
```
File Name: /home/antoine/parquet/testing/data/delta_binary_packed.parquet
Version: 1.0
Created By: parquet-mr version 1.10.0 (build 031a6654009e3b82020012a18434c582bd74c73a)
Total rows: 200
Number of RowGroups: 1
Number of Real Columns: 66
Number of Columns: 66
Number of Selected Columns: 66
Column 0: bitwidth0 (INT64)
Column 1: bitwidth1 (INT64)
Column 2: bitwidth2 (INT64)
Column 3: bitwidth3 (INT64)
Column 4: bitwidth4 (INT64)
Column 5: bitwidth5 (INT64)
Column 6: bitwidth6 (INT64)
Column 7: bitwidth7 (INT64)
Column 8: bitwidth8 (INT64)
Column 9: bitwidth9 (INT64)
Column 10: bitwidth10 (INT64)
Column 11: bitwidth11 (INT64)
Column 12: bitwidth12 (INT64)
Column 13: bitwidth13 (INT64)
Column 14: bitwidth14 (INT64)
Column 15: bitwidth15 (INT64)
Column 16: bitwidth16 (INT64)
Column 17: bitwidth17 (INT64)
Column 18: bitwidth18 (INT64)
Column 19: bitwidth19 (INT64)
Column 20: bitwidth20 (INT64)
Column 21: bitwidth21 (INT64)
Column 22: bitwidth22 (INT64)
Column 23: bitwidth23 (INT64)
Column 24: bitwidth24 (INT64)
Column 25: bitwidth25 (INT64)
Column 26: bitwidth26 (INT64)
Column 27: bitwidth27 (INT64)
Column 28: bitwidth28 (INT64)
Column 29: bitwidth29 (INT64)
Column 30: bitwidth30 (INT64)
Column 31: bitwidth31 (INT64)
Column 32: bitwidth32 (INT64)
Column 33: bitwidth33 (INT64)
Column 34: bitwidth34 (INT64)
Column 35: bitwidth35 (INT64)
Column 36: bitwidth36 (INT64)
Column 37: bitwidth37 (INT64)
Column 38: bitwidth38 (INT64)
Column 39: bitwidth39 (INT64)
Column 40: bitwidth40 (INT64)
Column 41: bitwidth41 (INT64)
Column 42: bitwidth42 (INT64)
Column 43: bitwidth43 (INT64)
Column 44: bitwidth44 (INT64)
Column 45: bitwidth45 (INT64)
Column 46: bitwidth46 (INT64)
Column 47: bitwidth47 (INT64)
Column 48: bitwidth48 (INT64)
Column 49: bitwidth49 (INT64)
Column 50: bitwidth50 (INT64)
Column 51: bitwidth51 (INT64)
Column 52: bitwidth52 (INT64)
Column 53: bitwidth53 (INT64)
Column 54: bitwidth54 (INT64)
Column 55: bitwidth55 (INT64)
Column 56: bitwidth56 (INT64)
Column 57: bitwidth57 (INT64)
Column 58: bitwidth58 (INT64)
Column 59: bitwidth59 (INT64)
Column 60: bitwidth60 (INT64)
Column 61: bitwidth61 (INT64)
Column 62: bitwidth62 (INT64)
Column 63: bitwidth63 (INT64)
Column 64: bitwidth64 (INT64)
Column 65: int_value (INT32)
--- Row Group: 0 ---
--- Total Bytes: 65467 ---
--- Total Compressed Bytes: 0 ---
--- Rows: 200 ---
Column 0
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 6374628540732951412, Min: 6374628540732951412
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 95, Compressed Size: 95
Column 1
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 0, Min: -104
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 114, Compressed Size: 114
Column 2
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 0, Min: -82
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 144, Compressed Size: 144
Column 3
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 0, Min: -96
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 172, Compressed Size: 172
Column 4
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 0, Min: -132
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 200, Compressed Size: 200
Column 5
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 24, Min: -290
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 228, Compressed Size: 228
Column 6
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 259, Min: -93
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 256, Compressed Size: 256
Column 7
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 476, Min: -64
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 284, Compressed Size: 284
Column 8
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 387, Min: -732
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 314, Compressed Size: 314
Column 9
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 194, Min: -1572
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 342, Compressed Size: 342
Column 10
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 5336, Min: -2353
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 370, Compressed Size: 370
Column 11
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 13445, Min: -8028
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 398, Compressed Size: 398
Column 12
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 2017, Min: -35523
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 426, Compressed Size: 426
Column 13
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 48649, Min: -4096
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 454, Compressed Size: 454
Column 14
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 65709, Min: -8244
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 482, Compressed Size: 482
Column 15
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 69786, Min: -106702
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 512, Compressed Size: 512
Column 16
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 162951, Min: -347012
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 540, Compressed Size: 540
Column 17
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 0, Min: -1054098
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 568, Compressed Size: 568
Column 18
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 664380, Min: -372793
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 596, Compressed Size: 596
Column 19
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 4001179, Min: -402775
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 624, Compressed Size: 624
Column 20
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 788039, Min: -4434785
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 652, Compressed Size: 652
Column 21
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 12455554, Min: -1070042
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 680, Compressed Size: 680
Column 22
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 2189135, Min: -17987827
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 710, Compressed Size: 710
Column 23
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 25967351, Min: -19361900
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 738, Compressed Size: 738
Column 24
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 95688064, Min: -17271207
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 766, Compressed Size: 766
Column 25
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 169215083, Min: -18759951
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 794, Compressed Size: 794
Column 26
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 163626565, Min: -168761837
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 822, Compressed Size: 822
Column 27
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 131734874, Min: -736933601
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 850, Compressed Size: 850
Column 28
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 913547745, Min: -490714808
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 878, Compressed Size: 878
Column 29
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 500305035, Min: -5834684238
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 908, Compressed Size: 908
Column 30
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 566280334, Min: -7728643109
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 936, Compressed Size: 936
Column 31
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 18831788461, Min: -2498101101
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 964, Compressed Size: 964
Column 32
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 23720914586, Min: -2147483648
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 992, Compressed Size: 992
Column 33
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 24075494509, Min: -4817999329
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 1020, Compressed Size: 1020
Column 34
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 12118456329, Min: -156025641218
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 1048, Compressed Size: 1048
Column 35
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 41614351758, Min: -114682966820
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 1076, Compressed Size: 1076
Column 36
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 82484946621, Min: -244178626927
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 1106, Compressed Size: 1106
Column 37
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 361459323159, Min: -275190620271
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 1134, Compressed Size: 1134
Column 38
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 1665294434042, Min: -420452598502
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 1162, Compressed Size: 1162
Column 39
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 110454290134, Min: -2926211785103
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 1190, Compressed Size: 1190
Column 40
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 3215717068302, Min: -4988823342986
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 1218, Compressed Size: 1218
Column 41
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 2166086616318, Min: -6488418568768
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 1246, Compressed Size: 1246
Column 42
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 10182365256028, Min: -8738522616121
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 1274, Compressed Size: 1274
Column 43
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 22909885827147, Min: -21214625470327
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 1304, Compressed Size: 1304
Column 44
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 67902133645749, Min: -9796939892175
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 1332, Compressed Size: 1332
Column 45
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 199494208930939, Min: -102473613757961
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 1360, Compressed Size: 1360
Column 46
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 18564971260296, Min: -359696498357610
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 1388, Compressed Size: 1388
Column 47
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 65624006999260, Min: -933995610201533
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 1416, Compressed Size: 1416
Column 48
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 983500521840940, Min: -878019827431629
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 1444, Compressed Size: 1444
Column 49
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 975533803684560, Min: -2091164446177739
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 1472, Compressed Size: 1472
Column 50
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 1276327559487856, Min: -5741928190724373
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 1502, Compressed Size: 1502
Column 51
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 0, Min: -15996275819941210
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 1530, Compressed Size: 1530
Column 52
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 12697545666077932, Min: -8823113595895130
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 1558, Compressed Size: 1558
Column 53
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 4785870085681342, Min: -24800000653307089
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 1586, Compressed Size: 1586
Column 54
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 26202576654140994, Min: -94647392931900711
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 1614, Compressed Size: 1614
Column 55
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 358302517069012889, Min: -32197353745654772
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 1642, Compressed Size: 1642
Column 56
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 678791154000627912, Min: -36028797018963968
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 1670, Compressed Size: 1670
Column 57
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 1444945950888122232, Min: -79246600304853010
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 1700, Compressed Size: 1700
Column 58
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 140747723990970254, Min: -1492687553985044679
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 1728, Compressed Size: 1728
Column 59
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 6318360990909070, Min: -3778424577629102559
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 1756, Compressed Size: 1756
Column 60
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 4574162334421819801, Min: -576460752303423488
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 1784, Compressed Size: 1784
Column 61
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 8803535686130338880, Min: -1155450847100943978
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 1812, Compressed Size: 1812
Column 62
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 9026687750017193101, Min: -4454039315625288390
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 1840, Compressed Size: 1840
Column 63
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 9150047972721273816, Min: -9220123451143279334
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 1868, Compressed Size: 1868
Column 64
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 8846115173408951296, Min: -9223372036854775808
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 1898, Compressed Size: 1898
Column 65
  Values: 200, Null Values: 0, Distinct Values: 0
  Max: 2142811258, Min: -2078683524
  Compression: UNCOMPRESSED, Encodings: DELTA_BINARY_PACKED
  Uncompressed Size: 980, Compressed Size: 980
```