Robert Justice created HIVE-5346: ------------------------------------ Summary: Perform some form of data validation to data types on insert, if users want to enable it. Key: HIVE-5346 URL: https://issues.apache.org/jira/browse/HIVE-5346 Project: Hive Issue Type: New Feature Components: SQL Affects Versions: 0.11.0 Reporter: Robert Justice Priority: Minor
We understand that Hive is a "schema on read" type implementation and does not verify data as it is loaded. However, it would be nice to have a switch to turn on (off by default) that checks the data be inserted satisfies the data types defined on the table. Obviously, this might be heavy handed and a performance hit, but could prevent some problems down the road for users that make mistakes. hive> describe test; OK col1 smallint Time taken: 0.11 seconds hive> insert into table test select count(*) + 43000 as bob from test; .... hive> select * from test; OK -32536 -22535 -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira