title: Change the direction of sorting keys expressions in ClickHouse
body: <p>Creating a datasource in Tinybird with this schema works as expected</p>
  <pre><code>DESCRIPTION generated from ../datasets/posts_1K.csv
  
  SCHEMA &gt;
      `date` Date,
      `post_id` Int32,
      `views` Int32
  
  ENGINE MergeTree
  ENGINE_SORTING_KEY date, post_id
  </code></pre>
  <p>I wonder if I can change the direction of the ordering in one of the expressions of the sorting key. This schema fails</p>
  <pre><code>DESCRIPTION generated from ../datasets/posts_1K.csv
  
  SCHEMA &gt;
      `date` Date,
      `post_id` Int32,
      `views` Int32
  
  ENGINE MergeTree
  ENGINE_SORTING_KEY date DESC, post_id
  </code></pre>
  <p>When doing <code>tb push datasources/posts_1K_sorted_date_desc_post_id.datasource</code>. Also tried with <code>ENGINE_SORTING_KEY &quot;date DESC, post_id&quot;</code></p>
  <p>Is something like this possible at all on ClickHouse or not? Not sure if it's possible reading the <a href="https://clickhouse.tech/docs/en/sql-reference/statements/create/table/" rel="nofollow noreferrer">docs</a></p>
  <p>Also - would something like this make sense in any case?</p>