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.

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

Solved Go to solution

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

Accepted Solutions
Highlighted

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

Expert Contributor

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

View solution in original post

1 REPLY 1
Highlighted

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

Expert Contributor

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

View solution in original post

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