sqoop同步mysql数据到parquet格式存储的hive表中

sqoop import "-Dorg.apache.sqoop.splitter.allow_text_splitter=true" \
--connect "jdbc:mysql://${host}:3306/${dbname}?useUnicode=true&characterEncoding=utf8" \
--username ${user} \
--password ${password} \
--query "select * from ${table_name} where \$CONDITIONS" \
--hcatalog-database ${hive_database} --hcatalog-table ${table_name} \
--hcatalog-storage-stanza "STORED AS parquet" \
--split-by org \
--hive-overwrite \
--null-string '\\N' --null-non-string '\\N' \
-m 1

orc格式同理