You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by an...@apache.org on 2016/05/28 01:12:57 UTC
[2/9] incubator-trafodion git commit: JIRA TRAFODION-2013 Hive null
values are now handled correctly.
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 ? Javier.Lewis@VFAxlnZEvOx.org 2452508
- 2 AAAAAAAACAAAAAAA 819667 1461 31655 2452318 2452288 Dr. Amy Moses Y 9 4 1966 TOGO ? Amy.Moses@Ovk9KjHH.com 2452318
- 3 AAAAAAAADAAAAAAA 1473522 6247 48572 2449130 2449100 Miss Latisha Hamilton N 18 9 1979 NIUE ? Latisha.Hamilton@V.com 2452313
- 4 AAAAAAAAEAAAAAAA 1703214 3986 39558 2450030 2450000 Dr. Michael White N 7 6 1983 MEXICO ? Michael.White@i.org 2452361
- 5 AAAAAAAAFAAAAAAA 953372 4470 36368 2449438 2449408 Sir Robert Moran N 8 5 1956 FIJI ? Robert.Moran@Hh.edu 2452469
- 6 AAAAAAAAGAAAAAAA 213219 6374 27082 2451883 2451853 Ms. Brunilda Sharp N 4 12 1925 SURINAME ? Brunilda.Sharp@T3pylZEUQjm.org 2452430
- 7 AAAAAAAAHAAAAAAA 68377 3219 44814 2451438 2451408 Ms. Fonda Wiles Y 24 4 1985 GAMBIA ? Fonda.Wiles@S9KnyEtz9hv.org 2452360
- 8 AAAAAAAAIAAAAAAA 1215897 2471 16598 2449406 2449376 Sir Ollie Shipman N 26 12 1938 KOREA, REPUBLIC OF ? Ollie.Shipman@be.org 2452334
- 9 AAAAAAAAJAAAAAAA 1168667 1404 49388 2452275 2452245 Sir Karl Gilbert N 26 10 1966 MONTSERRAT ? Karl.Gilbert@Crg5KyP2IxX9C4d6.edu 2452454
- 10 AAAAAAAAKAAAAAAA 1207553 5143 19580 2451353 2451323 Ms. Albert Brunson N 15 10 1973 JORDAN ? Albert.Brunson@62.com 2452641
- 11 AAAAAAAALAAAAAAA 1114415 6807 47999 2452288 2452258 Ms. Betty Williams N 18 12 1963 BURKINA FASO ? Betty.Williams@xRtDqM1eLBVQNoYAJ.com 2452398
- 12 AAAAAAAAMAAAAAAA 502141 6577 47366 2451039 2451009 Ms. Margaret Farias N 2 6 1956 TURKMENISTAN ? Margaret.Farias@cb.edu 2452634
- 13 AAAAAAAANAAAAAAA 1128748 2777 14006 2449658 2449628 Mrs. Rosalinda Grimes N 1 3 1970 UKRAINE ? Rosalinda.Grimes@tC8pcU7Lt.edu 2452616
- 14 AAAAAAAAOAAAAAAA 929344 892 6440 2450318 2450288 Mr. Jack Wilcox N 30 3 1937 SLOVENIA ? Jack.Wilcox@Y3Etqyv3.org 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 ? Margie.Browning@LM674NrE2.org 2452573
- 17 AAAAAAAABBAAAAAA 707524 3876 2228 2451068 2451038 Dr. Lee Stovall N 23 12 1972 PHILIPPINES ? Lee.Stovall@fqKC83UU0f.org 2452454
- 18 AAAAAAAACBAAAAAA 1361151 6580 18456 2450041 2450011 Sir Brad Lynch Y 1 9 1950 URUGUAY ? Brad.Lynch@nAbai.edu 2452549
- 19 AAAAAAAADBAAAAAA 1161742 4238 45581 2449580 2449550 Dr. Andre Moore N 20 10 1978 NICARAGUA ? Andre.Moore@cTZLGYi1ZJi.org 2452576
- 20 AAAAAAAAEBAAAAAA 1185612 89 38966 2450965 2450935 Mr. Stanton Dallas Y 17 5 1976 SWITZERLAND ? Stanton.Dallas@DBXgl18FGo.edu 2452334
+ 1 AAAAAAAABAAAAAAA 980124 7135 32946 2452238 2452208 Mr. Javier Lewis Y 9 12 1936 CHILE Javier.Lewis@VFAxlnZEvOx.org 2452508
+ 2 AAAAAAAACAAAAAAA 819667 1461 31655 2452318 2452288 Dr. Amy Moses Y 9 4 1966 TOGO Amy.Moses@Ovk9KjHH.com 2452318
+ 3 AAAAAAAADAAAAAAA 1473522 6247 48572 2449130 2449100 Miss Latisha Hamilton N 18 9 1979 NIUE Latisha.Hamilton@V.com 2452313
+ 4 AAAAAAAAEAAAAAAA 1703214 3986 39558 2450030 2450000 Dr. Michael White N 7 6 1983 MEXICO
<TRUNCATED>