Hadoop-Sqoop-Hive与Mysql互导

template

发布日期: 2023-04-23

文章字数: 69

阅读时长: 1 分

阅读次数:

导入数据到 HIVE

sqoop import \
    --connect jdbc:mysql://192.168.244.100:3306/sqooptest \
    --username root \
    --password root1234% \
    --table person \
    --num-mappers 1 \
    --hive-import \
    --fields-terminated-by "," \
    --hive-overwrite \
    --hive-table person_hive

hive/hdfs 导入数据到 mysql

sqoop export \
    --connect jdbc:mysql://192.168.244.100:3306/sqooptest \
    --username root \
    --password root1234% \
    --table person2 \
    --export-dir /user/hive/warehouse/person_hive \
    --m 1