Sql errored out with: Table not found


#1

Can anyone kindly help me to sort this out please, thank you very much:

scala> empDF.show
±--------+
| name|
±--------+
| kk,pasle|
|onk,pasle|
| mj,pasle|
±--------+

scala> emp2DF.registerTempTable(“employee2”)

val tbl = sqlContext.sql(“select name from employee2”)

image


#2

Import below one and then create dataframe and use register temp table.

Import sqlContext.implicits._