title: How to use ClickHouse partition value in SQL query?
body: <p>I have a table with tuple partitions: <code>(0, 0)</code>, <code>(0, 1)</code>, <code>(1, 0)</code>, <code>(1, 1)</code>, <code>(2, 0)</code>, <code>(2, 1)</code>, <code>(3, 0)</code>, ...</p>
  <pre class="lang-sql prettyprint-override"><code>CREATE TABLE my_table
  (
      id Int32,
      a Int32,
      b Float32,
      c Int32
  )
  ENGINE = MergeTree
  PARTITION BY
  (
      intDiv(id, 1000000),
      a &lt; 20000 AND b &gt; 0.6 AND c &gt;= 100
  )
  ORDER BY id;
  </code></pre>
  <p>I need only rows with partition <code>(&lt;any number&gt;, 1)</code> and I'm looking for a way to use partition value in a query like</p>
  <pre class="lang-sql prettyprint-override"><code>SELECT *
  FROM my_table
  WHERE my_table.partition[2] == 1;
  </code></pre>
  <p>Does ClickHouse have such a feature?</p>