You may try with below steps to de-duplicate the data in table t: 1. insert into new_t select distinct tuple from t 2. drop table t 3. rename new_t to t
Best regards, Ruilong Huo On Thu, Apr 7, 2016 at 6:36 PM, hawqstudy <[email protected]> wrote: > I inserted millions of rows into an existing table but found there’s > duplication. I would like to delete the rows based on the date column but > found there’s no delete command in Hawk. > > Is there any way I can remove the records without rebuilding the table > from scratch? >
