[
https://issues.apache.org/jira/browse/HIVE-16486?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dudu Markovitz updated HIVE-16486:
----------------------------------
Description:
-----------------------------------------------------------------------------
-- Use case 1: adding a column in the middle of a table
-----------------------------------------------------------------------------
create table mytable (i1 int,i3 int) partitioned by (ver int) stored as
textfile;
insert into mytable partition(ver=1) values (1,2),(3,4);
select * from mytable;
||i1||i3||ver||
|1|2|1|
|3|4|1|
alter table mytable replace columns (i1 int,i2 int,i3 int);
insert into mytable partition(ver=2) values (5,6,7),(8,9,10);
select * from mytable;
**************************************************************************
I would expect values 2 and 4 to appear under column i3 , In accordance with
the columns definition of partition ver=1, but they appear under column i2.
**************************************************************************
i1 i2 i3 ver
1 2 (null) 1
3 4 (null) 1
5 6 7 2
8 9 10 2
---------------------------------------------
-- Use case 2: dropping a column
---------------------------------------------
create table mytable (i1 int,i2 int) partitioned by (ver int) stored as
textfile;
insert into mytable partition(ver=1) values (1,2),(3,4);
select * from mytable;
i1 i2 ver
1 2 1
3 4 1
alter table mytable replace columns (i1 int);
insert into mytable partition(ver=2) values (5),(6);
select * from mytable;
i1 ver
1 1
3 1
5 2
6 2
**************************************************************************
I would expect column i2 to be part of the columns list when asterisk is being
used or at least that is would be available for explicit use
**************************************************************************
select i1,i2 from mytable;
Error while compiling statement: FAILED: SemanticException [Error 10004]: Line
1:10 Invalid table alias or column reference 'i2': (possible column names are:
i1, ver)
was:
-----------------------------------------------------------------------------
-- Use case 1: adding a column in the middle of a table
-----------------------------------------------------------------------------
create table mytable (i1 int,i3 int) partitioned by (ver int) stored as
textfile;
insert into mytable partition(ver=1) values (1,2),(3,4);
select * from mytable;
i1 i3 ver
1 2 1
3 4 1
alter table mytable replace columns (i1 int,i2 int,i3 int);
insert into mytable partition(ver=2) values (5,6,7),(8,9,10);
select * from mytable;
**************************************************************************
I would expect values 2 and 4 to appear under column i3 , In accordance with
the columns definition of partition ver=1, but they appear under column i2.
**************************************************************************
i1 i2 i3 ver
1 2 (null) 1
3 4 (null) 1
5 6 7 2
8 9 10 2
---------------------------------------------
-- Use case 2: dropping a column
---------------------------------------------
create table mytable (i1 int,i2 int) partitioned by (ver int) stored as
textfile;
insert into mytable partition(ver=1) values (1,2),(3,4);
select * from mytable;
i1 i2 ver
1 2 1
3 4 1
alter table mytable replace columns (i1 int);
insert into mytable partition(ver=2) values (5),(6);
select * from mytable;
i1 ver
1 1
3 1
5 2
6 2
**************************************************************************
I would expect column i2 to be part of the columns list when asterisk is being
used or at least that is would be available for explicit use
**************************************************************************
select i1,i2 from mytable;
Error while compiling statement: FAILED: SemanticException [Error 10004]: Line
1:10 Invalid table alias or column reference 'i2': (possible column names are:
i1, ver)
> schema changes for partitioned tables (RESTRICT, not CASCADE) other than
> adding columns at the end of a table, return wrong results
> -----------------------------------------------------------------------------------------------------------------------------------
>
> Key: HIVE-16486
> URL: https://issues.apache.org/jira/browse/HIVE-16486
> Project: Hive
> Issue Type: Bug
> Components: Serializers/Deserializers
> Affects Versions: 1.1.0
> Reporter: Dudu Markovitz
>
> -----------------------------------------------------------------------------
> -- Use case 1: adding a column in the middle of a table
> -----------------------------------------------------------------------------
> create table mytable (i1 int,i3 int) partitioned by (ver int) stored as
> textfile;
> insert into mytable partition(ver=1) values (1,2),(3,4);
> select * from mytable;
> ||i1||i3||ver||
> |1|2|1|
> |3|4|1|
> alter table mytable replace columns (i1 int,i2 int,i3 int);
> insert into mytable partition(ver=2) values (5,6,7),(8,9,10);
> select * from mytable;
> **************************************************************************
> I would expect values 2 and 4 to appear under column i3 , In accordance with
> the columns definition of partition ver=1, but they appear under column i2.
> **************************************************************************
> i1 i2 i3 ver
> 1 2 (null) 1
> 3 4 (null) 1
> 5 6 7 2
> 8 9 10 2
> ---------------------------------------------
> -- Use case 2: dropping a column
> ---------------------------------------------
> create table mytable (i1 int,i2 int) partitioned by (ver int) stored as
> textfile;
> insert into mytable partition(ver=1) values (1,2),(3,4);
> select * from mytable;
> i1 i2 ver
> 1 2 1
> 3 4 1
> alter table mytable replace columns (i1 int);
> insert into mytable partition(ver=2) values (5),(6);
> select * from mytable;
> i1 ver
> 1 1
> 3 1
> 5 2
> 6 2
> **************************************************************************
> I would expect column i2 to be part of the columns list when asterisk is
> being used or at least that is would be available for explicit use
> **************************************************************************
> select i1,i2 from mytable;
> Error while compiling statement: FAILED: SemanticException [Error 10004]:
> Line 1:10 Invalid table alias or column reference 'i2': (possible column
> names are: i1, ver)
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
