Support Questions

Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Data Analytics (CDA) group hub.

Hive 1.2.x - CTAS behavior when using CAST to specify type

As per this JIRA HIVE-11217, there was a bug in Hive where a CTAS statement having NULL in select clause throws IllegalArgumentException:Unknown primitive type VOID.

The bug was fixed and patched in version 1.3.0 and 2.0.0 as per the JIRA and the solution was to use CAST to specify a type when having NULL in select clause.

If I am using Hive 1.2.x and my CTAS select clause has "CAST(null as bigint)" will it still throw

IllegalArgumentException:Unknown primitive type VOID ?

1 ACCEPTED SOLUTION

Expert Contributor

Try using CAST, then it should not throw any exception and should work fine

View solution in original post

1 REPLY 1

Expert Contributor

Try using CAST, then it should not throw any exception and should work fine

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.