[ https://issues.apache.org/jira/browse/SPARK-38097?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17488576#comment-17488576 ]
Yuto Akutsu commented on SPARK-38097: ------------------------------------- [~maxgekk] I'll work on this. > Improve the error for pivoting of unsupported value types > --------------------------------------------------------- > > Key: SPARK-38097 > URL: https://issues.apache.org/jira/browse/SPARK-38097 > Project: Spark > Issue Type: Sub-task > Components: SQL > Affects Versions: 3.3.0 > Reporter: Max Gekk > Priority: Major > > The error message from: > {code:scala} > test("Improve the error for pivoting of unsupported value types") { > trainingSales > .groupBy($"sales.year") > .pivot(struct(lower($"sales.course"), $"training")) > .agg(sum($"sales.earnings")) > .show(false) > } > {code} > can confuse users: > {code:java} > The feature is not supported: literal for '[dotnet,Dummies]' of class > org.apache.spark.sql.catalyst.expressions.GenericRowWithSchema. > org.apache.spark.SparkRuntimeException: The feature is not supported: literal > for '[dotnet,Dummies]' of class > org.apache.spark.sql.catalyst.expressions.GenericRowWithSchema. > at > org.apache.spark.sql.errors.QueryExecutionErrors$.literalTypeUnsupportedError(QueryExecutionErrors.scala:245) > at > org.apache.spark.sql.catalyst.expressions.Literal$.apply(literals.scala:99) > at > org.apache.spark.sql.RelationalGroupedDataset.$anonfun$pivot$2(RelationalGroupedDataset.scala:455) > at > scala.collection.TraversableLike.$anonfun$map$1(TraversableLike.scala:286) > {code} > Need to improve the error message and make it more precise. > See https://github.com/apache/spark/pull/35302#discussion_r793629370 -- 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