[jira] [Created] (SPARK-27820) case insensitive resolver should be used in GetMapValue

["Michel Lemay (JIRA)" <ji...@apache.org>]

Michel Lemay created SPARK-27820:
------------------------------------

             Summary: case insensitive resolver should be used in GetMapValue
                 Key: SPARK-27820
                 URL: https://issues.apache.org/jira/browse/SPARK-27820
             Project: Spark
          Issue Type: Bug
          Components: SQL
    Affects Versions: 2.4.1
            Reporter: Michel Lemay


When extracting a key value from a MapType, it calls GetMapValue and only use the map type ordering. It should use the resolver instead.

Starting spark with: `{{spark-shell --conf spark.sql.caseSensitive=false`}}

Given dataframe:

 {{val df = List(Map("a" -> 1), Map("A" -> 2)).toDF("m")}}

And executing any of these will only return one row: case sensitive match in the keys of the map but case insensitive in the name of the column.

{{df.filter($"M.A".isNotNull).count }}
{{df.filter($"M"("A").isNotNull).count df.filter($"M".getField("A").isNotNull).count}}

 



--
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