You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by 忝忝向仧 <15...@qq.com> on 2020/06/27 09:32:26 UTC
【Hive Alter Table Add column at specified position】
Hi,all:
It seems that Hive can not alter table to add column at specified position.
For instance,the Table A has c1,c2,c3 columns,and i want to add column c4 after c1,therefore,the table would be like c1,c4,c2,c3 instead of c1,c2,c3,c4.
Thanks.
Re: 【Hive Alter Table Add column at specified position】
Posted by Rui Li <li...@gmail.com>.
Yeah, according to our DDL doc, we don't support this use case at the
moment. Perhaps you can use REPLACE COLUMNS as a workaround.
On Sat, Jun 27, 2020 at 5:32 PM 忝忝向仧 <15...@qq.com> wrote:
> Hi,all:
>
>
> It seems that Hive can not alter table to add column at specified
> position.
> For instance,the Table A has c1,c2,c3 columns,and i want to add column c4
> after c1,therefore,the table would be like c1,c4,c2,c3 instead of
> c1,c2,c3,c4.
>
>
> Thanks.
--
Best regards!
Rui Li