hive ddl :
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-DropTable
hive dml :
Hive Data Types:
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Types
/* create table db_working.t_students ( id int comment 'id', name string comment '姓名', age int comment '年龄', sex int comment '性别' ) comment '学生表' partitioned by (dt string) SELECT *FROM t_students ; SET mapreduce.job.queuename=root.users.bzbd_batch INSERT INTO TABLE db_working.t_students PARTITION (dt='2021-01-03') VALUES (1,'fred flintstone', 35, 1), (2,'barney rubble', 32, 0); INSERT OVERWRITE TABLE db_working.t_students PARTITION (dt='2021-01-04') VALUES (2,'fred flintstone', 35, 1), (3,'barney rubble', 32, 0); truncate table db_working.t_students PARTITION (dt='2021-01-03'); DROP TABLE IF EXISTS db_working.t_students ; **/
sqoop import \ --D mapreduce.job.queuename=root.users.xxxx \ --connect jdbc:mysql://localhost:3306/test \ --username _uat_tableName \ --password "M4IJLvTaizC#N@(#U" \ --table t03_shop_gmvrevslp_version \ --create-hive-table \ --hive-database db_working \ --hive-import \ --hive-overwrite \ --hive-table hive_tableName \ --mapreduce-job-name FromMySQL2hive \ --delete-target-dir \ --fields-terminated-by '\t' \ -m 1 \ --hive-partition-key dt \ --hive-partition-value "2021-01-04"