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

Posted to issues@flink.apache.org by "Jark Wu (Jira)" <ji...@apache.org> on 2022/07/22 02:34:00 UTC

[jira] [Assigned] (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 ]

Jark Wu reassigned FLINK-27014:
-------------------------------

    Assignee: luoyuxia

> 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
>            Assignee: 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.10#820010)