[ https://issues.apache.org/jira/browse/SPARK-37857?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17473228#comment-17473228 ]
Hyukjin Kwon commented on SPARK-37857: -------------------------------------- from a cursory look, we should probably fix. Are you interested in submitting a PR [~venk]? > Any depth search not working in get_json_object ($..foo) > -------------------------------------------------------- > > Key: SPARK-37857 > URL: https://issues.apache.org/jira/browse/SPARK-37857 > Project: Spark > Issue Type: Bug > Components: SQL > Affects Versions: 3.2.0 > Reporter: Venk > Priority: Major > > The following example should return a value _abc_ but instead returns null > {code:java} > spark.sql("""select get_json_object('{"k":{"value":"abc"}}', '$..value') as > j""").show(){code} > I checked the [spark test suite for Json expression parser | > [spark/JsonExpressionsSuite.scala at f12793de205a46c75529ac20649e2e61edc0b144 > · apache/spark · > GitHub|https://github.com/apache/spark/blob/f12793de205a46c75529ac20649e2e61edc0b144/sql/catalyst/src/test/scala/org/apache/spark/sql/catalyst/expressions/JsonExpressionsSuite.scala]] > and the example there seems to be for a negative test case (non-existent > key), so I'm not sure if this is expected. -- This message was sent by Atlassian Jira (v8.20.1#820001) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org