SuJinpei commented on a change in pull request #1850: [TRAFODION-3320] support
multiple characters field and record separator when for data loading and
extracting
URL: https://github.com/apache/trafodion/pull/1850#discussion_r309503987
##########
File path: core/conn/odb/src/odb.c
##########
@@ -14947,26 +15052,42 @@ static void usagexit()
" [:xmltag=[+]element][:xmlord][:xmldump]\n"
#endif
" Defaults/notes:\n"
- " * src file: local file or
{hdfs,mapr}[@host,port[,huser]].<HDFS_PATH>\n"
+ " * src file: local file or
{hdfs,mapr}[@host,port[,huser]].<HDFS_PATH>\n"
" * fs: default ','. Also <ASCII_dec> 0<ASCII_OCT> X<ASCII_HEX>\n"
- " * rs: default '\\n'. Also <ASCII_dec> 0<ASCII_OCT>
X<ASCII_HEX>\n"
- " * ec: default '\\'. Also <ASCII_dec> 0<ASCII_OCT>
X<ASCII_HEX>\n"
- " * pc: no default. Also <ASCII_dec> 0<ASCII_OCT> X<ASCII_HEX>\n"
+ " * mcfs: default use fs as feild seperator. If mcfs was set then
use mcfs as filed\n"
+ " seperator. mcfs means multi characters seperator and
support escape sequence:\n"
+ " \\n: new line\n"
+ " \\r: return\n"
+ " \\t: tab\n"
+ " \\xhh: ascii code in hex, example: \\x41 is 'A'\n"
+ " * rs: default '\\n'. Also <ASCII_dec> 0<ASCII_OCT>
X<ASCII_HEX>\n"
+ " * mcrs: default use rs as record seperator. If mcrs was set
then use mcrs as record\n"
+ " seperator. Please refer to mcfs"
+ " * ec: default '\\'. Also <ASCII_dec> 0<ASCII_OCT>
X<ASCII_HEX>\n"
+ " * pc: no default. Also <ASCII_dec> 0<ASCII_OCT> X<ASCII_HEX>\n"
" * direct: only for Vertica databases\n"
" * bpc: default 1,bpwc: default 4 \n"
" * loadcmd: default IN. only for Trafodion databases\n"
"Data extraction options [connection required]:\n"
" -e {src={table|-file}|sql=<custom
sql>}:tgt=[+]file[:pwhere=where_cond]\n"
- "
[:fs=fieldsep][:rs=recsep][:sq=stringqualifier][:ec=escape_char][:soe]\n"
- "
[:ns=nullstring][:es=emptystring][:rows=#rowset][:nomark][:binary][:bpc=#][:bpwc=#]\n"
- "
[:max=#max_rec][:[r]trim[+]][:cast][:multi][:parallel=number][:gzip[=lev]]\n"
- "
[:splitby=column][:uncommitted][:iobuff=#size][:hblock=#size][:ucs2toutf8]\n"
+ "
[:fs=fieldsep|:mcfs=fieldsep][:rs=recsep|:mcrs=recsep][:sq=stringqualifier]\n"
+ "
[:ec=escape_char][:soe][:ns=nullstring][:es=emptystring][:rows=#rowset][:nomark]\n"
+ "
[:binary][:bpc=#][:bpwc=#][:max=#max_rec][:[r]trim[+]][:cast][:multi][:parallel=number]\n"
+ "
[:gzip[=lev]][:splitby=column][:uncommitted][:iobuff=#size][:hblock=#size][:ucs2toutf8]\n"
"
[:pre={@sqlfile|sqlcmd}[:mpre={@sqlfile|sqlcmd}[:post={@sqlfile|sqlcmd}]\n"
"
[:tpar=#tables][:time][:cols=[-]columns]][:maxlen=#bytes][:xml]\n"
" Defaults/notes:\n"
" * tgt file: local file or
{hdfs,mapr}.[@host,port[,huser]].<HDFS_PATH>\n"
" * fs: default ','. Also <ASCII_dec> 0<ASCII_OCT> X<ASCII_HEX>\n"
- " * rs: default '\\n'. Also <ASCII_dec> 0<ASCII_OCT>
X<ASCII_HEX>\n"
+ " * mcfs: default use fs as feild seperator. If mcfs was set then
use mcfs as filed\n"
Review comment:
thank Dave.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
With regards,
Apache Git Services
