[jira] [Assigned] (TRAFODION-1904) Column list in insert into Hive table is ignored

["Hans Zeller (JIRA)" <ji...@apache.org>]

     [ 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)