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

dineshc — Sat, 01 Apr 2017 11:21:09 GMT

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 ?

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

sreeviswa_athic — Tue, 04 Apr 2017 02:38:02 GMT

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

question Hive 1.2.x - CTAS behavior when using CAST to specify type in Archives of Support Questions (Read Only)

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

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