sqoop-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From jar...@apache.org
Subject [2/2] git commit: SQOOP-962: Document null string behavior
Date Fri, 22 Mar 2013 03:55:15 GMT
SQOOP-962: Document null string behavior

(Venkat Ranganathan via Jarek Jarcec Cecho)


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

Branch: refs/heads/trunk
Commit: 7048ca30236b8f6a24c147d27a168c0ef2d150cb
Parents: a0a03d7
Author: Jarek Jarcec Cecho <jarcec@apache.org>
Authored: Thu Mar 21 20:50:26 2013 -0700
Committer: Jarek Jarcec Cecho <jarcec@apache.org>
Committed: Thu Mar 21 20:50:26 2013 -0700

----------------------------------------------------------------------
 src/docs/user/connectors.txt |   56 +++++++++++++++++++++++++++++++++++++
 1 files changed, 56 insertions(+), 0 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/sqoop/blob/7048ca30/src/docs/user/connectors.txt
----------------------------------------------------------------------
diff --git a/src/docs/user/connectors.txt b/src/docs/user/connectors.txt
index c172c4b..cf66112 100644
--- a/src/docs/user/connectors.txt
+++ b/src/docs/user/connectors.txt
@@ -310,3 +310,59 @@ $ sqoop export \
     --export-dir hdfsdir \
     --input-fields-terminated-by "\t"
 ----
+
+Null string handling
+^^^^^^^^^^^^^^^^^^^^
+
+Netezza direct connector supports the null-string features of Sqoop.  The null
+string values are converted to appropriate external table options during export
+and import operations.
+
+.Supported export control arguments:
+[grid="all"]
+`----------------------------------------`---------------------------------------
+Argument                                 Description
+---------------------------------------------------------------------------------
++\--input-null-string <null-string>+     The string to be interpreted as\
+                                         null for string columns.
++\--input-null-non-string <null-string>+ The string to be interpreted as\
+                                         null for non string columns.
+---------------------------------------------------------------------------------
+
+In the case of Netezza direct mode connector, both the arguments must be
+left to the default values or explicitly set to the same value.  Furthermore
+the null string value is restricted to 0-4 utf8 characters.
+
+On export, for non-string columns, if the chosen null value is a valid
+representation in the column domain, then the column might not be loaded as
+null.  For example, if the null string value is specified as "1", then on
+export, any occurrence of "1" in the input file will be loaded as value 1
+instead of NULL for int columns.
+
+It is suggested that the null value be specified as empty string for
+performance and consistency.
+
+.Supported import control arguments:
+[grid="all"]
+`----------------------------------------`---------------------------------------
+Argument                                 Description
+---------------------------------------------------------------------------------
++\--null-string <null-string>+           The string to be interpreted as\
+                                         null for string columns.
++\--null-non-string <null-string>+       The string to be interpreted as\
+                                         null for non string columns.
+---------------------------------------------------------------------------------
+
+In the case of Netezza direct mode connector, both the arguments must be
+left to the default values or explicitly set to the same value.  Furthermore
+the null string value is restricted to 0-4 utf8 characters.
+
+On import, for non-string columns, the chosen null value in current
+implementations the null value representation is ignored for non character
+columns.  For example, if the null string value is specified as "\N", then on
+import, any occurrence of NULL for non-char columns in the table will be
+imported as an empty string instead of '\N', the chosen null string
+representation.
+
+It is suggested that the null value be specified as empty string for
+performance and consistency.


Mime
View raw message