Vertica 导出数据测试用例

 ``` [dbadmin@vertica1 ~]$ vsql --help This is vsql, the Vertica Analytic Database interactive terminal. 
Usage:
 vsql [OPTIONS]... [DBNAME [USERNAME]]
General options:
 -d DBNAME       specify database name to connect to (default: "dbadmin")
 -c COMMAND      run only single command (SQL or internal) and exit
 -f FILENAME     execute commands from file, then exit
 -l              list available databases, then exit
 -v NAME=VALUE   set vsql variable NAME to VALUE
 -X              do not read startup file (~/.vsqlrc)
 --help          show this help, then exit
 --version       output version information, then exit
Input and output options:
 -a              echo all input from script
 -e              echo commands sent to server
 -E              display queries that internal commands generate
 -q              run quietly (no messages, only query output)
 -o FILENAME     send query results to file (or |pipe)
 -n              disable enhanced command line editing (readline)
 -s              single-step mode (confirm each query)
 -S              single-line mode (end of line terminates SQL command)
Output format options:
 -A              unaligned table output mode (-P format=unaligned)
 -b              beep on command completion
 -H              HTML table output mode (-P format=html)
 -t              print rows only (-P tuples_only)
 -T TEXT         set HTML table tag attributes (width, border) (-P tableattr=)
 -x              turn on expanded table output (-P expanded)
 -P VAR[=ARG]    set printing option VAR to ARG (see \pset command)
 -F STRING       set field separator for unaligned output (default: "|") (-P fieldsep=)
 -R STRING       set record separator (default: newline) (-P recordsep=)
Connection options:
 -B SERVER:PORT  set connection backup server/port (default: not set)
 -C              enable connection load balancing (default: not enabled)
 -h HOSTNAME     database server host or socket directory (default: "local socket")
 -p PORT         database server port (default: "5433")
 -U NAME         database user name (default: "dbadmin")
 -W              prompt for password (should happen automatically)
 -w PASSWORD     database user's password
 -k KRB SERVICE  Kerberos service name (default: "vertica")
 -K KRB HOST     Kerberos host name
For more information, type "?" (for vsql commands)
 from within vsql, or consult the vsql section in
 the Vertica Analytic Database documentation.

vsql -Utest -wtestpwd -At -F'|' -c "select * from t_jingyu" -o /tmp/t_jingyu_expdata.dat

vsql -Utest -wtestpwd -At -F'|' -c "select * from t_jingyu where col1=1" -o /tmp/t_jingyu_expdata_col1.dat

[dbadmin@vertica1 tmp]$ more /tmp/t_jingyu_expdata.dat
 4|martin|2014-06-20 00:00:00
 1|jingyu|2014-06-19 00:00:00
 5|靖宇|2014-06-19 00:00:00
 3|alfred|2014-05-20 00:00:00
 2|xiaobei|2014-06-20 00:00:00

[dbadmin@vertica1 tmp]$ more /tmp/t_jingyu_expdata_col1.dat
 1|jingyu|2014-06-19 00:00:00