Zero: jdbc:hive2://2.hadoop.com: 10008 & gt; Insert the overwrite table t_service_detail_log_txt PARTITION (fdate="2016-01-06") select * from t_service_detail_log where fdate="2016-01-06";
Zero: jdbc:hive2://2.hadoop.com: 10008 & gt; Select count (1) the from t_service_detail_log_txt where fdate='2016-01-06';
+ -- -- -- -- -- -- -- -- -- -- - + - +
| _c0 |
+ -- -- -- -- -- -- -- -- -- -- - + - +
44310448 | |
+ -- -- -- -- -- -- -- -- -- -- - + - +
1 row selected (24.948 seconds)
Zero: jdbc:hive2://2.hadoop.com: 10008 & gt;
Zero: jdbc:hive2://2.hadoop.com: 10008 & gt; The ALTER TABLE t_service_detail_log_txt DROP IF the EXISTS PARTITION (fdate='2016-01-06');
Error: org. Apache. Spark. SQL. Execution. QueryExecutionException: FAILED: SemanticException [Error 10006] : Partition not found (fdate=2016-01-06) (state=, code=0)
How to solve the delete data partition in the partition table?
CodePudding user response:
The building Lord what problem?