You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Anoop Sharma (JIRA)" <ji...@apache.org> on 2016/06/22 01:17:58 UTC
[jira] [Created] (TRAFODION-2084) inserting invalid data into a
hive column does not return error
Anoop Sharma created TRAFODION-2084:
---------------------------------------
Summary: 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)