github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/sem/tree/testdata/pretty/create_subpartition.align-only.golden (about) 1 // Code generated by TestPretty. DO NOT EDIT. 2 // GENERATED FILE DO NOT EDIT 3 1: 4 - 5 CREATE TABLE students ( 6 id 7 SERIAL8, 8 name 9 STRING, 10 email 11 STRING, 12 country 13 STRING, 14 expected_graduation_date 15 DATE, 16 PRIMARY KEY ( 17 country, 18 expected_graduation_date, 19 id 20 ) 21 ) 22 PARTITION BY LIST ( 23 country 24 ) 25 ( 26 PARTITION australia 27 VALUES IN ( 28 'AU', 29 'NZ' 30 ) 31 PARTITION BY RANGE ( 32 expected_graduation_date 33 ) 34 ( 35 PARTITION graduated_au 36 VALUES FROM ( 37 minvalue 38 ) 39 TO ( 40 '2017-08-15' 41 ), 42 PARTITION current_au 43 VALUES FROM ( 44 '2017-08-15' 45 ) 46 TO ( 47 maxvalue 48 ) 49 ), 50 PARTITION north_america 51 VALUES IN ( 52 'US', 53 'CA' 54 ) 55 PARTITION BY RANGE ( 56 expected_graduation_date 57 ) 58 ( 59 PARTITION graduated_us 60 VALUES FROM ( 61 minvalue 62 ) 63 TO ( 64 '2017-08-15' 65 ), 66 PARTITION current_us 67 VALUES FROM ( 68 '2017-08-15' 69 ) 70 TO ( 71 maxvalue 72 ) 73 ) 74 ) 75 76 23: 77 ----------------------- 78 CREATE TABLE students ( 79 id 80 SERIAL8, 81 name 82 STRING, 83 email 84 STRING, 85 country 86 STRING, 87 expected_graduation_date 88 DATE, 89 PRIMARY KEY ( 90 country, 91 expected_graduation_date, 92 id 93 ) 94 ) PARTITION BY LIST ( 95 country 96 ) ( 97 PARTITION australia 98 VALUES IN ( 99 'AU', 100 'NZ' 101 ) 102 PARTITION BY RANGE ( 103 expected_graduation_date 104 ) 105 ( 106 PARTITION graduated_au 107 VALUES FROM ( 108 minvalue 109 ) 110 TO ( 111 '2017-08-15' 112 ), 113 PARTITION current_au 114 VALUES FROM ( 115 '2017-08-15' 116 ) 117 TO ( 118 maxvalue 119 ) 120 ), 121 PARTITION north_america 122 VALUES IN ( 123 'US', 124 'CA' 125 ) 126 PARTITION BY RANGE ( 127 expected_graduation_date 128 ) 129 ( 130 PARTITION graduated_us 131 VALUES FROM ( 132 minvalue 133 ) 134 TO ( 135 '2017-08-15' 136 ), 137 PARTITION current_us 138 VALUES FROM ( 139 '2017-08-15' 140 ) 141 TO ( 142 maxvalue 143 ) 144 ) 145 ) 146 147 31: 148 ------------------------------- 149 CREATE TABLE students ( 150 id 151 SERIAL8, 152 name 153 STRING, 154 email 155 STRING, 156 country 157 STRING, 158 expected_graduation_date 159 DATE, 160 PRIMARY KEY ( 161 country, 162 expected_graduation_date, 163 id 164 ) 165 ) PARTITION BY LIST (country) ( 166 PARTITION australia 167 VALUES IN ( 168 'AU', 169 'NZ' 170 ) 171 PARTITION BY RANGE ( 172 expected_graduation_date 173 ) 174 ( 175 PARTITION graduated_au 176 VALUES FROM ( 177 minvalue 178 ) 179 TO ( 180 '2017-08-15' 181 ), 182 PARTITION current_au 183 VALUES FROM ( 184 '2017-08-15' 185 ) 186 TO ( 187 maxvalue 188 ) 189 ), 190 PARTITION north_america 191 VALUES IN ( 192 'US', 193 'CA' 194 ) 195 PARTITION BY RANGE ( 196 expected_graduation_date 197 ) 198 ( 199 PARTITION graduated_us 200 VALUES FROM ( 201 minvalue 202 ) 203 TO ( 204 '2017-08-15' 205 ), 206 PARTITION current_us 207 VALUES FROM ( 208 '2017-08-15' 209 ) 210 TO ( 211 maxvalue 212 ) 213 ) 214 ) 215 216 37: 217 ------------------------------------- 218 CREATE TABLE students ( 219 id SERIAL8, 220 name STRING, 221 email STRING, 222 country STRING, 223 expected_graduation_date DATE, 224 PRIMARY KEY ( 225 country, 226 expected_graduation_date, 227 id 228 ) 229 ) PARTITION BY LIST (country) ( 230 PARTITION australia 231 VALUES IN ( 232 'AU', 233 'NZ' 234 ) 235 PARTITION BY RANGE ( 236 expected_graduation_date 237 ) 238 ( 239 PARTITION graduated_au 240 VALUES FROM ( 241 minvalue 242 ) 243 TO ( 244 '2017-08-15' 245 ), 246 PARTITION current_au 247 VALUES FROM ( 248 '2017-08-15' 249 ) 250 TO ( 251 maxvalue 252 ) 253 ), 254 PARTITION north_america 255 VALUES IN ( 256 'US', 257 'CA' 258 ) 259 PARTITION BY RANGE ( 260 expected_graduation_date 261 ) 262 ( 263 PARTITION graduated_us 264 VALUES FROM ( 265 minvalue 266 ) 267 TO ( 268 '2017-08-15' 269 ), 270 PARTITION current_us 271 VALUES FROM ( 272 '2017-08-15' 273 ) 274 TO ( 275 maxvalue 276 ) 277 ) 278 ) 279 280 55: 281 ------------------------------------------------------- 282 CREATE TABLE students ( 283 id SERIAL8, 284 name STRING, 285 email STRING, 286 country STRING, 287 expected_graduation_date DATE, 288 PRIMARY KEY (country, expected_graduation_date, id) 289 ) PARTITION BY LIST (country) ( 290 PARTITION australia 291 VALUES IN ( 292 'AU', 293 'NZ' 294 ) 295 PARTITION BY RANGE ( 296 expected_graduation_date 297 ) 298 ( 299 PARTITION graduated_au 300 VALUES FROM ( 301 minvalue 302 ) 303 TO ( 304 '2017-08-15' 305 ), 306 PARTITION current_au 307 VALUES FROM ( 308 '2017-08-15' 309 ) 310 TO ( 311 maxvalue 312 ) 313 ), 314 PARTITION north_america 315 VALUES IN ( 316 'US', 317 'CA' 318 ) 319 PARTITION BY RANGE ( 320 expected_graduation_date 321 ) 322 ( 323 PARTITION graduated_us 324 VALUES FROM ( 325 minvalue 326 ) 327 TO ( 328 '2017-08-15' 329 ), 330 PARTITION current_us 331 VALUES FROM ( 332 '2017-08-15' 333 ) 334 TO ( 335 maxvalue 336 ) 337 ) 338 ) 339 340 56: 341 -------------------------------------------------------- 342 CREATE TABLE students ( 343 id SERIAL8, 344 name STRING, 345 email STRING, 346 country STRING, 347 expected_graduation_date DATE, 348 PRIMARY KEY (country, expected_graduation_date, id) 349 ) PARTITION BY LIST (country) ( 350 PARTITION australia 351 VALUES IN ( 352 'AU', 353 'NZ' 354 ) 355 PARTITION BY RANGE ( 356 expected_graduation_date 357 ) ( 358 PARTITION graduated_au 359 VALUES FROM ( 360 minvalue 361 ) 362 TO ( 363 '2017-08-15' 364 ), 365 PARTITION current_au 366 VALUES FROM ( 367 '2017-08-15' 368 ) 369 TO ( 370 maxvalue 371 ) 372 ), 373 PARTITION north_america 374 VALUES IN ( 375 'US', 376 'CA' 377 ) 378 PARTITION BY RANGE ( 379 expected_graduation_date 380 ) ( 381 PARTITION graduated_us 382 VALUES FROM ( 383 minvalue 384 ) 385 TO ( 386 '2017-08-15' 387 ), 388 PARTITION current_us 389 VALUES FROM ( 390 '2017-08-15' 391 ) 392 TO ( 393 maxvalue 394 ) 395 ) 396 ) 397 398 57: 399 --------------------------------------------------------- 400 CREATE TABLE students ( 401 id SERIAL8, 402 name STRING, 403 email STRING, 404 country STRING, 405 expected_graduation_date DATE, 406 PRIMARY KEY (country, expected_graduation_date, id) 407 ) PARTITION BY LIST (country) ( 408 PARTITION australia 409 VALUES IN ( 410 'AU', 411 'NZ' 412 ) 413 PARTITION BY RANGE ( 414 expected_graduation_date 415 ) ( 416 PARTITION graduated_au 417 VALUES FROM ( 418 minvalue 419 ) 420 TO ( 421 '2017-08-15' 422 ), 423 PARTITION current_au 424 VALUES FROM ( 425 '2017-08-15' 426 ) 427 TO (maxvalue) 428 ), 429 PARTITION north_america 430 VALUES IN ( 431 'US', 432 'CA' 433 ) 434 PARTITION BY RANGE ( 435 expected_graduation_date 436 ) ( 437 PARTITION graduated_us 438 VALUES FROM ( 439 minvalue 440 ) 441 TO ( 442 '2017-08-15' 443 ), 444 PARTITION current_us 445 VALUES FROM ( 446 '2017-08-15' 447 ) 448 TO (maxvalue) 449 ) 450 ) 451 452 58: 453 ---------------------------------------------------------- 454 CREATE TABLE students ( 455 id SERIAL8, 456 name STRING, 457 email STRING, 458 country STRING, 459 expected_graduation_date DATE, 460 PRIMARY KEY (country, expected_graduation_date, id) 461 ) PARTITION BY LIST (country) ( 462 PARTITION australia 463 VALUES IN ('AU', 'NZ') 464 PARTITION BY RANGE ( 465 expected_graduation_date 466 ) ( 467 PARTITION graduated_au 468 VALUES FROM ( 469 minvalue 470 ) 471 TO ( 472 '2017-08-15' 473 ), 474 PARTITION current_au 475 VALUES FROM ( 476 '2017-08-15' 477 ) 478 TO (maxvalue) 479 ), 480 PARTITION north_america 481 VALUES IN ('US', 'CA') 482 PARTITION BY RANGE ( 483 expected_graduation_date 484 ) ( 485 PARTITION graduated_us 486 VALUES FROM ( 487 minvalue 488 ) 489 TO ( 490 '2017-08-15' 491 ), 492 PARTITION current_us 493 VALUES FROM ( 494 '2017-08-15' 495 ) 496 TO (maxvalue) 497 ) 498 ) 499 500 62: 501 -------------------------------------------------------------- 502 CREATE TABLE students ( 503 id SERIAL8, 504 name STRING, 505 email STRING, 506 country STRING, 507 expected_graduation_date DATE, 508 PRIMARY KEY (country, expected_graduation_date, id) 509 ) PARTITION BY LIST (country) ( 510 PARTITION australia 511 VALUES IN ('AU', 'NZ') 512 PARTITION BY RANGE ( 513 expected_graduation_date 514 ) ( 515 PARTITION graduated_au 516 VALUES FROM ( 517 minvalue 518 ) 519 TO ('2017-08-15'), 520 PARTITION current_au 521 VALUES FROM ( 522 '2017-08-15' 523 ) 524 TO (maxvalue) 525 ), 526 PARTITION north_america 527 VALUES IN ('US', 'CA') 528 PARTITION BY RANGE ( 529 expected_graduation_date 530 ) ( 531 PARTITION graduated_us 532 VALUES FROM ( 533 minvalue 534 ) 535 TO ('2017-08-15'), 536 PARTITION current_us 537 VALUES FROM ( 538 '2017-08-15' 539 ) 540 TO (maxvalue) 541 ) 542 ) 543 544 63: 545 --------------------------------------------------------------- 546 CREATE TABLE students ( 547 id SERIAL8, 548 name STRING, 549 email STRING, 550 country STRING, 551 expected_graduation_date DATE, 552 PRIMARY KEY (country, expected_graduation_date, id) 553 ) PARTITION BY LIST (country) ( 554 PARTITION australia VALUES IN ( 555 'AU', 556 'NZ' 557 ) 558 PARTITION BY RANGE ( 559 expected_graduation_date 560 ) 561 ( 562 PARTITION graduated_au 563 VALUES FROM ( 564 minvalue 565 ) 566 TO ( 567 '2017-08-15' 568 ), 569 PARTITION current_au 570 VALUES FROM ( 571 '2017-08-15' 572 ) 573 TO ( 574 maxvalue 575 ) 576 ), 577 PARTITION north_america 578 VALUES IN ('US', 'CA') 579 PARTITION BY RANGE ( 580 expected_graduation_date 581 ) ( 582 PARTITION graduated_us 583 VALUES FROM ( 584 minvalue 585 ) 586 TO ('2017-08-15'), 587 PARTITION current_us 588 VALUES FROM ( 589 '2017-08-15' 590 ) 591 TO (maxvalue) 592 ) 593 ) 594 595 66: 596 ------------------------------------------------------------------ 597 CREATE TABLE students ( 598 id SERIAL8, 599 name STRING, 600 email STRING, 601 country STRING, 602 expected_graduation_date DATE, 603 PRIMARY KEY (country, expected_graduation_date, id) 604 ) PARTITION BY LIST (country) ( 605 PARTITION australia VALUES IN ( 606 'AU', 607 'NZ' 608 ) 609 PARTITION BY RANGE ( 610 expected_graduation_date 611 ) 612 ( 613 PARTITION graduated_au 614 VALUES FROM ( 615 minvalue 616 ) 617 TO ( 618 '2017-08-15' 619 ), 620 PARTITION current_au 621 VALUES FROM ( 622 '2017-08-15' 623 ) 624 TO ( 625 maxvalue 626 ) 627 ), 628 PARTITION north_america 629 VALUES IN ('US', 'CA') 630 PARTITION BY RANGE ( 631 expected_graduation_date 632 ) ( 633 PARTITION graduated_us 634 VALUES FROM (minvalue) 635 TO ('2017-08-15'), 636 PARTITION current_us 637 VALUES FROM ( 638 '2017-08-15' 639 ) 640 TO (maxvalue) 641 ) 642 ) 643 644 67: 645 ------------------------------------------------------------------- 646 CREATE TABLE students ( 647 id SERIAL8, 648 name STRING, 649 email STRING, 650 country STRING, 651 expected_graduation_date DATE, 652 PRIMARY KEY (country, expected_graduation_date, id) 653 ) PARTITION BY LIST (country) ( 654 PARTITION australia VALUES IN ( 655 'AU', 656 'NZ' 657 ) 658 PARTITION BY RANGE ( 659 expected_graduation_date 660 ) 661 ( 662 PARTITION graduated_au 663 VALUES FROM ( 664 minvalue 665 ) 666 TO ( 667 '2017-08-15' 668 ), 669 PARTITION current_au 670 VALUES FROM ( 671 '2017-08-15' 672 ) 673 TO ( 674 maxvalue 675 ) 676 ), 677 PARTITION north_america VALUES IN ( 678 'US', 679 'CA' 680 ) 681 PARTITION BY RANGE ( 682 expected_graduation_date 683 ) 684 ( 685 PARTITION graduated_us 686 VALUES FROM ( 687 minvalue 688 ) 689 TO ( 690 '2017-08-15' 691 ), 692 PARTITION current_us 693 VALUES FROM ( 694 '2017-08-15' 695 ) 696 TO ( 697 maxvalue 698 ) 699 ) 700 ) 701 702 72: 703 ------------------------------------------------------------------------ 704 CREATE TABLE students ( 705 id SERIAL8, 706 name STRING, 707 email STRING, 708 country STRING, 709 expected_graduation_date DATE, 710 PRIMARY KEY (country, expected_graduation_date, id) 711 ) PARTITION BY LIST (country) ( 712 PARTITION australia VALUES IN ( 713 'AU', 714 'NZ' 715 ) 716 PARTITION BY RANGE ( 717 expected_graduation_date 718 ) ( 719 PARTITION graduated_au 720 VALUES FROM ( 721 minvalue 722 ) 723 TO ( 724 '2017-08-15' 725 ), 726 PARTITION current_au 727 VALUES FROM ( 728 '2017-08-15' 729 ) 730 TO ( 731 maxvalue 732 ) 733 ), 734 PARTITION north_america VALUES IN ( 735 'US', 736 'CA' 737 ) 738 PARTITION BY RANGE ( 739 expected_graduation_date 740 ) 741 ( 742 PARTITION graduated_us 743 VALUES FROM ( 744 minvalue 745 ) 746 TO ( 747 '2017-08-15' 748 ), 749 PARTITION current_us 750 VALUES FROM ( 751 '2017-08-15' 752 ) 753 TO ( 754 maxvalue 755 ) 756 ) 757 ) 758 759 73: 760 ------------------------------------------------------------------------- 761 CREATE TABLE students ( 762 id SERIAL8, 763 name STRING, 764 email STRING, 765 country STRING, 766 expected_graduation_date DATE, 767 PRIMARY KEY (country, expected_graduation_date, id) 768 ) PARTITION BY LIST (country) ( 769 PARTITION australia VALUES IN ( 770 'AU', 771 'NZ' 772 ) 773 PARTITION BY RANGE ( 774 expected_graduation_date 775 ) ( 776 PARTITION graduated_au 777 VALUES FROM ( 778 minvalue 779 ) 780 TO ( 781 '2017-08-15' 782 ), 783 PARTITION current_au 784 VALUES FROM ( 785 '2017-08-15' 786 ) 787 TO (maxvalue) 788 ), 789 PARTITION north_america VALUES IN ( 790 'US', 791 'CA' 792 ) 793 PARTITION BY RANGE ( 794 expected_graduation_date 795 ) 796 ( 797 PARTITION graduated_us 798 VALUES FROM ( 799 minvalue 800 ) 801 TO ( 802 '2017-08-15' 803 ), 804 PARTITION current_us 805 VALUES FROM ( 806 '2017-08-15' 807 ) 808 TO ( 809 maxvalue 810 ) 811 ) 812 ) 813 814 74: 815 -------------------------------------------------------------------------- 816 CREATE TABLE students ( 817 id SERIAL8, 818 name STRING, 819 email STRING, 820 country STRING, 821 expected_graduation_date DATE, 822 PRIMARY KEY (country, expected_graduation_date, id) 823 ) PARTITION BY LIST (country) ( 824 PARTITION australia VALUES IN ('AU', 'NZ') 825 PARTITION BY RANGE ( 826 expected_graduation_date 827 ) ( 828 PARTITION graduated_au 829 VALUES FROM ( 830 minvalue 831 ) 832 TO ( 833 '2017-08-15' 834 ), 835 PARTITION current_au 836 VALUES FROM ( 837 '2017-08-15' 838 ) 839 TO (maxvalue) 840 ), 841 PARTITION north_america VALUES IN ( 842 'US', 843 'CA' 844 ) 845 PARTITION BY RANGE ( 846 expected_graduation_date 847 ) 848 ( 849 PARTITION graduated_us 850 VALUES FROM ( 851 minvalue 852 ) 853 TO ( 854 '2017-08-15' 855 ), 856 PARTITION current_us 857 VALUES FROM ( 858 '2017-08-15' 859 ) 860 TO ( 861 maxvalue 862 ) 863 ) 864 ) 865 866 76: 867 ---------------------------------------------------------------------------- 868 CREATE TABLE students ( 869 id SERIAL8, 870 name STRING, 871 email STRING, 872 country STRING, 873 expected_graduation_date DATE, 874 PRIMARY KEY (country, expected_graduation_date, id) 875 ) PARTITION BY LIST (country) ( 876 PARTITION australia VALUES IN ('AU', 'NZ') 877 PARTITION BY RANGE ( 878 expected_graduation_date 879 ) ( 880 PARTITION graduated_au 881 VALUES FROM ( 882 minvalue 883 ) 884 TO ( 885 '2017-08-15' 886 ), 887 PARTITION current_au 888 VALUES FROM ( 889 '2017-08-15' 890 ) 891 TO (maxvalue) 892 ), 893 PARTITION north_america VALUES IN ( 894 'US', 895 'CA' 896 ) 897 PARTITION BY RANGE ( 898 expected_graduation_date 899 ) ( 900 PARTITION graduated_us 901 VALUES FROM ( 902 minvalue 903 ) 904 TO ( 905 '2017-08-15' 906 ), 907 PARTITION current_us 908 VALUES FROM ( 909 '2017-08-15' 910 ) 911 TO ( 912 maxvalue 913 ) 914 ) 915 ) 916 917 77: 918 ----------------------------------------------------------------------------- 919 CREATE TABLE students ( 920 id SERIAL8, 921 name STRING, 922 email STRING, 923 country STRING, 924 expected_graduation_date DATE, 925 PRIMARY KEY (country, expected_graduation_date, id) 926 ) PARTITION BY LIST (country) ( 927 PARTITION australia VALUES IN ('AU', 'NZ') 928 PARTITION BY RANGE ( 929 expected_graduation_date 930 ) ( 931 PARTITION graduated_au 932 VALUES FROM ( 933 minvalue 934 ) 935 TO ( 936 '2017-08-15' 937 ), 938 PARTITION current_au 939 VALUES FROM ( 940 '2017-08-15' 941 ) 942 TO (maxvalue) 943 ), 944 PARTITION north_america VALUES IN ( 945 'US', 946 'CA' 947 ) 948 PARTITION BY RANGE ( 949 expected_graduation_date 950 ) ( 951 PARTITION graduated_us 952 VALUES FROM ( 953 minvalue 954 ) 955 TO ( 956 '2017-08-15' 957 ), 958 PARTITION current_us 959 VALUES FROM ( 960 '2017-08-15' 961 ) 962 TO (maxvalue) 963 ) 964 ) 965 966 78: 967 ------------------------------------------------------------------------------ 968 CREATE TABLE students ( 969 id SERIAL8, 970 name STRING, 971 email STRING, 972 country STRING, 973 expected_graduation_date DATE, 974 PRIMARY KEY (country, expected_graduation_date, id) 975 ) PARTITION BY LIST (country) ( 976 PARTITION australia VALUES IN ('AU', 'NZ') 977 PARTITION BY RANGE ( 978 expected_graduation_date 979 ) ( 980 PARTITION graduated_au 981 VALUES FROM ( 982 minvalue 983 ) 984 TO ('2017-08-15'), 985 PARTITION current_au 986 VALUES FROM ( 987 '2017-08-15' 988 ) 989 TO (maxvalue) 990 ), 991 PARTITION north_america VALUES IN ('US', 'CA') 992 PARTITION BY RANGE ( 993 expected_graduation_date 994 ) ( 995 PARTITION graduated_us 996 VALUES FROM ( 997 minvalue 998 ) 999 TO ( 1000 '2017-08-15' 1001 ), 1002 PARTITION current_us 1003 VALUES FROM ( 1004 '2017-08-15' 1005 ) 1006 TO (maxvalue) 1007 ) 1008 ) 1009 1010 82: 1011 ---------------------------------------------------------------------------------- 1012 CREATE TABLE students ( 1013 id SERIAL8, 1014 name STRING, 1015 email STRING, 1016 country STRING, 1017 expected_graduation_date DATE, 1018 PRIMARY KEY (country, expected_graduation_date, id) 1019 ) PARTITION BY LIST (country) ( 1020 PARTITION australia VALUES IN ('AU', 'NZ') 1021 PARTITION BY RANGE ( 1022 expected_graduation_date 1023 ) ( 1024 PARTITION graduated_au 1025 VALUES FROM (minvalue) 1026 TO ('2017-08-15'), 1027 PARTITION current_au 1028 VALUES FROM ( 1029 '2017-08-15' 1030 ) 1031 TO (maxvalue) 1032 ), 1033 PARTITION north_america VALUES IN ('US', 'CA') 1034 PARTITION BY RANGE ( 1035 expected_graduation_date 1036 ) ( 1037 PARTITION graduated_us 1038 VALUES FROM ( 1039 minvalue 1040 ) 1041 TO ('2017-08-15'), 1042 PARTITION current_us 1043 VALUES FROM ( 1044 '2017-08-15' 1045 ) 1046 TO (maxvalue) 1047 ) 1048 ) 1049 1050 86: 1051 -------------------------------------------------------------------------------------- 1052 CREATE TABLE students ( 1053 id SERIAL8, 1054 name STRING, 1055 email STRING, 1056 country STRING, 1057 expected_graduation_date DATE, 1058 PRIMARY KEY (country, expected_graduation_date, id) 1059 ) PARTITION BY LIST (country) ( 1060 PARTITION australia VALUES IN ('AU', 'NZ') 1061 PARTITION BY RANGE ( 1062 expected_graduation_date 1063 ) ( 1064 PARTITION graduated_au 1065 VALUES FROM (minvalue) 1066 TO ('2017-08-15'), 1067 PARTITION current_au 1068 VALUES FROM ('2017-08-15') 1069 TO (maxvalue) 1070 ), 1071 PARTITION north_america VALUES IN ('US', 'CA') 1072 PARTITION BY RANGE ( 1073 expected_graduation_date 1074 ) ( 1075 PARTITION graduated_us 1076 VALUES FROM (minvalue) 1077 TO ('2017-08-15'), 1078 PARTITION current_us 1079 VALUES FROM ( 1080 '2017-08-15' 1081 ) 1082 TO (maxvalue) 1083 ) 1084 ) 1085 1086 89: 1087 ----------------------------------------------------------------------------------------- 1088 CREATE TABLE students ( 1089 id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, 1090 PRIMARY KEY (country, expected_graduation_date, id) 1091 ) PARTITION BY LIST (country) ( 1092 PARTITION australia VALUES IN ('AU', 'NZ') 1093 PARTITION BY RANGE ( 1094 expected_graduation_date 1095 ) ( 1096 PARTITION graduated_au 1097 VALUES FROM (minvalue) 1098 TO ('2017-08-15'), 1099 PARTITION current_au 1100 VALUES FROM ('2017-08-15') 1101 TO (maxvalue) 1102 ), 1103 PARTITION north_america VALUES IN ('US', 'CA') 1104 PARTITION BY RANGE ( 1105 expected_graduation_date 1106 ) ( 1107 PARTITION graduated_us 1108 VALUES FROM (minvalue) 1109 TO ('2017-08-15'), 1110 PARTITION current_us 1111 VALUES FROM ( 1112 '2017-08-15' 1113 ) 1114 TO (maxvalue) 1115 ) 1116 ) 1117 1118 90: 1119 ------------------------------------------------------------------------------------------ 1120 CREATE TABLE students ( 1121 id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, 1122 PRIMARY KEY (country, expected_graduation_date, id) 1123 ) PARTITION BY LIST (country) ( 1124 PARTITION australia VALUES IN ('AU', 'NZ') 1125 PARTITION BY RANGE ( 1126 expected_graduation_date 1127 ) ( 1128 PARTITION graduated_au 1129 VALUES FROM (minvalue) 1130 TO ('2017-08-15'), 1131 PARTITION current_au VALUES FROM ( 1132 '2017-08-15' 1133 ) 1134 TO (maxvalue) 1135 ), 1136 PARTITION north_america VALUES IN ('US', 'CA') 1137 PARTITION BY RANGE ( 1138 expected_graduation_date 1139 ) ( 1140 PARTITION graduated_us 1141 VALUES FROM (minvalue) 1142 TO ('2017-08-15'), 1143 PARTITION current_us 1144 VALUES FROM ('2017-08-15') 1145 TO (maxvalue) 1146 ) 1147 ) 1148 1149 92: 1150 -------------------------------------------------------------------------------------------- 1151 CREATE TABLE students ( 1152 id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, 1153 PRIMARY KEY (country, expected_graduation_date, id) 1154 ) PARTITION BY LIST (country) ( 1155 PARTITION australia VALUES IN ('AU', 'NZ') 1156 PARTITION BY RANGE ( 1157 expected_graduation_date 1158 ) ( 1159 PARTITION graduated_au VALUES FROM ( 1160 minvalue 1161 ) 1162 TO ( 1163 '2017-08-15' 1164 ), 1165 PARTITION current_au VALUES FROM ( 1166 '2017-08-15' 1167 ) 1168 TO (maxvalue) 1169 ), 1170 PARTITION north_america VALUES IN ('US', 'CA') 1171 PARTITION BY RANGE ( 1172 expected_graduation_date 1173 ) ( 1174 PARTITION graduated_us 1175 VALUES FROM (minvalue) 1176 TO ('2017-08-15'), 1177 PARTITION current_us 1178 VALUES FROM ('2017-08-15') 1179 TO (maxvalue) 1180 ) 1181 ) 1182 1183 94: 1184 ---------------------------------------------------------------------------------------------- 1185 CREATE TABLE students ( 1186 id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, 1187 PRIMARY KEY (country, expected_graduation_date, id) 1188 ) PARTITION BY LIST (country) ( 1189 PARTITION australia VALUES IN ('AU', 'NZ') 1190 PARTITION BY RANGE ( 1191 expected_graduation_date 1192 ) ( 1193 PARTITION graduated_au VALUES FROM ( 1194 minvalue 1195 ) 1196 TO ( 1197 '2017-08-15' 1198 ), 1199 PARTITION current_au VALUES FROM ( 1200 '2017-08-15' 1201 ) 1202 TO (maxvalue) 1203 ), 1204 PARTITION north_america VALUES IN ('US', 'CA') 1205 PARTITION BY RANGE ( 1206 expected_graduation_date 1207 ) ( 1208 PARTITION graduated_us 1209 VALUES FROM (minvalue) 1210 TO ('2017-08-15'), 1211 PARTITION current_us VALUES FROM ( 1212 '2017-08-15' 1213 ) 1214 TO (maxvalue) 1215 ) 1216 ) 1217 1218 96: 1219 ------------------------------------------------------------------------------------------------ 1220 CREATE TABLE students ( 1221 id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, 1222 PRIMARY KEY (country, expected_graduation_date, id) 1223 ) PARTITION BY LIST (country) ( 1224 PARTITION australia VALUES IN ('AU', 'NZ') 1225 PARTITION BY RANGE ( 1226 expected_graduation_date 1227 ) ( 1228 PARTITION graduated_au VALUES FROM ( 1229 minvalue 1230 ) 1231 TO ( 1232 '2017-08-15' 1233 ), 1234 PARTITION current_au VALUES FROM ( 1235 '2017-08-15' 1236 ) 1237 TO (maxvalue) 1238 ), 1239 PARTITION north_america VALUES IN ('US', 'CA') 1240 PARTITION BY RANGE ( 1241 expected_graduation_date 1242 ) ( 1243 PARTITION graduated_us VALUES FROM ( 1244 minvalue 1245 ) 1246 TO ( 1247 '2017-08-15' 1248 ), 1249 PARTITION current_us VALUES FROM ( 1250 '2017-08-15' 1251 ) 1252 TO (maxvalue) 1253 ) 1254 ) 1255 1256 97: 1257 ------------------------------------------------------------------------------------------------- 1258 CREATE TABLE students ( 1259 id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, 1260 PRIMARY KEY (country, expected_graduation_date, id) 1261 ) PARTITION BY LIST (country) ( 1262 PARTITION australia VALUES IN ('AU', 'NZ') 1263 PARTITION BY RANGE ( 1264 expected_graduation_date 1265 ) ( 1266 PARTITION graduated_au VALUES FROM ( 1267 minvalue 1268 ) 1269 TO ('2017-08-15'), 1270 PARTITION current_au VALUES FROM ( 1271 '2017-08-15' 1272 ) 1273 TO (maxvalue) 1274 ), 1275 PARTITION north_america VALUES IN ('US', 'CA') 1276 PARTITION BY RANGE ( 1277 expected_graduation_date 1278 ) ( 1279 PARTITION graduated_us VALUES FROM ( 1280 minvalue 1281 ) 1282 TO ( 1283 '2017-08-15' 1284 ), 1285 PARTITION current_us VALUES FROM ( 1286 '2017-08-15' 1287 ) 1288 TO (maxvalue) 1289 ) 1290 ) 1291 1292 99: 1293 --------------------------------------------------------------------------------------------------- 1294 CREATE TABLE students ( 1295 id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, 1296 PRIMARY KEY (country, expected_graduation_date, id) 1297 ) PARTITION BY LIST (country) ( 1298 PARTITION australia VALUES IN ('AU', 'NZ') 1299 PARTITION BY RANGE (expected_graduation_date) ( 1300 PARTITION graduated_au 1301 VALUES FROM ( 1302 minvalue 1303 ) 1304 TO ( 1305 '2017-08-15' 1306 ), 1307 PARTITION current_au 1308 VALUES FROM ( 1309 '2017-08-15' 1310 ) 1311 TO ( 1312 maxvalue 1313 ) 1314 ), 1315 PARTITION north_america VALUES IN ('US', 'CA') 1316 PARTITION BY RANGE ( 1317 expected_graduation_date 1318 ) ( 1319 PARTITION graduated_us VALUES FROM ( 1320 minvalue 1321 ) 1322 TO ( 1323 '2017-08-15' 1324 ), 1325 PARTITION current_us VALUES FROM ( 1326 '2017-08-15' 1327 ) 1328 TO (maxvalue) 1329 ) 1330 ) 1331 1332 101: 1333 ----------------------------------------------------------------------------------------------------- 1334 CREATE TABLE students ( 1335 id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, 1336 PRIMARY KEY (country, expected_graduation_date, id) 1337 ) PARTITION BY LIST (country) ( 1338 PARTITION australia VALUES IN ('AU', 'NZ') 1339 PARTITION BY RANGE (expected_graduation_date) ( 1340 PARTITION graduated_au 1341 VALUES FROM ( 1342 minvalue 1343 ) 1344 TO ( 1345 '2017-08-15' 1346 ), 1347 PARTITION current_au 1348 VALUES FROM ( 1349 '2017-08-15' 1350 ) 1351 TO ( 1352 maxvalue 1353 ) 1354 ), 1355 PARTITION north_america VALUES IN ('US', 'CA') 1356 PARTITION BY RANGE ( 1357 expected_graduation_date 1358 ) ( 1359 PARTITION graduated_us VALUES FROM ( 1360 minvalue 1361 ) 1362 TO ('2017-08-15'), 1363 PARTITION current_us VALUES FROM ( 1364 '2017-08-15' 1365 ) 1366 TO (maxvalue) 1367 ) 1368 ) 1369 1370 103: 1371 ------------------------------------------------------------------------------------------------------- 1372 CREATE TABLE students ( 1373 id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, 1374 PRIMARY KEY (country, expected_graduation_date, id) 1375 ) PARTITION BY LIST (country) ( 1376 PARTITION australia VALUES IN ('AU', 'NZ') 1377 PARTITION BY RANGE (expected_graduation_date) ( 1378 PARTITION graduated_au 1379 VALUES FROM ( 1380 minvalue 1381 ) 1382 TO ( 1383 '2017-08-15' 1384 ), 1385 PARTITION current_au 1386 VALUES FROM ( 1387 '2017-08-15' 1388 ) 1389 TO ( 1390 maxvalue 1391 ) 1392 ), 1393 PARTITION north_america VALUES IN ('US', 'CA') 1394 PARTITION BY RANGE (expected_graduation_date) ( 1395 PARTITION graduated_us 1396 VALUES FROM ( 1397 minvalue 1398 ) 1399 TO ( 1400 '2017-08-15' 1401 ), 1402 PARTITION current_us 1403 VALUES FROM ( 1404 '2017-08-15' 1405 ) 1406 TO ( 1407 maxvalue 1408 ) 1409 ) 1410 ) 1411 1412 117: 1413 --------------------------------------------------------------------------------------------------------------------- 1414 CREATE TABLE students ( 1415 id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, 1416 PRIMARY KEY (country, expected_graduation_date, id) 1417 ) PARTITION BY LIST (country) ( 1418 PARTITION australia VALUES IN ('AU', 'NZ') 1419 PARTITION BY RANGE (expected_graduation_date) ( 1420 PARTITION graduated_au 1421 VALUES FROM ( 1422 minvalue 1423 ) 1424 TO ( 1425 '2017-08-15' 1426 ), 1427 PARTITION current_au 1428 VALUES FROM ( 1429 '2017-08-15' 1430 ) 1431 TO (maxvalue) 1432 ), 1433 PARTITION north_america VALUES IN ('US', 'CA') 1434 PARTITION BY RANGE (expected_graduation_date) ( 1435 PARTITION graduated_us 1436 VALUES FROM ( 1437 minvalue 1438 ) 1439 TO ( 1440 '2017-08-15' 1441 ), 1442 PARTITION current_us 1443 VALUES FROM ( 1444 '2017-08-15' 1445 ) 1446 TO ( 1447 maxvalue 1448 ) 1449 ) 1450 ) 1451 1452 121: 1453 ------------------------------------------------------------------------------------------------------------------------- 1454 CREATE TABLE students ( 1455 id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, 1456 PRIMARY KEY (country, expected_graduation_date, id) 1457 ) PARTITION BY LIST (country) ( 1458 PARTITION australia VALUES IN ('AU', 'NZ') 1459 PARTITION BY RANGE (expected_graduation_date) ( 1460 PARTITION graduated_au 1461 VALUES FROM ( 1462 minvalue 1463 ) 1464 TO ( 1465 '2017-08-15' 1466 ), 1467 PARTITION current_au 1468 VALUES FROM ( 1469 '2017-08-15' 1470 ) 1471 TO (maxvalue) 1472 ), 1473 PARTITION north_america VALUES IN ('US', 'CA') 1474 PARTITION BY RANGE (expected_graduation_date) ( 1475 PARTITION graduated_us 1476 VALUES FROM ( 1477 minvalue 1478 ) 1479 TO ( 1480 '2017-08-15' 1481 ), 1482 PARTITION current_us 1483 VALUES FROM ( 1484 '2017-08-15' 1485 ) 1486 TO (maxvalue) 1487 ) 1488 ) 1489 1490 122: 1491 -------------------------------------------------------------------------------------------------------------------------- 1492 CREATE TABLE students ( 1493 id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, 1494 PRIMARY KEY (country, expected_graduation_date, id) 1495 ) PARTITION BY LIST (country) ( 1496 PARTITION australia VALUES IN ('AU', 'NZ') 1497 PARTITION BY RANGE (expected_graduation_date) ( 1498 PARTITION graduated_au 1499 VALUES FROM ( 1500 minvalue 1501 ) 1502 TO ('2017-08-15'), 1503 PARTITION current_au 1504 VALUES FROM ( 1505 '2017-08-15' 1506 ) 1507 TO (maxvalue) 1508 ), 1509 PARTITION north_america VALUES IN ('US', 'CA') 1510 PARTITION BY RANGE (expected_graduation_date) ( 1511 PARTITION graduated_us 1512 VALUES FROM ( 1513 minvalue 1514 ) 1515 TO ( 1516 '2017-08-15' 1517 ), 1518 PARTITION current_us 1519 VALUES FROM ( 1520 '2017-08-15' 1521 ) 1522 TO (maxvalue) 1523 ) 1524 ) 1525 1526 126: 1527 ------------------------------------------------------------------------------------------------------------------------------ 1528 CREATE TABLE students ( 1529 id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, 1530 PRIMARY KEY (country, expected_graduation_date, id) 1531 ) PARTITION BY LIST (country) ( 1532 PARTITION australia VALUES IN ('AU', 'NZ') 1533 PARTITION BY RANGE (expected_graduation_date) ( 1534 PARTITION graduated_au 1535 VALUES FROM (minvalue) 1536 TO ('2017-08-15'), 1537 PARTITION current_au 1538 VALUES FROM ( 1539 '2017-08-15' 1540 ) 1541 TO (maxvalue) 1542 ), 1543 PARTITION north_america VALUES IN ('US', 'CA') 1544 PARTITION BY RANGE (expected_graduation_date) ( 1545 PARTITION graduated_us 1546 VALUES FROM ( 1547 minvalue 1548 ) 1549 TO ('2017-08-15'), 1550 PARTITION current_us 1551 VALUES FROM ( 1552 '2017-08-15' 1553 ) 1554 TO (maxvalue) 1555 ) 1556 ) 1557 1558 130: 1559 ---------------------------------------------------------------------------------------------------------------------------------- 1560 CREATE TABLE students ( 1561 id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, 1562 PRIMARY KEY (country, expected_graduation_date, id) 1563 ) PARTITION BY LIST (country) ( 1564 PARTITION australia VALUES IN ('AU', 'NZ') 1565 PARTITION BY RANGE (expected_graduation_date) ( 1566 PARTITION graduated_au 1567 VALUES FROM (minvalue) 1568 TO ('2017-08-15'), 1569 PARTITION current_au 1570 VALUES FROM ('2017-08-15') 1571 TO (maxvalue) 1572 ), 1573 PARTITION north_america VALUES IN ('US', 'CA') 1574 PARTITION BY RANGE (expected_graduation_date) ( 1575 PARTITION graduated_us 1576 VALUES FROM (minvalue) 1577 TO ('2017-08-15'), 1578 PARTITION current_us 1579 VALUES FROM ( 1580 '2017-08-15' 1581 ) 1582 TO (maxvalue) 1583 ) 1584 ) 1585 1586 134: 1587 -------------------------------------------------------------------------------------------------------------------------------------- 1588 CREATE TABLE students ( 1589 id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, 1590 PRIMARY KEY (country, expected_graduation_date, id) 1591 ) PARTITION BY LIST (country) ( 1592 PARTITION australia VALUES IN ('AU', 'NZ') 1593 PARTITION BY RANGE (expected_graduation_date) ( 1594 PARTITION graduated_au 1595 VALUES FROM (minvalue) 1596 TO ('2017-08-15'), 1597 PARTITION current_au VALUES FROM ( 1598 '2017-08-15' 1599 ) 1600 TO (maxvalue) 1601 ), 1602 PARTITION north_america VALUES IN ('US', 'CA') 1603 PARTITION BY RANGE (expected_graduation_date) ( 1604 PARTITION graduated_us 1605 VALUES FROM (minvalue) 1606 TO ('2017-08-15'), 1607 PARTITION current_us 1608 VALUES FROM ('2017-08-15') 1609 TO (maxvalue) 1610 ) 1611 ) 1612 1613 136: 1614 ---------------------------------------------------------------------------------------------------------------------------------------- 1615 CREATE TABLE students ( 1616 id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, 1617 PRIMARY KEY (country, expected_graduation_date, id) 1618 ) PARTITION BY LIST (country) ( 1619 PARTITION australia VALUES IN ('AU', 'NZ') 1620 PARTITION BY RANGE (expected_graduation_date) ( 1621 PARTITION graduated_au VALUES FROM ( 1622 minvalue 1623 ) 1624 TO ( 1625 '2017-08-15' 1626 ), 1627 PARTITION current_au VALUES FROM ( 1628 '2017-08-15' 1629 ) 1630 TO (maxvalue) 1631 ), 1632 PARTITION north_america VALUES IN ('US', 'CA') 1633 PARTITION BY RANGE (expected_graduation_date) ( 1634 PARTITION graduated_us 1635 VALUES FROM (minvalue) 1636 TO ('2017-08-15'), 1637 PARTITION current_us 1638 VALUES FROM ('2017-08-15') 1639 TO (maxvalue) 1640 ) 1641 ) 1642 1643 138: 1644 ------------------------------------------------------------------------------------------------------------------------------------------ 1645 CREATE TABLE students ( 1646 id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, 1647 PRIMARY KEY (country, expected_graduation_date, id) 1648 ) PARTITION BY LIST (country) ( 1649 PARTITION australia VALUES IN ('AU', 'NZ') 1650 PARTITION BY RANGE (expected_graduation_date) ( 1651 PARTITION graduated_au VALUES FROM ( 1652 minvalue 1653 ) 1654 TO ( 1655 '2017-08-15' 1656 ), 1657 PARTITION current_au VALUES FROM ( 1658 '2017-08-15' 1659 ) 1660 TO (maxvalue) 1661 ), 1662 PARTITION north_america VALUES IN ('US', 'CA') 1663 PARTITION BY RANGE (expected_graduation_date) ( 1664 PARTITION graduated_us 1665 VALUES FROM (minvalue) 1666 TO ('2017-08-15'), 1667 PARTITION current_us VALUES FROM ( 1668 '2017-08-15' 1669 ) 1670 TO (maxvalue) 1671 ) 1672 ) 1673 1674 140: 1675 -------------------------------------------------------------------------------------------------------------------------------------------- 1676 CREATE TABLE students ( 1677 id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, 1678 PRIMARY KEY (country, expected_graduation_date, id) 1679 ) PARTITION BY LIST (country) ( 1680 PARTITION australia VALUES IN ('AU', 'NZ') 1681 PARTITION BY RANGE (expected_graduation_date) ( 1682 PARTITION graduated_au VALUES FROM ( 1683 minvalue 1684 ) 1685 TO ( 1686 '2017-08-15' 1687 ), 1688 PARTITION current_au VALUES FROM ( 1689 '2017-08-15' 1690 ) 1691 TO (maxvalue) 1692 ), 1693 PARTITION north_america VALUES IN ('US', 'CA') 1694 PARTITION BY RANGE (expected_graduation_date) ( 1695 PARTITION graduated_us VALUES FROM ( 1696 minvalue 1697 ) 1698 TO ( 1699 '2017-08-15' 1700 ), 1701 PARTITION current_us VALUES FROM ( 1702 '2017-08-15' 1703 ) 1704 TO (maxvalue) 1705 ) 1706 ) 1707 1708 141: 1709 --------------------------------------------------------------------------------------------------------------------------------------------- 1710 CREATE TABLE students ( 1711 id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, 1712 PRIMARY KEY (country, expected_graduation_date, id) 1713 ) PARTITION BY LIST (country) ( 1714 PARTITION australia VALUES IN ('AU', 'NZ') 1715 PARTITION BY RANGE (expected_graduation_date) ( 1716 PARTITION graduated_au VALUES FROM ( 1717 minvalue 1718 ) 1719 TO ('2017-08-15'), 1720 PARTITION current_au VALUES FROM ( 1721 '2017-08-15' 1722 ) 1723 TO (maxvalue) 1724 ), 1725 PARTITION north_america VALUES IN ('US', 'CA') 1726 PARTITION BY RANGE (expected_graduation_date) ( 1727 PARTITION graduated_us VALUES FROM ( 1728 minvalue 1729 ) 1730 TO ( 1731 '2017-08-15' 1732 ), 1733 PARTITION current_us VALUES FROM ( 1734 '2017-08-15' 1735 ) 1736 TO (maxvalue) 1737 ) 1738 ) 1739 1740 145: 1741 ------------------------------------------------------------------------------------------------------------------------------------------------- 1742 CREATE TABLE students ( 1743 id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, 1744 PRIMARY KEY (country, expected_graduation_date, id) 1745 ) PARTITION BY LIST (country) ( 1746 PARTITION australia VALUES IN ('AU', 'NZ') 1747 PARTITION BY RANGE (expected_graduation_date) ( 1748 PARTITION graduated_au VALUES FROM (minvalue) 1749 TO ('2017-08-15'), 1750 PARTITION current_au VALUES FROM ( 1751 '2017-08-15' 1752 ) 1753 TO (maxvalue) 1754 ), 1755 PARTITION north_america VALUES IN ('US', 'CA') 1756 PARTITION BY RANGE (expected_graduation_date) ( 1757 PARTITION graduated_us VALUES FROM ( 1758 minvalue 1759 ) 1760 TO ('2017-08-15'), 1761 PARTITION current_us VALUES FROM ( 1762 '2017-08-15' 1763 ) 1764 TO (maxvalue) 1765 ) 1766 ) 1767 1768 147: 1769 --------------------------------------------------------------------------------------------------------------------------------------------------- 1770 CREATE TABLE students ( 1771 id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, 1772 PRIMARY KEY (country, expected_graduation_date, id) 1773 ) PARTITION BY LIST (country) ( 1774 PARTITION australia VALUES IN ('AU', 'NZ') 1775 PARTITION BY RANGE (expected_graduation_date) ( 1776 PARTITION graduated_au VALUES FROM (minvalue) 1777 TO ('2017-08-15'), 1778 PARTITION current_au VALUES FROM ('2017-08-15') 1779 TO (maxvalue) 1780 ), 1781 PARTITION north_america VALUES IN ('US', 'CA') 1782 PARTITION BY RANGE (expected_graduation_date) ( 1783 PARTITION graduated_us VALUES FROM ( 1784 minvalue 1785 ) 1786 TO ('2017-08-15'), 1787 PARTITION current_us VALUES FROM ( 1788 '2017-08-15' 1789 ) 1790 TO (maxvalue) 1791 ) 1792 ) 1793 1794 149: 1795 ----------------------------------------------------------------------------------------------------------------------------------------------------- 1796 CREATE TABLE students ( 1797 id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, 1798 PRIMARY KEY (country, expected_graduation_date, id) 1799 ) PARTITION BY LIST (country) ( 1800 PARTITION australia VALUES IN ('AU', 'NZ') 1801 PARTITION BY RANGE (expected_graduation_date) ( 1802 PARTITION graduated_au VALUES FROM (minvalue) 1803 TO ('2017-08-15'), 1804 PARTITION current_au VALUES FROM ('2017-08-15') 1805 TO (maxvalue) 1806 ), 1807 PARTITION north_america VALUES IN ('US', 'CA') 1808 PARTITION BY RANGE (expected_graduation_date) ( 1809 PARTITION graduated_us VALUES FROM (minvalue) 1810 TO ('2017-08-15'), 1811 PARTITION current_us VALUES FROM ( 1812 '2017-08-15' 1813 ) 1814 TO (maxvalue) 1815 ) 1816 ) 1817 1818 151: 1819 ------------------------------------------------------------------------------------------------------------------------------------------------------- 1820 CREATE TABLE students ( 1821 id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, 1822 PRIMARY KEY (country, expected_graduation_date, id) 1823 ) PARTITION BY LIST (country) ( 1824 PARTITION australia VALUES IN ('AU', 'NZ') 1825 PARTITION BY RANGE (expected_graduation_date) ( 1826 PARTITION graduated_au VALUES FROM (minvalue) 1827 TO ('2017-08-15'), 1828 PARTITION current_au VALUES FROM ('2017-08-15') 1829 TO (maxvalue) 1830 ), 1831 PARTITION north_america VALUES IN ('US', 'CA') 1832 PARTITION BY RANGE (expected_graduation_date) ( 1833 PARTITION graduated_us VALUES FROM (minvalue) 1834 TO ('2017-08-15'), 1835 PARTITION current_us VALUES FROM ('2017-08-15') 1836 TO (maxvalue) 1837 ) 1838 ) 1839 1840 161: 1841 ----------------------------------------------------------------------------------------------------------------------------------------------------------------- 1842 CREATE TABLE students ( 1843 id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, 1844 PRIMARY KEY (country, expected_graduation_date, id) 1845 ) PARTITION BY LIST (country) ( 1846 PARTITION australia VALUES IN ('AU', 'NZ') 1847 PARTITION BY RANGE (expected_graduation_date) ( 1848 PARTITION graduated_au VALUES FROM (minvalue) 1849 TO ('2017-08-15'), 1850 PARTITION current_au VALUES FROM ('2017-08-15') TO (maxvalue) 1851 ), 1852 PARTITION north_america VALUES IN ('US', 'CA') 1853 PARTITION BY RANGE (expected_graduation_date) ( 1854 PARTITION graduated_us VALUES FROM (minvalue) 1855 TO ('2017-08-15'), 1856 PARTITION current_us VALUES FROM ('2017-08-15') 1857 TO (maxvalue) 1858 ) 1859 ) 1860 1861 164: 1862 -------------------------------------------------------------------------------------------------------------------------------------------------------------------- 1863 CREATE TABLE students ( 1864 id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, 1865 PRIMARY KEY (country, expected_graduation_date, id) 1866 ) PARTITION BY LIST (country) ( 1867 PARTITION australia VALUES IN ('AU', 'NZ') 1868 PARTITION BY RANGE (expected_graduation_date) ( 1869 PARTITION graduated_au VALUES FROM (minvalue) TO ('2017-08-15'), 1870 PARTITION current_au VALUES FROM ('2017-08-15') TO (maxvalue) 1871 ), 1872 PARTITION north_america VALUES IN ('US', 'CA') 1873 PARTITION BY RANGE (expected_graduation_date) ( 1874 PARTITION graduated_us VALUES FROM (minvalue) 1875 TO ('2017-08-15'), 1876 PARTITION current_us VALUES FROM ('2017-08-15') 1877 TO (maxvalue) 1878 ) 1879 ) 1880 1881 165: 1882 --------------------------------------------------------------------------------------------------------------------------------------------------------------------- 1883 CREATE TABLE students ( 1884 id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, 1885 PRIMARY KEY (country, expected_graduation_date, id) 1886 ) PARTITION BY LIST (country) ( 1887 PARTITION australia VALUES IN ('AU', 'NZ') 1888 PARTITION BY RANGE (expected_graduation_date) ( 1889 PARTITION graduated_au VALUES FROM (minvalue) TO ('2017-08-15'), 1890 PARTITION current_au VALUES FROM ('2017-08-15') TO (maxvalue) 1891 ), 1892 PARTITION north_america VALUES IN ('US', 'CA') 1893 PARTITION BY RANGE (expected_graduation_date) ( 1894 PARTITION graduated_us VALUES FROM (minvalue) 1895 TO ('2017-08-15'), 1896 PARTITION current_us VALUES FROM ('2017-08-15') TO (maxvalue) 1897 ) 1898 ) 1899 1900 168: 1901 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------ 1902 CREATE TABLE students ( 1903 id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, 1904 PRIMARY KEY (country, expected_graduation_date, id) 1905 ) PARTITION BY LIST (country) ( 1906 PARTITION australia VALUES IN ('AU', 'NZ') 1907 PARTITION BY RANGE (expected_graduation_date) ( 1908 PARTITION graduated_au VALUES FROM (minvalue) TO ('2017-08-15'), 1909 PARTITION current_au VALUES FROM ('2017-08-15') TO (maxvalue) 1910 ), 1911 PARTITION north_america VALUES IN ('US', 'CA') 1912 PARTITION BY RANGE (expected_graduation_date) ( 1913 PARTITION graduated_us VALUES FROM (minvalue) TO ('2017-08-15'), 1914 PARTITION current_us VALUES FROM ('2017-08-15') TO (maxvalue) 1915 ) 1916 ) 1917 1918 181: 1919 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 1920 CREATE TABLE students (id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, PRIMARY KEY (country, expected_graduation_date, id)) PARTITION BY LIST ( 1921 country 1922 ) ( 1923 PARTITION australia 1924 VALUES IN ( 1925 'AU', 1926 'NZ' 1927 ) 1928 PARTITION BY RANGE ( 1929 expected_graduation_date 1930 ) 1931 ( 1932 PARTITION graduated_au 1933 VALUES FROM ( 1934 minvalue 1935 ) 1936 TO ( 1937 '2017-08-15' 1938 ), 1939 PARTITION current_au 1940 VALUES FROM ( 1941 '2017-08-15' 1942 ) 1943 TO ( 1944 maxvalue 1945 ) 1946 ), 1947 PARTITION north_america 1948 VALUES IN ( 1949 'US', 1950 'CA' 1951 ) 1952 PARTITION BY RANGE ( 1953 expected_graduation_date 1954 ) 1955 ( 1956 PARTITION graduated_us 1957 VALUES FROM ( 1958 minvalue 1959 ) 1960 TO ( 1961 '2017-08-15' 1962 ), 1963 PARTITION current_us 1964 VALUES FROM ( 1965 '2017-08-15' 1966 ) 1967 TO ( 1968 maxvalue 1969 ) 1970 ) 1971 ) 1972 1973 191: 1974 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 1975 CREATE TABLE students (id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, PRIMARY KEY (country, expected_graduation_date, id)) PARTITION BY LIST (country) ( 1976 PARTITION australia 1977 VALUES IN ( 1978 'AU', 1979 'NZ' 1980 ) 1981 PARTITION BY RANGE ( 1982 expected_graduation_date 1983 ) 1984 ( 1985 PARTITION graduated_au 1986 VALUES FROM ( 1987 minvalue 1988 ) 1989 TO ( 1990 '2017-08-15' 1991 ), 1992 PARTITION current_au 1993 VALUES FROM ( 1994 '2017-08-15' 1995 ) 1996 TO ( 1997 maxvalue 1998 ) 1999 ), 2000 PARTITION north_america 2001 VALUES IN ( 2002 'US', 2003 'CA' 2004 ) 2005 PARTITION BY RANGE ( 2006 expected_graduation_date 2007 ) 2008 ( 2009 PARTITION graduated_us 2010 VALUES FROM ( 2011 minvalue 2012 ) 2013 TO ( 2014 '2017-08-15' 2015 ), 2016 PARTITION current_us 2017 VALUES FROM ( 2018 '2017-08-15' 2019 ) 2020 TO ( 2021 maxvalue 2022 ) 2023 ) 2024 ) 2025 2026 216: 2027 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ 2028 CREATE TABLE students (id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, PRIMARY KEY (country, expected_graduation_date, id)) PARTITION BY LIST (country) ( 2029 PARTITION australia 2030 VALUES IN ( 2031 'AU', 2032 'NZ' 2033 ) 2034 PARTITION BY RANGE ( 2035 expected_graduation_date 2036 ) ( 2037 PARTITION graduated_au 2038 VALUES FROM ( 2039 minvalue 2040 ) 2041 TO ( 2042 '2017-08-15' 2043 ), 2044 PARTITION current_au 2045 VALUES FROM ( 2046 '2017-08-15' 2047 ) 2048 TO ( 2049 maxvalue 2050 ) 2051 ), 2052 PARTITION north_america 2053 VALUES IN ( 2054 'US', 2055 'CA' 2056 ) 2057 PARTITION BY RANGE ( 2058 expected_graduation_date 2059 ) ( 2060 PARTITION graduated_us 2061 VALUES FROM ( 2062 minvalue 2063 ) 2064 TO ( 2065 '2017-08-15' 2066 ), 2067 PARTITION current_us 2068 VALUES FROM ( 2069 '2017-08-15' 2070 ) 2071 TO ( 2072 maxvalue 2073 ) 2074 ) 2075 ) 2076 2077 217: 2078 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 2079 CREATE TABLE students (id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, PRIMARY KEY (country, expected_graduation_date, id)) PARTITION BY LIST (country) ( 2080 PARTITION australia 2081 VALUES IN ( 2082 'AU', 2083 'NZ' 2084 ) 2085 PARTITION BY RANGE ( 2086 expected_graduation_date 2087 ) ( 2088 PARTITION graduated_au 2089 VALUES FROM ( 2090 minvalue 2091 ) 2092 TO ( 2093 '2017-08-15' 2094 ), 2095 PARTITION current_au 2096 VALUES FROM ( 2097 '2017-08-15' 2098 ) 2099 TO (maxvalue) 2100 ), 2101 PARTITION north_america 2102 VALUES IN ( 2103 'US', 2104 'CA' 2105 ) 2106 PARTITION BY RANGE ( 2107 expected_graduation_date 2108 ) ( 2109 PARTITION graduated_us 2110 VALUES FROM ( 2111 minvalue 2112 ) 2113 TO ( 2114 '2017-08-15' 2115 ), 2116 PARTITION current_us 2117 VALUES FROM ( 2118 '2017-08-15' 2119 ) 2120 TO (maxvalue) 2121 ) 2122 ) 2123 2124 218: 2125 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 2126 CREATE TABLE students (id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, PRIMARY KEY (country, expected_graduation_date, id)) PARTITION BY LIST (country) ( 2127 PARTITION australia 2128 VALUES IN ('AU', 'NZ') 2129 PARTITION BY RANGE ( 2130 expected_graduation_date 2131 ) ( 2132 PARTITION graduated_au 2133 VALUES FROM ( 2134 minvalue 2135 ) 2136 TO ( 2137 '2017-08-15' 2138 ), 2139 PARTITION current_au 2140 VALUES FROM ( 2141 '2017-08-15' 2142 ) 2143 TO (maxvalue) 2144 ), 2145 PARTITION north_america 2146 VALUES IN ('US', 'CA') 2147 PARTITION BY RANGE ( 2148 expected_graduation_date 2149 ) ( 2150 PARTITION graduated_us 2151 VALUES FROM ( 2152 minvalue 2153 ) 2154 TO ( 2155 '2017-08-15' 2156 ), 2157 PARTITION current_us 2158 VALUES FROM ( 2159 '2017-08-15' 2160 ) 2161 TO (maxvalue) 2162 ) 2163 ) 2164 2165 222: 2166 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ 2167 CREATE TABLE students (id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, PRIMARY KEY (country, expected_graduation_date, id)) PARTITION BY LIST (country) ( 2168 PARTITION australia 2169 VALUES IN ('AU', 'NZ') 2170 PARTITION BY RANGE ( 2171 expected_graduation_date 2172 ) ( 2173 PARTITION graduated_au 2174 VALUES FROM ( 2175 minvalue 2176 ) 2177 TO ('2017-08-15'), 2178 PARTITION current_au 2179 VALUES FROM ( 2180 '2017-08-15' 2181 ) 2182 TO (maxvalue) 2183 ), 2184 PARTITION north_america 2185 VALUES IN ('US', 'CA') 2186 PARTITION BY RANGE ( 2187 expected_graduation_date 2188 ) ( 2189 PARTITION graduated_us 2190 VALUES FROM ( 2191 minvalue 2192 ) 2193 TO ('2017-08-15'), 2194 PARTITION current_us 2195 VALUES FROM ( 2196 '2017-08-15' 2197 ) 2198 TO (maxvalue) 2199 ) 2200 ) 2201 2202 223: 2203 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 2204 CREATE TABLE students (id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, PRIMARY KEY (country, expected_graduation_date, id)) PARTITION BY LIST (country) ( 2205 PARTITION australia VALUES IN ( 2206 'AU', 2207 'NZ' 2208 ) 2209 PARTITION BY RANGE ( 2210 expected_graduation_date 2211 ) 2212 ( 2213 PARTITION graduated_au 2214 VALUES FROM ( 2215 minvalue 2216 ) 2217 TO ( 2218 '2017-08-15' 2219 ), 2220 PARTITION current_au 2221 VALUES FROM ( 2222 '2017-08-15' 2223 ) 2224 TO ( 2225 maxvalue 2226 ) 2227 ), 2228 PARTITION north_america 2229 VALUES IN ('US', 'CA') 2230 PARTITION BY RANGE ( 2231 expected_graduation_date 2232 ) ( 2233 PARTITION graduated_us 2234 VALUES FROM ( 2235 minvalue 2236 ) 2237 TO ('2017-08-15'), 2238 PARTITION current_us 2239 VALUES FROM ( 2240 '2017-08-15' 2241 ) 2242 TO (maxvalue) 2243 ) 2244 ) 2245 2246 226: 2247 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 2248 CREATE TABLE students (id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, PRIMARY KEY (country, expected_graduation_date, id)) PARTITION BY LIST (country) ( 2249 PARTITION australia VALUES IN ( 2250 'AU', 2251 'NZ' 2252 ) 2253 PARTITION BY RANGE ( 2254 expected_graduation_date 2255 ) 2256 ( 2257 PARTITION graduated_au 2258 VALUES FROM ( 2259 minvalue 2260 ) 2261 TO ( 2262 '2017-08-15' 2263 ), 2264 PARTITION current_au 2265 VALUES FROM ( 2266 '2017-08-15' 2267 ) 2268 TO ( 2269 maxvalue 2270 ) 2271 ), 2272 PARTITION north_america 2273 VALUES IN ('US', 'CA') 2274 PARTITION BY RANGE ( 2275 expected_graduation_date 2276 ) ( 2277 PARTITION graduated_us 2278 VALUES FROM (minvalue) 2279 TO ('2017-08-15'), 2280 PARTITION current_us 2281 VALUES FROM ( 2282 '2017-08-15' 2283 ) 2284 TO (maxvalue) 2285 ) 2286 ) 2287 2288 227: 2289 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 2290 CREATE TABLE students (id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, PRIMARY KEY (country, expected_graduation_date, id)) PARTITION BY LIST (country) ( 2291 PARTITION australia VALUES IN ( 2292 'AU', 2293 'NZ' 2294 ) 2295 PARTITION BY RANGE ( 2296 expected_graduation_date 2297 ) 2298 ( 2299 PARTITION graduated_au 2300 VALUES FROM ( 2301 minvalue 2302 ) 2303 TO ( 2304 '2017-08-15' 2305 ), 2306 PARTITION current_au 2307 VALUES FROM ( 2308 '2017-08-15' 2309 ) 2310 TO ( 2311 maxvalue 2312 ) 2313 ), 2314 PARTITION north_america VALUES IN ( 2315 'US', 2316 'CA' 2317 ) 2318 PARTITION BY RANGE ( 2319 expected_graduation_date 2320 ) 2321 ( 2322 PARTITION graduated_us 2323 VALUES FROM ( 2324 minvalue 2325 ) 2326 TO ( 2327 '2017-08-15' 2328 ), 2329 PARTITION current_us 2330 VALUES FROM ( 2331 '2017-08-15' 2332 ) 2333 TO ( 2334 maxvalue 2335 ) 2336 ) 2337 ) 2338 2339 232: 2340 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 2341 CREATE TABLE students (id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, PRIMARY KEY (country, expected_graduation_date, id)) PARTITION BY LIST (country) ( 2342 PARTITION australia VALUES IN ( 2343 'AU', 2344 'NZ' 2345 ) 2346 PARTITION BY RANGE ( 2347 expected_graduation_date 2348 ) ( 2349 PARTITION graduated_au 2350 VALUES FROM ( 2351 minvalue 2352 ) 2353 TO ( 2354 '2017-08-15' 2355 ), 2356 PARTITION current_au 2357 VALUES FROM ( 2358 '2017-08-15' 2359 ) 2360 TO ( 2361 maxvalue 2362 ) 2363 ), 2364 PARTITION north_america VALUES IN ( 2365 'US', 2366 'CA' 2367 ) 2368 PARTITION BY RANGE ( 2369 expected_graduation_date 2370 ) 2371 ( 2372 PARTITION graduated_us 2373 VALUES FROM ( 2374 minvalue 2375 ) 2376 TO ( 2377 '2017-08-15' 2378 ), 2379 PARTITION current_us 2380 VALUES FROM ( 2381 '2017-08-15' 2382 ) 2383 TO ( 2384 maxvalue 2385 ) 2386 ) 2387 ) 2388 2389 233: 2390 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 2391 CREATE TABLE students (id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, PRIMARY KEY (country, expected_graduation_date, id)) PARTITION BY LIST (country) ( 2392 PARTITION australia VALUES IN ( 2393 'AU', 2394 'NZ' 2395 ) 2396 PARTITION BY RANGE ( 2397 expected_graduation_date 2398 ) ( 2399 PARTITION graduated_au 2400 VALUES FROM ( 2401 minvalue 2402 ) 2403 TO ( 2404 '2017-08-15' 2405 ), 2406 PARTITION current_au 2407 VALUES FROM ( 2408 '2017-08-15' 2409 ) 2410 TO (maxvalue) 2411 ), 2412 PARTITION north_america VALUES IN ( 2413 'US', 2414 'CA' 2415 ) 2416 PARTITION BY RANGE ( 2417 expected_graduation_date 2418 ) 2419 ( 2420 PARTITION graduated_us 2421 VALUES FROM ( 2422 minvalue 2423 ) 2424 TO ( 2425 '2017-08-15' 2426 ), 2427 PARTITION current_us 2428 VALUES FROM ( 2429 '2017-08-15' 2430 ) 2431 TO ( 2432 maxvalue 2433 ) 2434 ) 2435 ) 2436 2437 234: 2438 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ 2439 CREATE TABLE students (id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, PRIMARY KEY (country, expected_graduation_date, id)) PARTITION BY LIST (country) ( 2440 PARTITION australia VALUES IN ('AU', 'NZ') 2441 PARTITION BY RANGE ( 2442 expected_graduation_date 2443 ) ( 2444 PARTITION graduated_au 2445 VALUES FROM ( 2446 minvalue 2447 ) 2448 TO ( 2449 '2017-08-15' 2450 ), 2451 PARTITION current_au 2452 VALUES FROM ( 2453 '2017-08-15' 2454 ) 2455 TO (maxvalue) 2456 ), 2457 PARTITION north_america VALUES IN ( 2458 'US', 2459 'CA' 2460 ) 2461 PARTITION BY RANGE ( 2462 expected_graduation_date 2463 ) 2464 ( 2465 PARTITION graduated_us 2466 VALUES FROM ( 2467 minvalue 2468 ) 2469 TO ( 2470 '2017-08-15' 2471 ), 2472 PARTITION current_us 2473 VALUES FROM ( 2474 '2017-08-15' 2475 ) 2476 TO ( 2477 maxvalue 2478 ) 2479 ) 2480 ) 2481 2482 236: 2483 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 2484 CREATE TABLE students (id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, PRIMARY KEY (country, expected_graduation_date, id)) PARTITION BY LIST (country) ( 2485 PARTITION australia VALUES IN ('AU', 'NZ') 2486 PARTITION BY RANGE ( 2487 expected_graduation_date 2488 ) ( 2489 PARTITION graduated_au 2490 VALUES FROM ( 2491 minvalue 2492 ) 2493 TO ( 2494 '2017-08-15' 2495 ), 2496 PARTITION current_au 2497 VALUES FROM ( 2498 '2017-08-15' 2499 ) 2500 TO (maxvalue) 2501 ), 2502 PARTITION north_america VALUES IN ( 2503 'US', 2504 'CA' 2505 ) 2506 PARTITION BY RANGE ( 2507 expected_graduation_date 2508 ) ( 2509 PARTITION graduated_us 2510 VALUES FROM ( 2511 minvalue 2512 ) 2513 TO ( 2514 '2017-08-15' 2515 ), 2516 PARTITION current_us 2517 VALUES FROM ( 2518 '2017-08-15' 2519 ) 2520 TO ( 2521 maxvalue 2522 ) 2523 ) 2524 ) 2525 2526 237: 2527 --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 2528 CREATE TABLE students (id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, PRIMARY KEY (country, expected_graduation_date, id)) PARTITION BY LIST (country) ( 2529 PARTITION australia VALUES IN ('AU', 'NZ') 2530 PARTITION BY RANGE ( 2531 expected_graduation_date 2532 ) ( 2533 PARTITION graduated_au 2534 VALUES FROM ( 2535 minvalue 2536 ) 2537 TO ( 2538 '2017-08-15' 2539 ), 2540 PARTITION current_au 2541 VALUES FROM ( 2542 '2017-08-15' 2543 ) 2544 TO (maxvalue) 2545 ), 2546 PARTITION north_america VALUES IN ( 2547 'US', 2548 'CA' 2549 ) 2550 PARTITION BY RANGE ( 2551 expected_graduation_date 2552 ) ( 2553 PARTITION graduated_us 2554 VALUES FROM ( 2555 minvalue 2556 ) 2557 TO ( 2558 '2017-08-15' 2559 ), 2560 PARTITION current_us 2561 VALUES FROM ( 2562 '2017-08-15' 2563 ) 2564 TO (maxvalue) 2565 ) 2566 ) 2567 2568 238: 2569 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 2570 CREATE TABLE students (id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, PRIMARY KEY (country, expected_graduation_date, id)) PARTITION BY LIST (country) ( 2571 PARTITION australia VALUES IN ('AU', 'NZ') 2572 PARTITION BY RANGE ( 2573 expected_graduation_date 2574 ) ( 2575 PARTITION graduated_au 2576 VALUES FROM ( 2577 minvalue 2578 ) 2579 TO ('2017-08-15'), 2580 PARTITION current_au 2581 VALUES FROM ( 2582 '2017-08-15' 2583 ) 2584 TO (maxvalue) 2585 ), 2586 PARTITION north_america VALUES IN ('US', 'CA') 2587 PARTITION BY RANGE ( 2588 expected_graduation_date 2589 ) ( 2590 PARTITION graduated_us 2591 VALUES FROM ( 2592 minvalue 2593 ) 2594 TO ( 2595 '2017-08-15' 2596 ), 2597 PARTITION current_us 2598 VALUES FROM ( 2599 '2017-08-15' 2600 ) 2601 TO (maxvalue) 2602 ) 2603 ) 2604 2605 242: 2606 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 2607 CREATE TABLE students (id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, PRIMARY KEY (country, expected_graduation_date, id)) PARTITION BY LIST (country) ( 2608 PARTITION australia VALUES IN ('AU', 'NZ') 2609 PARTITION BY RANGE ( 2610 expected_graduation_date 2611 ) ( 2612 PARTITION graduated_au 2613 VALUES FROM (minvalue) 2614 TO ('2017-08-15'), 2615 PARTITION current_au 2616 VALUES FROM ( 2617 '2017-08-15' 2618 ) 2619 TO (maxvalue) 2620 ), 2621 PARTITION north_america VALUES IN ('US', 'CA') 2622 PARTITION BY RANGE ( 2623 expected_graduation_date 2624 ) ( 2625 PARTITION graduated_us 2626 VALUES FROM ( 2627 minvalue 2628 ) 2629 TO ('2017-08-15'), 2630 PARTITION current_us 2631 VALUES FROM ( 2632 '2017-08-15' 2633 ) 2634 TO (maxvalue) 2635 ) 2636 ) 2637 2638 246: 2639 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ 2640 CREATE TABLE students (id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, PRIMARY KEY (country, expected_graduation_date, id)) PARTITION BY LIST (country) ( 2641 PARTITION australia VALUES IN ('AU', 'NZ') 2642 PARTITION BY RANGE ( 2643 expected_graduation_date 2644 ) ( 2645 PARTITION graduated_au 2646 VALUES FROM (minvalue) 2647 TO ('2017-08-15'), 2648 PARTITION current_au 2649 VALUES FROM ('2017-08-15') 2650 TO (maxvalue) 2651 ), 2652 PARTITION north_america VALUES IN ('US', 'CA') 2653 PARTITION BY RANGE ( 2654 expected_graduation_date 2655 ) ( 2656 PARTITION graduated_us 2657 VALUES FROM (minvalue) 2658 TO ('2017-08-15'), 2659 PARTITION current_us 2660 VALUES FROM ( 2661 '2017-08-15' 2662 ) 2663 TO (maxvalue) 2664 ) 2665 ) 2666 2667 250: 2668 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 2669 CREATE TABLE students (id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, PRIMARY KEY (country, expected_graduation_date, id)) PARTITION BY LIST (country) ( 2670 PARTITION australia VALUES IN ('AU', 'NZ') 2671 PARTITION BY RANGE ( 2672 expected_graduation_date 2673 ) ( 2674 PARTITION graduated_au 2675 VALUES FROM (minvalue) 2676 TO ('2017-08-15'), 2677 PARTITION current_au VALUES FROM ( 2678 '2017-08-15' 2679 ) 2680 TO (maxvalue) 2681 ), 2682 PARTITION north_america VALUES IN ('US', 'CA') 2683 PARTITION BY RANGE ( 2684 expected_graduation_date 2685 ) ( 2686 PARTITION graduated_us 2687 VALUES FROM (minvalue) 2688 TO ('2017-08-15'), 2689 PARTITION current_us 2690 VALUES FROM ('2017-08-15') 2691 TO (maxvalue) 2692 ) 2693 ) 2694 2695 252: 2696 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ 2697 CREATE TABLE students (id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, PRIMARY KEY (country, expected_graduation_date, id)) PARTITION BY LIST (country) ( 2698 PARTITION australia VALUES IN ('AU', 'NZ') 2699 PARTITION BY RANGE ( 2700 expected_graduation_date 2701 ) ( 2702 PARTITION graduated_au VALUES FROM ( 2703 minvalue 2704 ) 2705 TO ( 2706 '2017-08-15' 2707 ), 2708 PARTITION current_au VALUES FROM ( 2709 '2017-08-15' 2710 ) 2711 TO (maxvalue) 2712 ), 2713 PARTITION north_america VALUES IN ('US', 'CA') 2714 PARTITION BY RANGE ( 2715 expected_graduation_date 2716 ) ( 2717 PARTITION graduated_us 2718 VALUES FROM (minvalue) 2719 TO ('2017-08-15'), 2720 PARTITION current_us 2721 VALUES FROM ('2017-08-15') 2722 TO (maxvalue) 2723 ) 2724 ) 2725 2726 254: 2727 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 2728 CREATE TABLE students (id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, PRIMARY KEY (country, expected_graduation_date, id)) PARTITION BY LIST (country) ( 2729 PARTITION australia VALUES IN ('AU', 'NZ') 2730 PARTITION BY RANGE ( 2731 expected_graduation_date 2732 ) ( 2733 PARTITION graduated_au VALUES FROM ( 2734 minvalue 2735 ) 2736 TO ( 2737 '2017-08-15' 2738 ), 2739 PARTITION current_au VALUES FROM ( 2740 '2017-08-15' 2741 ) 2742 TO (maxvalue) 2743 ), 2744 PARTITION north_america VALUES IN ('US', 'CA') 2745 PARTITION BY RANGE ( 2746 expected_graduation_date 2747 ) ( 2748 PARTITION graduated_us 2749 VALUES FROM (minvalue) 2750 TO ('2017-08-15'), 2751 PARTITION current_us VALUES FROM ( 2752 '2017-08-15' 2753 ) 2754 TO (maxvalue) 2755 ) 2756 ) 2757 2758 256: 2759 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 2760 CREATE TABLE students (id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, PRIMARY KEY (country, expected_graduation_date, id)) PARTITION BY LIST (country) ( 2761 PARTITION australia VALUES IN ('AU', 'NZ') 2762 PARTITION BY RANGE ( 2763 expected_graduation_date 2764 ) ( 2765 PARTITION graduated_au VALUES FROM ( 2766 minvalue 2767 ) 2768 TO ( 2769 '2017-08-15' 2770 ), 2771 PARTITION current_au VALUES FROM ( 2772 '2017-08-15' 2773 ) 2774 TO (maxvalue) 2775 ), 2776 PARTITION north_america VALUES IN ('US', 'CA') 2777 PARTITION BY RANGE ( 2778 expected_graduation_date 2779 ) ( 2780 PARTITION graduated_us VALUES FROM ( 2781 minvalue 2782 ) 2783 TO ( 2784 '2017-08-15' 2785 ), 2786 PARTITION current_us VALUES FROM ( 2787 '2017-08-15' 2788 ) 2789 TO (maxvalue) 2790 ) 2791 ) 2792 2793 257: 2794 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 2795 CREATE TABLE students (id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, PRIMARY KEY (country, expected_graduation_date, id)) PARTITION BY LIST (country) ( 2796 PARTITION australia VALUES IN ('AU', 'NZ') 2797 PARTITION BY RANGE ( 2798 expected_graduation_date 2799 ) ( 2800 PARTITION graduated_au VALUES FROM ( 2801 minvalue 2802 ) 2803 TO ('2017-08-15'), 2804 PARTITION current_au VALUES FROM ( 2805 '2017-08-15' 2806 ) 2807 TO (maxvalue) 2808 ), 2809 PARTITION north_america VALUES IN ('US', 'CA') 2810 PARTITION BY RANGE ( 2811 expected_graduation_date 2812 ) ( 2813 PARTITION graduated_us VALUES FROM ( 2814 minvalue 2815 ) 2816 TO ( 2817 '2017-08-15' 2818 ), 2819 PARTITION current_us VALUES FROM ( 2820 '2017-08-15' 2821 ) 2822 TO (maxvalue) 2823 ) 2824 ) 2825 2826 259: 2827 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 2828 CREATE TABLE students (id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, PRIMARY KEY (country, expected_graduation_date, id)) PARTITION BY LIST (country) ( 2829 PARTITION australia VALUES IN ('AU', 'NZ') 2830 PARTITION BY RANGE (expected_graduation_date) ( 2831 PARTITION graduated_au 2832 VALUES FROM ( 2833 minvalue 2834 ) 2835 TO ( 2836 '2017-08-15' 2837 ), 2838 PARTITION current_au 2839 VALUES FROM ( 2840 '2017-08-15' 2841 ) 2842 TO ( 2843 maxvalue 2844 ) 2845 ), 2846 PARTITION north_america VALUES IN ('US', 'CA') 2847 PARTITION BY RANGE ( 2848 expected_graduation_date 2849 ) ( 2850 PARTITION graduated_us VALUES FROM ( 2851 minvalue 2852 ) 2853 TO ( 2854 '2017-08-15' 2855 ), 2856 PARTITION current_us VALUES FROM ( 2857 '2017-08-15' 2858 ) 2859 TO (maxvalue) 2860 ) 2861 ) 2862 2863 261: 2864 --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 2865 CREATE TABLE students (id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, PRIMARY KEY (country, expected_graduation_date, id)) PARTITION BY LIST (country) ( 2866 PARTITION australia VALUES IN ('AU', 'NZ') 2867 PARTITION BY RANGE (expected_graduation_date) ( 2868 PARTITION graduated_au 2869 VALUES FROM ( 2870 minvalue 2871 ) 2872 TO ( 2873 '2017-08-15' 2874 ), 2875 PARTITION current_au 2876 VALUES FROM ( 2877 '2017-08-15' 2878 ) 2879 TO ( 2880 maxvalue 2881 ) 2882 ), 2883 PARTITION north_america VALUES IN ('US', 'CA') 2884 PARTITION BY RANGE ( 2885 expected_graduation_date 2886 ) ( 2887 PARTITION graduated_us VALUES FROM ( 2888 minvalue 2889 ) 2890 TO ('2017-08-15'), 2891 PARTITION current_us VALUES FROM ( 2892 '2017-08-15' 2893 ) 2894 TO (maxvalue) 2895 ) 2896 ) 2897 2898 263: 2899 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 2900 CREATE TABLE students (id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, PRIMARY KEY (country, expected_graduation_date, id)) PARTITION BY LIST (country) ( 2901 PARTITION australia VALUES IN ('AU', 'NZ') 2902 PARTITION BY RANGE (expected_graduation_date) ( 2903 PARTITION graduated_au 2904 VALUES FROM ( 2905 minvalue 2906 ) 2907 TO ( 2908 '2017-08-15' 2909 ), 2910 PARTITION current_au 2911 VALUES FROM ( 2912 '2017-08-15' 2913 ) 2914 TO ( 2915 maxvalue 2916 ) 2917 ), 2918 PARTITION north_america VALUES IN ('US', 'CA') 2919 PARTITION BY RANGE (expected_graduation_date) ( 2920 PARTITION graduated_us 2921 VALUES FROM ( 2922 minvalue 2923 ) 2924 TO ( 2925 '2017-08-15' 2926 ), 2927 PARTITION current_us 2928 VALUES FROM ( 2929 '2017-08-15' 2930 ) 2931 TO ( 2932 maxvalue 2933 ) 2934 ) 2935 ) 2936 2937 277: 2938 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 2939 CREATE TABLE students (id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, PRIMARY KEY (country, expected_graduation_date, id)) PARTITION BY LIST (country) ( 2940 PARTITION australia VALUES IN ('AU', 'NZ') 2941 PARTITION BY RANGE (expected_graduation_date) ( 2942 PARTITION graduated_au 2943 VALUES FROM ( 2944 minvalue 2945 ) 2946 TO ( 2947 '2017-08-15' 2948 ), 2949 PARTITION current_au 2950 VALUES FROM ( 2951 '2017-08-15' 2952 ) 2953 TO (maxvalue) 2954 ), 2955 PARTITION north_america VALUES IN ('US', 'CA') 2956 PARTITION BY RANGE (expected_graduation_date) ( 2957 PARTITION graduated_us 2958 VALUES FROM ( 2959 minvalue 2960 ) 2961 TO ( 2962 '2017-08-15' 2963 ), 2964 PARTITION current_us 2965 VALUES FROM ( 2966 '2017-08-15' 2967 ) 2968 TO ( 2969 maxvalue 2970 ) 2971 ) 2972 ) 2973 2974 281: 2975 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 2976 CREATE TABLE students (id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, PRIMARY KEY (country, expected_graduation_date, id)) PARTITION BY LIST (country) ( 2977 PARTITION australia VALUES IN ('AU', 'NZ') 2978 PARTITION BY RANGE (expected_graduation_date) ( 2979 PARTITION graduated_au 2980 VALUES FROM ( 2981 minvalue 2982 ) 2983 TO ( 2984 '2017-08-15' 2985 ), 2986 PARTITION current_au 2987 VALUES FROM ( 2988 '2017-08-15' 2989 ) 2990 TO (maxvalue) 2991 ), 2992 PARTITION north_america VALUES IN ('US', 'CA') 2993 PARTITION BY RANGE (expected_graduation_date) ( 2994 PARTITION graduated_us 2995 VALUES FROM ( 2996 minvalue 2997 ) 2998 TO ( 2999 '2017-08-15' 3000 ), 3001 PARTITION current_us 3002 VALUES FROM ( 3003 '2017-08-15' 3004 ) 3005 TO (maxvalue) 3006 ) 3007 ) 3008 3009 282: 3010 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ 3011 CREATE TABLE students (id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, PRIMARY KEY (country, expected_graduation_date, id)) PARTITION BY LIST (country) ( 3012 PARTITION australia VALUES IN ('AU', 'NZ') 3013 PARTITION BY RANGE (expected_graduation_date) ( 3014 PARTITION graduated_au 3015 VALUES FROM ( 3016 minvalue 3017 ) 3018 TO ('2017-08-15'), 3019 PARTITION current_au 3020 VALUES FROM ( 3021 '2017-08-15' 3022 ) 3023 TO (maxvalue) 3024 ), 3025 PARTITION north_america VALUES IN ('US', 'CA') 3026 PARTITION BY RANGE (expected_graduation_date) ( 3027 PARTITION graduated_us 3028 VALUES FROM ( 3029 minvalue 3030 ) 3031 TO ( 3032 '2017-08-15' 3033 ), 3034 PARTITION current_us 3035 VALUES FROM ( 3036 '2017-08-15' 3037 ) 3038 TO (maxvalue) 3039 ) 3040 ) 3041 3042 286: 3043 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 3044 CREATE TABLE students (id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, PRIMARY KEY (country, expected_graduation_date, id)) PARTITION BY LIST (country) ( 3045 PARTITION australia VALUES IN ('AU', 'NZ') 3046 PARTITION BY RANGE (expected_graduation_date) ( 3047 PARTITION graduated_au 3048 VALUES FROM (minvalue) 3049 TO ('2017-08-15'), 3050 PARTITION current_au 3051 VALUES FROM ( 3052 '2017-08-15' 3053 ) 3054 TO (maxvalue) 3055 ), 3056 PARTITION north_america VALUES IN ('US', 'CA') 3057 PARTITION BY RANGE (expected_graduation_date) ( 3058 PARTITION graduated_us 3059 VALUES FROM ( 3060 minvalue 3061 ) 3062 TO ('2017-08-15'), 3063 PARTITION current_us 3064 VALUES FROM ( 3065 '2017-08-15' 3066 ) 3067 TO (maxvalue) 3068 ) 3069 ) 3070 3071 290: 3072 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 3073 CREATE TABLE students (id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, PRIMARY KEY (country, expected_graduation_date, id)) PARTITION BY LIST (country) ( 3074 PARTITION australia VALUES IN ('AU', 'NZ') 3075 PARTITION BY RANGE (expected_graduation_date) ( 3076 PARTITION graduated_au 3077 VALUES FROM (minvalue) 3078 TO ('2017-08-15'), 3079 PARTITION current_au 3080 VALUES FROM ('2017-08-15') 3081 TO (maxvalue) 3082 ), 3083 PARTITION north_america VALUES IN ('US', 'CA') 3084 PARTITION BY RANGE (expected_graduation_date) ( 3085 PARTITION graduated_us 3086 VALUES FROM (minvalue) 3087 TO ('2017-08-15'), 3088 PARTITION current_us 3089 VALUES FROM ( 3090 '2017-08-15' 3091 ) 3092 TO (maxvalue) 3093 ) 3094 ) 3095 3096 294: 3097 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ 3098 CREATE TABLE students (id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, PRIMARY KEY (country, expected_graduation_date, id)) PARTITION BY LIST (country) ( 3099 PARTITION australia VALUES IN ('AU', 'NZ') 3100 PARTITION BY RANGE (expected_graduation_date) ( 3101 PARTITION graduated_au 3102 VALUES FROM (minvalue) 3103 TO ('2017-08-15'), 3104 PARTITION current_au VALUES FROM ( 3105 '2017-08-15' 3106 ) 3107 TO (maxvalue) 3108 ), 3109 PARTITION north_america VALUES IN ('US', 'CA') 3110 PARTITION BY RANGE (expected_graduation_date) ( 3111 PARTITION graduated_us 3112 VALUES FROM (minvalue) 3113 TO ('2017-08-15'), 3114 PARTITION current_us 3115 VALUES FROM ('2017-08-15') 3116 TO (maxvalue) 3117 ) 3118 ) 3119 3120 296: 3121 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 3122 CREATE TABLE students (id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, PRIMARY KEY (country, expected_graduation_date, id)) PARTITION BY LIST (country) ( 3123 PARTITION australia VALUES IN ('AU', 'NZ') 3124 PARTITION BY RANGE (expected_graduation_date) ( 3125 PARTITION graduated_au VALUES FROM ( 3126 minvalue 3127 ) 3128 TO ( 3129 '2017-08-15' 3130 ), 3131 PARTITION current_au VALUES FROM ( 3132 '2017-08-15' 3133 ) 3134 TO (maxvalue) 3135 ), 3136 PARTITION north_america VALUES IN ('US', 'CA') 3137 PARTITION BY RANGE (expected_graduation_date) ( 3138 PARTITION graduated_us 3139 VALUES FROM (minvalue) 3140 TO ('2017-08-15'), 3141 PARTITION current_us 3142 VALUES FROM ('2017-08-15') 3143 TO (maxvalue) 3144 ) 3145 ) 3146 3147 298: 3148 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 3149 CREATE TABLE students (id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, PRIMARY KEY (country, expected_graduation_date, id)) PARTITION BY LIST (country) ( 3150 PARTITION australia VALUES IN ('AU', 'NZ') 3151 PARTITION BY RANGE (expected_graduation_date) ( 3152 PARTITION graduated_au VALUES FROM ( 3153 minvalue 3154 ) 3155 TO ( 3156 '2017-08-15' 3157 ), 3158 PARTITION current_au VALUES FROM ( 3159 '2017-08-15' 3160 ) 3161 TO (maxvalue) 3162 ), 3163 PARTITION north_america VALUES IN ('US', 'CA') 3164 PARTITION BY RANGE (expected_graduation_date) ( 3165 PARTITION graduated_us 3166 VALUES FROM (minvalue) 3167 TO ('2017-08-15'), 3168 PARTITION current_us VALUES FROM ( 3169 '2017-08-15' 3170 ) 3171 TO (maxvalue) 3172 ) 3173 ) 3174 3175 300: 3176 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ 3177 CREATE TABLE students (id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, PRIMARY KEY (country, expected_graduation_date, id)) PARTITION BY LIST (country) ( 3178 PARTITION australia VALUES IN ('AU', 'NZ') 3179 PARTITION BY RANGE (expected_graduation_date) ( 3180 PARTITION graduated_au VALUES FROM ( 3181 minvalue 3182 ) 3183 TO ( 3184 '2017-08-15' 3185 ), 3186 PARTITION current_au VALUES FROM ( 3187 '2017-08-15' 3188 ) 3189 TO (maxvalue) 3190 ), 3191 PARTITION north_america VALUES IN ('US', 'CA') 3192 PARTITION BY RANGE (expected_graduation_date) ( 3193 PARTITION graduated_us VALUES FROM ( 3194 minvalue 3195 ) 3196 TO ( 3197 '2017-08-15' 3198 ), 3199 PARTITION current_us VALUES FROM ( 3200 '2017-08-15' 3201 ) 3202 TO (maxvalue) 3203 ) 3204 ) 3205 3206 301: 3207 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 3208 CREATE TABLE students (id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, PRIMARY KEY (country, expected_graduation_date, id)) PARTITION BY LIST (country) ( 3209 PARTITION australia VALUES IN ('AU', 'NZ') 3210 PARTITION BY RANGE (expected_graduation_date) ( 3211 PARTITION graduated_au VALUES FROM ( 3212 minvalue 3213 ) 3214 TO ('2017-08-15'), 3215 PARTITION current_au VALUES FROM ( 3216 '2017-08-15' 3217 ) 3218 TO (maxvalue) 3219 ), 3220 PARTITION north_america VALUES IN ('US', 'CA') 3221 PARTITION BY RANGE (expected_graduation_date) ( 3222 PARTITION graduated_us VALUES FROM ( 3223 minvalue 3224 ) 3225 TO ( 3226 '2017-08-15' 3227 ), 3228 PARTITION current_us VALUES FROM ( 3229 '2017-08-15' 3230 ) 3231 TO (maxvalue) 3232 ) 3233 ) 3234 3235 305: 3236 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 3237 CREATE TABLE students (id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, PRIMARY KEY (country, expected_graduation_date, id)) PARTITION BY LIST (country) ( 3238 PARTITION australia VALUES IN ('AU', 'NZ') 3239 PARTITION BY RANGE (expected_graduation_date) ( 3240 PARTITION graduated_au VALUES FROM (minvalue) 3241 TO ('2017-08-15'), 3242 PARTITION current_au VALUES FROM ( 3243 '2017-08-15' 3244 ) 3245 TO (maxvalue) 3246 ), 3247 PARTITION north_america VALUES IN ('US', 'CA') 3248 PARTITION BY RANGE (expected_graduation_date) ( 3249 PARTITION graduated_us VALUES FROM ( 3250 minvalue 3251 ) 3252 TO ('2017-08-15'), 3253 PARTITION current_us VALUES FROM ( 3254 '2017-08-15' 3255 ) 3256 TO (maxvalue) 3257 ) 3258 ) 3259 3260 307: 3261 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 3262 CREATE TABLE students (id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, PRIMARY KEY (country, expected_graduation_date, id)) PARTITION BY LIST (country) ( 3263 PARTITION australia VALUES IN ('AU', 'NZ') 3264 PARTITION BY RANGE (expected_graduation_date) ( 3265 PARTITION graduated_au VALUES FROM (minvalue) 3266 TO ('2017-08-15'), 3267 PARTITION current_au VALUES FROM ('2017-08-15') 3268 TO (maxvalue) 3269 ), 3270 PARTITION north_america VALUES IN ('US', 'CA') 3271 PARTITION BY RANGE (expected_graduation_date) ( 3272 PARTITION graduated_us VALUES FROM ( 3273 minvalue 3274 ) 3275 TO ('2017-08-15'), 3276 PARTITION current_us VALUES FROM ( 3277 '2017-08-15' 3278 ) 3279 TO (maxvalue) 3280 ) 3281 ) 3282 3283 309: 3284 --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 3285 CREATE TABLE students (id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, PRIMARY KEY (country, expected_graduation_date, id)) PARTITION BY LIST (country) ( 3286 PARTITION australia VALUES IN ('AU', 'NZ') 3287 PARTITION BY RANGE (expected_graduation_date) ( 3288 PARTITION graduated_au VALUES FROM (minvalue) 3289 TO ('2017-08-15'), 3290 PARTITION current_au VALUES FROM ('2017-08-15') 3291 TO (maxvalue) 3292 ), 3293 PARTITION north_america VALUES IN ('US', 'CA') 3294 PARTITION BY RANGE (expected_graduation_date) ( 3295 PARTITION graduated_us VALUES FROM (minvalue) 3296 TO ('2017-08-15'), 3297 PARTITION current_us VALUES FROM ( 3298 '2017-08-15' 3299 ) 3300 TO (maxvalue) 3301 ) 3302 ) 3303 3304 311: 3305 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 3306 CREATE TABLE students (id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, PRIMARY KEY (country, expected_graduation_date, id)) PARTITION BY LIST (country) ( 3307 PARTITION australia VALUES IN ('AU', 'NZ') 3308 PARTITION BY RANGE (expected_graduation_date) ( 3309 PARTITION graduated_au VALUES FROM (minvalue) 3310 TO ('2017-08-15'), 3311 PARTITION current_au VALUES FROM ('2017-08-15') 3312 TO (maxvalue) 3313 ), 3314 PARTITION north_america VALUES IN ('US', 'CA') 3315 PARTITION BY RANGE (expected_graduation_date) ( 3316 PARTITION graduated_us VALUES FROM (minvalue) 3317 TO ('2017-08-15'), 3318 PARTITION current_us VALUES FROM ('2017-08-15') 3319 TO (maxvalue) 3320 ) 3321 ) 3322 3323 321: 3324 --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 3325 CREATE TABLE students (id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, PRIMARY KEY (country, expected_graduation_date, id)) PARTITION BY LIST (country) ( 3326 PARTITION australia VALUES IN ('AU', 'NZ') 3327 PARTITION BY RANGE (expected_graduation_date) ( 3328 PARTITION graduated_au VALUES FROM (minvalue) 3329 TO ('2017-08-15'), 3330 PARTITION current_au VALUES FROM ('2017-08-15') TO (maxvalue) 3331 ), 3332 PARTITION north_america VALUES IN ('US', 'CA') 3333 PARTITION BY RANGE (expected_graduation_date) ( 3334 PARTITION graduated_us VALUES FROM (minvalue) 3335 TO ('2017-08-15'), 3336 PARTITION current_us VALUES FROM ('2017-08-15') 3337 TO (maxvalue) 3338 ) 3339 ) 3340 3341 324: 3342 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ 3343 CREATE TABLE students (id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, PRIMARY KEY (country, expected_graduation_date, id)) PARTITION BY LIST (country) ( 3344 PARTITION australia VALUES IN ('AU', 'NZ') 3345 PARTITION BY RANGE (expected_graduation_date) ( 3346 PARTITION graduated_au VALUES FROM (minvalue) TO ('2017-08-15'), 3347 PARTITION current_au VALUES FROM ('2017-08-15') TO (maxvalue) 3348 ), 3349 PARTITION north_america VALUES IN ('US', 'CA') 3350 PARTITION BY RANGE (expected_graduation_date) ( 3351 PARTITION graduated_us VALUES FROM (minvalue) 3352 TO ('2017-08-15'), 3353 PARTITION current_us VALUES FROM ('2017-08-15') 3354 TO (maxvalue) 3355 ) 3356 ) 3357 3358 325: 3359 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 3360 CREATE TABLE students (id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, PRIMARY KEY (country, expected_graduation_date, id)) PARTITION BY LIST (country) ( 3361 PARTITION australia VALUES IN ('AU', 'NZ') 3362 PARTITION BY RANGE (expected_graduation_date) ( 3363 PARTITION graduated_au VALUES FROM (minvalue) TO ('2017-08-15'), 3364 PARTITION current_au VALUES FROM ('2017-08-15') TO (maxvalue) 3365 ), 3366 PARTITION north_america VALUES IN ('US', 'CA') 3367 PARTITION BY RANGE (expected_graduation_date) ( 3368 PARTITION graduated_us VALUES FROM (minvalue) 3369 TO ('2017-08-15'), 3370 PARTITION current_us VALUES FROM ('2017-08-15') TO (maxvalue) 3371 ) 3372 ) 3373 3374 328: 3375 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 3376 CREATE TABLE students (id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, PRIMARY KEY (country, expected_graduation_date, id)) PARTITION BY LIST (country) ( 3377 PARTITION australia VALUES IN ('AU', 'NZ') 3378 PARTITION BY RANGE (expected_graduation_date) ( 3379 PARTITION graduated_au VALUES FROM (minvalue) TO ('2017-08-15'), 3380 PARTITION current_au VALUES FROM ('2017-08-15') TO (maxvalue) 3381 ), 3382 PARTITION north_america VALUES IN ('US', 'CA') 3383 PARTITION BY RANGE (expected_graduation_date) ( 3384 PARTITION graduated_us VALUES FROM (minvalue) TO ('2017-08-15'), 3385 PARTITION current_us VALUES FROM ('2017-08-15') TO (maxvalue) 3386 ) 3387 ) 3388 3389 387: 3390 --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 3391 CREATE TABLE students (id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, PRIMARY KEY (country, expected_graduation_date, id)) PARTITION BY LIST (country) ( 3392 PARTITION australia VALUES IN ('AU', 'NZ') 3393 PARTITION BY RANGE (expected_graduation_date) (PARTITION graduated_au VALUES FROM (minvalue) TO ('2017-08-15'), PARTITION current_au VALUES FROM ('2017-08-15') TO (maxvalue)), 3394 PARTITION north_america VALUES IN ('US', 'CA') 3395 PARTITION BY RANGE (expected_graduation_date) ( 3396 PARTITION graduated_us VALUES FROM (minvalue) TO ('2017-08-15'), 3397 PARTITION current_us VALUES FROM ('2017-08-15') TO (maxvalue) 3398 ) 3399 ) 3400 3401 390: 3402 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ 3403 CREATE TABLE students (id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, PRIMARY KEY (country, expected_graduation_date, id)) PARTITION BY LIST (country) ( 3404 PARTITION australia VALUES IN ('AU', 'NZ') 3405 PARTITION BY RANGE (expected_graduation_date) (PARTITION graduated_au VALUES FROM (minvalue) TO ('2017-08-15'), PARTITION current_au VALUES FROM ('2017-08-15') TO (maxvalue)), 3406 PARTITION north_america VALUES IN ('US', 'CA') 3407 PARTITION BY RANGE (expected_graduation_date) (PARTITION graduated_us VALUES FROM (minvalue) TO ('2017-08-15'), PARTITION current_us VALUES FROM ('2017-08-15') TO (maxvalue)) 3408 ) 3409 3410 410: 3411 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 3412 CREATE TABLE students (id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, PRIMARY KEY (country, expected_graduation_date, id)) PARTITION BY LIST (country) ( 3413 PARTITION australia VALUES IN ('AU', 'NZ') PARTITION BY RANGE (expected_graduation_date) (PARTITION graduated_au VALUES FROM (minvalue) TO ('2017-08-15'), PARTITION current_au VALUES FROM ('2017-08-15') TO (maxvalue)), 3414 PARTITION north_america VALUES IN ('US', 'CA') 3415 PARTITION BY RANGE (expected_graduation_date) (PARTITION graduated_us VALUES FROM (minvalue) TO ('2017-08-15'), PARTITION current_us VALUES FROM ('2017-08-15') TO (maxvalue)) 3416 ) 3417 3418 413: 3419 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 3420 CREATE TABLE students (id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, PRIMARY KEY (country, expected_graduation_date, id)) PARTITION BY LIST (country) ( 3421 PARTITION australia VALUES IN ('AU', 'NZ') PARTITION BY RANGE (expected_graduation_date) (PARTITION graduated_au VALUES FROM (minvalue) TO ('2017-08-15'), PARTITION current_au VALUES FROM ('2017-08-15') TO (maxvalue)), 3422 PARTITION north_america VALUES IN ('US', 'CA') PARTITION BY RANGE (expected_graduation_date) (PARTITION graduated_us VALUES FROM (minvalue) TO ('2017-08-15'), PARTITION current_us VALUES FROM ('2017-08-15') TO (maxvalue)) 3423 ) 3424 3425 632: 3426 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 3427 CREATE TABLE students (id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, PRIMARY KEY (country, expected_graduation_date, id)) PARTITION BY LIST (country) (PARTITION australia VALUES IN ('AU', 'NZ') PARTITION BY RANGE (expected_graduation_date) (PARTITION graduated_au VALUES FROM (minvalue) TO ('2017-08-15'), PARTITION current_au VALUES FROM ('2017-08-15') TO (maxvalue)), PARTITION north_america VALUES IN ('US', 'CA') PARTITION BY RANGE (expected_graduation_date) (PARTITION graduated_us VALUES FROM (minvalue) TO ('2017-08-15'), PARTITION current_us VALUES FROM ('2017-08-15') TO (maxvalue))) 3428 3429