- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Hive 1.2.x - CTAS behavior when using CAST to specify type
- Labels:
-
Apache Hive
Created ‎04-01-2017 04:21 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 ?
Created ‎04-03-2017 07:38 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try using CAST, then it should not throw any exception and should work fine
Created ‎04-03-2017 07:38 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try using CAST, then it should not throw any exception and should work fine
