1. 查看hadoop日志

hadoop job -logs job_1430340889927_194127 attempt_1430340889927_194127_m_000027_1

2.sqoop export导出到mysql数据库

sqoop export --connect jdbc:mysql://DMP-ETL-001/xwdb -m 1 --username xwtech --password hwfx123 --table user_label --export-dir /user/e_xinwang/private/tmp_yym_test/ --input-fields-terminated-by '\t'

3.显示hive表分区

show partitions exttable_map_mdn_city

4.删除分区 

alter table test drop partition (dt='20160213');