![](https://img-blog.csdnimg.cn/20190925084800861.png?x-oss-process=image/resize,m_fixed,h_224,w_224)
Sqoop
storm_fury
本是青灯不归客,却因浊酒留红尘
展开
-
Sqoop导入Mysql中tinyint(1)格式数据到hdfs或hive时问题
sqoop官网解决方案 27.2.5. MySQL: Import of TINYINT(1) from MySQL behaves strangely Problem: Sqoop is treating TINYINT(1) columns as booleans, which is for example causing issues with HIVE import. This is be...原创 2018-12-24 15:31:26 · 2987 阅读 · 0 评论 -
Sqoop导入Hive中merge-key实践
创建hive表merge_test beeline -u jdbc:hive2://192.168.1.101:10000 -n hive -e " create table if not exists default.merge_test ( id int, name String, age int, last_modify_time String )ROW F...原创 2019-03-21 08:57:04 · 3679 阅读 · 1 评论 -
利用Sqoop从PostgreSQL导入数据时遇到的坑
sqoop import \ --connect "jdbc:postgresql://10.101.70.169:5432/db_name" \ --username "postgres" \ --password "123456" \ --table "test_user"\ --target-dir "/user/hive/warehouse/test.db/test_user" \ --f...原创 2019-03-25 17:02:38 · 4922 阅读 · 3 评论