sqoop动态分区导入mysql,sqoop支持通过蜂巢进行动态分区吗？

does sqoop support dynamic partitioning with hive?

i tried using below-mentioned options :

--hive-partition-key and --hive=partition-vlaue is only for static partitioning

for eg:

sqoop import

--connect "jdbc:mysql://quickstart.cloudera:3306/prac"

--username root --password cloudera

--hive-import

--query "select id,name,ts from student where city='Mumbai' and \$CONDITIONS "

--hive-partition-key city

--hive-partition-value 'Mumbai'

--hive-table prac.student

--target-dir /user/mangesh/sqoop_import/student_temp5

--split-by id

解决方案

You can use hcatalog imports - you need sqoop 1.4.4 to do this.

sqoop import \

--connect "jdbc:oracle:SERVERDETAILS" \

--username \

--password \

--table \

--fields-terminated-by ',' \

--split-by \

--hcatalog-database

--hcatalog-table

For more details please go through