hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Elliot West <tea...@gmail.com>
Subject Re: the column names removed after insert select
Date Fri, 23 Oct 2015 10:02:39 GMT
I was seeing something similar in the initial ORC delta file when inserting
rows into a newly created ACID table. Subsequent deltas had the correct
columns names.

On 23 October 2015 at 08:25, patcharee <Patcharee.Thongtra@uni.no> wrote:

> Hi
>
> I inserted a table from select (insert into table newtable select date,
> hh, x, y from oldtable). After the insert the column names of the table
> have been removed, see the output below when I use hive --orcfiledump
>
> - Type: struct<_col0:int,_col1:int,_col2:int,_col3:int>
>
> while it is supposed to be
>
> - Type: struct<date:int,hh:int,x:int,y:int>
>
> Any ideas how this happened and how I can fix it. Please suggest me.
>
> BR,
> Patcharee
>

Mime
View raw message