[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: Error in query: unresolved operator 'Union;; 'Union :- Project [map(1, 2) AS map(1, 2)#106, str AS str#107] : +- 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))#109, 1 AS 1#108] +- 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: > Error in query: unresolved operator 'Union;; > 'Union > :- Project [map(1, 2) AS map(1, 2)#106, str AS str#107] > : +- 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))#109, 1 AS 1#108] > +- OneRowRelation$ > -- This message was sent by Atlassian JIRA (v7.6.3#76005) - To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org
[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-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org