Choosing a shard key.

If a table has a primary key that has multiple columns in it, should the shard key I specify contain those same multiple columns.

Example:

Table FACT_FN_GAS_READS contains primary key of:

read_id,  partition_sequence,  read_datetime

Thanks for your help!

6replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like Follow
  • Status Answered
  • 2 yrs agoLast active
  • 6Replies
  • 547Views
  • 4 Following