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
Linux x86-64

Symptoms

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:

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.


For example:

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms