trafodion-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From dbirds...@apache.org
Subject [3/5] trafodion git commit: Add more examples
Date Thu, 11 Jan 2018 19:06:06 GMT
Add more examples


Project: http://git-wip-us.apache.org/repos/asf/trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/trafodion/commit/f79596e6
Tree: http://git-wip-us.apache.org/repos/asf/trafodion/tree/f79596e6
Diff: http://git-wip-us.apache.org/repos/asf/trafodion/diff/f79596e6

Branch: refs/heads/master
Commit: f79596e6f8e5862f5676f896570776041ff59e5d
Parents: 5e4b476
Author: liu.yu <yu.liu@esgyn.cn>
Authored: Mon Jan 8 15:51:32 2018 +0800
Committer: liu.yu <yu.liu@esgyn.cn>
Committed: Mon Jan 8 15:51:32 2018 +0800

----------------------------------------------------------------------
 .../src/asciidoc/_chapters/sql_utilities.adoc   | 50 ++++++++++++++++++++
 1 file changed, 50 insertions(+)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/trafodion/blob/f79596e6/docs/sql_reference/src/asciidoc/_chapters/sql_utilities.adoc
----------------------------------------------------------------------
diff --git a/docs/sql_reference/src/asciidoc/_chapters/sql_utilities.adoc b/docs/sql_reference/src/asciidoc/_chapters/sql_utilities.adoc
index 55b2712..97a21bb 100644
--- a/docs/sql_reference/src/asciidoc/_chapters/sql_utilities.adoc
+++ b/docs/sql_reference/src/asciidoc/_chapters/sql_utilities.adoc
@@ -825,6 +825,56 @@ drwxr-xr-x   - trafodion trafodion          0 2018-01-03 17:19
 /bulkload/error_log/ERR_TRAFODION.SEABASE.TARGET_TABLE_20180103_091943
 ```
 
+* The examples below illustrate how the LOAD Statement behaves depending on the different
`num`. 
++
+Suppose that we have two same tables (source_table and target_table) as shown in the first
example.
++
+```
+SQL>LOAD WITH STOP AFTER 2 ERROR ROWS INTO target_table SELECT * FROM source_table;
+
+UTIL_OUTPUT
+---------------------------------------------------------------------------------------------
+Task:  LOAD            Status: Started    Object: TRAFODION.SEABASE.TARGET_TABLE        
                                                      
+Task:  CLEANUP         Status: Started    Time: 2018-01-05 10:53:52.20569               
                                       
+Task:  CLEANUP         Status: Ended      Time: 2018-01-05 10:53:52.45689
+Task:  CLEANUP         Status: Ended      Elapsed Time:    00:00:00.025
+Task:  LOADING DATA    Status: Started    Time: 2018-01-05 10:53:52.45757               
                                       
+*** WARNING[8114] The number of error rows is 3 [2018-01-05 10:53:53]
+*** ERROR[8113] The maximum number of error rows is exceeded. [2018-01-05 10:53:53]
+*** WARNING[8114] The number of error rows is 3 [2018-01-05 10:53:53]
+
+SQL>SELECT * FROM target_table;
+--- 0 row(s) selected.
+
+SQL>LOAD WITH STOP AFTER 3 ERROR ROWS INTO target_table SELECT * FROM source_table;
+
+UTIL_OUTPUT
+---------------------------------------------------------------------------------------------
+Task:  LOAD            Status: Started    Object: TRAFODION.SEABASE.TARGET_TABLE        
                                                      
+Task:  CLEANUP         Status: Started    Time: 2018-01-05 15:55:58.975459              
                                       
+Task:  CLEANUP         Status: Ended      Time: 2018-01-05 15:55:59.20219
+Task:  CLEANUP         Status: Ended      Elapsed Time:    00:00:00.045
+Task:  LOADING DATA    Status: Started    Time: 2018-01-05 15:55:59.20322               
                                       
+       Rows Processed: 6 
+       Error Rows:     3 
+Task:  LOADING DATA    Status: Ended      Time: 2018-01-05 15:55:59.960109
+Task:  LOADING DATA    Status: Ended      Elapsed Time:    00:00:00.940
+Task:  COMPLETION      Status: Started    Time: 2018-01-05 15:55:59.960180              
                                       
+       Rows Loaded:    3 
+Task:  COMPLETION      Status: Ended      Time: 2018-01-05 15:56:00.448496
+Task:  COMPLETION      Status: Ended      Elapsed Time:    00:00:00.488
+
+--- SQL operation complete.
+
+SQL>SELECT * FROM target_table;
+A           B   
+----------- ----
+          4 dd  
+          5 ee  
+          6 fff 
+--- 3 row(s) selected.
+```
+
 * For customer demographics data residing in
 `/hive/tpcds/customer_demographics`, create an external Hive table using
 the following Hive SQL:


Mime
View raw message