vortex-vwload

1 用法

Usage: vwload [options] database file ...
Options:
-a --attributes attr,...        List of attributes to load (default: all)
-B --rollback on/off            Roll back on failure
-c --cluster                    Cluster mode
-C --charset s                  Input character set (default: no conversion)
-d --dateformat format|attr=format,...
                                Set date format for attribute
-e --escape c                   Escape character to use (default: none)
-E --escapes                    Interpret data escape sequences
-f --fdelim c                   Field delimiter to use (default: "|")
-F --frequency frequency        Frequency of progress reports
-h --help                       Print this help text
-H --header                     Skip header line in file(s)
-i --ignfirst                   Ignore first field
-I --ignlast                    Ignore last field
-l --log path                   Log failed records to a file (cluster mode off)
                                or to multiple files in specified directory (cluster mode on)
-n --nullvalue s                NULL value string to use
-N --strictnulls                use strict NULL value checking
-m --timing                     Show timing info
-p --profile file               write server side profiling data to file
-P --password password          Password to use (default: prompt when needed)
-q --quote c                    Quote character(s) to use (default: none)
-r --rdelim c                   Record delimiter to use (default: "\n")
-R --rowmode                    Use insertmode row for loaded data.
-s --skip n                     Skip the first n records
-S --substitute c               Substitute invalid input characters with c
-t --table table                Table to load to
-T --textmode                   Open files in text mode
-u --user user                  Effective user
+user=authuser[,password]       Authentication user
-v --verbose                    Print verbose progress info
-x --errcount n                 Terminate after n errors in total (cluster mode off)
                                or n errors in any file (cluster mode on)
-z --stats                      Create histograms on all columns


2,字段分割符是,行分隔符是\n ,引用符号",当某个字段里面有“时候,vwload报错,解析出来的字段变少,怎么解析的?

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值