You can use temp table to insert the data and then use temp table to insert back to main table
On Tue, 21 Jul 2020 at 12:01 AM, Utkarsh Jain <utkarsh....@gmail.com> wrote: > Hello community, > > I am not sure that using 'insert overwrite using select within same table' > via spark SQL is a good approach or is there any other best alternative > approach to do this. > > Thanks > Utkarsh >