topic Re: What is default location when using "writeStream"? in Data Engineering

What is default location when using "writeStream"?

Mado — Thu, 20 Oct 2022 02:19:28 GMT

Hi,

Assume that I want to write a table by" writeStream". Where is the default location on DBFS where the table is saved?

Sample code:

spark.table("TEMP_SILVER").writeStream
 
        .option("checkpointLocation", "dbfs:/user/AAA@gmail.com")
 
        .trigger(availableNow=True)
 
        .table("silver")

Re: What is default location when using "writeStream"?

jose_gonzalez — Mon, 24 Oct 2022 18:31:28 GMT

Hi @Mohammad Saber ,

I would like to share the following docs that will help you to undertand better what this Structured Streaming API does:

1)https://spark.apache.org/docs/3.2.0/api/java/org/apache/spark/sql/streaming/DataStreamWriter.html#toTable-java.lang.String-

2) https://spark.apache.org/docs/latest/structured-streaming-programming-guide.html#streaming-table-apis

I hope it helps

Re: What is default location when using "writeStream"?

Anonymous — Sun, 27 Nov 2022 13:44:47 GMT

Hi @Mohammad Saber

Hope all is well! Just wanted to check in if you were able to resolve your issue and would you be happy to share the solution or mark an answer as best? Else please let us know if you need more help.

We'd love to hear from you.

Thanks!