Was testing a Simple clustering column with an example, but i was not able to see the default ASC order for the Clustering column
Here is the below example
CREATE TABLE pk_ck_clust_test2 ( id INT, name text, age INT, status text, primary key((age, id), name) )
insert into pk_ck_CLUST_test2 (id,name,age,status) values (25,'thiru1',30,'New30test'); insert into pk_ck_CLUST_test2 (id,name,age,status) values (24,'thiru1',30,'New30test'); insert into pk_ck_CLUST_test2 (id,name,age,status) values (26,'thiru1',30,'New30test'); insert into pk_ck_CLUST_test2 (id,name,age,status) values (15,'thiru1',30,'New30test'); insert into pk_ck_CLUST_test2 (id,name,age,status) values (24,'thiru0',30,'New30test'); insert into pk_ck_CLUST_test2 (id,name,age,status) values (24,'athiru0',30,'New80test');
select * from pk_ck_CLUST_test2; age | id | name. | status -----+----+---------+----------- 30 | 15 | thiru1 | New30test 30 | 25 | thiru1 | New30test 30 | 24 | athiru0 | New80test <======== (name : athiru0) Supposed to be the clsutering column and it should be ASC by Default , why is it showing up in the middle 30 | 24 | thiru0 | New70test 30 | 24 | thiru1 | New30test 30 | 26 | thiru1 | New30test
===> by the definition of a Clustering column the (name : athiru0) Supposed to be the clustering column and it should be ASC by
(name : athiru0) should be the fist value showing up based on name ASC , but i see its in the middle , just wondering if this has any more to it
Thanks