title: Query by multiple values from an AWS Athena bucketed table
body: <p>I have a bucketed table from which I want to query by multiple values.
  Here is an example:</p>
  
  <pre><code>SELECT *
  FROM my_bucketed_table
  WHERE bucketed_column IN (value1, value2)
  </code></pre>
  
  <p>The result is a full scan of the table, instead of using the index.</p>
  
  <p>When I used union to query each value at a time it worked as expected in terms of data scanned:</p>
  
  <pre><code>SELECT *
  FROM my_bucketed_table
  WHERE bucketed_column = value1
  UNION
  SELECT *
  FROM my_bucketed_table
  WHERE bucketed_column = value2
  </code></pre>
  
  <p>but I want the list to be dynamic, so this solution is not good enough for me.</p>
  
  <p>I expect the data scanned to be the same as in the UNION solution using the IN operator or a JOIN with another table</p>