Sqoop将MySQL表结构同步到hive(text、orc)

时间:2023-03-09 08:13:54
Sqoop将MySQL表结构同步到hive(text、orc)

Sqoop将MySQL表结构同步到hive

sqoop create-hive-table --connect jdbc:mysql://localhost:3306/sqooptest --username root --password 123qwe --table sqoop_job
--hive-table sqoop_job --fields-terminated-by ,

orc格式的

sqoop import --connect jdbc:mysql://localhost:3306/test --username root --password 1234qwer --table test_table --hcatalog-database db_fz
--hcatalog-table test_table --create-hcatalog-table --hcatalog-storage-stanza "stored as orc"