[jira] [Work started] (TRAFODION-2002) Missing column checks when inserting into Hive table

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

     [ https://issues.apache.org/jira/browse/TRAFODION-2002?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Work on TRAFODION-2002 started by Hans Zeller.
----------------------------------------------
> Missing column checks when inserting into Hive table
> ----------------------------------------------------
>
>                 Key: TRAFODION-2002
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-2002
>             Project: Apache Trafodion
>          Issue Type: Bug
>          Components: sql-cmp
>    Affects Versions: 1.2-incubating
>         Environment: Any
>            Reporter: Hans Zeller
>            Assignee: Hans Zeller
>             Fix For: 2.1-incubating
>
>
> Anoop found this problem: There are no checks when we insert into Hive tables, the SELECT list could have more or fewer columns than the Hive target table, and the types of the columns could be incompatible. Example:
> -- in Hive:
> drop table tph;
> create table tph (a int, b int);
> -- in Trafodion
> insert into hive.hive.tph values (1,1,1);
> select * from tph;
> -- shows two columns
> insert into hive.hive.tph values(1);
> select * from tph;
> -- those may cause a core dump



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)