]> git.proxmox.com Git - ceph.git/blame - ceph/src/arrow/julia/Arrow/test/arrowjson/datetime.json
import quincy 17.2.0
[ceph.git] / ceph / src / arrow / julia / Arrow / test / arrowjson / datetime.json
CommitLineData
1d09f67e
TL
1{
2 "schema": {
3 "fields": [
4 {
5 "name": "f0",
6 "type": {
7 "name": "date",
8 "unit": "DAY"
9 },
10 "nullable": true,
11 "children": []
12 },
13 {
14 "name": "f1",
15 "type": {
16 "name": "date",
17 "unit": "MILLISECOND"
18 },
19 "nullable": true,
20 "children": []
21 },
22 {
23 "name": "f2",
24 "type": {
25 "name": "time",
26 "unit": "SECOND",
27 "bitWidth": 32
28 },
29 "nullable": true,
30 "children": []
31 },
32 {
33 "name": "f3",
34 "type": {
35 "name": "time",
36 "unit": "MILLISECOND",
37 "bitWidth": 32
38 },
39 "nullable": true,
40 "children": []
41 },
42 {
43 "name": "f4",
44 "type": {
45 "name": "time",
46 "unit": "MICROSECOND",
47 "bitWidth": 64
48 },
49 "nullable": true,
50 "children": []
51 },
52 {
53 "name": "f5",
54 "type": {
55 "name": "time",
56 "unit": "NANOSECOND",
57 "bitWidth": 64
58 },
59 "nullable": true,
60 "children": []
61 },
62 {
63 "name": "f6",
64 "type": {
65 "name": "timestamp",
66 "unit": "SECOND"
67 },
68 "nullable": true,
69 "children": []
70 },
71 {
72 "name": "f7",
73 "type": {
74 "name": "timestamp",
75 "unit": "MILLISECOND"
76 },
77 "nullable": true,
78 "children": []
79 },
80 {
81 "name": "f8",
82 "type": {
83 "name": "timestamp",
84 "unit": "MICROSECOND"
85 },
86 "nullable": true,
87 "children": []
88 },
89 {
90 "name": "f9",
91 "type": {
92 "name": "timestamp",
93 "unit": "NANOSECOND"
94 },
95 "nullable": true,
96 "children": []
97 },
98 {
99 "name": "f10",
100 "type": {
101 "name": "timestamp",
102 "unit": "MILLISECOND"
103 },
104 "nullable": true,
105 "children": []
106 },
107 {
108 "name": "f11",
109 "type": {
110 "name": "timestamp",
111 "unit": "SECOND",
112 "timezone": "UTC"
113 },
114 "nullable": true,
115 "children": []
116 },
117 {
118 "name": "f12",
119 "type": {
120 "name": "timestamp",
121 "unit": "MILLISECOND",
122 "timezone": "US/Eastern"
123 },
124 "nullable": true,
125 "children": []
126 },
127 {
128 "name": "f13",
129 "type": {
130 "name": "timestamp",
131 "unit": "MICROSECOND",
132 "timezone": "Europe/Paris"
133 },
134 "nullable": true,
135 "children": []
136 },
137 {
138 "name": "f14",
139 "type": {
140 "name": "timestamp",
141 "unit": "NANOSECOND",
142 "timezone": "US/Pacific"
143 },
144 "nullable": true,
145 "children": []
146 }
147 ]
148 },
149 "batches": [
150 {
151 "count": 7,
152 "columns": [
153 {
154 "name": "f0",
155 "count": 7,
156 "VALIDITY": [
157 0,
158 0,
159 0,
160 1,
161 0,
162 1,
163 0
164 ],
165 "DATA": [
166 -719162,
167 2932896,
168 1251583,
169 -354578,
170 1947695,
171 -669151,
172 26653
173 ]
174 },
175 {
176 "name": "f1",
177 "count": 7,
178 "VALIDITY": [
179 1,
180 1,
181 0,
182 0,
183 1,
184 1,
185 0
186 ],
187 "DATA": [
188 "-62135596800000",
189 "253402214400000",
190 "-2820221740189",
191 "71549882314362",
192 "125067746235030",
193 "-27038791348254",
194 "42137473450326"
195 ]
196 },
197 {
198 "name": "f2",
199 "count": 7,
200 "VALIDITY": [
201 1,
202 0,
203 1,
204 1,
205 0,
206 0,
207 1
208 ],
209 "DATA": [
210 0,
211 86400,
212 76127,
213 6700,
214 27103,
215 56151,
216 56654
217 ]
218 },
219 {
220 "name": "f3",
221 "count": 7,
222 "VALIDITY": [
223 1,
224 0,
225 0,
226 1,
227 0,
228 1,
229 0
230 ],
231 "DATA": [
232 0,
233 86400000,
234 17984286,
235 76370591,
236 60937117,
237 2240575,
238 8788989
239 ]
240 },
241 {
242 "name": "f4",
243 "count": 7,
244 "VALIDITY": [
245 0,
246 1,
247 0,
248 1,
249 1,
250 0,
251 1
252 ],
253 "DATA": [
254 "0",
255 "86400000000",
256 "74085029005",
257 "23058796418",
258 "5827157574",
259 "30753386088",
260 "41165364667"
261 ]
262 },
263 {
264 "name": "f5",
265 "count": 7,
266 "VALIDITY": [
267 0,
268 1,
269 0,
270 0,
271 1,
272 1,
273 1
274 ],
275 "DATA": [
276 "0",
277 "86400000000000",
278 "23907445718784",
279 "74345421086418",
280 "75233481254444",
281 "82172159793710",
282 "58497242525071"
283 ]
284 },
285 {
286 "name": "f6",
287 "count": 7,
288 "VALIDITY": [
289 1,
290 1,
291 0,
292 1,
293 1,
294 1,
295 1
296 ],
297 "DATA": [
298 "-62135596800",
299 "253402214400",
300 "-61131551586",
301 "109841560561",
302 "-3916465142",
303 "146694684650",
304 "138850275868"
305 ]
306 },
307 {
308 "name": "f7",
309 "count": 7,
310 "VALIDITY": [
311 1,
312 0,
313 0,
314 1,
315 1,
316 1,
317 0
318 ],
319 "DATA": [
320 "-62135596800000",
321 "253402214400000",
322 "73881152631437",
323 "69908713976427",
324 "252339755754438",
325 "-24746530024729",
326 "169302540975380"
327 ]
328 },
329 {
330 "name": "f8",
331 "count": 7,
332 "VALIDITY": [
333 1,
334 1,
335 1,
336 1,
337 0,
338 1,
339 0
340 ],
341 "DATA": [
342 "-62135596800000000",
343 "253402214400000000",
344 "201464679490582249",
345 "168126161155504013",
346 "-23403778250906066",
347 "205706554937392102",
348 "45776665091115087"
349 ]
350 },
351 {
352 "name": "f9",
353 "count": 7,
354 "VALIDITY": [
355 0,
356 1,
357 0,
358 1,
359 1,
360 1,
361 1
362 ],
363 "DATA": [
364 "-9223372036854775808",
365 "9223372036854775807",
366 "-6357255048670867880",
367 "-8661447973993819541",
368 "-8212788386909103318",
369 "-8530954041419345600",
370 "-4218486829304453721"
371 ]
372 },
373 {
374 "name": "f10",
375 "count": 7,
376 "VALIDITY": [
377 0,
378 1,
379 1,
380 1,
381 1,
382 1,
383 0
384 ],
385 "DATA": [
386 "-62135596800000",
387 "253402214400000",
388 "206983911256609",
389 "94973546379549",
390 "-18473207641060",
391 "36529119814530",
392 "143273969098011"
393 ]
394 },
395 {
396 "name": "f11",
397 "count": 7,
398 "VALIDITY": [
399 1,
400 0,
401 1,
402 0,
403 1,
404 0,
405 0
406 ],
407 "DATA": [
408 "-62135596800",
409 "253402214400",
410 "225567855249",
411 "18090198256",
412 "-18645631593",
413 "1683299996",
414 "240974238031"
415 ]
416 },
417 {
418 "name": "f12",
419 "count": 7,
420 "VALIDITY": [
421 1,
422 0,
423 1,
424 1,
425 1,
426 0,
427 1
428 ],
429 "DATA": [
430 "-62135596800000",
431 "253402214400000",
432 "-41888047432132",
433 "142167692985706",
434 "96450253340232",
435 "-28800292871111",
436 "31551906541089"
437 ]
438 },
439 {
440 "name": "f13",
441 "count": 7,
442 "VALIDITY": [
443 1,
444 1,
445 0,
446 1,
447 1,
448 1,
449 0
450 ],
451 "DATA": [
452 "-62135596800000000",
453 "253402214400000000",
454 "-55035741541368439",
455 "110555619232926841",
456 "13584197914180451",
457 "-40099398122556776",
458 "154575532939365500"
459 ]
460 },
461 {
462 "name": "f14",
463 "count": 7,
464 "VALIDITY": [
465 0,
466 1,
467 0,
468 1,
469 1,
470 1,
471 1
472 ],
473 "DATA": [
474 "-9223372036854775808",
475 "9223372036854775807",
476 "5175948389020765869",
477 "5557679156666679724",
478 "4250919303876106324",
479 "9160676477011889469",
480 "8585006913301874724"
481 ]
482 }
483 ]
484 },
485 {
486 "count": 10,
487 "columns": [
488 {
489 "name": "f0",
490 "count": 10,
491 "VALIDITY": [
492 1,
493 0,
494 0,
495 1,
496 0,
497 1,
498 0,
499 1,
500 1,
501 0
502 ],
503 "DATA": [
504 -719162,
505 2932896,
506 1879965,
507 -566367,
508 37728,
509 1761040,
510 279144,
511 1056794,
512 756303,
513 525725
514 ]
515 },
516 {
517 "name": "f1",
518 "count": 10,
519 "VALIDITY": [
520 1,
521 1,
522 1,
523 1,
524 1,
525 1,
526 1,
527 0,
528 0,
529 0
530 ],
531 "DATA": [
532 "-62135596800000",
533 "253402214400000",
534 "-38092110755085",
535 "-28445105640862",
536 "82150583163219",
537 "54419670636015",
538 "157522888788052",
539 "-41135178703404",
540 "-55692081078291",
541 "23161948344048"
542 ]
543 },
544 {
545 "name": "f2",
546 "count": 10,
547 "VALIDITY": [
548 1,
549 1,
550 0,
551 0,
552 1,
553 1,
554 0,
555 1,
556 0,
557 0
558 ],
559 "DATA": [
560 0,
561 86400,
562 68158,
563 43645,
564 82390,
565 63272,
566 8687,
567 73663,
568 41080,
569 16606
570 ]
571 },
572 {
573 "name": "f3",
574 "count": 10,
575 "VALIDITY": [
576 1,
577 0,
578 1,
579 0,
580 0,
581 0,
582 0,
583 1,
584 0,
585 0
586 ],
587 "DATA": [
588 0,
589 86400000,
590 4300160,
591 71414742,
592 77204018,
593 20632726,
594 31365614,
595 66601445,
596 59573489,
597 62138475
598 ]
599 },
600 {
601 "name": "f4",
602 "count": 10,
603 "VALIDITY": [
604 1,
605 1,
606 1,
607 1,
608 1,
609 1,
610 1,
611 1,
612 0,
613 0
614 ],
615 "DATA": [
616 "0",
617 "86400000000",
618 "28651881349",
619 "76962235570",
620 "72557141940",
621 "81551970477",
622 "20740172257",
623 "69927019990",
624 "76743031592",
625 "82821335874"
626 ]
627 },
628 {
629 "name": "f5",
630 "count": 10,
631 "VALIDITY": [
632 0,
633 1,
634 1,
635 1,
636 0,
637 1,
638 1,
639 0,
640 0,
641 0
642 ],
643 "DATA": [
644 "0",
645 "86400000000000",
646 "69757112637445",
647 "57552711513942",
648 "29426946816946",
649 "34878855922929",
650 "33344575898987",
651 "80887006335433",
652 "34037765279999",
653 "51577535310194"
654 ]
655 },
656 {
657 "name": "f6",
658 "count": 10,
659 "VALIDITY": [
660 0,
661 1,
662 1,
663 1,
664 0,
665 1,
666 1,
667 1,
668 1,
669 1
670 ],
671 "DATA": [
672 "-62135596800",
673 "253402214400",
674 "17362133914",
675 "-45891238920",
676 "184875963653",
677 "189805054827",
678 "-58368591641",
679 "11979945774",
680 "-42159999942",
681 "-40114167869"
682 ]
683 },
684 {
685 "name": "f7",
686 "count": 10,
687 "VALIDITY": [
688 0,
689 1,
690 1,
691 0,
692 1,
693 0,
694 1,
695 1,
696 1,
697 0
698 ],
699 "DATA": [
700 "-62135596800000",
701 "253402214400000",
702 "228991365143433",
703 "169961535994833",
704 "200469360821110",
705 "69234108321383",
706 "198319780924526",
707 "191497586634193",
708 "175427870270356",
709 "57342673854963"
710 ]
711 },
712 {
713 "name": "f8",
714 "count": 10,
715 "VALIDITY": [
716 0,
717 1,
718 1,
719 1,
720 1,
721 0,
722 0,
723 1,
724 1,
725 1
726 ],
727 "DATA": [
728 "-62135596800000000",
729 "253402214400000000",
730 "56980200145982394",
731 "181929648203745781",
732 "139102923751831867",
733 "208997257530770666",
734 "16136961511557279",
735 "41555612864958844",
736 "13419848118557598",
737 "87383692083185618"
738 ]
739 },
740 {
741 "name": "f9",
742 "count": 10,
743 "VALIDITY": [
744 1,
745 0,
746 1,
747 1,
748 0,
749 1,
750 0,
751 1,
752 1,
753 1
754 ],
755 "DATA": [
756 "-9223372036854775808",
757 "9223372036854775807",
758 "-7031715621840828119",
759 "6059066797068981521",
760 "-1646261793033501417",
761 "-4220806875454311426",
762 "-5197114782094970725",
763 "-8786449967831538943",
764 "2974021310284646715",
765 "-8065049992539820014"
766 ]
767 },
768 {
769 "name": "f10",
770 "count": 10,
771 "VALIDITY": [
772 0,
773 0,
774 1,
775 0,
776 1,
777 0,
778 1,
779 0,
780 0,
781 1
782 ],
783 "DATA": [
784 "-62135596800000",
785 "253402214400000",
786 "178310981489839",
787 "-57632494932898",
788 "-49036210908585",
789 "52895117552494",
790 "171282515196488",
791 "132014017559614",
792 "37589110284897",
793 "-58565057255450"
794 ]
795 },
796 {
797 "name": "f11",
798 "count": 10,
799 "VALIDITY": [
800 1,
801 0,
802 0,
803 1,
804 1,
805 1,
806 1,
807 1,
808 0,
809 1
810 ],
811 "DATA": [
812 "-62135596800",
813 "253402214400",
814 "-25861647763",
815 "225566577159",
816 "239974631847",
817 "9594019763",
818 "195861877033",
819 "-19961060193",
820 "75621579368",
821 "-37516489502"
822 ]
823 },
824 {
825 "name": "f12",
826 "count": 10,
827 "VALIDITY": [
828 1,
829 1,
830 0,
831 1,
832 1,
833 0,
834 1,
835 1,
836 1,
837 1
838 ],
839 "DATA": [
840 "-62135596800000",
841 "253402214400000",
842 "197770622812426",
843 "195993483135189",
844 "187243903796151",
845 "193213107363200",
846 "83570298570259",
847 "252571502045214",
848 "129428288356579",
849 "-6553516468568"
850 ]
851 },
852 {
853 "name": "f13",
854 "count": 10,
855 "VALIDITY": [
856 1,
857 1,
858 0,
859 1,
860 0,
861 1,
862 1,
863 1,
864 0,
865 1
866 ],
867 "DATA": [
868 "-62135596800000000",
869 "253402214400000000",
870 "227405247332731417",
871 "-23876629555725661",
872 "172967389442803645",
873 "214366955371313241",
874 "86933375268516953",
875 "162567381239071692",
876 "40270626452354761",
877 "-9766478375147980"
878 ]
879 },
880 {
881 "name": "f14",
882 "count": 10,
883 "VALIDITY": [
884 1,
885 0,
886 0,
887 1,
888 1,
889 0,
890 0,
891 1,
892 1,
893 1
894 ],
895 "DATA": [
896 "-9223372036854775808",
897 "9223372036854775807",
898 "-3367778002617009344",
899 "-921482854487607004",
900 "1280046021732622411",
901 "-2084512789553264359",
902 "6774927372092824293",
903 "2301253808511314195",
904 "-447823511949250637",
905 "-9137589927882857097"
906 ]
907 }
908 ]
909 }
910 ]
911}