Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

prevent hive to return null values when type casting

prevent hive to return null values when type casting

Rising Star

Hello,

When using cast(column1 as int) as column hive returns a null value if for an example column1 had a string value or decimal

we want to keep track if files changed there structure etc. is there a way to let hive generate a runtime error or do something when trying to type cast a value to a type that isn't valid

Don't have an account?
Coming from Hortonworks? Activate your account here