[ 
https://issues.apache.org/jira/browse/SPARK-20017?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15931691#comment-15931691
 ] 

roncenzhao commented on SPARK-20017:
------------------------------------

The root cause of this exception is:
The `StringToMap`'s `dataType` is `MapType(StringType, StringType, 
valueContainsNull = false)` and the result of `str_to_map('')` is `"" -> null`, 
so in the function `explode`, it will throw NPE exception.

I think we should change the `dataType` of `StringToMap` to 
`MapType(StringType, StringType)`, the default value of `valueContainsNull` is 
`true`.

> Functions "str_to_map" and "explode" throws NPE exceptioin
> ----------------------------------------------------------
>
>                 Key: SPARK-20017
>                 URL: https://issues.apache.org/jira/browse/SPARK-20017
>             Project: Spark
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 2.1.0
>            Reporter: roncenzhao
>         Attachments: screenshot-1.png
>
>
> ```
> val sqlDf = spark.sql("select k,v from (select str_to_map('') as map_col from 
> range(2)) tbl lateral view explode(map_col) as k,v")
> sqlDf.show
> ```
> The sql throws NPE exception.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to