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)