You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Lijia Liu (JIRA)" <ji...@apache.org> on 2018/04/18 11:21:00 UTC
[jira] [Updated] (SPARK-24012) Union of map and other compatible
column
[ https://issues.apache.org/jira/browse/SPARK-24012?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Lijia Liu updated SPARK-24012:
------------------------------
Description:
Union of map and other compatible column result in unresolved operator 'Union; exception
Reproduction
spark-sql>select map(1,2), 'str' union all select map(1,2,3,null), 1
Output:
'Union
:- Project map(1, 2) AS map(1, 2)#6655, str AS str#6656
: +- OneRowRelation
+- Project map(1, cast(2 as int), 3, cast(null as int)) AS map(1, CAST(2 AS INT), 3, CAST(NULL AS INT))#6658, 1 AS 1#6657
+- OneRowRelation
was:
Union of map and other compatible column result in unresolved operator 'Union; exception
Reproduction
spark-sql>*select map(1,2), 'str' union all select map(1,2,3,null), 1*
Output:
'Union
:- Project [map(1, 2) AS map(1, 2)#6655, str AS str#6656]
: +- OneRowRelation
+- Project [map(1, cast(2 as int), 3, cast(null as int)) AS map(1, CAST(2 AS INT), 3, CAST(NULL AS INT))#6658, 1 AS 1#6657]
+- OneRowRelation
> Union of map and other compatible column
> ----------------------------------------
>
> Key: SPARK-24012
> URL: https://issues.apache.org/jira/browse/SPARK-24012
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 2.1.0, 2.2.1
> Reporter: Lijia Liu
> Priority: Major
>
> Union of map and other compatible column result in unresolved operator 'Union; exception
> Reproduction
> spark-sql>select map(1,2), 'str' union all select map(1,2,3,null), 1
> Output:
> 'Union
> :- Project map(1, 2) AS map(1, 2)#6655, str AS str#6656
> : +- OneRowRelation
> +- Project map(1, cast(2 as int), 3, cast(null as int)) AS map(1, CAST(2 AS INT), 3, CAST(NULL AS INT))#6658, 1 AS 1#6657
> +- OneRowRelation
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org