github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/sem/tree/testdata/pretty/create_subpartition.ref.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 31: 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 ) 95 PARTITION BY LIST (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 38: 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 ) 166 PARTITION BY LIST (country) 167 ( 168 PARTITION australia 169 VALUES IN ('AU', 'NZ') 170 PARTITION BY RANGE ( 171 expected_graduation_date 172 ) 173 ( 174 PARTITION graduated_au 175 VALUES FROM ( 176 minvalue 177 ) 178 TO ( 179 '2017-08-15' 180 ), 181 PARTITION current_au 182 VALUES FROM ( 183 '2017-08-15' 184 ) 185 TO ( 186 maxvalue 187 ) 188 ), 189 PARTITION north_america 190 VALUES IN ('US', 'CA') 191 PARTITION BY RANGE ( 192 expected_graduation_date 193 ) 194 ( 195 PARTITION graduated_us 196 VALUES FROM ( 197 minvalue 198 ) 199 TO ( 200 '2017-08-15' 201 ), 202 PARTITION current_us 203 VALUES FROM ( 204 '2017-08-15' 205 ) 206 TO ( 207 maxvalue 208 ) 209 ) 210 ) 211 212 41: 213 ----------------------------------------- 214 CREATE TABLE students ( 215 id 216 SERIAL8, 217 name 218 STRING, 219 email 220 STRING, 221 country 222 STRING, 223 expected_graduation_date 224 DATE, 225 PRIMARY KEY ( 226 country, 227 expected_graduation_date, 228 id 229 ) 230 ) 231 PARTITION BY LIST (country) 232 ( 233 PARTITION australia 234 VALUES IN ('AU', 'NZ') 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 (maxvalue) 251 ), 252 PARTITION north_america 253 VALUES IN ('US', 'CA') 254 PARTITION BY RANGE ( 255 expected_graduation_date 256 ) 257 ( 258 PARTITION graduated_us 259 VALUES FROM ( 260 minvalue 261 ) 262 TO ( 263 '2017-08-15' 264 ), 265 PARTITION current_us 266 VALUES FROM ( 267 '2017-08-15' 268 ) 269 TO (maxvalue) 270 ) 271 ) 272 273 46: 274 ---------------------------------------------- 275 CREATE TABLE students ( 276 id 277 SERIAL8, 278 name 279 STRING, 280 email 281 STRING, 282 country 283 STRING, 284 expected_graduation_date 285 DATE, 286 PRIMARY KEY ( 287 country, 288 expected_graduation_date, 289 id 290 ) 291 ) 292 PARTITION BY LIST (country) 293 ( 294 PARTITION australia 295 VALUES IN ('AU', 'NZ') 296 PARTITION BY RANGE ( 297 expected_graduation_date 298 ) 299 ( 300 PARTITION graduated_au 301 VALUES FROM ( 302 minvalue 303 ) 304 TO ('2017-08-15'), 305 PARTITION current_au 306 VALUES FROM ( 307 '2017-08-15' 308 ) 309 TO (maxvalue) 310 ), 311 PARTITION north_america 312 VALUES IN ('US', 'CA') 313 PARTITION BY RANGE ( 314 expected_graduation_date 315 ) 316 ( 317 PARTITION graduated_us 318 VALUES FROM ( 319 minvalue 320 ) 321 TO ('2017-08-15'), 322 PARTITION current_us 323 VALUES FROM ( 324 '2017-08-15' 325 ) 326 TO (maxvalue) 327 ) 328 ) 329 330 50: 331 -------------------------------------------------- 332 CREATE TABLE students ( 333 id 334 SERIAL8, 335 name 336 STRING, 337 email 338 STRING, 339 country 340 STRING, 341 expected_graduation_date 342 DATE, 343 PRIMARY KEY ( 344 country, 345 expected_graduation_date, 346 id 347 ) 348 ) 349 PARTITION BY LIST (country) 350 ( 351 PARTITION australia 352 VALUES IN ('AU', 'NZ') 353 PARTITION BY RANGE ( 354 expected_graduation_date 355 ) 356 ( 357 PARTITION graduated_au 358 VALUES FROM (minvalue) 359 TO ('2017-08-15'), 360 PARTITION current_au 361 VALUES FROM ( 362 '2017-08-15' 363 ) 364 TO (maxvalue) 365 ), 366 PARTITION north_america 367 VALUES IN ('US', 'CA') 368 PARTITION BY RANGE ( 369 expected_graduation_date 370 ) 371 ( 372 PARTITION graduated_us 373 VALUES FROM (minvalue) 374 TO ('2017-08-15'), 375 PARTITION current_us 376 VALUES FROM ( 377 '2017-08-15' 378 ) 379 TO (maxvalue) 380 ) 381 ) 382 383 54: 384 ------------------------------------------------------ 385 CREATE TABLE students ( 386 id 387 SERIAL8, 388 name 389 STRING, 390 email 391 STRING, 392 country 393 STRING, 394 expected_graduation_date 395 DATE, 396 PRIMARY KEY ( 397 country, 398 expected_graduation_date, 399 id 400 ) 401 ) 402 PARTITION BY LIST (country) 403 ( 404 PARTITION australia 405 VALUES IN ('AU', 'NZ') 406 PARTITION BY RANGE ( 407 expected_graduation_date 408 ) 409 ( 410 PARTITION graduated_au 411 VALUES FROM (minvalue) 412 TO ('2017-08-15'), 413 PARTITION current_au 414 VALUES FROM ('2017-08-15') 415 TO (maxvalue) 416 ), 417 PARTITION north_america 418 VALUES IN ('US', 'CA') 419 PARTITION BY RANGE ( 420 expected_graduation_date 421 ) 422 ( 423 PARTITION graduated_us 424 VALUES FROM (minvalue) 425 TO ('2017-08-15'), 426 PARTITION current_us 427 VALUES FROM ('2017-08-15') 428 TO (maxvalue) 429 ) 430 ) 431 432 55: 433 ------------------------------------------------------- 434 CREATE TABLE students ( 435 id 436 SERIAL8, 437 name 438 STRING, 439 email 440 STRING, 441 country 442 STRING, 443 expected_graduation_date 444 DATE, 445 PRIMARY KEY (country, expected_graduation_date, id) 446 ) 447 PARTITION BY LIST (country) 448 ( 449 PARTITION australia 450 VALUES IN ('AU', 'NZ') 451 PARTITION BY RANGE ( 452 expected_graduation_date 453 ) 454 ( 455 PARTITION graduated_au 456 VALUES FROM (minvalue) 457 TO ('2017-08-15'), 458 PARTITION current_au 459 VALUES FROM ('2017-08-15') 460 TO (maxvalue) 461 ), 462 PARTITION north_america 463 VALUES IN ('US', 'CA') 464 PARTITION BY RANGE ( 465 expected_graduation_date 466 ) 467 ( 468 PARTITION graduated_us 469 VALUES FROM (minvalue) 470 TO ('2017-08-15'), 471 PARTITION current_us 472 VALUES FROM ('2017-08-15') 473 TO (maxvalue) 474 ) 475 ) 476 477 61: 478 ------------------------------------------------------------- 479 CREATE TABLE students ( 480 id 481 SERIAL8, 482 name 483 STRING, 484 email 485 STRING, 486 country 487 STRING, 488 expected_graduation_date 489 DATE, 490 PRIMARY KEY (country, expected_graduation_date, id) 491 ) 492 PARTITION BY LIST (country) 493 ( 494 PARTITION australia 495 VALUES IN ('AU', 'NZ') 496 PARTITION BY RANGE (expected_graduation_date) 497 ( 498 PARTITION graduated_au 499 VALUES FROM (minvalue) 500 TO ('2017-08-15'), 501 PARTITION current_au 502 VALUES FROM ('2017-08-15') 503 TO (maxvalue) 504 ), 505 PARTITION north_america 506 VALUES IN ('US', 'CA') 507 PARTITION BY RANGE (expected_graduation_date) 508 ( 509 PARTITION graduated_us 510 VALUES FROM (minvalue) 511 TO ('2017-08-15'), 512 PARTITION current_us 513 VALUES FROM ('2017-08-15') 514 TO (maxvalue) 515 ) 516 ) 517 518 68: 519 -------------------------------------------------------------------- 520 CREATE TABLE students ( 521 id 522 SERIAL8, 523 name 524 STRING, 525 email 526 STRING, 527 country 528 STRING, 529 expected_graduation_date 530 DATE, 531 PRIMARY KEY (country, expected_graduation_date, id) 532 ) 533 PARTITION BY LIST (country) 534 ( 535 PARTITION australia 536 VALUES IN ('AU', 'NZ') 537 PARTITION BY RANGE (expected_graduation_date) 538 ( 539 PARTITION graduated_au 540 VALUES FROM (minvalue) 541 TO ('2017-08-15'), 542 PARTITION current_au 543 VALUES FROM ('2017-08-15') TO (maxvalue) 544 ), 545 PARTITION north_america 546 VALUES IN ('US', 'CA') 547 PARTITION BY RANGE (expected_graduation_date) 548 ( 549 PARTITION graduated_us 550 VALUES FROM (minvalue) 551 TO ('2017-08-15'), 552 PARTITION current_us 553 VALUES FROM ('2017-08-15') TO (maxvalue) 554 ) 555 ) 556 557 69: 558 --------------------------------------------------------------------- 559 CREATE TABLE students ( 560 id 561 SERIAL8, 562 name 563 STRING, 564 email 565 STRING, 566 country 567 STRING, 568 expected_graduation_date 569 DATE, 570 PRIMARY KEY (country, expected_graduation_date, id) 571 ) 572 PARTITION BY LIST (country) 573 ( 574 PARTITION australia 575 VALUES IN ('AU', 'NZ') 576 PARTITION BY RANGE (expected_graduation_date) 577 ( 578 PARTITION graduated_au 579 VALUES FROM (minvalue) TO ('2017-08-15'), 580 PARTITION current_au 581 VALUES FROM ('2017-08-15') TO (maxvalue) 582 ), 583 PARTITION north_america 584 VALUES IN ('US', 'CA') 585 PARTITION BY RANGE (expected_graduation_date) 586 ( 587 PARTITION graduated_us 588 VALUES FROM (minvalue) TO ('2017-08-15'), 589 PARTITION current_us 590 VALUES FROM ('2017-08-15') TO (maxvalue) 591 ) 592 ) 593 594 85: 595 ------------------------------------------------------------------------------------- 596 CREATE TABLE students ( 597 id 598 SERIAL8, 599 name 600 STRING, 601 email 602 STRING, 603 country 604 STRING, 605 expected_graduation_date 606 DATE, 607 PRIMARY KEY (country, expected_graduation_date, id) 608 ) 609 PARTITION BY LIST (country) 610 ( 611 PARTITION australia 612 VALUES IN ('AU', 'NZ') 613 PARTITION BY RANGE (expected_graduation_date) 614 ( 615 PARTITION graduated_au 616 VALUES FROM (minvalue) TO ('2017-08-15'), 617 PARTITION current_au VALUES FROM ('2017-08-15') TO (maxvalue) 618 ), 619 PARTITION north_america 620 VALUES IN ('US', 'CA') 621 PARTITION BY RANGE (expected_graduation_date) 622 ( 623 PARTITION graduated_us 624 VALUES FROM (minvalue) TO ('2017-08-15'), 625 PARTITION current_us VALUES FROM ('2017-08-15') TO (maxvalue) 626 ) 627 ) 628 629 88: 630 ---------------------------------------------------------------------------------------- 631 CREATE TABLE students ( 632 id 633 SERIAL8, 634 name 635 STRING, 636 email 637 STRING, 638 country 639 STRING, 640 expected_graduation_date 641 DATE, 642 PRIMARY KEY (country, expected_graduation_date, id) 643 ) 644 PARTITION BY LIST (country) 645 ( 646 PARTITION australia 647 VALUES IN ('AU', 'NZ') 648 PARTITION BY RANGE (expected_graduation_date) 649 ( 650 PARTITION graduated_au VALUES FROM (minvalue) TO ('2017-08-15'), 651 PARTITION current_au VALUES FROM ('2017-08-15') TO (maxvalue) 652 ), 653 PARTITION north_america 654 VALUES IN ('US', 'CA') 655 PARTITION BY RANGE (expected_graduation_date) 656 ( 657 PARTITION graduated_us VALUES FROM (minvalue) TO ('2017-08-15'), 658 PARTITION current_us VALUES FROM ('2017-08-15') TO (maxvalue) 659 ) 660 ) 661 662 89: 663 ----------------------------------------------------------------------------------------- 664 CREATE TABLE students ( 665 id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, 666 PRIMARY KEY (country, expected_graduation_date, id) 667 ) 668 PARTITION BY LIST (country) 669 ( 670 PARTITION australia 671 VALUES IN ('AU', 'NZ') 672 PARTITION BY RANGE (expected_graduation_date) 673 ( 674 PARTITION graduated_au VALUES FROM (minvalue) TO ('2017-08-15'), 675 PARTITION current_au VALUES FROM ('2017-08-15') TO (maxvalue) 676 ), 677 PARTITION north_america 678 VALUES IN ('US', 'CA') 679 PARTITION BY RANGE (expected_graduation_date) 680 ( 681 PARTITION graduated_us VALUES FROM (minvalue) TO ('2017-08-15'), 682 PARTITION current_us VALUES FROM ('2017-08-15') TO (maxvalue) 683 ) 684 ) 685 686 148: 687 ---------------------------------------------------------------------------------------------------------------------------------------------------- 688 CREATE TABLE students ( 689 id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, 690 PRIMARY KEY (country, expected_graduation_date, id) 691 ) 692 PARTITION BY LIST (country) 693 ( 694 PARTITION australia 695 VALUES IN ('AU', 'NZ') 696 PARTITION BY RANGE (expected_graduation_date) 697 ( 698 PARTITION graduated_au VALUES FROM (minvalue) TO ('2017-08-15'), 699 PARTITION current_au VALUES FROM ('2017-08-15') TO (maxvalue) 700 ), 701 PARTITION north_america 702 VALUES IN ('US', 'CA') 703 PARTITION BY RANGE (expected_graduation_date) 704 (PARTITION graduated_us VALUES FROM (minvalue) TO ('2017-08-15'), PARTITION current_us VALUES FROM ('2017-08-15') TO (maxvalue)) 705 ) 706 707 149: 708 ----------------------------------------------------------------------------------------------------------------------------------------------------- 709 CREATE TABLE students ( 710 id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, 711 PRIMARY KEY (country, expected_graduation_date, id) 712 ) 713 PARTITION BY LIST (country) 714 ( 715 PARTITION australia 716 VALUES IN ('AU', 'NZ') 717 PARTITION BY RANGE (expected_graduation_date) 718 (PARTITION graduated_au VALUES FROM (minvalue) TO ('2017-08-15'), PARTITION current_au VALUES FROM ('2017-08-15') TO (maxvalue)), 719 PARTITION north_america 720 VALUES IN ('US', 'CA') 721 PARTITION BY RANGE (expected_graduation_date) 722 (PARTITION graduated_us VALUES FROM (minvalue) TO ('2017-08-15'), PARTITION current_us VALUES FROM ('2017-08-15') TO (maxvalue)) 723 ) 724 725 161: 726 ----------------------------------------------------------------------------------------------------------------------------------------------------------------- 727 CREATE TABLE students (id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, PRIMARY KEY (country, expected_graduation_date, id)) 728 PARTITION BY LIST (country) 729 ( 730 PARTITION australia 731 VALUES IN ('AU', 'NZ') 732 PARTITION BY RANGE (expected_graduation_date) 733 (PARTITION graduated_au VALUES FROM (minvalue) TO ('2017-08-15'), PARTITION current_au VALUES FROM ('2017-08-15') TO (maxvalue)), 734 PARTITION north_america 735 VALUES IN ('US', 'CA') 736 PARTITION BY RANGE (expected_graduation_date) 737 (PARTITION graduated_us VALUES FROM (minvalue) TO ('2017-08-15'), PARTITION current_us VALUES FROM ('2017-08-15') TO (maxvalue)) 738 ) 739 740 190: 741 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 742 CREATE TABLE students (id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, PRIMARY KEY (country, expected_graduation_date, id)) 743 PARTITION BY LIST (country) 744 ( 745 PARTITION australia 746 VALUES IN ('AU', 'NZ') 747 PARTITION BY RANGE (expected_graduation_date) 748 (PARTITION graduated_au VALUES FROM (minvalue) TO ('2017-08-15'), PARTITION current_au VALUES FROM ('2017-08-15') TO (maxvalue)), 749 PARTITION north_america 750 VALUES IN ('US', 'CA') 751 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)) 752 ) 753 754 191: 755 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 756 CREATE TABLE students (id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, PRIMARY KEY (country, expected_graduation_date, id)) 757 PARTITION BY LIST (country) 758 ( 759 PARTITION australia 760 VALUES IN ('AU', 'NZ') 761 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)), 762 PARTITION north_america 763 VALUES IN ('US', 'CA') 764 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)) 765 ) 766 767 213: 768 --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 769 CREATE TABLE students (id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, PRIMARY KEY (country, expected_graduation_date, id)) 770 PARTITION BY LIST (country) 771 ( 772 PARTITION australia 773 VALUES IN ('AU', 'NZ') 774 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)), 775 PARTITION north_america 776 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)) 777 ) 778 779 214: 780 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 781 CREATE TABLE students (id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, PRIMARY KEY (country, expected_graduation_date, id)) 782 PARTITION BY LIST (country) 783 ( 784 PARTITION australia 785 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)), 786 PARTITION north_america 787 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)) 788 ) 789 790 230: 791 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 792 CREATE TABLE students (id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, PRIMARY KEY (country, expected_graduation_date, id)) 793 PARTITION BY LIST (country) 794 ( 795 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)), 796 PARTITION north_america 797 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)) 798 ) 799 800 233: 801 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 802 CREATE TABLE students (id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, PRIMARY KEY (country, expected_graduation_date, id)) 803 PARTITION BY LIST (country) 804 ( 805 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)), 806 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)) 807 ) 808 809 450: 810 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ 811 CREATE TABLE students (id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, PRIMARY KEY (country, expected_graduation_date, id)) 812 PARTITION BY LIST (country) 813 (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))) 814 815 474: 816 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ 817 CREATE TABLE students (id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, PRIMARY KEY (country, expected_graduation_date, id)) 818 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))) 819 820 632: 821 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 822 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))) 823 824