[SPARK-34963] Nested column pruning fails to extract case-insensitive struct field from array

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.4.7, 3.0.2, 3.1.1, 3.2.0
• Fix Version/s: 2.4.8, 3.0.3, 3.1.2, 3.2.0
• Component/s: SQL
• Assignee: L. C. Hsieh
• Reporter: L. C. Hsieh
• Created: 06/Apr/21 06:40
• Updated: 10/Apr/21 09:25
• Resolved: 09/Apr/21 19:14

Description

Under case-insensitive mode, nested column pruning rule cannot correctly push down extractor of a struct field of an array of struct, e.g.,

val query = spark.table("contacts").select("friends.First", "friends.MiDDle")

Issue Links

• links to: [Github] Pull Request #32059 (viirya)
• links to: [Github] Pull Request #32059 (viirya)
• links to: [Github] Pull Request #32112 (viirya)
• links to: [Github] Pull Request #32112 (viirya)