title: How can I check the partition list from Athena in AWS?
body: <p>I want to check the partition lists in Athena.</p>
  
  <p>I used query like this.</p>
  
  <pre><code>show partitions table_name
  </code></pre>
  
  <p>But I want to search specific table existed.</p>
  
  <p>So I used query like below but there was no results returned.</p>
  
  <pre><code>show partitions table_name partition(dt='2010-03-03')
  </code></pre>
  
  <p>Because dt contains hour data also.</p>
  
  <pre><code>dt='2010-03-03-01', dt='2010-03-03-02', ...........
  </code></pre>
  
  <p>So is there any way to search when I input '2010-03-03' then it search '2010-03-03-01', '2010-03-03-02'?</p>
  
  <p>Do I have to separate partition like this?</p>
  
  <pre><code>dt='2010-03-03', dh='01'
  </code></pre>
  
  <p>And show partitions table_name returned only 500 rows in Hive. Is the same in Athena also?</p>