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:10:00 UTC

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

     [ https://issues.apache.org/jira/browse/FLINK-27014?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

luoyuxia updated FLINK-27014:
-----------------------------
        Parent: FLINK-26360
    Issue Type: Sub-task  (was: Improvement)

> Hive dialect support select null literal in subquery
> ----------------------------------------------------
>
>                 Key: FLINK-27014
>                 URL: https://issues.apache.org/jira/browse/FLINK-27014
>             Project: Flink
>          Issue Type: Sub-task
>          Components: Connectors / Hive
>    Affects Versions: 1.16.0
>            Reporter: luoyuxia
>            Priority: Major
>
> 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)