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

Posted to issues@flink.apache.org by "luoyuxia (Jira)" <ji...@apache.org> on 2022/04/02 11:08:00 UTC

[jira] [Created] (FLINK-27014) Hive dialect support select null literal in subquery

luoyuxia created FLINK-27014:
--------------------------------

             Summary: Hive dialect support select null literal in subquery
                 Key: FLINK-27014
                 URL: https://issues.apache.org/jira/browse/FLINK-27014
             Project: Flink
          Issue Type: Improvement
          Components: Connectors / Hive
    Affects Versions: 1.16.0
            Reporter: luoyuxia


It'll throw the exception "Unsupported type 'NULL' to get internal serializer" with the following sql in Hive dialect

 
{code:java}
select count(key) from (select null as key from src)src {code}
The reason is null literal will be considered as NULL type, but there's no serializer for NULL type.  When meet such case, consider it as Varchar Type.

 

 



--
This message was sent by Atlassian Jira
(v8.20.1#820001)