title: How Create a hive external table with parquet format
body: <p>I am trying to create an external table in hive with the following query in HDFS.</p>
  <pre><code>CREATE EXTERNAL TABLE `post` (
      FileSK STRING,
      OriginalSK STRING,
      FileStatus STRING,
      TransactionType STRING,
      TransactionDate STRING
     )
    ROW FORMAT DELIMITED
    FIELDS TERMINATED BY ','
    STORED AS PARQUET TBLPROPERTIES(&quot;Parquet.compression&quot;=&quot;SNAPPY&quot;)
    LOCATION 'hdfs://.../post'
  </code></pre>
  <p>getting error</p>
  <blockquote>
  <p>Error while compiling statement: FAILED: ParseException line 11:2
  missing EOF at 'LOCATION' near ')'</p>
  </blockquote>
  <p>What is the best way to create a HIVE external table with data stored in parquet format?</p>