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

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

Hans Zeller created TRAFODION-2002:
--------------------------------------

             Summary: 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)