Make sure to set autoCommit on before issuing the DELETE. Otherwise the client needs to hold onto all the row keys of the rows being deleted.
On Tuesday, August 9, 2016, Sanooj Padmakumar <[email protected]> wrote: > Hi All, > > What will be the best way to delete huge number of rows ( around 100 > million records) from a phoenix table ? Primary key is composite and I know > the value of the column at the first position.Just to add, a normal delete > query throws exception indicating it cannot delete this huge quantity of > data > > > Thanks! > > -- > Thanks, > Sanooj Padmakumar >
