Hi Friends, What is the right syntax to query on collection of nested object? I have a following schema and SQL. But it does not return anything. Is the syntax correct?
root |-- id: string (nullable = false) |-- employee: array (nullable = false) | |-- element: struct (containsNull = true) | | |-- id: string (nullable = false) | | |-- name: string (nullable = false) | | |-- speciality: string (nullable = false) select id from member where employee.name = 'employee0' Uploaded a test if some one want to try it out. NestedObjectTest.java <http://apache-spark-user-list.1001560.n3.nabble.com/file/n24853/NestedObjectTest.java> -- View this message in context: http://apache-spark-user-list.1001560.n3.nabble.com/nested-collection-object-query-tp24853.html Sent from the Apache Spark User List mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscr...@spark.apache.org For additional commands, e-mail: user-h...@spark.apache.org