[SPARK-23748] Support select from temp tables

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.4.0
• Fix Version/s: 2.3.1, 2.4.0
• Component/s: Structured Streaming
• Assignee: Saisai Shao
• Reporter: Jose Torres
• Created: 20/Mar/18 16:23
• Updated: 16/Sep/18 02:47
• Resolved: 13/Apr/18 03:01

Description

As reported in the dev list, the following currently fails:

 

val jdf = spark.readStream.format("kafka").option("kafka.bootstrap.servers", "localhost:9092").option("subscribe", "join_test").option("startingOffsets", "earliest").load();

jdf.createOrReplaceTempView("table")

 

val resultdf = spark.sql("select * from table")

resultdf.writeStream.outputMode("append").format("console").option("truncate", false).trigger(Trigger.Continuous("1 second")).start()

Issue Links

• links to: [Github] Pull Request #21017 (jerryshao)