<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: How to create a temporary file with sql in Data Engineering</title>
    <link>https://community.databricks.com/t5/data-engineering/how-to-create-a-temporary-file-with-sql/m-p/14034#M8591</link>
    <description>&lt;P&gt;In Spark SQL, you could use commands like "insert overwrite directory" that indirectly creates a temporary file with the data&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;A href="https://docs.databricks.com/spark/latest/spark-sql/language-manual/sql-ref-syntax-dml-insert-overwrite-directory.html#examples" target="test_blank"&gt;https://docs.databricks.com/spark/latest/spark-sql/language-manual/sql-ref-syntax-dml-insert-overwrite-directory.html#examples&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Using shell you could create directory using&lt;/P&gt;&lt;P&gt;%sh mkdir /tmp/file&lt;/P&gt;&lt;P&gt;&amp;amp; create temp file using&lt;/P&gt;&lt;P&gt;&lt;B&gt;echo 'This is a test'&amp;nbsp;&amp;gt;&amp;nbsp;data.txt&lt;/B&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;B&gt;If you have more questions, please let us know what is the use case are you trying to do&lt;/B&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;</description>
    <pubDate>Wed, 20 Oct 2021 17:20:07 GMT</pubDate>
    <dc:creator>mathan_pillai</dc:creator>
    <dc:date>2021-10-20T17:20:07Z</dc:date>
    <item>
      <title>How to create a temporary file with sql</title>
      <link>https://community.databricks.com/t5/data-engineering/how-to-create-a-temporary-file-with-sql/m-p/14033#M8590</link>
      <description>&lt;P&gt;what are the commands to create a temporary file with SQL&lt;/P&gt;</description>
      <pubDate>Mon, 04 Oct 2021 14:57:05 GMT</pubDate>
      <guid>https://community.databricks.com/t5/data-engineering/how-to-create-a-temporary-file-with-sql/m-p/14033#M8590</guid>
      <dc:creator>nlee</dc:creator>
      <dc:date>2021-10-04T14:57:05Z</dc:date>
    </item>
    <item>
      <title>Re: How to create a temporary file with sql</title>
      <link>https://community.databricks.com/t5/data-engineering/how-to-create-a-temporary-file-with-sql/m-p/14034#M8591</link>
      <description>&lt;P&gt;In Spark SQL, you could use commands like "insert overwrite directory" that indirectly creates a temporary file with the data&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;A href="https://docs.databricks.com/spark/latest/spark-sql/language-manual/sql-ref-syntax-dml-insert-overwrite-directory.html#examples" target="test_blank"&gt;https://docs.databricks.com/spark/latest/spark-sql/language-manual/sql-ref-syntax-dml-insert-overwrite-directory.html#examples&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Using shell you could create directory using&lt;/P&gt;&lt;P&gt;%sh mkdir /tmp/file&lt;/P&gt;&lt;P&gt;&amp;amp; create temp file using&lt;/P&gt;&lt;P&gt;&lt;B&gt;echo 'This is a test'&amp;nbsp;&amp;gt;&amp;nbsp;data.txt&lt;/B&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;B&gt;If you have more questions, please let us know what is the use case are you trying to do&lt;/B&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;</description>
      <pubDate>Wed, 20 Oct 2021 17:20:07 GMT</pubDate>
      <guid>https://community.databricks.com/t5/data-engineering/how-to-create-a-temporary-file-with-sql/m-p/14034#M8591</guid>
      <dc:creator>mathan_pillai</dc:creator>
      <dc:date>2021-10-20T17:20:07Z</dc:date>
    </item>
  </channel>
</rss>

