When the update history data.. Whether need to delete the original partition dynamic partitioning again?.
The grammar is such..
The ALTER TABLE BSum_CrmProfile DROP PARTITION (Datekey='2017-02-26');
The ALTER TABLE BSum_CrmProfile DROP PARTITION (Datekey='2017-02-27');
INSERT INTO TABLE BSum_CrmProfile PARTITION (DateKey)
The SELECT MemberNumber, DateKey FROM CrmProfile WHERE DateKey IN (' 2017-02-26 ', '2017-02-27') GROUP BY MemberNumber, DateKey DISTRIBUTE BY DateKey;
First remove partition.. Then use the Insert into the t1 select from t2 where in () to dynamically create partitions..
Want to ask next if change the insert into to insert the overwrite.. Not deleted partitions manually..
Statement will remove all partitions or only cover the current partition.
CodePudding user response:
A mistake.. When using partition using will overwrite directly failed..Or manually delete partition to rebuild it. Honestly.
CodePudding user response:
Can't knot stick.. Also no one answer..People's words.. Say via the Rest interface to release the hive tasks..
Returns the input line is too long
The input line is too long..
The problem..