You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "Meera (JIRA)" <ji...@apache.org> on 2019/05/07 14:25:00 UTC

[jira] [Created] (HIVE-21699) Issue in execute old queries in HIve 2.2

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)