9.20每日总结
今日学习时间两小时,下载了sqoop,完成了sqoop的配置,完成了从hive到mysql的数据传输,所使用的语句
bin/sqoop export \ --connect "jdbc:mysql://node1:3306/test?useUnicode=true&characterEncoding=utf-8" \ --username root \ --password 123456 \ --table test_sales_wash \ --num-mappers 1 \ --export-dir /user/hive/warehouse/test.db/test_sales_wash \ --input-fields-terminated-by ","