create table tmp_base
(
 userid              string
,name                string
,sex                 string
,age                 int
,create_date         TIMESTAMP
)row format delimited
fields terminated by 't'
stored as textfile
;

create table tmp_base
(
 userid              varchar
,name                varchar
,sex                 varchar
,age                 int8
,create_date         TIMESTAMP
)

sqoop export
--connect
jdbc:postgresql://192.168.20.40:5432/bankwarehouse?currentSchema=warehouse
--username
gpadmin
--password
changeme
--table
tb_user_base_property
--update-key
userid
--columns
userid,name,sex,age,create_date
--export-dir
/$HIVE_WAREHOUSE/db_test.db/tmp_base
--input-fields-terminated-by
"t"
--input-null-string
"\\N"
--input-null-non-string
"\\N"