title: Create hive external table from partitioned parquet files in Azure HDInsights
body: <p>I have data saved as parquet files in Azure blob storage. Data is partitioned by year, month, day and hour like:</p>
  
  <p><code>cont/data/year=2017/month=02/day=01/</code></p>
  
  <p>I want to create external table in Hive using following create statement, which I wrote using <a href="https://www.cloudera.com/documentation/enterprise/5-8-x/topics/impala_create_table.html" rel="noreferrer">this reference</a>.</p>
  
  <pre><code>CREATE EXTERNAL TABLE table_name (uid string, title string, value string) 
  PARTITIONED BY (year int, month int, day int) STORED AS PARQUET 
  LOCATION 'wasb://cont@storage_name.blob.core.windows.net/data';
  </code></pre>
  
  <p>This creates table but has no rows when querying. I tried same create statement without <code>PARTITIONED BY</code> clause and that seems to work. So looks like issue is with partitioning.</p>
  
  <p>What am I missing?</p>