sqoop 从mysql导出数据到hive datetime类型后多了个'.0'
mysql表datetime类型字段 导入到hive中后面多了个 .0,如下
mysql: 2014-06-20 10:42:01
hive : 2014-06-20 10:42:01.0
sqoop命令:
sqoop import \
--connect jdbc:mysql://ip:port/db_name \
--username usernae \
--password 'passwd' \
--query 'select * from table where $CONDITIONS ' \
--map-column-hive id=DATETIME,value=string \
--split-by id \
--fields-terminated-by '\t' \
--lines-terminated-by '\n' \
--null-non-string '' \
--null-string '' \
--hive-overwrite \
--target-dir /user/hive/warehouse/tmp.db/sqoop_tmp_table \
-- --default-character-set=utf-8 -m 8