I create a table and tried to insert the data but got the below exception due to case sensitivity.
INSERT INTO TABLE X(A,B,C) select A,B,C FROM Y;
FAILED: SemanticException 1:27 '[A, B, C]' in insert schema specification are not found among regular columns of default.X nor dynamic partition columns.. Error encountered near token 'C'
Whereas the below successful:
INSERT INTO TABLE X(a,b,c) select A,B,C FROM Y;
After some investigation, I found Hive metastore store table info in lowercase and is case-sensitive.
Is there any way I can make sure JDBC drive can handle this scenario? We are using a tool to push data from RDBMS system to Hive and it is generating CREATE & INSERT statements in uppercase. I am working with the tool SME's as well if they can enfore a lowercase schema during code generation.
I'm confirm that. Destination table column names must be writted in lowercase , otherwise insert statement does'nt work