Inserting Data into Partitions Created Before Altering Hive Table Fails With SemanticException [Error 10044]
(Doc ID 1640087.1)
Last updated on MARCH 28, 2014
Applies to:Big Data Appliance Integrated Software - Version 2.3.1 and later
Inserting data into a old partition which is created before altering the hive table by adding a new column to the table, fails with the error like the following:
Time taken: 0.339 seconds
Time taken: 0.183 seconds
> DEALER_NO from ro where dealer_no="35025";
FAILED: SemanticException [Error 10044]: Line 1:23 Cannot insert into target table because column number/types are different '"35025"': Table insclause-0 has 25 columns, but query has 26 columns.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document