org.apache.spark.sql.AnalysisException

Table not found: `dev`.`emp`; line 1 pos 18


Solutions on the web141

Solution icon of stackoverflow
Table not found: `dev`.`emp`; line 1 pos 18

Solution icon of github
via GitHub by trestletech
, 1 year ago
Table not found: flights; line 2 pos 18

Solution icon of github
via GitHub by jjallaire
, 1 year ago
Table not found: flights; line 2 pos 18

Solution icon of github
via GitHub by jjallaire
, 1 year ago
Table not found: flights; line 2 pos 18

Solution icon of stackoverflow
Table not found: test; line 1 pos 14

Solution icon of stackoverflow
via Stack Overflow by EP89
, 4 months ago
Table not found: training; line 1 pos 144

Solution icon of stackoverflow
Table or view not found: employeedetails; line 1 pos 43

Solution icon of stackoverflow
Table not found: health; line 1 pos 21

Solution icon of stackoverflow
Table or view not found: sample_07; line 1 pos 21

Solution icon of stackoverflow
Table or view not found: `wiki`.`treated_article`; line 1 pos 14; 'Project [*] +- 'UnresolvedRelation `wiki`.`treated_article`

Stack trace

  • org.apache.spark.sql.AnalysisException: Table not found: `dev`.`emp`; line 1 pos 18 at org.apache.spark.sql.catalyst.analysis.package$AnalysisErrorAt.failAnalysis(package.scala:42) at org.apache.spark.sql.catalyst.analysis.CheckAnalysis$$anonfun$checkAnalysis$1.apply(CheckAnalysis.scala:54) at org.apache.spark.sql.catalyst.analysis.CheckAnalysis$$anonfun$checkAnalysis$1.apply(CheckAnalysis.scala:50) at org.apache.spark.sql.catalyst.trees.TreeNode.foreachUp(TreeNode.scala:121) at org.apache.spark.sql.catalyst.trees.TreeNode$$anonfun$foreachUp$1.apply(TreeNode.scala:120) at org.apache.spark.sql.catalyst.trees.TreeNode$$anonfun$foreachUp$1.apply(TreeNode.scala:120) at scala.collection.immutable.List.foreach(List.scala:318) at org.apache.spark.sql.catalyst.trees.TreeNode.foreachUp(TreeNode.scala:120) at org.apache.spark.sql.catalyst.analysis.CheckAnalysis$class.checkAnalysis(CheckAnalysis.scala:50) at org.apache.spark.sql.catalyst.analysis.Analyzer.checkAnalysis(Analyzer.scala:44) at org.apache.spark.sql.execution.QueryExecution.assertAnalyzed(QueryExecution.scala:34) at org.apache.spark.sql.DataFrame.<init>(DataFrame.scala:133) at org.apache.spark.sql.DataFrame$.apply(DataFrame.scala:52) at org.apache.spark.sql.SQLContext.sql(SQLContext.scala:817) at com.impetus.idw.data.connector.SparkHiveToHdfs.main(SparkHiveToHdfs.java:30) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497) at org.apache.spark.deploy.yarn.ApplicationMaster$$anon$2.run(ApplicationMaster.scala:559)

Write tip

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Once, 5 months ago
Samebug visitor profile picture
Unknown user
Once, 1 month ago
Once, 1 month ago
4 times, 2 months ago
8 more bugmates