create index default_rating on `default`(rating) using GSI with {"num_replica":1}
create index default_claims on `default`(claim) using GSI with {"num_replica":2}
create index default_result on `default`(result) using GSI with {"num_replica":1,"defer_build": true}
create primary index on `default` using GSI with {"num_replica":2}
create index o1_claims on `other-1`(claim) using GSI with {"num_replica":1,"defer_build": true}
create index o1_result_rating on `other-1`(rating,result) using GSI with {"num_replica":1}
create index o2_claims on `other-2`(claim) using GSI with {"num_replica":1}
create index o3_claims on `other-3`(claim) using GSI with {"num_replica":1}
create index default_result_ratings_claims_pindex on `default`(rating,result,claim) partition by hash(rating) using GSI with {"num_replica":1, "num_partition":4}
create primary index on `other-1` partition by hash(rating,result,claim) using GSI with {"num_partition":4}
create index o2_result_rating on `other-2`(rating,result) partition by hash(rating) using GSI with {"num_partition":4}
create index o3_result_rating on `other-3`(rating,result) partition by hash(rating,LOWER(result)) using GSI with {"defer_build": true, "num_partition":4}