[HIVE-17845] insert fails if target table columns are not lowercase

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.2.1
• Fix Version/s: 3.0.0
• Target Version/s: 2.3.0
• Assignee: Naresh P R
• Reporter: Naresh P R
• Created: 19/Oct/17 10:41
• Updated: 22/May/18 23:17
• Resolved: 23/Oct/17 17:05

Description

eg.,
INSERT INTO TABLE EMP(ID,NAME) select * FROM SRC;
FAILED: SemanticException 1:27 '[ID,NAME]' in insert schema specification are not found among regular columns of default.EMP nor dynamic partition columns.. Error encountered near token 'NAME'

Whereas below insert is successful:
INSERT INTO TABLE EMP(id,name) select * FROM SRC;

Issue Links

• duplicates: HIVE-10378 Hive Update statement set keyword work with lower case only and doesn't give any error if wrong column name specified in the set clause.