You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by li...@apache.org on 2018/04/13 12:38:44 UTC
[04/32] trafodion git commit: cherry-pick Load XML Files
cherry-pick Load XML Files
Project: http://git-wip-us.apache.org/repos/asf/trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/trafodion/commit/fb007c00
Tree: http://git-wip-us.apache.org/repos/asf/trafodion/tree/fb007c00
Diff: http://git-wip-us.apache.org/repos/asf/trafodion/diff/fb007c00
Branch: refs/heads/master
Commit: fb007c00469a36b37e58d1821581fdbe38527626
Parents: 08b41ed
Author: liu.yu <yu...@esgyn.cn>
Authored: Sun Aug 13 16:06:25 2017 +0800
Committer: liu.yu <yu...@esgyn.cn>
Committed: Tue Aug 22 11:54:15 2017 +0800
----------------------------------------------------------------------
docs/odb_user/src/asciidoc/_chapters/load.adoc | 38 +++++++++------------
1 file changed, 17 insertions(+), 21 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/trafodion/blob/fb007c00/docs/odb_user/src/asciidoc/_chapters/load.adoc
----------------------------------------------------------------------
diff --git a/docs/odb_user/src/asciidoc/_chapters/load.adoc b/docs/odb_user/src/asciidoc/_chapters/load.adoc
index 6a2eb86..91c0125 100644
--- a/docs/odb_user/src/asciidoc/_chapters/load.adoc
+++ b/docs/odb_user/src/asciidoc/_chapters/load.adoc
@@ -455,7 +455,7 @@ JOB:FIXED:23:10 <- insert into JOB characters starting at position
Load as follows:
```
-$ odb64luo –u user –p xx –d dsn \
+$ odb64luo –u user –p xx –d dsn \
-l src=frends1.dat:tgt=TRAFODION.MFTEST.FRIENDS1:map=ff.map:ns=\?:pc=32
```
@@ -494,16 +494,16 @@ You can use a mapfile like this:
```
~/Devel/odb $ cat person.map
PID:SEQ:100
-FNAME:DSRAND:datasets/first_names.txt
-LNAME:DSRAND:datasets/last_names.txt
+FNAME:DSRAND:datasets/first_names.txt
+LNAME:DSRAND:datasets/last_names.txt
COUNTRY:DSRAND:datasets/countries.txt
-CITY:DSRAND:datasets/cities.txt
+CITY:DSRAND:datasets/cities.txt
BDATE:DRAND:1800:2012
SEX:LSTRAND:M,F,U
-EMAIL:EMRAND:3:12:5:8:com,edu,org,net
-SALARY:NRAND:9:2
-EMPL:DSRAND:datasets/fortune500.txt
-NOTES:TXTRAND:20:80:datasets/lorem_ipsum.txt
+EMAIL:EMRAND:3:12:5:8:com,edu,org,net
+SALARY:NRAND:9:2
+EMPL:DSRAND:datasets/fortune500.txt
+NOTES:TXTRAND:20:80:datasets/lorem_ipsum.txt
LOADTS:CTSTAMP
```
@@ -599,7 +599,7 @@ Then:
* Fifth column (`COMMENT`) is loaded with the fifth column in the input file (`COMMENT:4`)
[[load_binary_files]]
-== Loading Binary Files
+== Load Binary Files
Assuming that your back-end database (and your ODBC Driver) supports BLOB data types, or equivalent,
you can use odb to directly load binary (or any other) files into a database column using the `[:em=char]` symbol
to identify the file to be loaded into that specific database field.
@@ -637,7 +637,6 @@ odb considers the string following the “em” character as the path of the fil
NOTE: odb does not load rows where the size of the input file is greater than the target database column.
-=======
[[load_xml_files]]
== Load XML Files
Trafodion odb supports loading XML files into tables, the key construct for XML files can be an element or an attribute.
@@ -741,7 +740,7 @@ And an input file that contains:
The max length of the second field in this file is:
```
-~/Devel/odb $ awk -F\, 'BEGIN\{max=0} \{if(NF==2)\{len=length($i);if(len>max)max=len}}
+~/Devel/odb $ awk -F\, 'BEGIN\{max=0} \{if(NF==2)\{len=length($i);if(len>max)max=len}}
END\{print max}' tmx.dat
15
```
@@ -841,7 +840,7 @@ The following table describes each extract operator:
[cols="30%,70%",options="header",]
|===
-| Extract option | Meaning
+| Extract option | Meaning
| `src=<CAT.SCH.TAB>\|-file` | Defines the source table(s). You can use: +
+
- a single table name (for example TRAFODION.MFTEST.LINEITEM) +
@@ -1178,7 +1177,7 @@ You can use odb to copy a list of tables from one database to another.
*Example*
```
-~/Devel/odb $ cat tlist.txt
+~/Devel/odb $ cat tlist.txt
# List of tables to extract
src=TRAFODION.MAURIZIO.ORDERS
@@ -1198,7 +1197,7 @@ Please note the `src=-tlist.txt`. This command copies:
[cols="50%,50%",options="header",]
|===
-| Source | Target
+| Source | Target
| `TRAFODION.MAURIZIO.ORDERS` | `tpch.stg_orders`
| `TRAFODION.MAURIZIO.CUSTOMER` | `tpch.stg_customer`
| `TRAFODION.MAURIZIO.PART` | `tpch.stg_part`
@@ -1216,10 +1215,10 @@ Using different _splitby columns_.
```
~/Devel/odb $ cat tlist2.txt
-# List of tables to extract and their “splitby columns”
-src=TRAFODION.MAURIZIO.ORDERS:splitby=O_ORDERKEY
-src=TRAFODION.MAURIZIO.CUSTOMER:splitby=C_CUSTOMERKEY
-src=TRAFODION.MAURIZIO.PART:splitby=P_PARTKEY
+# List of tables to extract and their “splitby columns”
+src=TRAFODION.MAURIZIO.ORDERS:splitby=O_ORDERKEY
+src=TRAFODION.MAURIZIO.CUSTOMER:splitby=C_CUSTOMERKEY
+src=TRAFODION.MAURIZIO.PART:splitby=P_PARTKEY
src=TRAFODION.MAURIZIO.LINEITEM:splitby=L_PARTKEY
```
@@ -1285,6 +1284,3 @@ relational database. For example, you can copy to from HIVE and other databases
from/to Hadoop. odb interacts directly with the HDFS file system using *libhdfs*.
+
This option is currently available only under Linux.
-
-
-