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.
... View more
