You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@spark.apache.org by Utkarsh Jain <ut...@gmail.com> on 2020/07/20 18:31:04 UTC

Insert overwrite using select within same table

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

Re: Insert overwrite using select within same table

Posted by Umesh Bansal <ba...@gmail.com>.

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 <ut...@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
>