You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by db...@apache.org on 2016/05/05 23:39:52 UTC
[21/22] incubator-trafodion git commit: Document changes as a result
of usage testing.
Document changes as a result of usage testing.
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/fc644772
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/fc644772
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/fc644772
Branch: refs/heads/master
Commit: fc6447729ef0e7bd02576f6b3b194edbc6f074e7
Parents: 4392a83
Author: Gunnar Tapper <gt...@esgyn.local>
Authored: Wed May 4 22:26:34 2016 -0600
Committer: Gunnar Tapper <gt...@esgyn.local>
Committed: Wed May 4 22:26:34 2016 -0600
----------------------------------------------------------------------
.../src/asciidoc/_chapters/concepts.adoc | 13 ++++----
.../src/asciidoc/_chapters/install.adoc | Bin 13534 -> 13248 bytes
docs/odb_user/src/asciidoc/_chapters/load.adoc | 30 ++++++++++---------
.../src/asciidoc/_chapters/requirements.adoc | 1 +
4 files changed, 24 insertions(+), 20 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/fc644772/docs/odb_user/src/asciidoc/_chapters/concepts.adoc
----------------------------------------------------------------------
diff --git a/docs/odb_user/src/asciidoc/_chapters/concepts.adoc b/docs/odb_user/src/asciidoc/_chapters/concepts.adoc
index 5a79855..9167902 100644
--- a/docs/odb_user/src/asciidoc/_chapters/concepts.adoc
+++ b/docs/odb_user/src/asciidoc/_chapters/concepts.adoc
@@ -201,15 +201,16 @@ You can list available drivers with `-lsdrv`:
```
~/Devel/odb $ ./odb64luo -lsdrv
-Trafodion - Description=Trafodion ODBC Stand Alone Driver +
+Trafodion - Description=Trafodion ODBC Stand Alone Driver
...
```
You can list locally configured data sources with `-lsdsn`:
```
-~/Devel/odb $ ./odb64luo -lsdsn traf - Trafodion
-VMFELICI \u2013 Vertica +
+~/Devel/odb $ ./odb64luo -lsdsn
+traf - Trafodion
+VMFELICI \u2013 Vertica
...
```
@@ -516,7 +517,7 @@ script (`-f`) will be executed, independently from the others, using a different
Running scripts in parallel.
```
-~/Devel/odb $ ./odb64luo -x "select count(*) from types" -f script1.sql
+~/Devel/odb $ ./odb64luo -x "select count(*) from types" -f script1.sql
```
Uses two _independent_ threads executed in parallel. The first thread will run `select count(*) from types` and the other `script1.sql`.
@@ -532,7 +533,7 @@ of `script1.sql` and three instances of `script2.sql` in parallel using `3 + 5 +
Running eleven commands and scripts in parallel
```
-~/Devel/odb $ ./odb64luo -x 3:"select count(*) from types" -f 5:script1.sql \
+~/Devel/odb $ ./odb64luo -x 3:"select count(*) from types" -f 5:script1.sql \
-f 3:script2.sql -q
[1.0.0]--- 1 row(s) selected in 0.000s (prep 0.000s, exec 0.000s, fetch 0.000s/0.000s)
@@ -558,7 +559,7 @@ You can limit the maximum number of threads with `-T` option.
The following command runs the same 11 commands/scripts limiting the number of threads (*and ODBC connections*) to 4:
```
-~/Devel/odb $ ./odb64luo -x 3:"select count(*) from types" -f 5:script1.sql \
+~/Devel/odb $ ./odb64luo -x 3:"select count(*) from types" -f 5:script1.sql \
-f 3:script2.sql -q -T 4
[1.0.0]--- 1 row(s) selected in 0.000s (prep 0.000s, exec 0.000s, fetch 0.000s/0.000s)
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/fc644772/docs/odb_user/src/asciidoc/_chapters/install.adoc
----------------------------------------------------------------------
diff --git a/docs/odb_user/src/asciidoc/_chapters/install.adoc b/docs/odb_user/src/asciidoc/_chapters/install.adoc
index d505a49..f4ce867 100644
Binary files a/docs/odb_user/src/asciidoc/_chapters/install.adoc and b/docs/odb_user/src/asciidoc/_chapters/install.adoc differ
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/fc644772/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 9d2f669..087c0dc 100644
--- a/docs/odb_user/src/asciidoc/_chapters/load.adoc
+++ b/docs/odb_user/src/asciidoc/_chapters/load.adoc
@@ -124,7 +124,7 @@ If you add a `+` sign in front of the file-name, odb *appends* to `<file>`inste
- `end`: Commit when all rows (assigned to a given thread) have been inserted. +
- `#rows`: Commit every `#rows` inserted rows. +
- `x#rs`: Commit every `#rs` rowset (see `rows`)
-| `direct` | Adds `/*+ DIRECT */` hint to the insert statement. To be used with Vertica databases in order to store inserted rows *directly* into
+| `direct` | Adds `/\*+ DIRECT */`* hint to the insert statement. To be used with Vertica databases in order to store inserted rows **directly** into
the Read-Only Storage (ROS). See Vertica\u2019s documentation.
| `fieldtrunc=\{0-4}` | Defines how odb manages fields longer than the destination target column: +
+
@@ -399,14 +399,14 @@ In addition: you need to *_convert date format_* and replace all occurrences of
The following map file accomplishes these goals:
-***
-$ cat test/load_map/ml1.map +
-# Map file to load TRAFODION.MFTEST.FRIENDS from friends.dat +
-ID:seq:1 # Inserts into ID column a sequence starting from 1 +
-NAME:4:REPLACE:Lucia:Lucy # Loads field #4 into NAME and replace all occurrences of Lucia with Lucy +
-AGE:2 # Loads field #2 (they start from zero) into AGE +
+```
+$ cat test/load_map/ml1.map
+# Map file to load TRAFODION.MFTEST.FRIENDS from friends.dat
+ID:seq:1 # Inserts into ID column a sequence starting from 1
+NAME:4:REPLACE:Lucia:Lucy # Loads field #4 into NAME and replace all occurrences of Lucia with Lucy
+AGE:2 # Loads field #2 (they start from zero) into AGE
BDATE:6:DCONV:d.b.y # Loads field #6 into BDATE converting date format from dd mmm yyyy
-***
+```
<<<
Load as follows:
@@ -479,7 +479,7 @@ CREATE TABLE TRAFODION.MAURIZIO."PERSON"
, BDATE DATE NOT NULL
, SEX CHAR(1) NOT NULL
, EMAIL VARCHAR(40) NOT NULL
-, SALARY NUMERIC SIGNED(9,2) NOT NULL
+, SALARY NUMERIC(9,2) NOT NULL
, EMPL VARCHAR(40) NOT NULL
, NOTES VARCHAR(80)
, LOADTS TIMESTAMP(0)
@@ -492,13 +492,14 @@ CREATE TABLE TRAFODION.MAURIZIO."PERSON"
You can use a mapfile like this:
```
-~/Devel/odb $ cat person.map PID:SEQ:100
-
+~/Devel/odb $ cat person.map
+PID:SEQ:100
FNAME:DSRAND:datasets/first_names.txt
LNAME:DSRAND:datasets/last_names.txt
COUNTRY:DSRAND:datasets/countries.txt
CITY:DSRAND:datasets/cities.txt
-BDATE:DRAND:1800:2012 SEX:LSTRAND:M,F,U
+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
@@ -529,8 +530,9 @@ with length between 20 and 80 characters`
You generate and load test data with a command like this:
```
-$ ./ odb64luo -l src=nofile:tgt=traf.maurizio.person:max=1000000:
-map=person.map:rows=5000:parallel=8:loadcmd=U
+$ bin/odb64luo -u user -p password -d traf -l src=nofile:
+tgt=traf.maurizio.person:max=1000000:
+map=person.map:rows=5000:parallel=8:loadcmd=INSERT
```
Please note `src=nofile\u201d (it means _there is no input file_) and `max=1000000` (generate and load one million rows). The above command
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/fc644772/docs/provisioning_guide/src/asciidoc/_chapters/requirements.adoc
----------------------------------------------------------------------
diff --git a/docs/provisioning_guide/src/asciidoc/_chapters/requirements.adoc b/docs/provisioning_guide/src/asciidoc/_chapters/requirements.adoc
index 9e6eed8..949d6fa 100644
--- a/docs/provisioning_guide/src/asciidoc/_chapters/requirements.adoc
+++ b/docs/provisioning_guide/src/asciidoc/_chapters/requirements.adoc
@@ -97,6 +97,7 @@ Please verify these requirements on each node you will install {project-name} on
| FQDN |
• `/etc/hosts` is set up for fully-qualified node names (FQDN). +
• `/etc/resolv.conf` is configured to use a name server. |
+• `hostname --fqdn` shows the fully-qualified node name, if any. +
• `host -T <FQDN>` (responds if using a DNS server, times out otherwise) +
• Simply ssh among nodes using `ssh <FQDN>`.
| Port Availability | The Linux Kernel Firewall (`iptables`) has either been disabled or <<ip-ports,ports required by {project-name}>> have been opened. |