below is the example let me know if that works for you.    You can use Range or hash partition , also we can perform Range as well as hash partition together or just hash partition by using bucket .    Below is the table that has primary key that coloum id we are using for partition (that is a good practice )    CREATE TABLE customersDetails ( state STRING, PRIMARY KEY (state, name) ) PARTITION BY RANGE (state) ( PARTITION VALUE = 'al', PARTITION VALUE = 'ak', PARTITION VALUE = 'wv', PARTITION VALUE = 'wy' ) STORED AS KUDU;   ... View more