You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Peter Toth (JIRA)" <ji...@apache.org> on 2019/07/04 13:43:00 UTC
[jira] [Commented] (SPARK-28251) Fix error message of inserting
into a non-existing table
[ https://issues.apache.org/jira/browse/SPARK-28251?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16878660#comment-16878660 ]
Peter Toth commented on SPARK-28251:
------------------------------------
cc [~dongjoon]
> Fix error message of inserting into a non-existing table
> --------------------------------------------------------
>
> Key: SPARK-28251
> URL: https://issues.apache.org/jira/browse/SPARK-28251
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 3.0.0
> Reporter: Peter Toth
> Priority: Minor
>
> Inserting into a non-existing table returns an error message that could be a bit more user friendly:
> {noformat}
> scala> sql("INSERT INTO test VALUES (1)").show
> org.apache.spark.sql.AnalysisException: unresolved operator 'InsertIntoTable 'UnresolvedRelation [test], false, false;;
> 'InsertIntoTable 'UnresolvedRelation [test], false, false
> +- LocalRelation [col1#4]
> at org.apache.spark.sql.catalyst.analysis.CheckAnalysis.failAnalysis(CheckAnalysis.scala:45)
> at org.apache.spark.sql.catalyst.analysis.CheckAnalysis.failAnalysis$(CheckAnalysis.scala:44)
> at org.apache.spark.sql.catalyst.analysis.Analyzer.failAnalysis(Analyzer.scala:97)
> at org.apache.spark.sql.catalyst.analysis.CheckAnalysis.$anonfun$checkAnalysis$35(CheckAnalysis.scala:461)
> at org.apache.spark.sql.catalyst.analysis.CheckAnalysis.$anonfun$checkAnalysis$35$adapted(CheckAnalysis.scala:459)
> at org.apache.spark.sql.catalyst.trees.TreeNode.foreachUp(TreeNode.scala:150)
> at org.apache.spark.sql.catalyst.analysis.CheckAnalysis.checkAnalysis(CheckAnalysis.scala:459)
> at org.apache.spark.sql.catalyst.analysis.CheckAnalysis.checkAnalysis$(CheckAnalysis.scala:85)
> at org.apache.spark.sql.catalyst.analysis.Analyzer.checkAnalysis(Analyzer.scala:97)
> at org.apache.spark.sql.catalyst.analysis.Analyzer.$anonfun$executeAndCheck$1(Analyzer.scala:114)
> at org.apache.spark.sql.catalyst.plans.logical.AnalysisHelper$.markInAnalyzer(AnalysisHelper.scala:201)
> at org.apache.spark.sql.catalyst.analysis.Analyzer.executeAndCheck(Analyzer.scala:111)
> at org.apache.spark.sql.execution.QueryExecution.$anonfun$analyzed$1(QueryExecution.scala:63)
> at org.apache.spark.sql.catalyst.QueryPlanningTracker.measurePhase(QueryPlanningTracker.scala:111)
> at org.apache.spark.sql.execution.QueryExecution.analyzed$lzycompute(QueryExecution.scala:61)
> at org.apache.spark.sql.execution.QueryExecution.analyzed(QueryExecution.scala:61)
> at org.apache.spark.sql.execution.QueryExecution.assertAnalyzed(QueryExecution.scala:53)
> at org.apache.spark.sql.Dataset$.ofRows(Dataset.scala:87)
> at org.apache.spark.sql.SparkSession.sql(SparkSession.scala:653)
> ... 47 elided
> {noformat}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org