Insert overwrite using select within same table

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Insert overwrite using select within same table

Utkarsh Jain
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
Reply | Threaded
Open this post in threaded view
|

Re: Insert overwrite using select within same table

Umesh Bansal
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 <[hidden email]> 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