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