Sqoop同步mysql数据导hive中,–query 参数中,字段有特殊字段、关键字处理方法
sqoop import --connect "$jdbcurl" \
--username $username \
--password $password \
--columns "id,name,describe,created_at,updated_at,deleted_at" \
--query "select id,name,\`describe\`,created_at,updated_at,deleted_at from tags where \$CONDITIONS" \
--hive-table test.dd_ch_tags \
--hive-drop-import-delims \
--split-by 'id' \
--target-dir "/tmp/dd_ch_tags" \
--delete-target-dir \
--hive-overwrite \
--null-string '\\N' \
--null-non-string '\\N' \
--fields-terminated-by "\0001" \
--m 1 \
--hive-import \