Meera created HIVE-21699: ---------------------------- Summary: Issue in execute old queries in HIve 2.2 Key: HIVE-21699 URL: https://issues.apache.org/jira/browse/HIVE-21699 Project: Hive Issue Type: Bug Components: Hive Affects Versions: 2.2.0 Reporter: Meera
Hi We have queries in Hive 1.x version that had CTAS with ability to create column with value as null. But when we upgraded to Hive 2.2 the same queries are not executing and throws issue as FAILED: SemanticException [Error 10305]: CREATE-TABLE-AS-SELECT creates a VOID type, please use CAST to specify the type, near field: Test1 We saw that the Jira fix 11217 was only to fix the semantic error exception . IS there any patch from Hive to fix this issue by type casting automatically for these type of issues or do we need to typecast the null column manually post upgrade for all the affected queries ? Thanks -- This message was sent by Atlassian JIRA (v7.6.3#76005)