[ https://issues.apache.org/jira/browse/TRAFODION-1904?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Hans Zeller reassigned TRAFODION-1904: -------------------------------------- Assignee: Hans Zeller > Column list in insert into Hive table is ignored > ------------------------------------------------ > > Key: TRAFODION-1904 > URL: https://issues.apache.org/jira/browse/TRAFODION-1904 > Project: Apache Trafodion > Issue Type: Bug > Components: sql-cmp > Affects Versions: 1.3-incubating > Environment: Any > Reporter: Hans Zeller > Assignee: Hans Zeller > > Trafodion supports inserts into simple Hive tables. However, I noticed that > if a column list is specified, that list is ignored. Example: > Create this table in Hive: > {noformat} > create table instest(a int, b string, c int); > {noformat} > Then, in Trafodion: > {noformat} > create table inssrc(a int, b char(10), c int); > insert into inssrc values(1,'two', 3); > insert into hive.hive.instest(c,b,a) select a,b,c from inssrc; > {noformat} > Use a new sqlci session: > {noformat} > cqd hive_max_string_length '20'; > select * from hive.hive.instest; > {noformat} > This returns 1, two, 3 instead of 3, two, 1. > Similarly, if the list is shorter than the number of columns in the Hive > table, it fills the last columns with NULLs, not the omitted columns. -- This message was sent by Atlassian JIRA (v6.3.4#6332)