[jira] [Work started] (TRAFODION-2084) inserting invalid data into a hive column does not return error

["Anoop Sharma (JIRA)" <ji...@apache.org>]

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

Work on TRAFODION-2084 started by Anoop Sharma.
-----------------------------------------------
> inserting invalid data into a hive column does not return error
> ---------------------------------------------------------------
>
>                 Key: TRAFODION-2084
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-2084
>             Project: Apache Trafodion
>          Issue Type: Bug
>            Reporter: Anoop Sharma
>            Assignee: Anoop Sharma
>
> If invalid data is inserted into a hive table, it doesn't return an error
> during insert time.
> But error is returned when that invalid data is accessed during select.
> It makes the table unusable.
> Example:
> Create table from hive:
> hive> create table t (a smallint);
> OK
> Time taken: 0.079 seconds
> hive> 
> Insert invalid data from traf sqlci which succeeds:
> Apache Trafodion Conversational Interface 2.1.0
> Copyright (c) 2015-2016 Apache Software Foundation
> >>insert into hive.hive.t values (11111111);
> --- 1 row(s) inserted.
> >>
> Selecting that data returns error:
> >>select * from hive.hive.t;
> *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Conversion of Source Type:VARCHAR(REC_BYTE_V_ASCII,8 BYTES,ISO88591) Source Value:11111111 to Target Type:SMALLINT SIGNED(REC_BIN16_SIGNED).
> --- 0 row(s) selected.
> >>



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