title: Finding Parquet File Created with Apache Drill
body: <p>After reading this post: 
  <a href="http://tgrall.github.io/blog/2015/08/17/convert-csv-file-to-apache-parquet-dot-dot-dot-with-drill/" rel="nofollow">http://tgrall.github.io/blog/2015/08/17/convert-csv-file-to-apache-parquet-dot-dot-dot-with-drill/</a></p>
  
  <p>I'm trying to convert a CSV file to a Parquet file. I can successfully query my CSV: </p>
  
  <pre><code>select * from dfs.`/Users/[username]/Desktop/drill_example.csv` limit 5;
  </code></pre>
  
  <p>with an output of: </p>
  
  <pre><code>+-------------------+
  |      columns      |
  +-------------------+
  | ["1","UT","M\r"]  |
  | ["2","CA","M\r"]  |
  | ["3","CA","F\r"]  |
  | ["4","NJ","M\r"]  |
  | ["5","FL","F\r"]  |
  +-------------------+
  </code></pre>
  
  <p>I then change the format to Parquet via: </p>
  
  <pre><code>alter session set `store.format`='parquet';
  </code></pre>
  
  <p>with an output of: </p>
  
  <pre><code>+-------+------------------------+
  |  ok   |        summary         |
  +-------+------------------------+
  | true  | store.format updated.  |
  +-------+------------------------+
  </code></pre>
  
  <p>I then create the new table/file using this code: </p>
  
  <pre><code>CREATE TABLE dfs.tmp.`/Users/[username]/Desktop/drill_example_parquet` AS
  select * from dfs.`/Users/[username]/Desktop/drill_example.csv`;
  </code></pre>
  
  <p>with the following output: </p>
  
  <pre><code>SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
  SLF4J: Defaulting to no-operation (NOP) logger implementation
  SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.
  +-----------+----------------------------+
  | Fragment  | Number of records written  |
  +-----------+----------------------------+
  | 0_0       | 10000                      |
  +-----------+----------------------------+
  1 row selected (1.292 seconds)
  </code></pre>
  
  <p>The table/file is created because I can query it with this code: </p>
  
  <pre><code>SELECT *
  FROM dfs.tmp.`/Users/[username]/Desktop/drill_example_parquet`;
  </code></pre>
  
  <p>but I can't find the file on my computer. How do I get the Parquet <strong>file</strong> (not table)? In other words, the Parquet version of the CSV file on my desktop. Do I have to export it somehow? Also, how do I delete these tables once I'm done? </p>
  
  <p>Thanks in advance. </p>