title: Select with where on partition key too slow with limit on Spark Sql
body: <p>I am executing a query like 
  <code>select &lt;column&gt; from &lt;mytable&gt; where &lt;partition_key&gt; = &lt;value&gt; limit 10</code></p>
  
  <p>and it is taking FOREVER to execute. I looked at the physical plan and I see a <code>HiveTableScan</code> in there and that looked fishy, does that mean the query is scanning the entire table? I was expecting the query to</p>
  
  <p>A. exactly scan 1 partition and no more</p>
  
  <p>B. end the scan as soon as it returns 10 rows</p>
  
  <p>Is my understanding incorrect? How do I make spark perform exactly this?</p>