Re: the column names removed after insert select

Hi This has been fixed recently https://issues.apache.org/jira/browse/HIVE-4243 This used to be a problem with the way hive writes rows out. The ObjectInspectors sent out by hive’s filesink operator contains internal column names and not the names of the destination table. From the record

Re: the column names removed after insert select

Excellent news. Thanks. On 23 October 2015 at 15:50, Prasanth Jayachandran < pjayachand...@hortonworks.com> wrote: > Hi > > This has been fixed recently > https://issues.apache.org/jira/browse/HIVE-4243 > > This used to be a problem with the way hive writes rows out. The > ObjectInspectors sent

Re: the column names removed after insert select

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 wrote: > Hi > > I inserted a table from select (insert into table

the column names removed after insert select

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