trafodion-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ansha...@apache.org
Subject [2/9] incubator-trafodion git commit: JIRA TRAFODION-2013 Hive null values are now handled correctly.
Date Sat, 28 May 2016 01:12:57 GMT
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>


Mime
View raw message