[ https://issues.apache.org/jira/browse/SPARK-38120?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Wenchen Fan reassigned SPARK-38120: ----------------------------------- Assignee: Khalid Mammadov > HiveExternalCatalog.listPartitions is failing when partition column name is > upper case and dot in partition value > ----------------------------------------------------------------------------------------------------------------- > > Key: SPARK-38120 > URL: https://issues.apache.org/jira/browse/SPARK-38120 > Project: Spark > Issue Type: Bug > Components: SQL > Affects Versions: 3.0.3, 3.1.2, 3.2.1 > Reporter: Khalid Mammadov > Assignee: Khalid Mammadov > Priority: Minor > Fix For: 3.3.0, 3.2.2 > > > HiveExternalCatalog.listPartitions method call is failing when a partition > column name is upper case and partition value contains dot. It's related to > this change > [https://github.com/apache/spark/commit/f18b905f6cace7686ef169fda7de474079d0af23] > The test casein that PR does not produce the issue as partition column name > is lower case. > > Below how to reproduce the issue: > scala> import org.apache.spark.sql.catalyst.TableIdentifier > import org.apache.spark.sql.catalyst.TableIdentifier > scala> spark.sql("CREATE TABLE customer(id INT, name STRING) PARTITIONED BY > (partCol1 STRING, partCol2 STRING)") > scala> spark.sql("INSERT INTO customer PARTITION (partCol1 = 'CA', partCol2 = > 'i.j') VALUES (100, 'John')") > scala> spark.sessionState.catalog.listPartitions(TableIdentifier("customer"), > Some(Map("partCol2" -> "i.j"))).foreach(println) > java.util.NoSuchElementException: key not found: partcol2 > at scala.collection.immutable.Map$Map2.apply(Map.scala:227) > at > org.apache.spark.sql.catalyst.catalog.ExternalCatalogUtils$.$anonfun$isPartialPartitionSpec$1(ExternalCatalogUtils.scala:205) > at > org.apache.spark.sql.catalyst.catalog.ExternalCatalogUtils$.$anonfun$isPartialPartitionSpec$1$adapted(ExternalCatalogUtils.scala:202) > at scala.collection.immutable.Map$Map1.forall(Map.scala:196) > at > org.apache.spark.sql.catalyst.catalog.ExternalCatalogUtils$.isPartialPartitionSpec(ExternalCatalogUtils.scala:202) > at > org.apache.spark.sql.hive.HiveExternalCatalog.$anonfun$listPartitions$6(HiveExternalCatalog.scala:1312) > at > org.apache.spark.sql.hive.HiveExternalCatalog.$anonfun$listPartitions$6$adapted(HiveExternalCatalog.scala:1312) > at > scala.collection.TraversableLike.$anonfun$filterImpl$1(TraversableLike.scala:304) > at scala.collection.mutable.ResizableArray.foreach(ResizableArray.scala:62) > at scala.collection.mutable.ResizableArray.foreach$(ResizableArray.scala:55) > at scala.collection.mutable.ArrayBuffer.foreach(ArrayBuffer.scala:49) > at scala.collection.TraversableLike.filterImpl(TraversableLike.scala:303) > at scala.collection.TraversableLike.filterImpl$(TraversableLike.scala:297) > at scala.collection.AbstractTraversable.filterImpl(Traversable.scala:108) > at scala.collection.TraversableLike.filter(TraversableLike.scala:395) > at scala.collection.TraversableLike.filter$(TraversableLike.scala:395) > at scala.collection.AbstractTraversable.filter(Traversable.scala:108) > at > org.apache.spark.sql.hive.HiveExternalCatalog.$anonfun$listPartitions$1(HiveExternalCatalog.scala:1312) > at > org.apache.spark.sql.hive.HiveExternalCatalog.withClientWrappingException(HiveExternalCatalog.scala:114) > at > org.apache.spark.sql.hive.HiveExternalCatalog.withClient(HiveExternalCatalog.scala:103) > at > org.apache.spark.sql.hive.HiveExternalCatalog.listPartitions(HiveExternalCatalog.scala:1296) > at > org.apache.spark.sql.catalyst.catalog.ExternalCatalogWithListener.listPartitions(ExternalCatalogWithListener.scala:254) > at > org.apache.spark.sql.catalyst.catalog.SessionCatalog.listPartitions(SessionCatalog.scala:1251) > ... 47 elided -- 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