If I want to partition my BigQuery table by a date (post_date) and an integer column(user_id in integers), both are which frequently used in where/joins/groupby, does the order that I create my partition table matter?
E.g PARTITION BY DATE(post_date), user_id vs E.g PARTITION BY user_id, DATE(post_date)
Will there be a difference in performance?