http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/1a549e0e/core/sql/regress/hive/EXPECTED018 ---------------------------------------------------------------------- diff --git a/core/sql/regress/hive/EXPECTED018 b/core/sql/regress/hive/EXPECTED018 index 2321774..01f4e0b 100644 --- a/core/sql/regress/hive/EXPECTED018 +++ b/core/sql/regress/hive/EXPECTED018 @@ -6,6 +6,9 @@ >>create table nulls (a char(5), b char(10)); --- SQL operation complete. +>>create table null_format_src (a varchar(5), b varchar(5)); + +--- SQL operation complete. >> >>create table customer_demographics +>( @@ -132,6 +135,13 @@ +> ('aaa5',null),(null,'bbbbb6'); --- 6 row(s) inserted. +>> +>>insert into null_format_src values ++> ('a', 'b'), ('a', null), (null, 'b'), ('a', ''), ('', 'b'), ++> (null, ''), (':', null), ('', ''), (':', ':'), (null, null); + +--- 10 row(s) inserted. +>> >>--load1 >>load with no recovery into customer_address +>select * from hive.hive.customer_address; @@ -140,9 +150,9 @@ Task: CLEANUP Status: Started Object: TRAFODION.HBASE.CUSTOMER_ADDRE Task: CLEANUP Status: Ended Object: TRAFODION.HBASE.CUSTOMER_ADDRESS Task: PREPARATION Status: Started Object: TRAFODION.HBASE.CUSTOMER_ADDRESS Rows Processed: 50000 -Task: PREPARATION Status: Ended ET: 00:00:07.552 +Task: PREPARATION Status: Ended ET: 00:00:09.173 Task: COMPLETION Status: Started Object: TRAFODION.HBASE.CUSTOMER_ADDRESS -Task: COMPLETION Status: Ended ET: 00:00:00.234 +Task: COMPLETION Status: Ended ET: 00:00:00.304 --- 50000 row(s) loaded. >>-- @@ -171,9 +181,9 @@ Task: CLEANUP Status: Started Object: TRAFODION.HBASE.CUSTOMER_DEMOG Task: CLEANUP Status: Ended Object: TRAFODION.HBASE.CUSTOMER_DEMOGRAPHICS Task: PREPARATION Status: Started Object: TRAFODION.HBASE.CUSTOMER_DEMOGRAPHICS Rows Processed: 20000 -Task: PREPARATION Status: Ended ET: 00:00:09.332 +Task: PREPARATION Status: Ended ET: 00:00:11.448 Task: COMPLETION Status: Started Object: TRAFODION.HBASE.CUSTOMER_DEMOGRAPHICS -Task: COMPLETION Status: Ended ET: 00:00:00.204 +Task: COMPLETION Status: Ended ET: 00:00:00.275 --- 20000 row(s) loaded. >>-- @@ -203,9 +213,9 @@ Task: CLEANUP Status: Started Object: TRAFODION.HBASE.CUSTOMER_DEMOG Task: CLEANUP Status: Ended Object: TRAFODION.HBASE.CUSTOMER_DEMOGRAPHICS_SALT Task: PREPARATION Status: Started Object: TRAFODION.HBASE.CUSTOMER_DEMOGRAPHICS_SALT Rows Processed: 20000 -Task: PREPARATION Status: Ended ET: 00:00:06.534 +Task: PREPARATION Status: Ended ET: 00:00:07.319 Task: COMPLETION Status: Started Object: TRAFODION.HBASE.CUSTOMER_DEMOGRAPHICS_SALT -Task: COMPLETION Status: Ended ET: 00:00:00.188 +Task: COMPLETION Status: Ended ET: 00:00:00.198 --- 20000 row(s) loaded. >>-- >> @@ -225,9 +235,9 @@ Task: CLEANUP Status: Started Object: TRAFODION.HBASE.CUSTOMER_SALT Task: CLEANUP Status: Ended Object: TRAFODION.HBASE.CUSTOMER_SALT Task: PREPARATION Status: Started Object: TRAFODION.HBASE.CUSTOMER_SALT Rows Processed: 100000 -Task: PREPARATION Status: Ended ET: 00:00:07.227 +Task: PREPARATION Status: Ended ET: 00:00:08.340 Task: COMPLETION Status: Started Object: TRAFODION.HBASE.CUSTOMER_SALT -Task: COMPLETION Status: Ended ET: 00:00:00.159 +Task: COMPLETION Status: Ended ET: 00:00:00.212 --- 100000 row(s) loaded. >>-- @@ -256,9 +266,9 @@ Task: CLEANUP Status: Started Object: TRAFODION.HBASE.STORE_SALES_SA Task: CLEANUP Status: Ended Object: TRAFODION.HBASE.STORE_SALES_SALT Task: PREPARATION Status: Started Object: TRAFODION.HBASE.STORE_SALES_SALT Rows Processed: 160756 -Task: PREPARATION Status: Ended ET: 00:00:08.924 +Task: PREPARATION Status: Ended ET: 00:00:10.675 Task: COMPLETION Status: Started Object: TRAFODION.HBASE.STORE_SALES_SALT -Task: COMPLETION Status: Ended ET: 00:00:00.166 +Task: COMPLETION Status: Ended ET: 00:00:00.256 --- 160756 row(s) loaded. >>-- @@ -271,58 +281,170 @@ Task: COMPLETION Status: Ended ET: 00:00:00.166 160756 --- 1 row(s) selected. ->>------------------------------- ->>--hive insert 0 ->>insert overwrite table hive.hive.nulls select * from nulls; +>> +>>------------------------------------------ +>>-- handling of various null formats +>> +>>-- using insert +>>insert overwrite table hive.hive.null_format_default select * from null_format_src; ---- 6 row(s) inserted. ->>select * from hive.hive.nulls order by a,b; +--- 10 row(s) inserted. +>>select * from hive.hive.null_format_default; A B ------------------------------------------------------------ ------------------------------------------------------------ -aaa1 bbbbb1 -aaa3 ? -aaa5 ? -? bbbbb2 -? bbbbb6 +a b +a ? +? b +a + b +? +: ? + +: : ? ? ---- 6 row(s) selected. +--- 10 row(s) selected. >> ->>---index 0 ->>create index customer_idx1 on customer_salt(c_first_name, c_last_name); +>>insert overwrite table hive.hive.null_format_empty select * from null_format_src; ---- SQL operation complete. +--- 10 row(s) inserted. +>>select * from hive.hive.null_format_empty; + +A B +------------------------------------------------------------ ------------------------------------------------------------ + +a b +a ? +? b +a ? +? b +? ? +: ? +? ? +: : +? ? + +--- 10 row(s) selected. >> +>>insert overwrite table hive.hive.null_format_colon select * from null_format_src; + +--- 10 row(s) inserted. +>>select * from hive.hive.null_format_colon; + +A B +------------------------------------------------------------ ------------------------------------------------------------ + +a b +a ? +? b +a + b +? +? ? + +? ? +? ? + +--- 10 row(s) selected. >> ->>sh regrhbase.ksh $REGRTSTDIR/TEST018_create_hbase_objects.hbase &> $REGRRUNDIR/LOG018_create_hbase_tables.log ; >> ->>---unload 0 -- nulls +>>-- using unload >>unload with purgedata from target -+> into '/user/hive/exttables/nulls' -+> select * from nulls; ++> into '/user/hive/exttables/null_format_default' ++> select * from null_format_src; Task: UNLOAD Status: Started Task: EMPTY TARGET Status: Started -Task: EMPTY TARGET Status: Ended ET: 00:00:00.010 +Task: EMPTY TARGET Status: Ended ET: 00:00:00.006 +Task: EXTRACT Status: Started + Rows Processed: 10 +Task: EXTRACT Status: Ended ET: 00:00:00.238 + +--- 10 row(s) unloaded. +>>select * from hive.hive.null_format_default; + +A B +------------------------------------------------------------ ------------------------------------------------------------ + +a b +a ? +? b +a + b +? +: ? + +: : +? ? + +--- 10 row(s) selected. +>> +>>unload with purgedata from target ++> into '/user/hive/exttables/null_format_empty' ++> select * from null_format_src; +Task: UNLOAD Status: Started +Task: EMPTY TARGET Status: Started +Task: EMPTY TARGET Status: Ended ET: 00:00:00.006 +Task: EXTRACT Status: Started + Rows Processed: 10 +Task: EXTRACT Status: Ended ET: 00:00:00.246 + +--- 10 row(s) unloaded. +>>select * from hive.hive.null_format_empty; + +A B +------------------------------------------------------------ ------------------------------------------------------------ + +a b +a ? +? b +a ? +? b +? ? +: ? +? ? +: : +? ? + +--- 10 row(s) selected. +>> +>>unload with purgedata from target ++> into '/user/hive/exttables/null_format_colon' ++> select * from null_format_src; +Task: UNLOAD Status: Started +Task: EMPTY TARGET Status: Started +Task: EMPTY TARGET Status: Ended ET: 00:00:00.009 Task: EXTRACT Status: Started - Rows Processed: 6 -Task: EXTRACT Status: Ended ET: 00:00:00.223 + Rows Processed: 10 +Task: EXTRACT Status: Ended ET: 00:00:00.222 ---- 6 row(s) unloaded. ->>select * from hive.hive.nulls order by a,b; +--- 10 row(s) unloaded. +>>select * from hive.hive.null_format_colon; A B ------------------------------------------------------------ ------------------------------------------------------------ -aaa1 bbbbb1 -aaa3 ? -aaa5 ? -? bbbbb2 -? bbbbb6 +a b +a ? +? b +a + b +? +? ? + ? ? +? ? + +--- 10 row(s) selected. +>> +>>---index 0 +>>create index customer_idx1 on customer_salt(c_first_name, c_last_name); ---- 6 row(s) selected. +--- SQL operation complete. +>> +>>sh regrhbase.ksh $REGRTSTDIR/TEST018_create_hbase_objects.hbase &> $REGRRUNDIR/LOG018_create_hbase_tables.log ; +>> >> >>--exp1 >>explain options 'f' @@ -349,12 +471,12 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD +>; Task: UNLOAD Status: Started Task: EMPTY TARGET Status: Started -Task: EMPTY TARGET Status: Ended ET: 00:00:00.004 +Task: EMPTY TARGET Status: Ended ET: 00:00:00.011 Task: EXTRACT Status: Started Rows Processed: 50000 -Task: EXTRACT Status: Ended ET: 00:00:02.445 +Task: EXTRACT Status: Ended ET: 00:00:02.786 Task: MERGE FILES Status: Started -Task: MERGE FILES Status: Ended ET: 00:00:00.034 +Task: MERGE FILES Status: Ended ET: 00:00:00.036 --- 50000 row(s) unloaded. >>log; @@ -387,10 +509,10 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD +><<+ cardinality 10e10 >>; Task: UNLOAD Status: Started Task: EMPTY TARGET Status: Started -Task: EMPTY TARGET Status: Ended ET: 00:00:00.006 +Task: EMPTY TARGET Status: Ended ET: 00:00:00.010 Task: EXTRACT Status: Started Rows Processed: 20000 -Task: EXTRACT Status: Ended ET: 00:00:00.773 +Task: EXTRACT Status: Ended ET: 00:00:00.868 Task: MERGE FILES Status: Started Task: MERGE FILES Status: Ended ET: 00:00:00.031 @@ -414,9 +536,9 @@ Task: EMPTY TARGET Status: Started Task: EMPTY TARGET Status: Ended ET: 00:00:00.008 Task: EXTRACT Status: Started Rows Processed: 20000 -Task: EXTRACT Status: Ended ET: 00:00:00.769 +Task: EXTRACT Status: Ended ET: 00:00:00.837 Task: MERGE FILES Status: Started -Task: MERGE FILES Status: Ended ET: 00:00:00.026 +Task: MERGE FILES Status: Ended ET: 00:00:00.029 --- 20000 row(s) unloaded. >>log; @@ -451,9 +573,9 @@ Task: EMPTY TARGET Status: Started Task: EMPTY TARGET Status: Ended ET: 00:00:00.007 Task: EXTRACT Status: Started Rows Processed: 20000 -Task: EXTRACT Status: Ended ET: 00:00:00.736 +Task: EXTRACT Status: Ended ET: 00:00:01.024 Task: MERGE FILES Status: Started -Task: MERGE FILES Status: Ended ET: 00:00:00.039 +Task: MERGE FILES Status: Ended ET: 00:00:00.041 --- 20000 row(s) unloaded. >> @@ -474,9 +596,9 @@ Task: EMPTY TARGET Status: Started Task: EMPTY TARGET Status: Ended ET: 00:00:00.005 Task: EXTRACT Status: Started Rows Processed: 20000 -Task: EXTRACT Status: Ended ET: 00:00:00.552 +Task: EXTRACT Status: Ended ET: 00:00:00.722 Task: MERGE FILES Status: Started -Task: MERGE FILES Status: Ended ET: 00:00:00.032 +Task: MERGE FILES Status: Ended ET: 00:00:00.048 --- 20000 row(s) unloaded. >> @@ -509,10 +631,10 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD +><<+ cardinality 10e10 >>; Task: UNLOAD Status: Started Task: EMPTY TARGET Status: Started -Task: EMPTY TARGET Status: Ended ET: 00:00:00.005 +Task: EMPTY TARGET Status: Ended ET: 00:00:00.013 Task: EXTRACT Status: Started Rows Processed: 20000 -Task: EXTRACT Status: Ended ET: 00:00:00.480 +Task: EXTRACT Status: Ended ET: 00:00:00.591 --- 20000 row(s) unloaded. >> @@ -532,12 +654,12 @@ regrhadoop.ksh fs -ls /bulkload/customer_demographics_salt/file* | grep file | +><<+ cardinality 10e10 >>; Task: UNLOAD Status: Started Task: EMPTY TARGET Status: Started -Task: EMPTY TARGET Status: Ended ET: 00:00:00.008 +Task: EMPTY TARGET Status: Ended ET: 00:00:00.012 Task: EXTRACT Status: Started Rows Processed: 20000 -Task: EXTRACT Status: Ended ET: 00:00:00.560 +Task: EXTRACT Status: Ended ET: 00:00:00.672 Task: MERGE FILES Status: Started -Task: MERGE FILES Status: Ended ET: 00:00:00.034 +Task: MERGE FILES Status: Ended ET: 00:00:00.040 --- 20000 row(s) unloaded. >> @@ -670,12 +792,12 @@ CD_DEMO_SK CD_GENDER +><<+ cardinality 10e10 >>; Task: UNLOAD Status: Started Task: EMPTY TARGET Status: Started -Task: EMPTY TARGET Status: Ended ET: 00:00:00.006 +Task: EMPTY TARGET Status: Ended ET: 00:00:00.005 Task: EXTRACT Status: Started Rows Processed: 20000 -Task: EXTRACT Status: Ended ET: 00:00:00.541 +Task: EXTRACT Status: Ended ET: 00:00:00.616 Task: MERGE FILES Status: Started -Task: MERGE FILES Status: Ended ET: 00:00:00.035 +Task: MERGE FILES Status: Ended ET: 00:00:00.055 --- 20000 row(s) unloaded. >>log; @@ -713,9 +835,9 @@ Task: EMPTY TARGET Status: Started Task: EMPTY TARGET Status: Ended ET: 00:00:00.005 Task: EXTRACT Status: Started Rows Processed: 20000 -Task: EXTRACT Status: Ended ET: 00:00:00.447 +Task: EXTRACT Status: Ended ET: 00:00:00.562 Task: MERGE FILES Status: Started -Task: MERGE FILES Status: Ended ET: 00:00:00.035 +Task: MERGE FILES Status: Ended ET: 00:00:00.046 --- 20000 row(s) unloaded. >> @@ -768,7 +890,7 @@ Task: EMPTY TARGET Status: Started Task: EMPTY TARGET Status: Ended ET: 00:00:00.005 Task: EXTRACT Status: Started Rows Processed: 20000 -Task: EXTRACT Status: Ended ET: 00:00:00.434 +Task: EXTRACT Status: Ended ET: 00:00:00.480 --- 20000 row(s) unloaded. >> @@ -818,7 +940,7 @@ Task: EMPTY TARGET Status: Started Task: EMPTY TARGET Status: Ended ET: 00:00:00.005 Task: EXTRACT Status: Started Rows Processed: 50000 -Task: EXTRACT Status: Ended ET: 00:00:01.808 +Task: EXTRACT Status: Ended ET: 00:00:01.946 --- 50000 row(s) unloaded. >> @@ -843,14 +965,14 @@ CA_ADDRESS_SK CA_ADDRESS_ID 4 AAAAAAAAEAAAAAAA 111 Smith Wy Suite A Oak Ridge Kit Carson County CO 88371 United States -7.0000000E+000 condo 5 AAAAAAAAFAAAAAAA 31 College Blvd Suite 180 Glendale Barry County MO 63951 United States -6.0000000E+000 single family 6 AAAAAAAAGAAAAAAA 59 Williams Sixth Parkway Suite 100 Lakeview Chelan County WA 98579 United States -8.0000000E+000 single family - 7 AAAAAAAAHAAAAAAA ? Hill 7th Road Suite U Farmington ? ? 39145 United States ? ? + 7 AAAAAAAAHAAAAAAA Hill 7th Road Suite U Farmington 39145 United States ? 8 AAAAAAAAIAAAAAAA 875 Lincoln Ct. Suite Y Union Bledsoe County TN 38721 United States -5.0000000E+000 apartment 9 AAAAAAAAJAAAAAAA 819 1st Laurel Ave Suite 70 New Hope Perry County AL 39431 United States -6.0000000E+000 condo 10 AAAAAAAAKAAAAAAA 851 Woodland Poplar ST Suite Y Martinsville Haines Borough AK 90419 United States -9.0000000E+000 condo 11 AAAAAAAALAAAAAAA 189 13th 2nd Street Suite 470 Maple Grove Madison County MT 68252 United States -7.0000000E+000 single family 12 AAAAAAAAMAAAAAAA 76 Ash 8th Ct. Suite O Edgewood Mifflin County PA 10069 United States -5.0000000E+000 apartment 13 AAAAAAAANAAAAAAA 424 Main Second Ln Suite 130 Greenville Noxubee County MS 51387 United States -6.0000000E+000 single family - 14 AAAAAAAAOAAAAAAA 923 Pine Oak Dr. Suite 100 ? Lipscomb County TX 77752 ? -6.0000000E+000 ? + 14 AAAAAAAAOAAAAAAA 923 Pine Oak Dr. Suite 100 Lipscomb County TX 77752 -6.0000000E+000 15 AAAAAAAAPAAAAAAA 314 Spring Ct. Suite B Oakland Washington County OH 49843 United States -5.0000000E+000 apartment 16 AAAAAAAAABAAAAAA 576 Adams Center Street Suite J Valley View Oldham County TX 75124 United States -6.0000000E+000 condo 17 AAAAAAAABBAAAAAA 801 Green Dr. Suite 0 Montpelier Richland County OH 48930 United States -5.0000000E+000 single family @@ -868,10 +990,10 @@ CA_ADDRESS_SK CA_ADDRESS_ID +>select * from trafodion.hbase.customer_address ; Task: UNLOAD Status: Started Task: EMPTY TARGET Status: Started -Task: EMPTY TARGET Status: Ended ET: 00:00:00.005 +Task: EMPTY TARGET Status: Ended ET: 00:00:00.006 Task: EXTRACT Status: Started Rows Processed: 50000 -Task: EXTRACT Status: Ended ET: 00:00:01.800 +Task: EXTRACT Status: Ended ET: 00:00:01.891 --- 50000 row(s) unloaded. >> @@ -896,14 +1018,14 @@ CA_ADDRESS_SK CA_ADDRESS_ID 4 AAAAAAAAEAAAAAAA 111 Smith Wy Suite A Oak Ridge Kit Carson County CO 88371 United States -7.0000000E+000 condo 5 AAAAAAAAFAAAAAAA 31 College Blvd Suite 180 Glendale Barry County MO 63951 United States -6.0000000E+000 single family 6 AAAAAAAAGAAAAAAA 59 Williams Sixth Parkway Suite 100 Lakeview Chelan County WA 98579 United States -8.0000000E+000 single family - 7 AAAAAAAAHAAAAAAA ? Hill 7th Road Suite U Farmington ? ? 39145 United States ? ? + 7 AAAAAAAAHAAAAAAA Hill 7th Road Suite U Farmington 39145 United States ? 8 AAAAAAAAIAAAAAAA 875 Lincoln Ct. Suite Y Union Bledsoe County TN 38721 United States -5.0000000E+000 apartment 9 AAAAAAAAJAAAAAAA 819 1st Laurel Ave Suite 70 New Hope Perry County AL 39431 United States -6.0000000E+000 condo 10 AAAAAAAAKAAAAAAA 851 Woodland Poplar ST Suite Y Martinsville Haines Borough AK 90419 United States -9.0000000E+000 condo 11 AAAAAAAALAAAAAAA 189 13th 2nd Street Suite 470 Maple Grove Madison County MT 68252 United States -7.0000000E+000 single family 12 AAAAAAAAMAAAAAAA 76 Ash 8th Ct. Suite O Edgewood Mifflin County PA 10069 United States -5.0000000E+000 apartment 13 AAAAAAAANAAAAAAA 424 Main Second Ln Suite 130 Greenville Noxubee County MS 51387 United States -6.0000000E+000 single family - 14 AAAAAAAAOAAAAAAA 923 Pine Oak Dr. Suite 100 ? Lipscomb County TX 77752 ? -6.0000000E+000 ? + 14 AAAAAAAAOAAAAAAA 923 Pine Oak Dr. Suite 100 Lipscomb County TX 77752 -6.0000000E+000 15 AAAAAAAAPAAAAAAA 314 Spring Ct. Suite B Oakland Washington County OH 49843 United States -5.0000000E+000 apartment 16 AAAAAAAAABAAAAAA 576 Adams Center Street Suite J Valley View Oldham County TX 75124 United States -6.0000000E+000 condo 17 AAAAAAAABBAAAAAA 801 Green Dr. Suite 0 Montpelier Richland County OH 48930 United States -5.0000000E+000 single family @@ -930,10 +1052,10 @@ CA_ADDRESS_SK CA_ADDRESS_ID +>select * from trafodion.hbase.customer_salt; Task: UNLOAD Status: Started Task: EMPTY TARGET Status: Started -Task: EMPTY TARGET Status: Ended ET: 00:00:00.005 +Task: EMPTY TARGET Status: Ended ET: 00:00:00.006 Task: EXTRACT Status: Started Rows Processed: 100000 -Task: EXTRACT Status: Ended ET: 00:00:05.750 +Task: EXTRACT Status: Ended ET: 00:00:06.124 --- 100000 row(s) unloaded. >>select count(*) from hive.hive.unload_customer; @@ -951,26 +1073,26 @@ Task: EXTRACT Status: Ended ET: 00:00:05.750 C_CUSTOMER_SK C_CUSTOMER_ID C_CURRENT_CDEMO_SK C_CURRENT_HDEMO_SK C_CURRENT_ADDR_SK C_FIRST_SHIPTO_DATE_SK C_FIRST_SALES_DATE_SK C_SALUTATION C_FIRST_NAME C_LAST_NAME C_PREFERRED_CUST_FLAG C_BIRTH_DAY C_BIRTH_MONTH C_BIRTH_YEAR C_BIRTH_COUNTRY C_LOGIN C_EMAIL_ADDRESS C_LAST_REVIEW_DATE ------------- ---------------------------------------------------------------------------------------------------- ------------------ ------------------ ----------------- ---------------------- --------------------- ---------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------- ----------- ------------- ------------ ---------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------- ------------------ ---------------------------------------------------------------------------------- - 1 AAAAAAAABAAAAAAA 980124 7135 32946 2452238 2452208 Mr. Javier Lewis Y 9 12 1936 CHILE ? [email protected] 2452508 - 2 AAAAAAAACAAAAAAA 819667 1461 31655 2452318 2452288 Dr. Amy Moses Y 9 4 1966 TOGO ? [email protected] 2452318 - 3 AAAAAAAADAAAAAAA 1473522 6247 48572 2449130 2449100 Miss Latisha Hamilton N 18 9 1979 NIUE ? [email protected] 2452313 - 4 AAAAAAAAEAAAAAAA 1703214 3986 39558 2450030 2450000 Dr. Michael White N 7 6 1983 MEXICO ? [email protected] 2452361 - 5 AAAAAAAAFAAAAAAA 953372 4470 36368 2449438 2449408 Sir Robert Moran N 8 5 1956 FIJI ? [email protected] 2452469 - 6 AAAAAAAAGAAAAAAA 213219 6374 27082 2451883 2451853 Ms. Brunilda Sharp N 4 12 1925 SURINAME ? [email protected] 2452430 - 7 AAAAAAAAHAAAAAAA 68377 3219 44814 2451438 2451408 Ms. Fonda Wiles Y 24 4 1985 GAMBIA ? [email protected] 2452360 - 8 AAAAAAAAIAAAAAAA 1215897 2471 16598 2449406 2449376 Sir Ollie Shipman N 26 12 1938 KOREA, REPUBLIC OF ? [email protected] 2452334 - 9 AAAAAAAAJAAAAAAA 1168667 1404 49388 2452275 2452245 Sir Karl Gilbert N 26 10 1966 MONTSERRAT ? [email protected] 2452454 - 10 AAAAAAAAKAAAAAAA 1207553 5143 19580 2451353 2451323 Ms. Albert Brunson N 15 10 1973 JORDAN ? [email protected] 2452641 - 11 AAAAAAAALAAAAAAA 1114415 6807 47999 2452288 2452258 Ms. Betty Williams N 18 12 1963 BURKINA FASO ? [email protected] 2452398 - 12 AAAAAAAAMAAAAAAA 502141 6577 47366 2451039 2451009 Ms. Margaret Farias N 2 6 1956 TURKMENISTAN ? [email protected] 2452634 - 13 AAAAAAAANAAAAAAA 1128748 2777 14006 2449658 2449628 Mrs. Rosalinda Grimes N 1 3 1970 UKRAINE ? [email protected] 2452616 - 14 AAAAAAAAOAAAAAAA 929344 892 6440 2450318 2450288 Mr. Jack Wilcox N 30 3 1937 SLOVENIA ? [email protected] 2452641 - 15 AAAAAAAAPAAAAAAA ? 134 30469 ? 2449010 Ms. Tonya ? ? ? 12 1969 ? ? ? 2452376 - 16 AAAAAAAAABAAAAAA 1196373 3014 29302 2451346 2451316 Dr. Margie Browning N 24 12 1933 PHILIPPINES ? [email protected] 2452573 - 17 AAAAAAAABBAAAAAA 707524 3876 2228 2451068 2451038 Dr. Lee Stovall N 23 12 1972 PHILIPPINES ? [email protected] 2452454 - 18 AAAAAAAACBAAAAAA 1361151 6580 18456 2450041 2450011 Sir Brad Lynch Y 1 9 1950 URUGUAY ? [email protected] 2452549 - 19 AAAAAAAADBAAAAAA 1161742 4238 45581 2449580 2449550 Dr. Andre Moore N 20 10 1978 NICARAGUA ? [email protected] 2452576 - 20 AAAAAAAAEBAAAAAA 1185612 89 38966 2450965 2450935 Mr. Stanton Dallas Y 17 5 1976 SWITZERLAND ? [email protected] 2452334 + 1 AAAAAAAABAAAAAAA 980124 7135 32946 2452238 2452208 Mr. Javier Lewis Y 9 12 1936 CHILE [email protected] 2452508 + 2 AAAAAAAACAAAAAAA 819667 1461 31655 2452318 2452288 Dr. Amy Moses Y 9 4 1966 TOGO [email protected] 2452318 + 3 AAAAAAAADAAAAAAA 1473522 6247 48572 2449130 2449100 Miss Latisha Hamilton N 18 9 1979 NIUE [email protected] 2452313 + 4 AAAAAAAAEAAAAAAA 1703214 3986 39558 2450030 2450000 Dr. Michael White N 7 6 1983 MEXICO
<TRUNCATED>
