Support Questions

Find answers, ask questions, and share your expertise

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

avatar

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

avatar
Super Collaborator

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

View solution in original post

1 REPLY 1

avatar
Super Collaborator

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