Ask Your Question

Error HIVE_21 in Hive Metadata processor

asked 2020-04-15 06:18:24 -0600

aisha gravatar image

updated 2020-04-21 09:36:52 -0600

metadaddy gravatar image

I'm getting an error of:

Hive_21- type mismatch for column, expected decimal , actual string

However I haven't formatted any field to a particular data format. The column it is raising an issue for has both strings and decimals so I have left the column as it is. But it once it gets to the Hive Metadata stage, it throws the error above.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2020-04-21 09:36:01 -0600

metadaddy gravatar image

As you've discovered, the Hive Metadata processor depends on the fields having consistent type across time. Decide what type that field should be in Hive and use the Field Type Converter upstream from the Hive Metadata processor so that it is always the same type.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-04-15 06:18:24 -0600

Seen: 67 times

Last updated: Apr 21 '20