[jira] [Created] (SPARK-38097) Improve the error for pivoting of unsupported value types

["Max Gekk (Jira)" <ji...@apache.org>]

Max Gekk created SPARK-38097:
--------------------------------

             Summary: 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


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.



--
This message was sent by Atlassian Jira
(v8.20.1#820001)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org