Ask Your Question
1

Error HIVE_21 in Hive Metadata processor

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

aisha gravatar image

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

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
0

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

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

Stats

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

Seen: 19 times

Last updated: Apr 21