Hi Amber, As per Spark in general you can register temporary tables…
Paragraph (1) %spark sqlContext.sql(“select * from db.table where col = ‘buyer’”).registerTempTable(“tempBuyer”) Paragraph (2) %sql Select * from tempBuyer You can also load dependencies and use these to create temporary tables as per the Spark documentation… CREATE TEMPORARY TABLE jsonTable USING org.apache.spark.sql.json OPTIONS ( path "examples/src/main/resources/people.json" ) SELECT * FROM jsonTable Cheers, Joel Van Veluwen QUANTIUM Level 25, 8 Chifley 8-12 Chifley Square Sydney NSW 2000 T: +61 2 8224 8981 M: +61 403 153 265 F: +61 2 9292 6444 W: quantium.com.au<http://www.quantium.com.au> ________________________________ linkedin.com/company/quantium<http://www.linkedin.com/company/quantium> facebook.com/QuantiumAustralia<http://www.facebook.com/QuantiumAustralia> twitter.com/QuantiumAU<http://www.twitter.com/QuantiumAU> The contents of this email, including attachments, may be confidential information. If you are not the intended recipient, any use, disclosure or copying of the information is unauthorised. If you have received this email in error, we would be grateful if you would notify us immediately by email reply, phone (+ 61 2 9292 6400) or fax (+ 61 2 9292 6444) and delete the message from your system. From: Amber Li [mailto:am...@picsart.com] Sent: Tuesday, 22 March 2016 10:29 AM To: users@zeppelin.incubator.apache.org Subject: volatile table or temp views using sparksql Hi I am new to Zeppelin. I wonder if we could create volatile tables or temp views as some middle steps at a single window on Zeppelin? Or the middle step tables need to stored as a physical table somewhere and then to be reloaded for further calculation? Thanks! Amber
