org.apache.spark.sql.AnalysisException: Table not found: `dev`.`emp`; line 1 pos 18


Solutions on the web57

Solution icon of stackoverflow
Table not found: `dev`.`emp`; line 1 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 github
via GitHub by trestletech
, 1 year ago
Table not found: flights; line 2 pos 18

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

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

Solution icon of stackoverflow
Table not found: sampledb.rsparktest3; line 1 pos 35

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

Solution icon of stackoverflow
Table or view not found: mst_ex_user; line 1 pos 14

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

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, 1 week ago
Once, 1 month ago
Once, 6 months ago
Samebug visitor profile picture
Unknown user
Once, 3 months ago
9 more bugmates