Hi Javier, When our users ask this question, I tend to answer "keep it above a billion". More partitions is better.
I'm not aware of any actual limits on partition count. Practically it's almost always limited by the disk space in a server. Tom van der Woerdt Site Reliability Engineer Booking.com B.V. Vijzelstraat 66-80 Amsterdam 1017HL Netherlands [image: Booking.com] <http://www.booking.com/> The world's #1 accommodation site 43 languages, 198+ offices worldwide, 120,000+ global destinations, 1,550,000+ room nights booked every day No booking fees, best price always guaranteed Subsidiary of Booking Holdings Inc. (NASDAQ: BKNG) On Wed, Mar 7, 2018 at 12:06 PM, Javier Pareja <pareja.jav...@gmail.com> wrote: > Hello all, > > I have been trying to find an answer to the following but I have had no > luck so far: > Is there any limit to the number of partitions that a table can have? > Let's say a table has a partition key an no clustering key, is there a > recommended limit on the number of values that this partition key can have? > Is it recommended to have a clustering key to reduce this number by storing > several rows in each partition instead of one row per partition. > > Regards, > > F Javier Pareja >
