You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@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)